PACKAGE: APPS.AS_LEADS_LOG_PKG

Source

1 PACKAGE AS_LEADS_LOG_PKG AUTHID CURRENT_USER as
2 /* $Header: asxtllgs.pls 115.6 2003/07/04 12:02:53 gbatra ship $ */
3 -- Start of Comments
4 -- Package name     : AS_LEADS_LOG_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_LOG_ID   IN OUT NOCOPY NUMBER,
12           p_LEAD_ID    NUMBER,
13           p_CREATED_BY    NUMBER,
14           p_CREATION_DATE    DATE,
15           p_LAST_UPDATED_BY    NUMBER,
16           p_LAST_UPDATE_DATE    DATE,
17           p_LAST_UPDATE_LOGIN    NUMBER,
18           p_STATUS_CODE    VARCHAR2,
19           p_SALES_STAGE_ID    NUMBER,
20           p_WIN_PROBABILITY    NUMBER,
21           p_DECISION_DATE    DATE,
22           p_ADDRESS_ID    NUMBER,
23           p_CHANNEL_CODE    VARCHAR2,
24           p_CURRENCY_CODE    VARCHAR2,
25           p_TOTAL_AMOUNT    NUMBER,
26 	  p_SECURITY_GROUP_ID      NUMBER,
27 	  p_CUSTOMER_ID            NUMBER,
28  	  p_DESCRIPTION            VARCHAR2,
29 	  p_SOURCE_PROMOTION_ID    NUMBER,
30 	  p_OFFER_ID               NUMBER,
31    	  p_CLOSE_COMPETITOR_ID    VARCHAR2,
32 	  p_VEHICLE_RESPONSE_CODE  VARCHAR2,
33  	  p_SALES_METHODOLOGY_ID   NUMBER,
34 	  p_OWNER_SALESFORCE_ID    NUMBER,
35 	  p_OWNER_SALES_GROUP_ID   NUMBER,
36 	  p_LOG_START_DATE	   DATE,
37 	  p_LOG_END_DATE	   DATE,
38 	  p_LOG_ACTIVE_DAYS	   NUMBER,
39 	  p_ENDDAY_LOG_FLAG	   VARCHAR2,
40 	  p_CURRENT_LOG		   NUMBER,
41 	  p_ORG_ID                 NUMBER,
42 	  p_TRIGGER_MODE 	   VARCHAR2);
43 
44 PROCEDURE Update_Row(
45           p_LOG_ID    IN OUT NOCOPY NUMBER,
46           p_LEAD_ID    NUMBER,
47 	  p_OLD_LEAD_ID NUMBER,
48           p_CREATED_BY    NUMBER,
49           p_CREATION_DATE    DATE,
50           p_LAST_UPDATED_BY    NUMBER,
51           p_LAST_UPDATE_DATE    DATE,
52 	  p_OLD_LAST_UPDATE_DATE DATE,
53           p_LAST_UPDATE_LOGIN    NUMBER,
54           p_STATUS_CODE    VARCHAR2,
55           p_SALES_STAGE_ID    NUMBER,
56           p_WIN_PROBABILITY    NUMBER,
57           p_DECISION_DATE    DATE,
58           p_ADDRESS_ID    NUMBER,
59           p_CHANNEL_CODE    VARCHAR2,
60           p_CURRENCY_CODE    VARCHAR2,
61           p_TOTAL_AMOUNT    NUMBER,
62 	  p_SECURITY_GROUP_ID      NUMBER,
63 	  p_CUSTOMER_ID            NUMBER,
64  	  p_DESCRIPTION            VARCHAR2,
65 	  p_SOURCE_PROMOTION_ID    NUMBER,
66 	  p_OFFER_ID               NUMBER,
67    	  p_CLOSE_COMPETITOR_ID    VARCHAR2,
68 	  p_VEHICLE_RESPONSE_CODE  VARCHAR2,
69  	  p_SALES_METHODOLOGY_ID   NUMBER,
70 	  p_OWNER_SALESFORCE_ID    NUMBER,
71 	  p_OWNER_SALES_GROUP_ID   NUMBER,
72 	  p_LOG_START_DATE	   DATE,
73 	  p_LOG_END_DATE	   DATE,
74 	  p_LOG_ACTIVE_DAYS	   NUMBER,
75 	  p_ENDDAY_LOG_FLAG	   VARCHAR2,
76 	  p_CURRENT_LOG		   NUMBER,
77 	  p_ORG_ID                 NUMBER,
78 	  p_TRIGGER_MODE 	   VARCHAR2);
79 
80 PROCEDURE Lock_Row(
81           p_LOG_ID    NUMBER,
82           p_LEAD_ID    NUMBER,
83           p_CREATED_BY    NUMBER,
84           p_CREATION_DATE    DATE,
85           p_LAST_UPDATED_BY    NUMBER,
86           p_LAST_UPDATE_DATE    DATE,
87           p_LAST_UPDATE_LOGIN    NUMBER,
88           p_STATUS_CODE    VARCHAR2,
89           p_SALES_STAGE_ID    NUMBER,
90           p_WIN_PROBABILITY    NUMBER,
91           p_DECISION_DATE    DATE,
92           p_ADDRESS_ID    NUMBER,
93           p_CHANNEL_CODE    VARCHAR2,
94           p_CURRENCY_CODE    VARCHAR2,
95           p_TOTAL_AMOUNT    NUMBER);
96 
97 PROCEDURE Delete_Row(
98     p_LOG_ID  NUMBER);
99 End AS_LEADS_LOG_PKG;