APPS.JL_BR_AR_REMIT_COLL_OCCUR dependencies on JL_BR_AR_OCCURRENCE_DOCS_ALL

Line 212: insert into JL_BR_AR_OCCURRENCE_DOCS_ALL

208: into l_occurrence_id
209: from dual;
210:
211: -- CE uptake - Bug#2932986
212: insert into JL_BR_AR_OCCURRENCE_DOCS_ALL
213: (OCCURRENCE_ID,
214: DOCUMENT_ID,
215: BANK_OCCURRENCE_CODE,
216: --BANK_NUMBER,

Line 309: /* select occurrence_id into l_occ from jl_br_ar_occurrence_docs_all

305: and T.TERM_ID(+) = PS.TERM_ID
306: and T.SEQUENCE_NUM(+) = PS.TERMS_SEQUENCE_NUMBER
307: and PS.PAYMENT_SCHEDULE_ID = CURSOR_PS.PAYMENT_SCHEDULE_ID;
308: --commented below code for bug 9468277.
309: /* select occurrence_id into l_occ from jl_br_ar_occurrence_docs_all
310: where document_id = cursor_ps.document_id; */
311:
312: -- SLA Uptake - Bug#4301543
313: JL_BR_AR_BANK_ACCT_PKG.Create_Event_Dists (

Line 329: UPDATE JL_BR_AR_OCCURRENCE_DOCS_ALL

325: p_factoring_charges_amt => NULL ,
326: p_event_id => l_event_id
327: );
328:
329: UPDATE JL_BR_AR_OCCURRENCE_DOCS_ALL
330: SET event_id =l_event_id
331: WHERE occurrence_id = l_occurrence_id;
332: -- End SLA Uptake - Bug#4301543
333:

Line 417: INSERT INTO JL_BR_AR_OCCURRENCE_DOCS_ALL

413: into l_occurrence_id
414: from dual;
415:
416:
417: INSERT INTO JL_BR_AR_OCCURRENCE_DOCS_ALL
418: (OCCURRENCE_ID,
419: DOCUMENT_ID,
420: BANK_OCCURRENCE_CODE,
421: --BANK_NUMBER,

Line 541: UPDATE JL_BR_AR_OCCURRENCE_DOCS_ALL

537: p_factoring_charges_amt => CURSOR_PS.FACTORING_AMOUNT ,
538: p_event_id => l_event_id
539: );
540:
541: UPDATE JL_BR_AR_OCCURRENCE_DOCS_ALL
542: SET event_id =l_event_id
543: WHERE occurrence_id = l_occurrence_id;
544: -- End SLA Uptake - Bug#4301543
545:

Line 680: from JL_BR_AR_OCCURRENCE_DOCS_ALL OD,

676: /* This cursor is used to read documents from Borderos that
677: was not formated */
678: cursor OC is
679: select OD.OCCURRENCE_ID, BO.STD_OCCURRENCE_CODE, OD.DOCUMENT_ID
680: from JL_BR_AR_OCCURRENCE_DOCS_ALL OD,
681: JL_BR_AR_BORDEROS B,
682: JL_BR_AR_BANK_OCCURRENCES BO
683: where OD.OCCURRENCE_STATUS = 'SELECTED'
684: and B.BORDERO_STATUS = 'SELECTED'

Line 707: update JL_BR_AR_OCCURRENCE_DOCS_ALL

703: EXIT WHEN check2%NOTFOUND;
704:
705: for TMP in OC loop
706: /* Update occurrence status to CONFIRMED */
707: update JL_BR_AR_OCCURRENCE_DOCS_ALL
708: set OCCURRENCE_STATUS = 'CONFIRMED'
709: where OCCURRENCE_ID = TMP.OCCURRENCE_ID;
710: if TMP.STD_OCCURRENCE_CODE = 'PROTEST' then
711: /* update AR_PAYMENT_SCHEDULES