APPS.IGIRCABJP dependencies on IGI_AR_JOURNAL_INTERIM

Line 27: igi_ar_journal_interim

23: --
24: PROCEDURE GetAdjustments ( p_Report IN ReportParametersType ) IS
25: BEGIN
26: INSERT INTO
27: igi_ar_journal_interim
28: (
29: status,
30: actual_flag,
31: request_id,

Line 170: igi_ar_journal_interim

166: PROCEDURE GetTxnDistributions( p_Report IN ReportParametersType )
167: IS
168: BEGIN
169: INSERT INTO
170: igi_ar_journal_interim
171: (
172: status,
173: actual_flag,
174: request_id,

Line 363: igi_ar_journal_interim

359: PROCEDURE GetRxptHistory( p_Report IN ReportParametersType ) IS
360: BEGIN
361: --
362: INSERT INTO
363: igi_ar_journal_interim
364: (
365: status,
366: actual_flag,
367: request_id,

Line 516: igi_ar_journal_interim

512: --
513: PROCEDURE GetRecApplications( p_Report IN ReportParametersType ) IS
514: BEGIN
515: INSERT INTO
516: igi_ar_journal_interim
517: (
518: status,
519: actual_flag,
520: request_id,

Line 782: igi_ar_journal_interim

778: --
779: PROCEDURE GetMiscCashDists( p_Report IN ReportParametersType ) IS
780: BEGIN
781: INSERT INTO
782: igi_ar_journal_interim
783: (
784: status,
785: actual_flag,
786: request_id,

Line 929: from igi_ar_journal_interim

925: nvl(sum(nvl(entered_dr,0)),0) entered_dr,
926: nvl(sum(nvl(entered_cr,0)),0) entered_cr,
927: nvl(sum(nvl(accounted_dr,0)),0) accounted_dr,
928: nvl(sum(nvl(accounted_cr,0)),0) accounted_cr
929: from igi_ar_journal_interim
930: where je_source_name = 'Receivables'
931: and set_of_books_id = p_Report.SetOfBooksId
932: and request_id = p_Report.ReqId
933: group by

Line 947: delete from igi_ar_journal_interim iaji

943: --
944: --
945: FOR RBal IN CBal
946: LOOP
947: delete from igi_ar_journal_interim iaji
948: where iaji.je_source_name = 'Receivables'
949: and iaji.set_of_books_id = p_Report.SetOfBooksId
950: and iaji.request_id = p_Report.ReqID
951: and iaji.reference23 = RBal.balance_id

Line 1164: from igi_ar_journal_interim

1160: FUNCTION CountInterimJournals ( p_request_id in number ) return number
1161: IS
1162: cursor c_e is
1163: select count(*) ct
1164: from igi_ar_journal_interim
1165: where request_id = p_request_id
1166: ;
1167: BEGIN
1168: for l_e in c_e loop

Line 1371: delete from igi_ar_journal_interim

1367: l_Report.CreatedBy := fnd_global.user_id;
1368: --
1369: --
1370: IF DebugMode THEN
1371: delete from igi_ar_journal_interim
1372: -- where request_id = l_Report.ReqId
1373: ;
1374: END IF;
1375:

Line 1388: 'Get accrual data into IGI_AR_JOURNAL_INTERIM ');

1384:
1385:
1386: IF (l_state_level >= l_debug_level ) THEN
1387: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1388: 'Get accrual data into IGI_AR_JOURNAL_INTERIM ');
1389: END IF;
1390:
1391: IF l_Report.PostedDateFrom IS NULL THEN
1392: l_Report.PostedDateFrom := to_date('01-01-1952', 'DD-MM-YYYY');

Line 1439: 'Delete records from IGI_AR_JOURNAL_INTERIM (IF not debug)');

1435: ReportOutput (l_Report);
1436:
1437: IF (l_state_level >= l_debug_level ) THEN
1438: FND_LOG.STRING (l_state_level , 'igi.plsql.igircajb.IGIRCABJP.ReportCBR',
1439: 'Delete records from IGI_AR_JOURNAL_INTERIM (IF not debug)');
1440: END IF;
1441:
1442:
1443: IF NOT DebugMode THEN

Line 1444: delete from igi_ar_journal_interim

1440: END IF;
1441:
1442:
1443: IF NOT DebugMode THEN
1444: delete from igi_ar_journal_interim
1445: where request_id = l_Report.ReqId
1446: ;
1447: END IF;
1448: