1 Package AS_LEADS_AUDIT_PKG AUTHID CURRENT_USER AS
2 /* $Header: asxopads.pls 120.2 2006/03/25 04:20:28 savadhan noship $ */
3
4 Procedure Leads_Trigger_Handler(
5 p_new_last_update_date IN as_leads_all.last_update_date%type ,
6 p_old_last_update_date IN as_leads_all.last_update_date%type ,
7 p_new_last_updated_by IN as_leads_all.last_updated_by%type,
8 p_new_creation_date IN as_leads_all.creation_date%type,
9 p_new_created_by IN as_leads_all.created_by%type,
10 p_new_last_update_login IN as_leads_all.last_update_login%type,
11 p_new_lead_id IN as_leads_all.lead_id%type,
12 p_old_lead_id IN as_leads_all.lead_id%type,
13 p_new_address_id IN as_leads_all.address_id%type,
14 p_old_address_id IN as_leads_all.address_id%type,
15 p_new_status IN as_leads_all.status%type,
16 p_old_status IN as_leads_all.status%type,
17 p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
18 p_old_sales_stage_id IN as_leads_all.sales_stage_id%type,
19 p_new_channel_code IN as_leads_all.channel_code%type,
20 p_old_channel_code IN as_leads_all.channel_code%type,
21 p_new_win_probability IN as_leads_all.win_probability%type,
22 p_old_win_probability IN as_leads_all.win_probability%type,
23 p_new_decision_date IN as_leads_all.decision_date%type ,
24 p_old_decision_date IN as_leads_all.decision_date%type ,
25 p_new_currency_code IN as_leads_all.currency_code%type,
26 p_old_currency_code IN as_leads_all.currency_code%type,
27 p_new_total_amount IN as_leads_all.total_amount%type,
28 p_old_total_amount IN as_leads_all.total_amount%type,
29
30 p_new_security_group_id IN as_leads_all.security_group_id%type,
31 p_old_security_group_id IN as_leads_all.security_group_id%type,
32
33 p_new_customer_id IN as_leads_all.customer_id%type,
34 p_old_customer_id IN as_leads_all.customer_id%type,
35 p_new_description IN as_leads_all.description%type,
36 p_old_description IN as_leads_all.description%type,
37 p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
38 p_old_source_promotion_id IN as_leads_all.source_promotion_id%type,
39 p_new_offer_id IN as_leads_all.offer_id%type,
40 p_old_offer_id IN as_leads_all.offer_id%type,
41 p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
42 p_old_close_competitor_id IN as_leads_all.close_competitor_id%type,
43 p_new_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
44 p_old_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
45 p_new_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
46 p_old_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
47 p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
48 p_old_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
49 p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
50 p_old_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
51 p_new_org_id IN as_leads_all.org_id%type,
52 p_old_org_id IN as_leads_all.org_id%type,
53 p_trigger_mode IN VARCHAR2);
54 Procedure Lead_Lines_Trigger_Handler(
55 p_trigger_mode IN VARCHAR2,
56 p_new_lead_id IN as_lead_lines_all.lead_id%type,
57 p_old_lead_id IN as_lead_lines_all.lead_id%type,
58 p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
59 p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
60 p_new_last_update_date IN as_lead_lines_all.last_update_date%type,
61 p_old_last_update_date IN as_lead_lines_all.last_update_date%type,
62 p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
63 p_old_last_updated_by IN as_lead_lines_all.last_updated_by%type,
64 p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
65 p_old_last_update_login IN as_lead_lines_all.last_update_login%type,
66 p_new_creation_date IN as_lead_lines_all.creation_date%type,
67 p_old_creation_date IN as_lead_lines_all.creation_date%type,
68 p_new_created_by IN as_lead_lines_all.created_by%type,
69 p_old_created_by IN as_lead_lines_all.created_by%type,
70
71 p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
72 p_old_interest_type_id IN as_lead_lines_all.interest_type_id%type,
73 p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
74 p_old_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
75 p_new_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
76 p_old_second_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
77 p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
78 p_old_product_category_id IN as_lead_lines_all.product_category_id%type,
79 p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
80 p_old_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
81 p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
82 p_old_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
83 p_new_organization_id IN as_lead_lines_all.organization_id%type,
84 p_old_organization_id IN as_lead_lines_all.organization_id%type,
85 p_new_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
86 p_old_source_promotion_id IN as_lead_lines_all.source_promotion_id%type,
87 p_new_offer_id IN as_lead_lines_all.offer_id%type,
88 p_old_offer_id IN as_lead_lines_all.offer_id%type,
89 p_new_org_id IN as_lead_lines_all.org_id%type,
90 p_old_org_id IN as_lead_lines_all.org_id%type,
91 p_new_forecast_date IN as_lead_lines_all.forecast_date%type,
92 p_old_forecast_date IN as_lead_lines_all.forecast_date%type,
93 p_new_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
94 p_old_rolling_forecast_flag IN as_lead_lines_all.rolling_forecast_flag%type,
95 p_new_total_amount IN as_lead_lines_all.total_amount%type ,
96 p_old_total_amount IN as_lead_lines_all.total_amount%type ,
97 p_new_quantity IN as_lead_lines_all.quantity%type ,
98 p_old_quantity IN as_lead_lines_all.quantity%type ,
99 p_new_uom IN as_lead_lines_all.UOM_CODE%type,
100 p_old_uom IN as_lead_lines_all.UOM_CODE%type);
101
102
103 PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
104 p_new_lead_id IN as_sales_credits.lead_id%type,
105 p_old_lead_id IN as_sales_credits.lead_id%type,
106
107 p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108 p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109
110 p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111 p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112 p_new_last_update_date IN as_sales_credits.last_update_date%type,
113 p_old_last_update_date IN as_sales_credits.last_update_date%type,
114
115 p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116 p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
117
118 p_new_last_update_login IN as_sales_credits.last_update_login%type,
119 p_old_last_update_login IN as_sales_credits.last_update_login%type,
120
121 p_new_creation_date IN as_sales_credits.creation_date%type,
122 p_old_creation_date IN as_sales_credits.creation_date%type,
123
124 p_new_created_by IN as_sales_credits.created_by%type,
125 p_old_created_by IN as_sales_credits.created_by%type,
126
127 p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128 p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129 p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130 p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131 p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132 p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133 p_new_credit_percent IN as_sales_credits.credit_percent%type,
134 p_old_credit_percent IN as_sales_credits.credit_percent%type,
135 p_new_credit_amount IN as_sales_credits.credit_amount%type,
136 p_old_credit_amount IN as_sales_credits.credit_amount%type,
137 p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138 p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139 p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140 p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141 p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
142 p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);
143
144 PROCEDURE GET_VALUE(p_old_last_update_date IN DATE,
145 p_new_last_update_date IN DATE,
146 IsInsert OUT NOCOPY NUMBER);
147
148 End AS_LEADS_AUDIT_PKG ;