74: -- ---------------------------------------------------------------------------------
75:
76: type party_notify_rec_tbl_type is RECORD
77: (
78: WF_ITEM_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
79: WF_ITEM_KEY pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
80: LEAD_ASSIGNMENT_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
81: NOTIFICATION_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
82: USER_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
75:
76: type party_notify_rec_tbl_type is RECORD
77: (
78: WF_ITEM_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
79: WF_ITEM_KEY pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
80: LEAD_ASSIGNMENT_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
81: NOTIFICATION_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
82: USER_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
83: USER_NAME pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
76: type party_notify_rec_tbl_type is RECORD
77: (
78: WF_ITEM_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
79: WF_ITEM_KEY pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
80: LEAD_ASSIGNMENT_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
81: NOTIFICATION_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
82: USER_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
83: USER_NAME pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
84: RESOURCE_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
77: (
78: WF_ITEM_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
79: WF_ITEM_KEY pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
80: LEAD_ASSIGNMENT_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
81: NOTIFICATION_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
82: USER_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
83: USER_NAME pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
84: RESOURCE_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
85: RESPONSE_DATE pv_assignment_pub.g_date_table_type := pv_assignment_pub.g_date_table_type(),
78: WF_ITEM_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
79: WF_ITEM_KEY pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
80: LEAD_ASSIGNMENT_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
81: NOTIFICATION_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
82: USER_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
83: USER_NAME pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
84: RESOURCE_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
85: RESPONSE_DATE pv_assignment_pub.g_date_table_type := pv_assignment_pub.g_date_table_type(),
86: RESOURCE_RESPONSE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
79: WF_ITEM_KEY pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
80: LEAD_ASSIGNMENT_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
81: NOTIFICATION_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
82: USER_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
83: USER_NAME pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
84: RESOURCE_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
85: RESPONSE_DATE pv_assignment_pub.g_date_table_type := pv_assignment_pub.g_date_table_type(),
86: RESOURCE_RESPONSE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
87: DECISION_MAKER_FLAG pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type()
80: LEAD_ASSIGNMENT_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
81: NOTIFICATION_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
82: USER_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
83: USER_NAME pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
84: RESOURCE_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
85: RESPONSE_DATE pv_assignment_pub.g_date_table_type := pv_assignment_pub.g_date_table_type(),
86: RESOURCE_RESPONSE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
87: DECISION_MAKER_FLAG pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type()
88: );
81: NOTIFICATION_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
82: USER_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
83: USER_NAME pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
84: RESOURCE_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
85: RESPONSE_DATE pv_assignment_pub.g_date_table_type := pv_assignment_pub.g_date_table_type(),
86: RESOURCE_RESPONSE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
87: DECISION_MAKER_FLAG pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type()
88: );
89:
82: USER_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
83: USER_NAME pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
84: RESOURCE_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
85: RESPONSE_DATE pv_assignment_pub.g_date_table_type := pv_assignment_pub.g_date_table_type(),
86: RESOURCE_RESPONSE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
87: DECISION_MAKER_FLAG pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type()
88: );
89:
90:
83: USER_NAME pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
84: RESOURCE_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
85: RESPONSE_DATE pv_assignment_pub.g_date_table_type := pv_assignment_pub.g_date_table_type(),
86: RESOURCE_RESPONSE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
87: DECISION_MAKER_FLAG pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type()
88: );
89:
90:
91: PROCEDURE bulk_cr_party_notification(