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 308: select occurrence_id into l_occ from jl_br_ar_occurrence_docs_all

304: where CT.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID
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: select occurrence_id into l_occ from jl_br_ar_occurrence_docs_all
309: where document_id = cursor_ps.document_id;
310:
311: -- SLA Uptake - Bug#4301543
312: JL_BR_AR_BANK_ACCT_PKG.Create_Event_Dists (

Line 328: UPDATE JL_BR_AR_OCCURRENCE_DOCS_ALL

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

Line 415: INSERT INTO JL_BR_AR_OCCURRENCE_DOCS_ALL

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

Line 537: UPDATE JL_BR_AR_OCCURRENCE_DOCS_ALL

533: p_factoring_charges_amt => CURSOR_PS.FACTORING_AMOUNT ,
534: p_event_id => l_event_id
535: );
536:
537: UPDATE JL_BR_AR_OCCURRENCE_DOCS_ALL
538: SET event_id =l_event_id
539: WHERE occurrence_id = l_occurrence_id;
540: -- End SLA Uptake - Bug#4301543
541:

Line 675: from JL_BR_AR_OCCURRENCE_DOCS_ALL OD,

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

Line 702: update JL_BR_AR_OCCURRENCE_DOCS_ALL

698: EXIT WHEN check2%NOTFOUND;
699:
700: for TMP in OC loop
701: /* Update occurrence status to CONFIRMED */
702: update JL_BR_AR_OCCURRENCE_DOCS_ALL
703: set OCCURRENCE_STATUS = 'CONFIRMED'
704: where OCCURRENCE_ID = TMP.OCCURRENCE_ID;
705: if TMP.STD_OCCURRENCE_CODE = 'PROTEST' then
706: /* update AR_PAYMENT_SCHEDULES