NAME: Interaction History Data Purge
SHORT CODE: JTFIHPURGE
MODULE: Oracle CRM Foundation

Description: Interaction History Data Purge
Navigation: Oracle CRM Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_Party_IDs : List of Parties ID, use coma as separator
• p_Party_Type : Party Identifier
• p_Start_Date : Start Date Time for Range
• p_End_Date : End Date Time for Range
• p_SafeMode : SafeMode – True or False
• p_Purge_Type : If it equals ‘ALL’ then will be deleted All Interactions
• p_ActivityOutcome : List of Activity Outcomes, use a comma as a separator
• p_ActivityResult : List of Activity Results, use a comma as a separator
• p_ActivityReason : List of Activity Reasons, use a comma as a separator
• p_InterOutcome : List of Interaction Outcomes, use a comma as a separator
• p_InterResult : List of Interaction Results, use a comma as a separator
• p_InterReason : List of Interaction Reasons, use a comma as a separator
• p_Active : Status for Interactions Y or N (default N)

NAME: CRMSUBSCRIBER
SHORT CODE: CRMSUBSCRIBER
MODULE: Oracle CRM Foundation

Description: CRM Mesage Subscriber
Navigation: Oracle CRM Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• P_QUEUE_NAMES : QUEUES TO BE POLLED, specify queue name with comma(,) delimiter

NAME: Copy Territory Hierarchy Node
SHORT CODE: COPY_TERR_HIERARCHY_NODE
MODULE: Oracle CRM Foundation

Description: Copies a territory and all its sub-territories
Navigation: Oracle CRM Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_copy_source_terr_id : Territory Node
• p_name : Territory Name
• p_description : Territory Description
• p_rank : Territory Rank
• p_start_date : Start Date
• p_end_date : End Date
• p_copy_rsc_flag : Copy Resource flag
• p_copy_hierarchy_flag : Copy Hierarchy flag
• p_first_terr_node_flag : First Territory Node
• p_debug_flag : Debug Flag
• p_sql_trace : Sql Trace Flag