eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_LEADS_AUDIT_PKG dependencies on AS_LEADS_ALL

Line 12: p_new_last_update_date IN as_leads_all.last_update_date%type ,

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,

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

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

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

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

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

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

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

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

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

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

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

Line 24: p_new_sales_stage_id IN as_leads_all.sales_stage_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,
28: p_new_win_probability IN as_leads_all.win_probability%type,

Line 25: p_old_sales_stage_id IN as_leads_all.sales_stage_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,
29: p_old_win_probability IN as_leads_all.win_probability%type,

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

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

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

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

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

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

Line 32: p_new_currency_code IN as_leads_all.currency_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,
36: p_new_security_group_id IN as_leads_all.security_group_id%type,

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

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

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

Line 36: p_new_security_group_id IN as_leads_all.security_group_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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 55: p_old_owner_sales_group_id IN as_leads_all.owner_sales_group_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)
59: IS

Line 56: p_new_org_id IN as_leads_all.org_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
60: l_LOG_ID NUMBER;

Line 57: p_old_org_id IN as_leads_all.org_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;
61: IsInsert NUMBER :=0;