NAME: Update close_reason for Leads – Main
SHORT CODE: ASXADFLM
MODULE: Oracle Sales Foundation

Description: Update close_reason for Leads – Main
Navigation: Oracle Sales Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• X_OPEN_FLAG : The value of the open flag to be updated in the as_accesses_all table
• X_STATUS_CODE : The value of the status_code based on which the update will be done.
• p_num_workers : Number of workers
• p_batch_size : Number of records commited at one shot
• p_debug_flag : Debug flag

NAME: Purge TAP Access Tables
SHORT CODE: ASTPRG
MODULE: Oracle Sales Foundation

Description: Purge AS_ACCESSES_ALL and AS_TERRITORY_ACCESSES tables
Navigation: Oracle Sales Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• Debug : Run program in Debug mode
• SQL Trace : Do SQL statement tracing

NAME: Delete from TAP Access Tables
SHORT CODE: ASTPON
MODULE: Oracle Sales Foundation

Description: Delete from AS_ACCESSES_ALL and AS_TERRITORY_ACCESSES tables
Navigation: Oracle Sales Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• Debug : Run program in Debug mode
• SQL Trace : Do SQL statement tracing
• Worker ID : Worker ID