1: Package AS_LEADS_AUDIT_PKG 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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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 ,
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 ,
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,
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,
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,
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,
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:
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,
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,
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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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(
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,
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,