31: -- NOTES
32: --
33: ---------------------------------------------------------------------
34:
35: gc_partner_message VARCHAR2(200) := fnd_message.get_string('PV','PV_PARTNER');
36: gc_assignment_type_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGNMENT_TYPE');
37: gc_decline_reason_message VARCHAR2(200) := fnd_message.get_string('PV','PV_DECLINE_REASON');
38: gc_oppty_timeout_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGN_OPPTY_TIMEOUT');
39: gc_oppty_cm_timeout_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGN_CM_TIMEOUT');
32: --
33: ---------------------------------------------------------------------
34:
35: gc_partner_message VARCHAR2(200) := fnd_message.get_string('PV','PV_PARTNER');
36: gc_assignment_type_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGNMENT_TYPE');
37: gc_decline_reason_message VARCHAR2(200) := fnd_message.get_string('PV','PV_DECLINE_REASON');
38: gc_oppty_timeout_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGN_OPPTY_TIMEOUT');
39: gc_oppty_cm_timeout_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGN_CM_TIMEOUT');
40:
33: ---------------------------------------------------------------------
34:
35: gc_partner_message VARCHAR2(200) := fnd_message.get_string('PV','PV_PARTNER');
36: gc_assignment_type_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGNMENT_TYPE');
37: gc_decline_reason_message VARCHAR2(200) := fnd_message.get_string('PV','PV_DECLINE_REASON');
38: gc_oppty_timeout_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGN_OPPTY_TIMEOUT');
39: gc_oppty_cm_timeout_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGN_CM_TIMEOUT');
40:
41: FUNCTION GET_ADDTNL_LOG_DETAILS ( p_oppty_routing_log_id NUMBER,
34:
35: gc_partner_message VARCHAR2(200) := fnd_message.get_string('PV','PV_PARTNER');
36: gc_assignment_type_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGNMENT_TYPE');
37: gc_decline_reason_message VARCHAR2(200) := fnd_message.get_string('PV','PV_DECLINE_REASON');
38: gc_oppty_timeout_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGN_OPPTY_TIMEOUT');
39: gc_oppty_cm_timeout_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGN_CM_TIMEOUT');
40:
41: FUNCTION GET_ADDTNL_LOG_DETAILS ( p_oppty_routing_log_id NUMBER,
42: p_event VARCHAR2,
35: gc_partner_message VARCHAR2(200) := fnd_message.get_string('PV','PV_PARTNER');
36: gc_assignment_type_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGNMENT_TYPE');
37: gc_decline_reason_message VARCHAR2(200) := fnd_message.get_string('PV','PV_DECLINE_REASON');
38: gc_oppty_timeout_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGN_OPPTY_TIMEOUT');
39: gc_oppty_cm_timeout_message VARCHAR2(200) := fnd_message.get_string('PV','PV_ASSIGN_CM_TIMEOUT');
40:
41: FUNCTION GET_ADDTNL_LOG_DETAILS ( p_oppty_routing_log_id NUMBER,
42: p_event VARCHAR2,
43: p_lead_workflow_id NUMBER,