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_SC_DENORM_TRG dependencies on AS_LEADS_ALL

Line 5: p_new_last_update_date IN as_leads_all.last_update_date%type ,

1: Package AS_SC_DENORM_TRG AUTHID CURRENT_USER AS
2: /* $Header: asxopdts.pls 115.28 2004/01/16 11:23:14 sumahali ship $ */
3:
4: Procedure Leads_Trigger_Handler(
5: p_new_last_update_date IN as_leads_all.last_update_date%type ,
6: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
7: p_new_creation_date IN as_leads_all.creation_date%type,
8: p_new_created_by IN as_leads_all.created_by%type,
9: p_new_last_update_login IN as_leads_all.last_update_login%type,

Line 6: p_new_last_updated_by IN as_leads_all.last_updated_by%type,

2: /* $Header: asxopdts.pls 115.28 2004/01/16 11:23:14 sumahali ship $ */
3:
4: Procedure Leads_Trigger_Handler(
5: p_new_last_update_date IN as_leads_all.last_update_date%type ,
6: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
7: p_new_creation_date IN as_leads_all.creation_date%type,
8: p_new_created_by IN as_leads_all.created_by%type,
9: p_new_last_update_login IN as_leads_all.last_update_login%type,
10: p_new_customer_id IN as_leads_all.customer_id%type,

Line 7: p_new_creation_date IN as_leads_all.creation_date%type,

3:
4: Procedure Leads_Trigger_Handler(
5: p_new_last_update_date IN as_leads_all.last_update_date%type ,
6: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
7: p_new_creation_date IN as_leads_all.creation_date%type,
8: p_new_created_by IN as_leads_all.created_by%type,
9: p_new_last_update_login IN as_leads_all.last_update_login%type,
10: p_new_customer_id IN as_leads_all.customer_id%type,
11: p_new_address_id IN as_leads_all.address_id%type,

Line 8: p_new_created_by IN as_leads_all.created_by%type,

4: Procedure Leads_Trigger_Handler(
5: p_new_last_update_date IN as_leads_all.last_update_date%type ,
6: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
7: p_new_creation_date IN as_leads_all.creation_date%type,
8: p_new_created_by IN as_leads_all.created_by%type,
9: p_new_last_update_login IN as_leads_all.last_update_login%type,
10: p_new_customer_id IN as_leads_all.customer_id%type,
11: p_new_address_id IN as_leads_all.address_id%type,
12: p_new_lead_id IN as_leads_all.lead_id%type,

Line 9: p_new_last_update_login IN as_leads_all.last_update_login%type,

5: p_new_last_update_date IN as_leads_all.last_update_date%type ,
6: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
7: p_new_creation_date IN as_leads_all.creation_date%type,
8: p_new_created_by IN as_leads_all.created_by%type,
9: p_new_last_update_login IN as_leads_all.last_update_login%type,
10: p_new_customer_id IN as_leads_all.customer_id%type,
11: p_new_address_id IN as_leads_all.address_id%type,
12: p_new_lead_id IN as_leads_all.lead_id%type,
13: p_new_lead_number IN as_leads_all.lead_number%type,

Line 10: p_new_customer_id IN as_leads_all.customer_id%type,

6: p_new_last_updated_by IN as_leads_all.last_updated_by%type,
7: p_new_creation_date IN as_leads_all.creation_date%type,
8: p_new_created_by IN as_leads_all.created_by%type,
9: p_new_last_update_login IN as_leads_all.last_update_login%type,
10: p_new_customer_id IN as_leads_all.customer_id%type,
11: p_new_address_id IN as_leads_all.address_id%type,
12: p_new_lead_id IN as_leads_all.lead_id%type,
13: p_new_lead_number IN as_leads_all.lead_number%type,
14: p_new_description IN as_leads_all.description%type,

Line 11: p_new_address_id IN as_leads_all.address_id%type,

7: p_new_creation_date IN as_leads_all.creation_date%type,
8: p_new_created_by IN as_leads_all.created_by%type,
9: p_new_last_update_login IN as_leads_all.last_update_login%type,
10: p_new_customer_id IN as_leads_all.customer_id%type,
11: p_new_address_id IN as_leads_all.address_id%type,
12: p_new_lead_id IN as_leads_all.lead_id%type,
13: p_new_lead_number IN as_leads_all.lead_number%type,
14: p_new_description IN as_leads_all.description%type,
15: p_new_decision_date IN as_leads_all.decision_date%type ,

Line 12: p_new_lead_id IN as_leads_all.lead_id%type,

8: p_new_created_by IN as_leads_all.created_by%type,
9: p_new_last_update_login IN as_leads_all.last_update_login%type,
10: p_new_customer_id IN as_leads_all.customer_id%type,
11: p_new_address_id IN as_leads_all.address_id%type,
12: p_new_lead_id IN as_leads_all.lead_id%type,
13: p_new_lead_number IN as_leads_all.lead_number%type,
14: p_new_description IN as_leads_all.description%type,
15: p_new_decision_date IN as_leads_all.decision_date%type ,
16: p_old_decision_date IN as_leads_all.decision_date%type ,

Line 13: p_new_lead_number IN as_leads_all.lead_number%type,

9: p_new_last_update_login IN as_leads_all.last_update_login%type,
10: p_new_customer_id IN as_leads_all.customer_id%type,
11: p_new_address_id IN as_leads_all.address_id%type,
12: p_new_lead_id IN as_leads_all.lead_id%type,
13: p_new_lead_number IN as_leads_all.lead_number%type,
14: p_new_description IN as_leads_all.description%type,
15: p_new_decision_date IN as_leads_all.decision_date%type ,
16: 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,

Line 14: p_new_description IN as_leads_all.description%type,

10: p_new_customer_id IN as_leads_all.customer_id%type,
11: p_new_address_id IN as_leads_all.address_id%type,
12: p_new_lead_id IN as_leads_all.lead_id%type,
13: p_new_lead_number IN as_leads_all.lead_number%type,
14: p_new_description IN as_leads_all.description%type,
15: p_new_decision_date IN as_leads_all.decision_date%type ,
16: 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_new_source_promotion_id IN as_leads_all.source_promotion_id%type,

Line 15: p_new_decision_date IN as_leads_all.decision_date%type ,

11: p_new_address_id IN as_leads_all.address_id%type,
12: p_new_lead_id IN as_leads_all.lead_id%type,
13: p_new_lead_number IN as_leads_all.lead_number%type,
14: p_new_description IN as_leads_all.description%type,
15: p_new_decision_date IN as_leads_all.decision_date%type ,
16: 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_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
19: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,

Line 16: p_old_decision_date IN as_leads_all.decision_date%type ,

12: p_new_lead_id IN as_leads_all.lead_id%type,
13: p_new_lead_number IN as_leads_all.lead_number%type,
14: p_new_description IN as_leads_all.description%type,
15: p_new_decision_date IN as_leads_all.decision_date%type ,
16: 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_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
19: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
20: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,

Line 17: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,

13: p_new_lead_number IN as_leads_all.lead_number%type,
14: p_new_description IN as_leads_all.description%type,
15: p_new_decision_date IN as_leads_all.decision_date%type ,
16: 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_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
19: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
20: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
21: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,

Line 18: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,

14: p_new_description IN as_leads_all.description%type,
15: p_new_decision_date IN as_leads_all.decision_date%type ,
16: 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_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
19: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
20: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
21: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
22: p_new_win_probability IN as_leads_all.win_probability%type,

Line 19: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,

15: p_new_decision_date IN as_leads_all.decision_date%type ,
16: 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_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
19: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
20: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
21: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
22: p_new_win_probability IN as_leads_all.win_probability%type,
23: p_old_win_probability IN as_leads_all.win_probability%type,

Line 20: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,

16: 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_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
19: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
20: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
21: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
22: p_new_win_probability IN as_leads_all.win_probability%type,
23: p_old_win_probability IN as_leads_all.win_probability%type,
24: p_new_status IN as_leads_all.status%type,

Line 21: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,

17: p_new_sales_stage_id IN as_leads_all.sales_stage_id%type,
18: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
19: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
20: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
21: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
22: p_new_win_probability IN as_leads_all.win_probability%type,
23: p_old_win_probability IN as_leads_all.win_probability%type,
24: p_new_status IN as_leads_all.status%type,
25: p_old_status IN as_leads_all.status%type,

Line 22: p_new_win_probability IN as_leads_all.win_probability%type,

18: p_new_source_promotion_id IN as_leads_all.source_promotion_id%type,
19: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
20: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
21: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
22: p_new_win_probability IN as_leads_all.win_probability%type,
23: p_old_win_probability IN as_leads_all.win_probability%type,
24: p_new_status IN as_leads_all.status%type,
25: p_old_status IN as_leads_all.status%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,

Line 23: p_old_win_probability IN as_leads_all.win_probability%type,

19: p_new_close_competitor_id IN as_leads_all.close_competitor_id%type,
20: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
21: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
22: p_new_win_probability IN as_leads_all.win_probability%type,
23: p_old_win_probability IN as_leads_all.win_probability%type,
24: p_new_status IN as_leads_all.status%type,
25: p_old_status IN as_leads_all.status%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_new_lead_source_code IN as_leads_all.lead_source_code%type,

Line 24: p_new_status IN as_leads_all.status%type,

20: p_new_owner_salesforce_id IN as_leads_all.owner_salesforce_id%type,
21: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
22: p_new_win_probability IN as_leads_all.win_probability%type,
23: p_old_win_probability IN as_leads_all.win_probability%type,
24: p_new_status IN as_leads_all.status%type,
25: p_old_status IN as_leads_all.status%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
28: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,

Line 25: p_old_status IN as_leads_all.status%type,

21: p_new_owner_sales_group_id IN as_leads_all.owner_sales_group_id%type,
22: p_new_win_probability IN as_leads_all.win_probability%type,
23: p_old_win_probability IN as_leads_all.win_probability%type,
24: p_new_status IN as_leads_all.status%type,
25: p_old_status IN as_leads_all.status%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
28: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
29: p_new_currency_code IN as_leads_all.currency_code%type,

Line 26: p_new_channel_code IN as_leads_all.channel_code%type,

22: p_new_win_probability IN as_leads_all.win_probability%type,
23: p_old_win_probability IN as_leads_all.win_probability%type,
24: p_new_status IN as_leads_all.status%type,
25: p_old_status IN as_leads_all.status%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
28: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
29: p_new_currency_code IN as_leads_all.currency_code%type,
30: p_old_currency_code IN as_leads_all.currency_code%type,

Line 27: p_new_lead_source_code IN as_leads_all.lead_source_code%type,

23: p_old_win_probability IN as_leads_all.win_probability%type,
24: p_new_status IN as_leads_all.status%type,
25: p_old_status IN as_leads_all.status%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
28: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
29: p_new_currency_code IN as_leads_all.currency_code%type,
30: p_old_currency_code IN as_leads_all.currency_code%type,
31: p_new_total_amount IN as_leads_all.total_amount%type,

Line 28: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,

24: p_new_status IN as_leads_all.status%type,
25: p_old_status IN as_leads_all.status%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
28: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
29: p_new_currency_code IN as_leads_all.currency_code%type,
30: p_old_currency_code IN as_leads_all.currency_code%type,
31: p_new_total_amount IN as_leads_all.total_amount%type,
32: p_old_total_amount IN as_leads_all.total_amount%type,

Line 29: p_new_currency_code IN as_leads_all.currency_code%type,

25: p_old_status IN as_leads_all.status%type,
26: p_new_channel_code IN as_leads_all.channel_code%type,
27: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
28: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
29: p_new_currency_code IN as_leads_all.currency_code%type,
30: p_old_currency_code IN as_leads_all.currency_code%type,
31: p_new_total_amount IN as_leads_all.total_amount%type,
32: p_old_total_amount IN as_leads_all.total_amount%type,
33: p_old_lead_id IN as_leads_all.lead_id%type,

Line 30: 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_new_lead_source_code IN as_leads_all.lead_source_code%type,
28: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
29: p_new_currency_code IN as_leads_all.currency_code%type,
30: p_old_currency_code IN as_leads_all.currency_code%type,
31: p_new_total_amount IN as_leads_all.total_amount%type,
32: p_old_total_amount IN as_leads_all.total_amount%type,
33: p_old_lead_id IN as_leads_all.lead_id%type,
34: p_new_org_id IN as_leads_all.org_id%type,

Line 31: p_new_total_amount IN as_leads_all.total_amount%type,

27: p_new_lead_source_code IN as_leads_all.lead_source_code%type,
28: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
29: p_new_currency_code IN as_leads_all.currency_code%type,
30: p_old_currency_code IN as_leads_all.currency_code%type,
31: p_new_total_amount IN as_leads_all.total_amount%type,
32: p_old_total_amount IN as_leads_all.total_amount%type,
33: p_old_lead_id IN as_leads_all.lead_id%type,
34: p_new_org_id IN as_leads_all.org_id%type,
35: p_new_deleted_flag IN as_leads_all.deleted_flag%type,

Line 32: p_old_total_amount IN as_leads_all.total_amount%type,

28: p_new_orig_system_reference IN as_leads_all.orig_system_reference%type,
29: p_new_currency_code IN as_leads_all.currency_code%type,
30: p_old_currency_code IN as_leads_all.currency_code%type,
31: p_new_total_amount IN as_leads_all.total_amount%type,
32: p_old_total_amount IN as_leads_all.total_amount%type,
33: p_old_lead_id IN as_leads_all.lead_id%type,
34: p_new_org_id IN as_leads_all.org_id%type,
35: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
36: p_new_parent_project IN as_leads_all.parent_project%type,

Line 33: p_old_lead_id IN as_leads_all.lead_id%type,

29: p_new_currency_code IN as_leads_all.currency_code%type,
30: p_old_currency_code IN as_leads_all.currency_code%type,
31: p_new_total_amount IN as_leads_all.total_amount%type,
32: p_old_total_amount IN as_leads_all.total_amount%type,
33: p_old_lead_id IN as_leads_all.lead_id%type,
34: p_new_org_id IN as_leads_all.org_id%type,
35: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
36: p_new_parent_project IN as_leads_all.parent_project%type,
37: p_new_close_reason IN as_leads_all.close_reason%type,

Line 34: p_new_org_id IN as_leads_all.org_id%type,

30: p_old_currency_code IN as_leads_all.currency_code%type,
31: p_new_total_amount IN as_leads_all.total_amount%type,
32: p_old_total_amount IN as_leads_all.total_amount%type,
33: p_old_lead_id IN as_leads_all.lead_id%type,
34: p_new_org_id IN as_leads_all.org_id%type,
35: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
36: p_new_parent_project IN as_leads_all.parent_project%type,
37: p_new_close_reason IN as_leads_all.close_reason%type,
38: p_new_attr_category IN as_sales_credits_denorm.attribute_category%type,

Line 35: p_new_deleted_flag IN as_leads_all.deleted_flag%type,

31: p_new_total_amount IN as_leads_all.total_amount%type,
32: p_old_total_amount IN as_leads_all.total_amount%type,
33: p_old_lead_id IN as_leads_all.lead_id%type,
34: p_new_org_id IN as_leads_all.org_id%type,
35: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
36: p_new_parent_project IN as_leads_all.parent_project%type,
37: p_new_close_reason IN as_leads_all.close_reason%type,
38: p_new_attr_category IN as_sales_credits_denorm.attribute_category%type,
39: p_new_attr1 IN as_sales_credits_denorm.attribute1%type,

Line 36: p_new_parent_project IN as_leads_all.parent_project%type,

32: p_old_total_amount IN as_leads_all.total_amount%type,
33: p_old_lead_id IN as_leads_all.lead_id%type,
34: p_new_org_id IN as_leads_all.org_id%type,
35: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
36: p_new_parent_project IN as_leads_all.parent_project%type,
37: p_new_close_reason IN as_leads_all.close_reason%type,
38: p_new_attr_category IN as_sales_credits_denorm.attribute_category%type,
39: p_new_attr1 IN as_sales_credits_denorm.attribute1%type,
40: p_new_attr2 IN as_sales_credits_denorm.attribute1%type,

Line 37: p_new_close_reason IN as_leads_all.close_reason%type,

33: p_old_lead_id IN as_leads_all.lead_id%type,
34: p_new_org_id IN as_leads_all.org_id%type,
35: p_new_deleted_flag IN as_leads_all.deleted_flag%type,
36: p_new_parent_project IN as_leads_all.parent_project%type,
37: p_new_close_reason IN as_leads_all.close_reason%type,
38: p_new_attr_category IN as_sales_credits_denorm.attribute_category%type,
39: p_new_attr1 IN as_sales_credits_denorm.attribute1%type,
40: p_new_attr2 IN as_sales_credits_denorm.attribute1%type,
41: p_new_attr3 IN as_sales_credits_denorm.attribute1%type,