APPS.AS_PIPELINE_MOVE_PUB dependencies on AS_SALES_CREDITS

Line 123: FROM AS_SALES_CREDITS ASSC

119: SELECT LEAD_LINE_ID,
120: CREDIT_TYPE_ID,
121: SUM(CREDIT_AMOUNT) CR_AMT ,
122: SUM(CREDIT_PERCENT) CR_PCT
123: FROM AS_SALES_CREDITS ASSC
124: WHERE ASSC.LEAD_ID = l_lead_id
125: AND ASSC.SALESFORCE_ID = l_salesforceid
126: AND ASSC.SALESGROUP_ID = l_salesgroupid
127: AND ASSC.PERSON_ID = l_personid

Line 203: --** CASE 1 - SR2 already exists in as_sales_credits **

199: LOOP
200: FETCH curs INTO L_LEAD_ID ;
201: EXIT WHEN curs%NOTFOUND ;
202: --* UPDATE SALES CREDITS **
203: --** CASE 1 - SR2 already exists in as_sales_credits **
204: --** add up the salescredits for SR1 to SR2, update SR2's salescredits and delete the salescredits for SR1 **
205: --dbms_output.put_line('CASE 1 - SR2 already exists in as_sales_credits');
206:
207: -- find r2 sales credit exist

Line 205: --dbms_output.put_line('CASE 1 - SR2 already exists in as_sales_credits');

201: EXIT WHEN curs%NOTFOUND ;
202: --* UPDATE SALES CREDITS **
203: --** CASE 1 - SR2 already exists in as_sales_credits **
204: --** add up the salescredits for SR1 to SR2, update SR2's salescredits and delete the salescredits for SR1 **
205: --dbms_output.put_line('CASE 1 - SR2 already exists in as_sales_credits');
206:
207: -- find r2 sales credit exist
208: --dbms_output.put_line(to_char(l_lead_id) || '-' || to_char(from_res) || '-' || to_char(from_group_id)|| '-' || to_char(from_person));
209:

Line 221: FROM AS_SALES_CREDITS SC

217:
218: --dbms_output.put_line(to_char(sc_rec.credit_type_id) || '-' || to_char(sc_rec.cr_amt) || '-' || to_char(sc_rec.cr_pct));
219:
220: SELECT COUNT(*) INTO is_in_sales_credits
221: FROM AS_SALES_CREDITS SC
222: WHERE SC.LEAD_ID = L_LEAD_ID
223: AND SC.LEAD_LINE_ID = SC_REC.LEAD_LINE_ID
224: AND SC.SALESFORCE_ID = to_res
225: AND SC.SALESGROUP_ID = to_group_id

Line 230: UPDATE AS_SALES_CREDITS ASSC

226: AND SC.CREDIT_TYPE_ID = SC_REC.CREDIT_TYPE_ID;
227: IF is_in_sales_credits > 0 THEN
228: BEGIN
229: -- update salescredits for SR2
230: UPDATE AS_SALES_CREDITS ASSC
231: SET object_version_number = nvl(object_version_number,0) + 1, ASSC.CREDIT_AMOUNT = ASSC.CREDIT_AMOUNT + SC_REC.CR_AMT,
232: ASSC.CREDIT_PERCENT = ASSC.CREDIT_PERCENT + SC_REC.CR_PCT
233: WHERE ASSC.LEAD_ID = L_LEAD_ID
234: AND ASSC.LEAD_LINE_ID = SC_REC.LEAD_LINE_ID

Line 240: FROM AS_SALES_CREDITS z

236: AND ASSC.SALESGROUP_ID = to_group_id
237: AND ASSC.PERSON_ID = to_person
238: AND ASSC.CREDIT_TYPE_ID = SC_REC.CREDIT_TYPE_ID
239: AND ROWID = (SELECT MIN(ROWID)
240: FROM AS_SALES_CREDITS z
241: WHERE z.LEAD_ID = L_LEAD_ID
242: AND z.LEAD_LINE_ID = SC_REC.LEAD_LINE_ID
243: AND z.SALESFORCE_ID = ASSC.SALESFORCE_ID
244: AND z.SALESGROUP_ID = ASSC.SALESGROUP_ID

Line 250: --** CASE 2 - SR2 does not exist in as_sales_credits **

246: AND z.CREDIT_TYPE_ID = SC_REC.CREDIT_TYPE_ID);
247: END;
248: ELSE
249: BEGIN
250: --** CASE 2 - SR2 does not exist in as_sales_credits **
251: UPDATE AS_SALES_CREDITS
252: SET object_version_number = nvl(object_version_number,0) + 1, SALESFORCE_ID = to_res,
253: PERSON_ID = to_person,
254: SALESGROUP_ID = to_group_id

Line 251: UPDATE AS_SALES_CREDITS

247: END;
248: ELSE
249: BEGIN
250: --** CASE 2 - SR2 does not exist in as_sales_credits **
251: UPDATE AS_SALES_CREDITS
252: SET object_version_number = nvl(object_version_number,0) + 1, SALESFORCE_ID = to_res,
253: PERSON_ID = to_person,
254: SALESGROUP_ID = to_group_id
255: WHERE LEAD_ID = L_LEAD_ID

Line 265: DELETE FROM AS_SALES_CREDITS

261: END;
262: END IF;
263: --dbms_output.put_line('After updating sales credit:'|| SQL%ROWCOUNT);
264: -- delete salescredits for SR1
265: DELETE FROM AS_SALES_CREDITS
266: WHERE LEAD_ID = L_LEAD_ID
267: AND LEAD_LINE_ID = SC_REC.LEAD_LINE_ID
268: AND SALESFORCE_ID = from_res
269: AND SALESGROUP_ID = from_group_id

Line 510: update AS_SALES_CREDITS sc

506: FND_FILE.PUT_LINE(FND_FILE.LOG,'Win Prob : '||from_win_prob||'-'||to_win_prob);
507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);
508: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);
509: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);
510: update AS_SALES_CREDITS sc
511: set object_version_number = nvl(object_version_number,0) + 1, salesforce_id = to_sf_id,
512: person_id = to_person,
513: salesgroup_id = to_sg_id
514: where exists

Line 529: update AS_SALES_CREDITS sc

525: FND_FILE.PUT_LINE(FND_FILE.LOG,'Close Date : '||from_close_date||'-'||to_close_date);
526: FND_FILE.PUT_LINE(FND_FILE.LOG,'From SF/SG : '||from_sf_id||'-'||from_sg_id);
527: FND_FILE.PUT_LINE(FND_FILE.LOG,'To SF/SG : '||to_sf_id||'-'||to_sg_id);
528: while (i_count <= st_count) loop
529: update AS_SALES_CREDITS sc
530: set object_version_number = nvl(object_version_number,0) + 1, salesforce_id = to_sf_id,
531: person_id = to_person,
532: salesgroup_id = to_sg_id
533: where exists