DBA Data[Home] [Help]

PACKAGE: APPS.AS_LEADS_LINES_LOG_PKG

Source


1 PACKAGE AS_LEADS_LINES_LOG_PKG as
2 /* $Header: asxtlnls.pls 120.2 2005/09/02 04:05:30 appldev ship $ */
3 PROCEDURE Insert_Row(p_lead_id    NUMBER,
4   p_lead_line_id                    NUMBER,
5   p_last_update_date                        DATE,
6   p_last_updated_by                         NUMBER,
7   p_last_update_login                       NUMBER,
8   p_creation_date                   DATE,
9   p_created_by                              NUMBER,
10   p_interest_type_id                        NUMBER,
11   p_primary_interest_code_id                NUMBER,
12   p_secondary_interest_code_id              NUMBER,
13   p_product_category_id                     NUMBER,
14   p_product_cat_set_id                      NUMBER,
15   p_inventory_item_id                       NUMBER,
16   p_organization                    NUMBER,
17   p_source_promotion_id                     NUMBER,
18   p_offer_id                                NUMBER,
19   p_org_id                          NUMBER,
20   p_forecast_date                   DATE,
21   p_rolling_forecast_flag           VARCHAR2,
22   p_endday_log_flag         VARCHAR2,
23   p_TRIGGER_MODE 	   	    VARCHAR2);
24 PROCEDURE Update_Row(p_lead_id            NUMBER,
25 	old_lead_line_id                  NUMBER,
26 	old_last_update_date              DATE,
27 	new_last_update_date		DATE,
28 	p_last_updated_by               NUMBER,
29     	p_last_update_login             NUMBER,
30     	p_creation_date                 DATE,
31     	p_created_by                    NUMBER,
32     	p_interest_type_id              NUMBER,
33     	p_primary_interest_code_id      NUMBER,
34     	p_secondary_interest_code_id    NUMBER,
35         p_product_category_id           NUMBER,
36         p_product_cat_set_id            NUMBER,
37     	p_inventory_item_id             NUMBER,
38     	p_organization_id               NUMBER,
39     	p_source_promotion_id           NUMBER,
40     	p_offer_id                      NUMBER,
41     	p_org_id                        NUMBER,
42     	p_forecast_date                 DATE,
43     	p_rolling_forecast_flag         VARCHAR2,
44     	p_endday_log_flag       VARCHAR2,
45     	p_TRIGGER_MODE 	   		VARCHAR2);
46 
47 
48 PROCEDURE Delete_Row(p_old_lead_id	NUMBER,
49   		p_old_lead_line_id 	NUMBER,
50 		p_old_last_update_date      DATE,
51 		p_old_last_updated_by       NUMBER,
52 		p_old_last_update_login     NUMBER,
53 		p_old_creation_date         DATE,
54   		p_old_created_by            NUMBER,
55         p_endday_log_flag         VARCHAR2);
56 
57 END AS_LEADS_LINES_LOG_PKG;