100: p_old_uom IN as_lead_lines_all.UOM_CODE%type);
101:
102:
103: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
104: p_new_lead_id IN as_sales_credits.lead_id%type,
105: p_old_lead_id IN as_sales_credits.lead_id%type,
106:
107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
101:
102:
103: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
104: p_new_lead_id IN as_sales_credits.lead_id%type,
105: p_old_lead_id IN as_sales_credits.lead_id%type,
106:
107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:
103: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
104: p_new_lead_id IN as_sales_credits.lead_id%type,
105: p_old_lead_id IN as_sales_credits.lead_id%type,
106:
107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
104: p_new_lead_id IN as_sales_credits.lead_id%type,
105: p_old_lead_id IN as_sales_credits.lead_id%type,
106:
107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
106:
107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:
107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
117:
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
117:
118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
117:
118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,
120:
114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
117:
118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,
120:
121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
117:
118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,
120:
121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,
123:
117:
118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,
120:
121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,
123:
124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,
120:
121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,
123:
124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
126:
120:
121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,
123:
124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,
123:
124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
123:
124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
142: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
142: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);
143:
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
142: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);
143:
144: PROCEDURE GET_VALUE(p_old_last_update_date IN DATE,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
142: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);
143:
144: PROCEDURE GET_VALUE(p_old_last_update_date IN DATE,
145: p_new_last_update_date IN DATE,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
142: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);
143:
144: PROCEDURE GET_VALUE(p_old_last_update_date IN DATE,
145: p_new_last_update_date IN DATE,
146: IsInsert OUT NOCOPY NUMBER);