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,
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,
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,
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,
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,
42 p_new_attr4 IN as_sales_credits_denorm.attribute1%type,
43 p_new_attr5 IN as_sales_credits_denorm.attribute1%type,
44 p_new_attr6 IN as_sales_credits_denorm.attribute1%type,
45 p_new_attr7 IN as_sales_credits_denorm.attribute1%type,
46 p_new_attr8 IN as_sales_credits_denorm.attribute1%type,
47 p_new_attr9 IN as_sales_credits_denorm.attribute1%type,
48 p_new_attr10 IN as_sales_credits_denorm.attribute1%type,
49 p_new_attr11 IN as_sales_credits_denorm.attribute1%type,
50 p_new_attr12 IN as_sales_credits_denorm.attribute1%type,
51 p_new_attr13 IN as_sales_credits_denorm.attribute1%type,
52 p_new_attr14 IN as_sales_credits_denorm.attribute1%type,
53 p_new_attr15 IN as_sales_credits_denorm.attribute1%type,
54 p_new_sales_methodology_id IN as_sales_credits_denorm.sales_methodology_id%type,
55 p_trigger_mode IN VARCHAR2);
56
57 Procedure Lead_Lines_Trigger_Handler(
58 p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,
59 p_new_last_updated_by IN as_lead_lines_all.last_updated_by%type,
60 p_new_creation_date IN as_lead_lines_all.creation_date%type,
61 p_new_created_by IN as_lead_lines_all.created_by%type,
62 p_new_last_update_login IN as_lead_lines_all.last_update_login%type,
63 p_new_lead_id IN as_lead_lines_all.lead_id%type,
64 p_new_lead_line_id IN as_lead_lines_all.lead_line_id%type,
65 p_new_interest_type_id IN as_lead_lines_all.interest_type_id%type,
66 p_new_primary_interest_code_id IN as_lead_lines_all.primary_interest_code_id%type,
67 p_new_sec_interest_code_id IN as_lead_lines_all.secondary_interest_code_id%type,
68 p_new_product_category_id IN as_lead_lines_all.product_category_id%type,
69 p_new_product_cat_set_id IN as_lead_lines_all.product_cat_set_id%type,
70 p_new_total_amount IN as_lead_lines_all.total_amount%type,
71 p_old_total_amount IN as_lead_lines_all.total_amount%type,
72 p_old_lead_line_id IN as_lead_lines_all.lead_line_id%type,
73 p_new_quantity IN as_lead_lines_all.quantity%type,
74 p_new_uom_code IN as_lead_lines_all.uom_code%type,
75 p_new_inventory_item_id IN as_lead_lines_all.inventory_item_id%type,
76 p_new_organization_id IN as_lead_lines_all.organization_id%type,
77 p_old_frcst_date IN as_lead_lines_all.forecast_date%type,
78 p_old_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
79 p_new_frcst_date IN as_lead_lines_all.forecast_date%type,
80 p_new_rolling_frcst_flg IN as_lead_lines_all.rolling_forecast_flag%type,
81 p_trigger_mode IN VARCHAR2);
82
83 Procedure Sales_Credit_Trg_Handler(
84 p_new_sales_credit_id IN NUMBER,
85 p_new_last_update_date IN DATE,
86 p_new_last_updated_by IN NUMBER,
87 p_new_creation_date IN DATE,
88 p_new_created_by IN NUMBER,
89 p_new_last_update_login IN NUMBER,
90 p_new_request_id IN NUMBER,
91 p_new_lead_id IN NUMBER,
92 p_new_lead_line_id IN NUMBER,
93 p_new_salesforce_id IN NUMBER,
94 p_new_person_id IN NUMBER,
95 p_new_salesgroup_id IN NUMBER,
96 p_new_credit_amount IN NUMBER,
97 p_new_credit_percent IN NUMBER,
98 p_old_sales_credit_id IN NUMBER,
99 p_new_credit_type_id IN NUMBER,
100 p_new_partner_address_id IN NUMBER,
101 p_old_partner_customer_id IN NUMBER,
102 p_new_partner_customer_id IN NUMBER,
103 p_opp_worst_forecast_amount IN NUMBER,
104 p_opp_forecast_amount IN NUMBER,
105 p_opp_best_forecast_amount IN NUMBER,
106 p_trigger_mode IN OUT NOCOPY VARCHAR2);
107
108 Procedure convert_amounts(p_from_currency IN Varchar2,
109 p_decision_date IN Date,
110 p_ctotal_amt IN OUT NOCOPY Number,
111 p_csc_amt IN OUT NOCOPY Number,
112 p_cwon_amt IN OUT NOCOPY Number,
113 p_cweighted_amt IN OUT NOCOPY Number,
114 p_status_flg OUT NOCOPY Number);
115
116
117 Procedure Fetch_Interest_Info (
118 p_interest_type_id IN Number,
119 p_interest_type OUT NOCOPY Varchar2,
120 p_primary_interest_code_id IN Number,
121 p_primary_interest_code OUT NOCOPY Varchar2,
122 p_secondary_interest_code_id IN Number,
123 p_secondary_interest_code OUT NOCOPY Varchar2);
124
125
126
127 INVALID_FORECAST_CALENDAR EXCEPTION;
128 INVALID_PERIOD EXCEPTION;
129
130 End AS_SC_DENORM_TRG ;