PACKAGE: APPS.PV_OPPTY_ROUTING_LOG

Source

1 PACKAGE PV_OPPTY_ROUTING_LOG AS
2 /* $Header: pvxvorls.pls 120.1 2006/03/10 15:02:11 amaram noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          PV_OPPTY_ROUTING_LOG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 
17 
18 
19 ---------------------------------------------------------------------
20 -- FUNCTION
21 --    GET_ADDTNL_LOG_DETAILS
22 --
23 -- PURPOSE
24 --    Based on the OPPTY_ROUTING_LOGS_ID,  event, LEAD_WORKFLOW_ID, LEAD_ASSIGNMENT_ID
25 --   This function returns the additional details about oppty history log
26 --
27 -- PARAMETERS
28 --    OPPTY_ROUTING_LOGS_ID,  event, LEAD_WORKFLOW_ID, LEAD_ASSIGNMENT_ID
29 --    returns additional details as varchar2
30 --
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');
40 
41 	FUNCTION GET_ADDTNL_LOG_DETAILS (       p_oppty_routing_log_id     NUMBER,
42                                         p_event			VARCHAR2,
43                                         p_lead_workflow_id     NUMBER,
44 					p_lead_assignment_id	NUMBER
45 				 )
46 RETURN VARCHAR2 DETERMINISTIC;
47 
48 END PV_OPPTY_ROUTING_LOG;