DBA Data[Home] [Help]

PACKAGE: APPS.AS_SALES_CREDITS_LOG_PKG

Source


1 PACKAGE AS_SALES_CREDITS_LOG_PKG AUTHID CURRENT_USER as
2 /* $Header: asxtscls.pls 120.2 2005/09/02 04:05:37 appldev ship $ */
3 PROCEDURE Insert_Row(p_new_lead_id    	NUMBER,
4   						p_new_lead_line_id 	NUMBER,
5 						p_new_sales_credit_id	NUMBER,
6 						p_new_last_update_date  DATE,
7 						p_new_last_updated_by   NUMBER,
8 						p_new_last_update_login NUMBER,
9 						p_new_creation_date     DATE,
10   						p_new_created_by        NUMBER,
11 						p_new_salesforce_id	NUMBER,
12 						p_new_salesgroup_id	NUMBER,
13 						p_new_credit_type_id	NUMBER,
14 						p_new_credit_percent	NUMBER,
15 						p_new_credit_amount	NUMBER,
16 						p_new_opp_worst_frcst_amount NUMBER,
17 						p_new_opp_frcst_amount NUMBER,
18 						p_new_opp_best_frcst_amount NUMBER,
19 						p_endday_log_flag   VARCHAR2,
20 						p_TRIGGER_MODE 	   	VARCHAR2);
21 
22 PROCEDURE Update_Row(p_new_lead_id          NUMBER,
23 	p_new_lead_line_id              NUMBER,
24 	p_old_sales_credit_id		NUMBER,
25 	p_old_last_update_date          DATE,
26 	p_new_last_update_date		DATE,
27 	p_new_last_updated_by           NUMBER,
28     	p_new_last_update_login         NUMBER,
29     	p_new_creation_date             DATE,
30     	p_new_created_by                NUMBER,
31 	p_new_salesforce_id		NUMBER,
32 	p_new_salesgroup_id		NUMBER,
33 	p_new_credit_type_id		NUMBER,
34 	p_new_credit_percent		NUMBER,
35 	p_new_credit_amount		NUMBER,
36 	p_new_opp_worst_frcst_amount NUMBER,
37 	p_new_opp_frcst_amount NUMBER,
38 	p_new_opp_best_frcst_amount NUMBER,
39 	p_endday_log_flag           VARCHAR2,
40 	p_TRIGGER_MODE 	   	    	VARCHAR2);
41 
42 
43 Procedure Delete_Row(p_old_lead_id   NUMBER,
44   	p_old_lead_line_id 	NUMBER,
45 	p_old_sales_credit_id	NUMBER,
46 	p_old_last_update_date  DATE,
47 	p_old_last_updated_by   NUMBER,
48 	p_old_last_update_login NUMBER,
49 	p_old_creation_date     DATE,
50   	p_old_created_by        NUMBER,
51 	p_endday_log_flag           VARCHAR2);
52 
53 END AS_SALES_CREDITS_LOG_PKG;