8: --
9: --
10:
11: Procedure Leads_Trigger_Handler(
12: p_new_last_update_date IN as_leads_all.last_update_date%type ,
13: p_old_last_update_date IN as_leads_all.last_update_date%type ,
14: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
15: p_new_creation_date IN as_leads_all.creation_date%type,
16: p_new_created_by IN as_leads_all.created_by%type,
9: --
10:
11: Procedure Leads_Trigger_Handler(
12: p_new_last_update_date IN as_leads_all.last_update_date%type ,
13: p_old_last_update_date IN as_leads_all.last_update_date%type ,
14: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
15: p_new_creation_date IN as_leads_all.creation_date%type,
16: p_new_created_by IN as_leads_all.created_by%type,
17: p_new_last_update_login IN as_leads_all.last_update_login%type,
10:
11: Procedure Leads_Trigger_Handler(
12: p_new_last_update_date IN as_leads_all.last_update_date%type ,
13: p_old_last_update_date IN as_leads_all.last_update_date%type ,
14: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
15: p_new_creation_date IN as_leads_all.creation_date%type,
16: p_new_created_by IN as_leads_all.created_by%type,
17: p_new_last_update_login IN as_leads_all.last_update_login%type,
18: p_new_lead_id IN as_leads_all.lead_id%type,
11: Procedure Leads_Trigger_Handler(
12: p_new_last_update_date IN as_leads_all.last_update_date%type ,
13: p_old_last_update_date IN as_leads_all.last_update_date%type ,
14: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
15: p_new_creation_date IN as_leads_all.creation_date%type,
16: p_new_created_by IN as_leads_all.created_by%type,
17: p_new_last_update_login IN as_leads_all.last_update_login%type,
18: p_new_lead_id IN as_leads_all.lead_id%type,
19: p_old_lead_id IN as_leads_all.lead_id%type,
12: p_new_last_update_date IN as_leads_all.last_update_date%type ,
13: p_old_last_update_date IN as_leads_all.last_update_date%type ,
14: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
15: p_new_creation_date IN as_leads_all.creation_date%type,
16: p_new_created_by IN as_leads_all.created_by%type,
17: p_new_last_update_login IN as_leads_all.last_update_login%type,
18: p_new_lead_id IN as_leads_all.lead_id%type,
19: p_old_lead_id IN as_leads_all.lead_id%type,
20: p_new_address_id IN as_leads_all.address_id%type,
13: p_old_last_update_date IN as_leads_all.last_update_date%type ,
14: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
15: p_new_creation_date IN as_leads_all.creation_date%type,
16: p_new_created_by IN as_leads_all.created_by%type,
17: p_new_last_update_login IN as_leads_all.last_update_login%type,
18: p_new_lead_id IN as_leads_all.lead_id%type,
19: p_old_lead_id IN as_leads_all.lead_id%type,
20: p_new_address_id IN as_leads_all.address_id%type,
21: p_old_address_id IN as_leads_all.address_id%type,
14: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
15: p_new_creation_date IN as_leads_all.creation_date%type,
16: p_new_created_by IN as_leads_all.created_by%type,
17: p_new_last_update_login IN as_leads_all.last_update_login%type,
18: p_new_lead_id IN as_leads_all.lead_id%type,
19: p_old_lead_id IN as_leads_all.lead_id%type,
20: p_new_address_id IN as_leads_all.address_id%type,
21: p_old_address_id IN as_leads_all.address_id%type,
22: p_new_status IN as_leads_all.status%type,
15: p_new_creation_date IN as_leads_all.creation_date%type,
16: p_new_created_by IN as_leads_all.created_by%type,
17: p_new_last_update_login IN as_leads_all.last_update_login%type,
18: p_new_lead_id IN as_leads_all.lead_id%type,
19: p_old_lead_id IN as_leads_all.lead_id%type,
20: p_new_address_id IN as_leads_all.address_id%type,
21: p_old_address_id IN as_leads_all.address_id%type,
22: p_new_status IN as_leads_all.status%type,
23: p_old_status IN as_leads_all.status%type,
16: p_new_created_by IN as_leads_all.created_by%type,
17: p_new_last_update_login IN as_leads_all.last_update_login%type,
18: p_new_lead_id IN as_leads_all.lead_id%type,
19: p_old_lead_id IN as_leads_all.lead_id%type,
20: p_new_address_id IN as_leads_all.address_id%type,
21: p_old_address_id IN as_leads_all.address_id%type,
22: p_new_status IN as_leads_all.status%type,
23: p_old_status IN as_leads_all.status%type,
24: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
17: p_new_last_update_login IN as_leads_all.last_update_login%type,
18: p_new_lead_id IN as_leads_all.lead_id%type,
19: p_old_lead_id IN as_leads_all.lead_id%type,
20: p_new_address_id IN as_leads_all.address_id%type,
21: p_old_address_id IN as_leads_all.address_id%type,
22: p_new_status IN as_leads_all.status%type,
23: p_old_status IN as_leads_all.status%type,
24: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
25: p_old_sales_stage_id IN as_leads_all.sales_stage_id%type,
18: p_new_lead_id IN as_leads_all.lead_id%type,
19: p_old_lead_id IN as_leads_all.lead_id%type,
20: p_new_address_id IN as_leads_all.address_id%type,
21: p_old_address_id IN as_leads_all.address_id%type,
22: p_new_status IN as_leads_all.status%type,
23: p_old_status IN as_leads_all.status%type,
24: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
25: p_old_sales_stage_id IN as_leads_all.sales_stage_id%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
19: p_old_lead_id IN as_leads_all.lead_id%type,
20: p_new_address_id IN as_leads_all.address_id%type,
21: p_old_address_id IN as_leads_all.address_id%type,
22: p_new_status IN as_leads_all.status%type,
23: p_old_status IN as_leads_all.status%type,
24: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
25: p_old_sales_stage_id IN as_leads_all.sales_stage_id%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_old_channel_code IN as_leads_all.channel_code%type,
20: p_new_address_id IN as_leads_all.address_id%type,
21: p_old_address_id IN as_leads_all.address_id%type,
22: p_new_status IN as_leads_all.status%type,
23: p_old_status IN as_leads_all.status%type,
24: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
25: p_old_sales_stage_id IN as_leads_all.sales_stage_id%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_old_channel_code IN as_leads_all.channel_code%type,
28: p_new_win_probability IN as_leads_all.win_probability%type,
21: p_old_address_id IN as_leads_all.address_id%type,
22: p_new_status IN as_leads_all.status%type,
23: p_old_status IN as_leads_all.status%type,
24: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
25: p_old_sales_stage_id IN as_leads_all.sales_stage_id%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_old_channel_code IN as_leads_all.channel_code%type,
28: p_new_win_probability IN as_leads_all.win_probability%type,
29: p_old_win_probability IN as_leads_all.win_probability%type,
22: p_new_status IN as_leads_all.status%type,
23: p_old_status IN as_leads_all.status%type,
24: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
25: p_old_sales_stage_id IN as_leads_all.sales_stage_id%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_old_channel_code IN as_leads_all.channel_code%type,
28: p_new_win_probability IN as_leads_all.win_probability%type,
29: p_old_win_probability IN as_leads_all.win_probability%type,
30: p_new_decision_date IN as_leads_all.decision_date%type ,
23: p_old_status IN as_leads_all.status%type,
24: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
25: p_old_sales_stage_id IN as_leads_all.sales_stage_id%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_old_channel_code IN as_leads_all.channel_code%type,
28: p_new_win_probability IN as_leads_all.win_probability%type,
29: p_old_win_probability IN as_leads_all.win_probability%type,
30: p_new_decision_date IN as_leads_all.decision_date%type ,
31: p_old_decision_date IN as_leads_all.decision_date%type ,
24: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
25: p_old_sales_stage_id IN as_leads_all.sales_stage_id%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_old_channel_code IN as_leads_all.channel_code%type,
28: p_new_win_probability IN as_leads_all.win_probability%type,
29: p_old_win_probability IN as_leads_all.win_probability%type,
30: p_new_decision_date IN as_leads_all.decision_date%type ,
31: p_old_decision_date IN as_leads_all.decision_date%type ,
32: p_new_currency_code IN as_leads_all.currency_code%type,
25: p_old_sales_stage_id IN as_leads_all.sales_stage_id%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_old_channel_code IN as_leads_all.channel_code%type,
28: p_new_win_probability IN as_leads_all.win_probability%type,
29: p_old_win_probability IN as_leads_all.win_probability%type,
30: p_new_decision_date IN as_leads_all.decision_date%type ,
31: p_old_decision_date IN as_leads_all.decision_date%type ,
32: p_new_currency_code IN as_leads_all.currency_code%type,
33: p_old_currency_code IN as_leads_all.currency_code%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_old_channel_code IN as_leads_all.channel_code%type,
28: p_new_win_probability IN as_leads_all.win_probability%type,
29: p_old_win_probability IN as_leads_all.win_probability%type,
30: p_new_decision_date IN as_leads_all.decision_date%type ,
31: p_old_decision_date IN as_leads_all.decision_date%type ,
32: p_new_currency_code IN as_leads_all.currency_code%type,
33: p_old_currency_code IN as_leads_all.currency_code%type,
34: p_new_total_amount IN as_leads_all.total_amount%type,
27: p_old_channel_code IN as_leads_all.channel_code%type,
28: p_new_win_probability IN as_leads_all.win_probability%type,
29: p_old_win_probability IN as_leads_all.win_probability%type,
30: p_new_decision_date IN as_leads_all.decision_date%type ,
31: p_old_decision_date IN as_leads_all.decision_date%type ,
32: p_new_currency_code IN as_leads_all.currency_code%type,
33: p_old_currency_code IN as_leads_all.currency_code%type,
34: p_new_total_amount IN as_leads_all.total_amount%type,
35: p_old_total_amount IN as_leads_all.total_amount%type,
28: p_new_win_probability IN as_leads_all.win_probability%type,
29: p_old_win_probability IN as_leads_all.win_probability%type,
30: p_new_decision_date IN as_leads_all.decision_date%type ,
31: p_old_decision_date IN as_leads_all.decision_date%type ,
32: p_new_currency_code IN as_leads_all.currency_code%type,
33: p_old_currency_code IN as_leads_all.currency_code%type,
34: p_new_total_amount IN as_leads_all.total_amount%type,
35: p_old_total_amount IN as_leads_all.total_amount%type,
36: p_new_security_group_id IN as_leads_all.security_group_id%type,
29: p_old_win_probability IN as_leads_all.win_probability%type,
30: p_new_decision_date IN as_leads_all.decision_date%type ,
31: p_old_decision_date IN as_leads_all.decision_date%type ,
32: p_new_currency_code IN as_leads_all.currency_code%type,
33: p_old_currency_code IN as_leads_all.currency_code%type,
34: p_new_total_amount IN as_leads_all.total_amount%type,
35: p_old_total_amount IN as_leads_all.total_amount%type,
36: p_new_security_group_id IN as_leads_all.security_group_id%type,
37: p_old_security_group_id IN as_leads_all.security_group_id%type,
30: p_new_decision_date IN as_leads_all.decision_date%type ,
31: p_old_decision_date IN as_leads_all.decision_date%type ,
32: p_new_currency_code IN as_leads_all.currency_code%type,
33: p_old_currency_code IN as_leads_all.currency_code%type,
34: p_new_total_amount IN as_leads_all.total_amount%type,
35: p_old_total_amount IN as_leads_all.total_amount%type,
36: p_new_security_group_id IN as_leads_all.security_group_id%type,
37: p_old_security_group_id IN as_leads_all.security_group_id%type,
38: p_new_customer_id IN as_leads_all.customer_id%type,
31: p_old_decision_date IN as_leads_all.decision_date%type ,
32: p_new_currency_code IN as_leads_all.currency_code%type,
33: p_old_currency_code IN as_leads_all.currency_code%type,
34: p_new_total_amount IN as_leads_all.total_amount%type,
35: p_old_total_amount IN as_leads_all.total_amount%type,
36: p_new_security_group_id IN as_leads_all.security_group_id%type,
37: p_old_security_group_id IN as_leads_all.security_group_id%type,
38: p_new_customer_id IN as_leads_all.customer_id%type,
39: p_old_customer_id IN as_leads_all.customer_id%type,
32: p_new_currency_code IN as_leads_all.currency_code%type,
33: p_old_currency_code IN as_leads_all.currency_code%type,
34: p_new_total_amount IN as_leads_all.total_amount%type,
35: p_old_total_amount IN as_leads_all.total_amount%type,
36: p_new_security_group_id IN as_leads_all.security_group_id%type,
37: p_old_security_group_id IN as_leads_all.security_group_id%type,
38: p_new_customer_id IN as_leads_all.customer_id%type,
39: p_old_customer_id IN as_leads_all.customer_id%type,
40: p_new_description IN as_leads_all.description%type,
33: p_old_currency_code IN as_leads_all.currency_code%type,
34: p_new_total_amount IN as_leads_all.total_amount%type,
35: p_old_total_amount IN as_leads_all.total_amount%type,
36: p_new_security_group_id IN as_leads_all.security_group_id%type,
37: p_old_security_group_id IN as_leads_all.security_group_id%type,
38: p_new_customer_id IN as_leads_all.customer_id%type,
39: p_old_customer_id IN as_leads_all.customer_id%type,
40: p_new_description IN as_leads_all.description%type,
41: p_old_description IN as_leads_all.description%type,
34: p_new_total_amount IN as_leads_all.total_amount%type,
35: p_old_total_amount IN as_leads_all.total_amount%type,
36: p_new_security_group_id IN as_leads_all.security_group_id%type,
37: p_old_security_group_id IN as_leads_all.security_group_id%type,
38: p_new_customer_id IN as_leads_all.customer_id%type,
39: p_old_customer_id IN as_leads_all.customer_id%type,
40: p_new_description IN as_leads_all.description%type,
41: p_old_description IN as_leads_all.description%type,
42: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
35: p_old_total_amount IN as_leads_all.total_amount%type,
36: p_new_security_group_id IN as_leads_all.security_group_id%type,
37: p_old_security_group_id IN as_leads_all.security_group_id%type,
38: p_new_customer_id IN as_leads_all.customer_id%type,
39: p_old_customer_id IN as_leads_all.customer_id%type,
40: p_new_description IN as_leads_all.description%type,
41: p_old_description IN as_leads_all.description%type,
42: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
43: p_old_source_promotion_id IN as_leads_all.source_promotion_id%type,
36: p_new_security_group_id IN as_leads_all.security_group_id%type,
37: p_old_security_group_id IN as_leads_all.security_group_id%type,
38: p_new_customer_id IN as_leads_all.customer_id%type,
39: p_old_customer_id IN as_leads_all.customer_id%type,
40: p_new_description IN as_leads_all.description%type,
41: p_old_description IN as_leads_all.description%type,
42: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
43: p_old_source_promotion_id IN as_leads_all.source_promotion_id%type,
44: p_new_offer_id IN as_leads_all.offer_id%type,
37: p_old_security_group_id IN as_leads_all.security_group_id%type,
38: p_new_customer_id IN as_leads_all.customer_id%type,
39: p_old_customer_id IN as_leads_all.customer_id%type,
40: p_new_description IN as_leads_all.description%type,
41: p_old_description IN as_leads_all.description%type,
42: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
43: p_old_source_promotion_id IN as_leads_all.source_promotion_id%type,
44: p_new_offer_id IN as_leads_all.offer_id%type,
45: p_old_offer_id IN as_leads_all.offer_id%type,
38: p_new_customer_id IN as_leads_all.customer_id%type,
39: p_old_customer_id IN as_leads_all.customer_id%type,
40: p_new_description IN as_leads_all.description%type,
41: p_old_description IN as_leads_all.description%type,
42: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
43: p_old_source_promotion_id IN as_leads_all.source_promotion_id%type,
44: p_new_offer_id IN as_leads_all.offer_id%type,
45: p_old_offer_id IN as_leads_all.offer_id%type,
46: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
39: p_old_customer_id IN as_leads_all.customer_id%type,
40: p_new_description IN as_leads_all.description%type,
41: p_old_description IN as_leads_all.description%type,
42: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
43: p_old_source_promotion_id IN as_leads_all.source_promotion_id%type,
44: p_new_offer_id IN as_leads_all.offer_id%type,
45: p_old_offer_id IN as_leads_all.offer_id%type,
46: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
47: p_old_close_competitor_id IN as_leads_all.close_competitor_id%type,
40: p_new_description IN as_leads_all.description%type,
41: p_old_description IN as_leads_all.description%type,
42: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
43: p_old_source_promotion_id IN as_leads_all.source_promotion_id%type,
44: p_new_offer_id IN as_leads_all.offer_id%type,
45: p_old_offer_id IN as_leads_all.offer_id%type,
46: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
47: p_old_close_competitor_id IN as_leads_all.close_competitor_id%type,
48: p_new_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
41: p_old_description IN as_leads_all.description%type,
42: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
43: p_old_source_promotion_id IN as_leads_all.source_promotion_id%type,
44: p_new_offer_id IN as_leads_all.offer_id%type,
45: p_old_offer_id IN as_leads_all.offer_id%type,
46: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
47: p_old_close_competitor_id IN as_leads_all.close_competitor_id%type,
48: p_new_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
49: p_old_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
42: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
43: p_old_source_promotion_id IN as_leads_all.source_promotion_id%type,
44: p_new_offer_id IN as_leads_all.offer_id%type,
45: p_old_offer_id IN as_leads_all.offer_id%type,
46: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
47: p_old_close_competitor_id IN as_leads_all.close_competitor_id%type,
48: p_new_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
49: p_old_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
50: p_new_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
43: p_old_source_promotion_id IN as_leads_all.source_promotion_id%type,
44: p_new_offer_id IN as_leads_all.offer_id%type,
45: p_old_offer_id IN as_leads_all.offer_id%type,
46: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
47: p_old_close_competitor_id IN as_leads_all.close_competitor_id%type,
48: p_new_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
49: p_old_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
50: p_new_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
51: p_old_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
44: p_new_offer_id IN as_leads_all.offer_id%type,
45: p_old_offer_id IN as_leads_all.offer_id%type,
46: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
47: p_old_close_competitor_id IN as_leads_all.close_competitor_id%type,
48: p_new_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
49: p_old_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
50: p_new_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
51: p_old_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
52: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
45: p_old_offer_id IN as_leads_all.offer_id%type,
46: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
47: p_old_close_competitor_id IN as_leads_all.close_competitor_id%type,
48: p_new_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
49: p_old_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
50: p_new_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
51: p_old_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
52: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
53: p_old_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
46: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
47: p_old_close_competitor_id IN as_leads_all.close_competitor_id%type,
48: p_new_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
49: p_old_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
50: p_new_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
51: p_old_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
52: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
53: p_old_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
54: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
47: p_old_close_competitor_id IN as_leads_all.close_competitor_id%type,
48: p_new_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
49: p_old_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
50: p_new_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
51: p_old_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
52: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
53: p_old_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
54: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
55: p_old_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
48: p_new_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
49: p_old_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
50: p_new_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
51: p_old_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
52: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
53: p_old_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
54: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
55: p_old_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
56: p_new_org_id IN as_leads_all.org_id%type,
49: p_old_vehicle_response_code IN as_leads_all.vehicle_response_code%type,
50: p_new_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
51: p_old_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
52: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
53: p_old_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
54: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
55: p_old_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
56: p_new_org_id IN as_leads_all.org_id%type,
57: p_old_org_id IN as_leads_all.org_id%type,
50: p_new_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
51: p_old_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
52: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
53: p_old_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
54: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
55: p_old_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
56: p_new_org_id IN as_leads_all.org_id%type,
57: p_old_org_id IN as_leads_all.org_id%type,
58: p_trigger_mode IN VARCHAR2)
51: p_old_sales_methodology_id IN as_leads_all.sales_methodology_id%type,
52: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
53: p_old_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
54: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
55: p_old_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
56: p_new_org_id IN as_leads_all.org_id%type,
57: p_old_org_id IN as_leads_all.org_id%type,
58: p_trigger_mode IN VARCHAR2)
59: IS
52: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
53: p_old_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
54: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
55: p_old_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
56: p_new_org_id IN as_leads_all.org_id%type,
57: p_old_org_id IN as_leads_all.org_id%type,
58: p_trigger_mode IN VARCHAR2)
59: IS
60: l_LOG_ID NUMBER;
53: p_old_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
54: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
55: p_old_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
56: p_new_org_id IN as_leads_all.org_id%type,
57: p_old_org_id IN as_leads_all.org_id%type,
58: p_trigger_mode IN VARCHAR2)
59: IS
60: l_LOG_ID NUMBER;
61: IsInsert NUMBER :=0;