DBA Data[Home] [Help]

APPS.AS_LEADS_AUDIT_PKG dependencies on AS_LEADS_ALL

Line 5: p_new_last_update_date IN as_leads_all.last_update_date%type ,

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,

Line 6: p_old_last_update_date IN as_leads_all.last_update_date%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,

Line 7: p_new_last_updated_by IN as_leads_all.last_updated_by%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,

Line 8: p_new_creation_date IN as_leads_all.creation_date%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,

Line 9: p_new_created_by IN as_leads_all.created_by%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,

Line 10: p_new_last_update_login IN as_leads_all.last_update_login%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,

Line 11: p_new_lead_id IN as_leads_all.lead_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,

Line 12: p_old_lead_id IN as_leads_all.lead_id%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,

Line 13: p_new_address_id IN as_leads_all.address_id%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,

Line 14: p_old_address_id IN as_leads_all.address_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,

Line 15: p_new_status IN as_leads_all.status%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,

Line 16: p_old_status IN as_leads_all.status%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,

Line 17: p_new_sales_stage_id IN as_leads_all.sales_stage_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,

Line 18: p_old_sales_stage_id IN as_leads_all.sales_stage_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,

Line 19: p_new_channel_code IN as_leads_all.channel_code%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 ,

Line 20: p_old_channel_code IN as_leads_all.channel_code%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 ,

Line 21: p_new_win_probability IN as_leads_all.win_probability%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,

Line 22: p_old_win_probability IN as_leads_all.win_probability%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,

Line 23: p_new_decision_date IN as_leads_all.decision_date%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,

Line 24: p_old_decision_date IN as_leads_all.decision_date%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,

Line 25: p_new_currency_code IN as_leads_all.currency_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:

Line 26: p_old_currency_code IN as_leads_all.currency_code%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,

Line 27: p_new_total_amount IN as_leads_all.total_amount%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,

Line 28: p_old_total_amount IN as_leads_all.total_amount%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:

Line 30: p_new_security_group_id IN as_leads_all.security_group_id%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,

Line 31: p_old_security_group_id IN as_leads_all.security_group_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,

Line 33: p_new_customer_id IN as_leads_all.customer_id%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,

Line 34: p_old_customer_id IN as_leads_all.customer_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,

Line 35: p_new_description IN as_leads_all.description%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,

Line 36: p_old_description IN as_leads_all.description%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,

Line 37: p_new_source_promotion_id IN as_leads_all.source_promotion_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,

Line 38: p_old_source_promotion_id IN as_leads_all.source_promotion_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,

Line 39: p_new_offer_id IN as_leads_all.offer_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,

Line 40: p_old_offer_id IN as_leads_all.offer_id%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,

Line 41: p_new_close_competitor_id IN as_leads_all.close_competitor_id%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,

Line 42: p_old_close_competitor_id IN as_leads_all.close_competitor_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,

Line 43: p_new_vehicle_response_code IN as_leads_all.vehicle_response_code%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,

Line 44: p_old_vehicle_response_code IN as_leads_all.vehicle_response_code%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,

Line 45: p_new_sales_methodology_id IN as_leads_all.sales_methodology_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,

Line 46: p_old_sales_methodology_id IN as_leads_all.sales_methodology_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,

Line 47: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_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,

Line 48: p_old_owner_salesforce_id IN as_leads_all.owner_salesforce_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,

Line 49: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_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);

Line 50: p_old_owner_sales_group_id IN as_leads_all.owner_sales_group_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(

Line 51: p_new_org_id IN as_leads_all.org_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,

Line 52: p_old_org_id IN as_leads_all.org_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,