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_LOG

Line 73: update as_leads_log

69: -- dbms_output.put_line( 'p_new_last_update_date = '|| to_char(p_new_last_update_date, 'DD-MON-YYYY HH:MI:SSSSS') );
70:
71: IF (UPPER(nvl(FND_PROFILE.VALUE('AS_OPP_ENABLE_LOG'), 'N')) = 'Y' ) THEN
72:
73: update as_leads_log
74: set object_version_number = nvl(object_version_number,0) + 1, log_end_date = p_new_last_update_date,
75: current_log = 0,
76: log_active_days = trunc(p_new_last_update_date) - trunc (p_old_last_update_date),
77: endday_log_flag = decode (trunc(p_new_last_update_date), trunc (p_old_last_update_date), 'N', 'Y')

Line 83: -- dbms_output.put_line('Before Calling AS_LEADS_LOG_PKG.Insert_Row');

79: and last_update_date = p_old_last_update_date;
80:
81: IF ( p_trigger_mode = 'ON-INSERT' ) THEN
82: -- dbms_output.put_line('I am in ON-INSERT of Leads_Trigger_Handler');
83: -- dbms_output.put_line('Before Calling AS_LEADS_LOG_PKG.Insert_Row');
84:
85: AS_LEADS_LOG_PKG.Insert_Row(
86: px_LOG_ID => l_LOG_ID,
87: p_LEAD_ID => p_new_lead_id,

Line 85: AS_LEADS_LOG_PKG.Insert_Row(

81: IF ( p_trigger_mode = 'ON-INSERT' ) THEN
82: -- dbms_output.put_line('I am in ON-INSERT of Leads_Trigger_Handler');
83: -- dbms_output.put_line('Before Calling AS_LEADS_LOG_PKG.Insert_Row');
84:
85: AS_LEADS_LOG_PKG.Insert_Row(
86: px_LOG_ID => l_LOG_ID,
87: p_LEAD_ID => p_new_lead_id,
88: p_CREATED_BY => p_new_created_by,
89: p_CREATION_DATE => p_new_creation_date,

Line 131: FROM AS_LEADS_LOG

127: -- dbms_output.put_line('I am in ON-UPDATE of Leads_Trigger_Handler');
128: -- dbms_output.put_line('ISINSERT VALUE IS:'|| ISInsert);
129:
130: SELECT count(*) INTO l_lead_count
131: FROM AS_LEADS_LOG
132: WHERE LEAD_ID = p_old_lead_id;
133:
134: IF ( l_lead_count = 0 ) THEN
135: -- dbms_output.put_line('AS_LEADS_LOG: Not exists condition'|| l_lead_count);

Line 135: -- dbms_output.put_line('AS_LEADS_LOG: Not exists condition'|| l_lead_count);

131: FROM AS_LEADS_LOG
132: WHERE LEAD_ID = p_old_lead_id;
133:
134: IF ( l_lead_count = 0 ) THEN
135: -- dbms_output.put_line('AS_LEADS_LOG: Not exists condition'|| l_lead_count);
136: AS_LEADS_LOG_PKG.Insert_Row(
137: px_LOG_ID => l_LOG_ID,
138: p_LEAD_ID => p_new_lead_id,
139: p_CREATED_BY => p_new_created_by,

Line 136: AS_LEADS_LOG_PKG.Insert_Row(

132: WHERE LEAD_ID = p_old_lead_id;
133:
134: IF ( l_lead_count = 0 ) THEN
135: -- dbms_output.put_line('AS_LEADS_LOG: Not exists condition'|| l_lead_count);
136: AS_LEADS_LOG_PKG.Insert_Row(
137: px_LOG_ID => l_LOG_ID,
138: p_LEAD_ID => p_new_lead_id,
139: p_CREATED_BY => p_new_created_by,
140: p_CREATION_DATE => p_new_creation_date,

Line 176: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_address_id,0));

172: END IF;
173: ELSE
174: --DBMS_OUTPUT.DISABLE;
175:
176: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_address_id,0));
177: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old address value'|| nvl(p_old_address_id,0));
178: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_status,0));
179: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old status value'|| nvl(p_old_status,0));
180: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new stage value'|| nvl(p_new_sales_stage_id,0));

Line 177: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old address value'|| nvl(p_old_address_id,0));

173: ELSE
174: --DBMS_OUTPUT.DISABLE;
175:
176: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_address_id,0));
177: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old address value'|| nvl(p_old_address_id,0));
178: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_status,0));
179: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old status value'|| nvl(p_old_status,0));
180: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new stage value'|| nvl(p_new_sales_stage_id,0));
181: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old stage value'|| nvl(p_old_sales_stage_id,0));

Line 178: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_status,0));

174: --DBMS_OUTPUT.DISABLE;
175:
176: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_address_id,0));
177: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old address value'|| nvl(p_old_address_id,0));
178: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_status,0));
179: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old status value'|| nvl(p_old_status,0));
180: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new stage value'|| nvl(p_new_sales_stage_id,0));
181: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old stage value'|| nvl(p_old_sales_stage_id,0));
182: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new channel value'|| nvl(p_new_channel_code,0));

Line 179: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old status value'|| nvl(p_old_status,0));

175:
176: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_address_id,0));
177: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old address value'|| nvl(p_old_address_id,0));
178: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_status,0));
179: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old status value'|| nvl(p_old_status,0));
180: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new stage value'|| nvl(p_new_sales_stage_id,0));
181: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old stage value'|| nvl(p_old_sales_stage_id,0));
182: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new channel value'|| nvl(p_new_channel_code,0));
183: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old channel value'|| nvl(p_old_channel_code,0));

Line 180: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new stage value'|| nvl(p_new_sales_stage_id,0));

176: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_address_id,0));
177: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old address value'|| nvl(p_old_address_id,0));
178: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_status,0));
179: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old status value'|| nvl(p_old_status,0));
180: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new stage value'|| nvl(p_new_sales_stage_id,0));
181: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old stage value'|| nvl(p_old_sales_stage_id,0));
182: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new channel value'|| nvl(p_new_channel_code,0));
183: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old channel value'|| nvl(p_old_channel_code,0));
184: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new win value'|| nvl(p_new_win_probability,0));

Line 181: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old stage value'|| nvl(p_old_sales_stage_id,0));

177: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old address value'|| nvl(p_old_address_id,0));
178: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_status,0));
179: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old status value'|| nvl(p_old_status,0));
180: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new stage value'|| nvl(p_new_sales_stage_id,0));
181: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old stage value'|| nvl(p_old_sales_stage_id,0));
182: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new channel value'|| nvl(p_new_channel_code,0));
183: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old channel value'|| nvl(p_old_channel_code,0));
184: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new win value'|| nvl(p_new_win_probability,0));
185: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old win value'|| nvl(p_old_win_probability,0));

Line 182: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new channel value'|| nvl(p_new_channel_code,0));

178: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new amount value'|| nvl(p_new_status,0));
179: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old status value'|| nvl(p_old_status,0));
180: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new stage value'|| nvl(p_new_sales_stage_id,0));
181: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old stage value'|| nvl(p_old_sales_stage_id,0));
182: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new channel value'|| nvl(p_new_channel_code,0));
183: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old channel value'|| nvl(p_old_channel_code,0));
184: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new win value'|| nvl(p_new_win_probability,0));
185: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old win value'|| nvl(p_old_win_probability,0));
186: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new date value'|| p_new_decision_date);

Line 183: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old channel value'|| nvl(p_old_channel_code,0));

179: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old status value'|| nvl(p_old_status,0));
180: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new stage value'|| nvl(p_new_sales_stage_id,0));
181: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old stage value'|| nvl(p_old_sales_stage_id,0));
182: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new channel value'|| nvl(p_new_channel_code,0));
183: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old channel value'|| nvl(p_old_channel_code,0));
184: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new win value'|| nvl(p_new_win_probability,0));
185: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old win value'|| nvl(p_old_win_probability,0));
186: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new date value'|| p_new_decision_date);
187: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old date value'|| p_old_decision_date);

Line 184: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new win value'|| nvl(p_new_win_probability,0));

180: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new stage value'|| nvl(p_new_sales_stage_id,0));
181: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old stage value'|| nvl(p_old_sales_stage_id,0));
182: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new channel value'|| nvl(p_new_channel_code,0));
183: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old channel value'|| nvl(p_old_channel_code,0));
184: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new win value'|| nvl(p_new_win_probability,0));
185: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old win value'|| nvl(p_old_win_probability,0));
186: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new date value'|| p_new_decision_date);
187: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old date value'|| p_old_decision_date);
188: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new Curr value'|| nvl(p_new_currency_code,0));

Line 185: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old win value'|| nvl(p_old_win_probability,0));

181: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old stage value'|| nvl(p_old_sales_stage_id,0));
182: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new channel value'|| nvl(p_new_channel_code,0));
183: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old channel value'|| nvl(p_old_channel_code,0));
184: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new win value'|| nvl(p_new_win_probability,0));
185: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old win value'|| nvl(p_old_win_probability,0));
186: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new date value'|| p_new_decision_date);
187: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old date value'|| p_old_decision_date);
188: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new Curr value'|| nvl(p_new_currency_code,0));
189: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old Curr value'|| nvl(p_old_currency_code,0));

Line 186: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new date value'|| p_new_decision_date);

182: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new channel value'|| nvl(p_new_channel_code,0));
183: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old channel value'|| nvl(p_old_channel_code,0));
184: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new win value'|| nvl(p_new_win_probability,0));
185: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old win value'|| nvl(p_old_win_probability,0));
186: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new date value'|| p_new_decision_date);
187: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old date value'|| p_old_decision_date);
188: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new Curr value'|| nvl(p_new_currency_code,0));
189: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old Curr value'|| nvl(p_old_currency_code,0));
190: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new tamount value'|| nvl(p_new_total_amount,0));

Line 187: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old date value'|| p_old_decision_date);

183: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old channel value'|| nvl(p_old_channel_code,0));
184: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new win value'|| nvl(p_new_win_probability,0));
185: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old win value'|| nvl(p_old_win_probability,0));
186: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new date value'|| p_new_decision_date);
187: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old date value'|| p_old_decision_date);
188: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new Curr value'|| nvl(p_new_currency_code,0));
189: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old Curr value'|| nvl(p_old_currency_code,0));
190: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new tamount value'|| nvl(p_new_total_amount,0));
191: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old tamount value'|| nvl(p_old_total_amount,0));

Line 188: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new Curr value'|| nvl(p_new_currency_code,0));

184: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new win value'|| nvl(p_new_win_probability,0));
185: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old win value'|| nvl(p_old_win_probability,0));
186: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new date value'|| p_new_decision_date);
187: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old date value'|| p_old_decision_date);
188: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new Curr value'|| nvl(p_new_currency_code,0));
189: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old Curr value'|| nvl(p_old_currency_code,0));
190: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new tamount value'|| nvl(p_new_total_amount,0));
191: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old tamount value'|| nvl(p_old_total_amount,0));
192: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new sgroup value'|| nvl(p_new_security_group_id,0));

Line 189: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old Curr value'|| nvl(p_old_currency_code,0));

185: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old win value'|| nvl(p_old_win_probability,0));
186: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new date value'|| p_new_decision_date);
187: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old date value'|| p_old_decision_date);
188: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new Curr value'|| nvl(p_new_currency_code,0));
189: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old Curr value'|| nvl(p_old_currency_code,0));
190: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new tamount value'|| nvl(p_new_total_amount,0));
191: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old tamount value'|| nvl(p_old_total_amount,0));
192: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new sgroup value'|| nvl(p_new_security_group_id,0));
193: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old sgroup value'|| nvl(p_old_security_group_id,0));

Line 190: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new tamount value'|| nvl(p_new_total_amount,0));

186: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new date value'|| p_new_decision_date);
187: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old date value'|| p_old_decision_date);
188: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new Curr value'|| nvl(p_new_currency_code,0));
189: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old Curr value'|| nvl(p_old_currency_code,0));
190: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new tamount value'|| nvl(p_new_total_amount,0));
191: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old tamount value'|| nvl(p_old_total_amount,0));
192: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new sgroup value'|| nvl(p_new_security_group_id,0));
193: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old sgroup value'|| nvl(p_old_security_group_id,0));
194: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new customer value'|| nvl(p_new_customer_id,0));

Line 191: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old tamount value'|| nvl(p_old_total_amount,0));

187: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old date value'|| p_old_decision_date);
188: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new Curr value'|| nvl(p_new_currency_code,0));
189: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old Curr value'|| nvl(p_old_currency_code,0));
190: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new tamount value'|| nvl(p_new_total_amount,0));
191: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old tamount value'|| nvl(p_old_total_amount,0));
192: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new sgroup value'|| nvl(p_new_security_group_id,0));
193: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old sgroup value'|| nvl(p_old_security_group_id,0));
194: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new customer value'|| nvl(p_new_customer_id,0));
195: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old customer value'|| nvl(p_old_customer_id,0));

Line 192: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new sgroup value'|| nvl(p_new_security_group_id,0));

188: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new Curr value'|| nvl(p_new_currency_code,0));
189: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old Curr value'|| nvl(p_old_currency_code,0));
190: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new tamount value'|| nvl(p_new_total_amount,0));
191: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old tamount value'|| nvl(p_old_total_amount,0));
192: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new sgroup value'|| nvl(p_new_security_group_id,0));
193: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old sgroup value'|| nvl(p_old_security_group_id,0));
194: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new customer value'|| nvl(p_new_customer_id,0));
195: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old customer value'|| nvl(p_old_customer_id,0));
196: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new oppdesc value'|| nvl(p_new_description,0));

Line 193: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old sgroup value'|| nvl(p_old_security_group_id,0));

189: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old Curr value'|| nvl(p_old_currency_code,0));
190: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new tamount value'|| nvl(p_new_total_amount,0));
191: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old tamount value'|| nvl(p_old_total_amount,0));
192: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new sgroup value'|| nvl(p_new_security_group_id,0));
193: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old sgroup value'|| nvl(p_old_security_group_id,0));
194: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new customer value'|| nvl(p_new_customer_id,0));
195: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old customer value'|| nvl(p_old_customer_id,0));
196: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new oppdesc value'|| nvl(p_new_description,0));
197: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old oppdesc value'|| nvl(p_old_description,0));

Line 194: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new customer value'|| nvl(p_new_customer_id,0));

190: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new tamount value'|| nvl(p_new_total_amount,0));
191: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old tamount value'|| nvl(p_old_total_amount,0));
192: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new sgroup value'|| nvl(p_new_security_group_id,0));
193: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old sgroup value'|| nvl(p_old_security_group_id,0));
194: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new customer value'|| nvl(p_new_customer_id,0));
195: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old customer value'|| nvl(p_old_customer_id,0));
196: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new oppdesc value'|| nvl(p_new_description,0));
197: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old oppdesc value'|| nvl(p_old_description,0));
198: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new spromo value'|| nvl(p_new_source_promotion_id,0));

Line 195: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old customer value'|| nvl(p_old_customer_id,0));

191: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old tamount value'|| nvl(p_old_total_amount,0));
192: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new sgroup value'|| nvl(p_new_security_group_id,0));
193: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old sgroup value'|| nvl(p_old_security_group_id,0));
194: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new customer value'|| nvl(p_new_customer_id,0));
195: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old customer value'|| nvl(p_old_customer_id,0));
196: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new oppdesc value'|| nvl(p_new_description,0));
197: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old oppdesc value'|| nvl(p_old_description,0));
198: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new spromo value'|| nvl(p_new_source_promotion_id,0));
199: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old spromo value'|| nvl(p_old_source_promotion_id,0));

Line 196: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new oppdesc value'|| nvl(p_new_description,0));

192: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new sgroup value'|| nvl(p_new_security_group_id,0));
193: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old sgroup value'|| nvl(p_old_security_group_id,0));
194: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new customer value'|| nvl(p_new_customer_id,0));
195: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old customer value'|| nvl(p_old_customer_id,0));
196: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new oppdesc value'|| nvl(p_new_description,0));
197: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old oppdesc value'|| nvl(p_old_description,0));
198: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new spromo value'|| nvl(p_new_source_promotion_id,0));
199: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old spromo value'|| nvl(p_old_source_promotion_id,0));
200: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new offer value'|| nvl(p_new_offer_id,0));

Line 197: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old oppdesc value'|| nvl(p_old_description,0));

193: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old sgroup value'|| nvl(p_old_security_group_id,0));
194: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new customer value'|| nvl(p_new_customer_id,0));
195: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old customer value'|| nvl(p_old_customer_id,0));
196: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new oppdesc value'|| nvl(p_new_description,0));
197: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old oppdesc value'|| nvl(p_old_description,0));
198: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new spromo value'|| nvl(p_new_source_promotion_id,0));
199: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old spromo value'|| nvl(p_old_source_promotion_id,0));
200: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new offer value'|| nvl(p_new_offer_id,0));
201: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old offer value'|| nvl(p_old_offer_id,0));

Line 198: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new spromo value'|| nvl(p_new_source_promotion_id,0));

194: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new customer value'|| nvl(p_new_customer_id,0));
195: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old customer value'|| nvl(p_old_customer_id,0));
196: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new oppdesc value'|| nvl(p_new_description,0));
197: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old oppdesc value'|| nvl(p_old_description,0));
198: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new spromo value'|| nvl(p_new_source_promotion_id,0));
199: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old spromo value'|| nvl(p_old_source_promotion_id,0));
200: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new offer value'|| nvl(p_new_offer_id,0));
201: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old offer value'|| nvl(p_old_offer_id,0));
202: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new compt value'|| nvl(p_new_close_competitor_id,0));

Line 199: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old spromo value'|| nvl(p_old_source_promotion_id,0));

195: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old customer value'|| nvl(p_old_customer_id,0));
196: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new oppdesc value'|| nvl(p_new_description,0));
197: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old oppdesc value'|| nvl(p_old_description,0));
198: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new spromo value'|| nvl(p_new_source_promotion_id,0));
199: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old spromo value'|| nvl(p_old_source_promotion_id,0));
200: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new offer value'|| nvl(p_new_offer_id,0));
201: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old offer value'|| nvl(p_old_offer_id,0));
202: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new compt value'|| nvl(p_new_close_competitor_id,0));
203: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old compt value'|| nvl(p_old_close_competitor_id,0));

Line 200: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new offer value'|| nvl(p_new_offer_id,0));

196: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new oppdesc value'|| nvl(p_new_description,0));
197: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old oppdesc value'|| nvl(p_old_description,0));
198: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new spromo value'|| nvl(p_new_source_promotion_id,0));
199: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old spromo value'|| nvl(p_old_source_promotion_id,0));
200: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new offer value'|| nvl(p_new_offer_id,0));
201: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old offer value'|| nvl(p_old_offer_id,0));
202: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new compt value'|| nvl(p_new_close_competitor_id,0));
203: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old compt value'|| nvl(p_old_close_competitor_id,0));
204: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new vresp value'|| nvl(p_new_vehicle_response_code,0));

Line 201: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old offer value'|| nvl(p_old_offer_id,0));

197: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old oppdesc value'|| nvl(p_old_description,0));
198: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new spromo value'|| nvl(p_new_source_promotion_id,0));
199: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old spromo value'|| nvl(p_old_source_promotion_id,0));
200: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new offer value'|| nvl(p_new_offer_id,0));
201: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old offer value'|| nvl(p_old_offer_id,0));
202: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new compt value'|| nvl(p_new_close_competitor_id,0));
203: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old compt value'|| nvl(p_old_close_competitor_id,0));
204: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new vresp value'|| nvl(p_new_vehicle_response_code,0));
205: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old vresp value'|| nvl(p_old_vehicle_response_code,0));

Line 202: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new compt value'|| nvl(p_new_close_competitor_id,0));

198: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new spromo value'|| nvl(p_new_source_promotion_id,0));
199: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old spromo value'|| nvl(p_old_source_promotion_id,0));
200: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new offer value'|| nvl(p_new_offer_id,0));
201: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old offer value'|| nvl(p_old_offer_id,0));
202: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new compt value'|| nvl(p_new_close_competitor_id,0));
203: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old compt value'|| nvl(p_old_close_competitor_id,0));
204: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new vresp value'|| nvl(p_new_vehicle_response_code,0));
205: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old vresp value'|| nvl(p_old_vehicle_response_code,0));
206: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new meth value'|| nvl(p_new_sales_methodology_id,0));

Line 203: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old compt value'|| nvl(p_old_close_competitor_id,0));

199: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old spromo value'|| nvl(p_old_source_promotion_id,0));
200: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new offer value'|| nvl(p_new_offer_id,0));
201: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old offer value'|| nvl(p_old_offer_id,0));
202: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new compt value'|| nvl(p_new_close_competitor_id,0));
203: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old compt value'|| nvl(p_old_close_competitor_id,0));
204: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new vresp value'|| nvl(p_new_vehicle_response_code,0));
205: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old vresp value'|| nvl(p_old_vehicle_response_code,0));
206: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new meth value'|| nvl(p_new_sales_methodology_id,0));
207: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old meth value'|| nvl(p_old_sales_methodology_id,0));

Line 204: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new vresp value'|| nvl(p_new_vehicle_response_code,0));

200: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new offer value'|| nvl(p_new_offer_id,0));
201: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old offer value'|| nvl(p_old_offer_id,0));
202: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new compt value'|| nvl(p_new_close_competitor_id,0));
203: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old compt value'|| nvl(p_old_close_competitor_id,0));
204: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new vresp value'|| nvl(p_new_vehicle_response_code,0));
205: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old vresp value'|| nvl(p_old_vehicle_response_code,0));
206: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new meth value'|| nvl(p_new_sales_methodology_id,0));
207: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old meth value'|| nvl(p_old_sales_methodology_id,0));
208: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesf value'|| nvl(p_new_owner_salesforce_id,0));

Line 205: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old vresp value'|| nvl(p_old_vehicle_response_code,0));

201: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old offer value'|| nvl(p_old_offer_id,0));
202: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new compt value'|| nvl(p_new_close_competitor_id,0));
203: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old compt value'|| nvl(p_old_close_competitor_id,0));
204: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new vresp value'|| nvl(p_new_vehicle_response_code,0));
205: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old vresp value'|| nvl(p_old_vehicle_response_code,0));
206: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new meth value'|| nvl(p_new_sales_methodology_id,0));
207: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old meth value'|| nvl(p_old_sales_methodology_id,0));
208: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesf value'|| nvl(p_new_owner_salesforce_id,0));
209: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesf value'|| nvl(p_old_owner_salesforce_id,0));

Line 206: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new meth value'|| nvl(p_new_sales_methodology_id,0));

202: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new compt value'|| nvl(p_new_close_competitor_id,0));
203: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old compt value'|| nvl(p_old_close_competitor_id,0));
204: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new vresp value'|| nvl(p_new_vehicle_response_code,0));
205: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old vresp value'|| nvl(p_old_vehicle_response_code,0));
206: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new meth value'|| nvl(p_new_sales_methodology_id,0));
207: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old meth value'|| nvl(p_old_sales_methodology_id,0));
208: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesf value'|| nvl(p_new_owner_salesforce_id,0));
209: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesf value'|| nvl(p_old_owner_salesforce_id,0));
210: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesg value'|| nvl(p_new_owner_sales_group_id,0));

Line 207: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old meth value'|| nvl(p_old_sales_methodology_id,0));

203: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old compt value'|| nvl(p_old_close_competitor_id,0));
204: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new vresp value'|| nvl(p_new_vehicle_response_code,0));
205: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old vresp value'|| nvl(p_old_vehicle_response_code,0));
206: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new meth value'|| nvl(p_new_sales_methodology_id,0));
207: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old meth value'|| nvl(p_old_sales_methodology_id,0));
208: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesf value'|| nvl(p_new_owner_salesforce_id,0));
209: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesf value'|| nvl(p_old_owner_salesforce_id,0));
210: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesg value'|| nvl(p_new_owner_sales_group_id,0));
211: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesg value'|| nvl(p_old_owner_sales_group_id,0));

Line 208: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesf value'|| nvl(p_new_owner_salesforce_id,0));

204: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new vresp value'|| nvl(p_new_vehicle_response_code,0));
205: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old vresp value'|| nvl(p_old_vehicle_response_code,0));
206: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new meth value'|| nvl(p_new_sales_methodology_id,0));
207: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old meth value'|| nvl(p_old_sales_methodology_id,0));
208: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesf value'|| nvl(p_new_owner_salesforce_id,0));
209: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesf value'|| nvl(p_old_owner_salesforce_id,0));
210: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesg value'|| nvl(p_new_owner_sales_group_id,0));
211: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesg value'|| nvl(p_old_owner_sales_group_id,0));
212: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new org value'|| nvl(p_new_org_id,0));

Line 209: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesf value'|| nvl(p_old_owner_salesforce_id,0));

205: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old vresp value'|| nvl(p_old_vehicle_response_code,0));
206: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new meth value'|| nvl(p_new_sales_methodology_id,0));
207: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old meth value'|| nvl(p_old_sales_methodology_id,0));
208: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesf value'|| nvl(p_new_owner_salesforce_id,0));
209: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesf value'|| nvl(p_old_owner_salesforce_id,0));
210: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesg value'|| nvl(p_new_owner_sales_group_id,0));
211: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesg value'|| nvl(p_old_owner_sales_group_id,0));
212: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new org value'|| nvl(p_new_org_id,0));
213: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old org value'|| nvl(p_old_org_id,0));

Line 210: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesg value'|| nvl(p_new_owner_sales_group_id,0));

206: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new meth value'|| nvl(p_new_sales_methodology_id,0));
207: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old meth value'|| nvl(p_old_sales_methodology_id,0));
208: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesf value'|| nvl(p_new_owner_salesforce_id,0));
209: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesf value'|| nvl(p_old_owner_salesforce_id,0));
210: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesg value'|| nvl(p_new_owner_sales_group_id,0));
211: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesg value'|| nvl(p_old_owner_sales_group_id,0));
212: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new org value'|| nvl(p_new_org_id,0));
213: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old org value'|| nvl(p_old_org_id,0));
214:

Line 211: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesg value'|| nvl(p_old_owner_sales_group_id,0));

207: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old meth value'|| nvl(p_old_sales_methodology_id,0));
208: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesf value'|| nvl(p_new_owner_salesforce_id,0));
209: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesf value'|| nvl(p_old_owner_salesforce_id,0));
210: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesg value'|| nvl(p_new_owner_sales_group_id,0));
211: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesg value'|| nvl(p_old_owner_sales_group_id,0));
212: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new org value'|| nvl(p_new_org_id,0));
213: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old org value'|| nvl(p_old_org_id,0));
214:
215: IF( ( ( nvl(p_new_address_id,0) <> nvl(p_old_address_id,0) ) OR

Line 212: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new org value'|| nvl(p_new_org_id,0));

208: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesf value'|| nvl(p_new_owner_salesforce_id,0));
209: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesf value'|| nvl(p_old_owner_salesforce_id,0));
210: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesg value'|| nvl(p_new_owner_sales_group_id,0));
211: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesg value'|| nvl(p_old_owner_sales_group_id,0));
212: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new org value'|| nvl(p_new_org_id,0));
213: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old org value'|| nvl(p_old_org_id,0));
214:
215: IF( ( ( nvl(p_new_address_id,0) <> nvl(p_old_address_id,0) ) OR
216: ( p_new_last_update_date <> p_old_last_update_date ) OR

Line 213: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old org value'|| nvl(p_old_org_id,0));

209: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesf value'|| nvl(p_old_owner_salesforce_id,0));
210: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new salesg value'|| nvl(p_new_owner_sales_group_id,0));
211: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old salesg value'|| nvl(p_old_owner_sales_group_id,0));
212: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check new org value'|| nvl(p_new_org_id,0));
213: -- dbms_output.put_line('AS_LEADS_LOG: Before changes state check old org value'|| nvl(p_old_org_id,0));
214:
215: IF( ( ( nvl(p_new_address_id,0) <> nvl(p_old_address_id,0) ) OR
216: ( p_new_last_update_date <> p_old_last_update_date ) OR
217: ( nvl(p_new_status,0) <> nvl(p_old_status,0) ) OR

Line 236: -- dbms_output.put_line('AS_LEADS_LOG: changed state i am in sam day'|| IsInsert);

232: ( nvl(p_new_owner_salesforce_id,0) <> nvl(p_old_owner_salesforce_id,0) ) OR
233: ( nvl(p_new_owner_sales_group_id,0) <> nvl(p_old_owner_sales_group_id,0) ) OR
234: ( nvl(p_new_org_id,0) <> nvl(p_old_org_id,0) ) ) ) THEN
235: IF ( IsInsert = 0) THEN
236: -- dbms_output.put_line('AS_LEADS_LOG: changed state i am in sam day'|| IsInsert);
237: AS_LEADS_LOG_PKG.Update_Row(
238: p_LOG_ID => l_LOG_ID,
239: p_LEAD_ID => p_new_lead_id,
240: p_OLD_LEAD_ID => p_old_lead_id,

Line 237: AS_LEADS_LOG_PKG.Update_Row(

233: ( nvl(p_new_owner_sales_group_id,0) <> nvl(p_old_owner_sales_group_id,0) ) OR
234: ( nvl(p_new_org_id,0) <> nvl(p_old_org_id,0) ) ) ) THEN
235: IF ( IsInsert = 0) THEN
236: -- dbms_output.put_line('AS_LEADS_LOG: changed state i am in sam day'|| IsInsert);
237: AS_LEADS_LOG_PKG.Update_Row(
238: p_LOG_ID => l_LOG_ID,
239: p_LEAD_ID => p_new_lead_id,
240: p_OLD_LEAD_ID => p_old_lead_id,
241: p_CREATED_BY => p_new_created_by,

Line 277: -- dbms_output.put_line('AS_LEADS_LOG: not changed state i am in diff day'|| IsInsert);

273: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
274: 'asxopadb: Update Log: '||p_old_lead_id || 'and '|| p_old_last_update_date );
275: END IF;
276: ELSE
277: -- dbms_output.put_line('AS_LEADS_LOG: not changed state i am in diff day'|| IsInsert);
278: AS_LEADS_LOG_PKG.Insert_Row(
279: px_LOG_ID => l_LOG_ID,
280: p_LEAD_ID => p_new_lead_id,
281: p_CREATED_BY => p_new_created_by,

Line 278: AS_LEADS_LOG_PKG.Insert_Row(

274: 'asxopadb: Update Log: '||p_old_lead_id || 'and '|| p_old_last_update_date );
275: END IF;
276: ELSE
277: -- dbms_output.put_line('AS_LEADS_LOG: not changed state i am in diff day'|| IsInsert);
278: AS_LEADS_LOG_PKG.Insert_Row(
279: px_LOG_ID => l_LOG_ID,
280: p_LEAD_ID => p_new_lead_id,
281: p_CREATED_BY => p_new_created_by,
282: p_CREATION_DATE => p_new_creation_date,

Line 317: -- dbms_output.put_line('AS_LEADS_LOG: manually updating the data');

313: 'asxopadb: Insert Log: '||l_LOG_ID );
314: END IF;
315: END IF;
316: /*ELSE
317: -- dbms_output.put_line('AS_LEADS_LOG: manually updating the data');
318: UPDATE as_leads_log
319: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = p_new_last_update_date
320: WHERE log_id = ( select max(log_id)
321: from as_leads_log

Line 318: UPDATE as_leads_log

314: END IF;
315: END IF;
316: /*ELSE
317: -- dbms_output.put_line('AS_LEADS_LOG: manually updating the data');
318: UPDATE as_leads_log
319: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = p_new_last_update_date
320: WHERE log_id = ( select max(log_id)
321: from as_leads_log
322: where lead_id = p_new_lead_id);*/

Line 321: from as_leads_log

317: -- dbms_output.put_line('AS_LEADS_LOG: manually updating the data');
318: UPDATE as_leads_log
319: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = p_new_last_update_date
320: WHERE log_id = ( select max(log_id)
321: from as_leads_log
322: where lead_id = p_new_lead_id);*/
323: END IF;
324: END IF;
325: END IF;