APPS.IGIRCBJP dependencies on IGI_AR_JOURNAL_INTERIM

Line 535: | igi_ar_cash_basis_dists, and a record into igi_ar_journal_interim |

531: | PRIVATE PROCEDURE |
532: | CreateDistribution |
533: | DESCRIPTION |
534: | Creates a distribution by inserting a record into |
535: | igi_ar_cash_basis_dists, and a record into igi_ar_journal_interim |
536: | PARAMETERS |
537: | |
538: | EXCEPTIONS RAISED |
539: | |

Line 572: igi_ar_journal_interim

568: IF p_App.PostingControlId > 0
569: THEN
570: BEGIN
571: INSERT INTO
572: igi_ar_journal_interim
573: (
574: status,
575: actual_flag,
576: request_id,

Line 738: igi_ar_journal_interim

734: --
735: BEGIN
736: WritetoLogFile ( l_state_level, 'CreateDistribution','CreateDistribution : Insert into AR_JOURNAL_INTERIM...');
737: INSERT INTO
738: igi_ar_journal_interim
739: (
740: status,
741: actual_flag,
742: request_id,

Line 1267: igi_ar_journal_interim

1263: LOOP
1264: BEGIN
1265:
1266: INSERT INTO
1267: igi_ar_journal_interim
1268: (
1269: status,
1270: actual_flag,
1271: request_id,

Line 1783: igi_ar_journal_interim

1779: PROCEDURE InsertIntoAR( RCrh IN CCrh%ROWTYPE ) IS
1780: BEGIN
1781:
1782: INSERT INTO
1783: igi_ar_journal_interim
1784: (
1785: status,
1786: actual_flag,
1787: request_id,

Line 1992: igi_ar_journal_interim

1988: FOR RMcd IN CMcd
1989: LOOP
1990:
1991: INSERT INTO
1992: igi_ar_journal_interim
1993: (
1994: status,
1995: actual_flag,
1996: request_id,

Line 2104: DELETE FROM igi_ar_journal_interim

2100: p_BalanceId IN NUMBER,
2101: p_CategoryCode IN VARCHAR2 ) IS
2102: BEGIN
2103: --
2104: DELETE FROM igi_ar_journal_interim
2105: WHERE reference22 = p_BalanceId
2106: AND reference28 = p_CategoryCode
2107: AND set_of_books_id = p_Report.CashSetOfBooksId
2108: AND request_id = p_Report.ReqId;

Line 2125: | Checks that the records inserted into igi_ar_journal_interim balance for each |

2121: /*---------------------------------------------------------------------------*
2122: | PRIVATE PROCEDURE |
2123: | CheckBalance |
2124: | DESCRIPTION |
2125: | Checks that the records inserted into igi_ar_journal_interim balance for each |
2126: | BalanceId (reference22). |
2127: | Any BalanceId that fails to balance will be reported on |
2128: | (via WriteToLogFile), and will be deleted with ClearOOB |
2129: | PARAMETERS |

Line 2151: FROM igi_ar_journal_interim i

2147: SUM(nvl(i.entered_dr,0)) SumEnteredDr,
2148: SUM(nvl(i.entered_cr,0)) SumEnteredCr,
2149: SUM(nvl(i.accounted_dr,0)) SumAccountedDr,
2150: SUM(nvl(i.accounted_cr,0)) SumAccountedCr
2151: FROM igi_ar_journal_interim i
2152: WHERE i.request_id = p_Report.ReqId
2153: AND i.set_of_books_id = p_Report.CashSetOfBooksId
2154: GROUP BY i.reference28,
2155: i.reference22

Line 2166: FROM igi_ar_journal_interim i

2162: i.accounted_dr AccountedDr,
2163: i.accounted_cr AccountedCr,
2164: i.reference30 TableName,
2165: i.reference23 Id
2166: FROM igi_ar_journal_interim i
2167: WHERE i.request_id = p_Report.ReqId
2168: AND i.set_of_books_id = p_Report.CashSetOfBooksId
2169: AND i.reference22 = p_BalanceId
2170: AND i.reference28 = p_CategoryCode

Line 2541: DELETE igi_ar_journal_interim

2537: , l_message
2538: );
2539: end if;
2540:
2541: DELETE igi_ar_journal_interim
2542: WHERE request_id = p_Report.ReqId;
2543:
2544: commit;
2545: EXCEPTION

Line 2584: from igi_ar_journal_interim

2580: FUNCTION CountInterimJournals ( p_request_id in number ) return number
2581: IS
2582: cursor c_e is
2583: select count(*) ct
2584: from igi_ar_journal_interim
2585: where request_id = p_request_id
2586: ;
2587: BEGIN
2588: for l_e in c_e loop