eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CASH_BASIS_JE_REPORT dependencies on AR_JOURNAL_INTERIM

Line 519: | Inserts a record into ar_journal_interim |

515: /*---------------------------------------------------------------------------*
516: | PRIVATE PROCEDURE |
517: | CreateInterim |
518: | DESCRIPTION |
519: | Inserts a record into ar_journal_interim |
520: | PARAMETERS |
521: | |
522: | EXCEPTIONS RAISED |
523: | |

Line 533: PROCEDURE CreateInterim( p_interim_rec IN ar_journal_interim%ROWTYPE) IS

529: | |
530: | HISTORY |
531: | 02-Jul-2004 Hiroshi Yoshihara bug3718694 Created |
532: *---------------------------------------------------------------------------*/
533: PROCEDURE CreateInterim( p_interim_rec IN ar_journal_interim%ROWTYPE) IS
534: BEGIN
535: INSERT INTO
536: ar_journal_interim
537: (

Line 536: ar_journal_interim

532: *---------------------------------------------------------------------------*/
533: PROCEDURE CreateInterim( p_interim_rec IN ar_journal_interim%ROWTYPE) IS
534: BEGIN
535: INSERT INTO
536: ar_journal_interim
537: (
538: status,
539: actual_flag,
540: request_id,

Line 610: | ar_cash_basis_distributions, and a record into ar_journal_interim |

606: | PRIVATE PROCEDURE |
607: | CreateDistribution |
608: | DESCRIPTION |
609: | Creates a distribution by inserting a record into |
610: | ar_cash_basis_distributions, and a record into ar_journal_interim |
611: | PARAMETERS |
612: | |
613: | EXCEPTIONS RAISED |
614: | |

Line 649: ar_journal_interim

645: IF p_App.PostingControlId > 0
646: THEN
647: BEGIN
648: INSERT INTO
649: ar_journal_interim
650: (
651: status,
652: actual_flag,
653: request_id,

Line 810: -- ar_journal_interim .

806: RAISE;
807: END;
808: --
809: -- bug3718694 Call CreateInterim procedure to insert record into
810: -- ar_journal_interim .
811: DECLARE
812: l_interim_rec ar_journal_interim%ROWTYPE;
813: BEGIN
814: l_interim_rec.status := 'NEW';

Line 812: l_interim_rec ar_journal_interim%ROWTYPE;

808: --
809: -- bug3718694 Call CreateInterim procedure to insert record into
810: -- ar_journal_interim .
811: DECLARE
812: l_interim_rec ar_journal_interim%ROWTYPE;
813: BEGIN
814: l_interim_rec.status := 'NEW';
815: l_interim_rec.actual_flag := 'A';
816: l_interim_rec.request_id := p_Report.ReqId;

Line 1291: -- ar_journal_interim .

1287: arp_standard.debug( ' AR_RECEIVABLE_APPLICATIONS (non-app)...' );
1288: FOR RRa IN CRa
1289: LOOP
1290: -- bug3718694 Call CreateInterim procedure to insert record into
1291: -- ar_journal_interim .
1292: DECLARE
1293: l_interim_rec ar_journal_interim%ROWTYPE;
1294:
1295: BEGIN

Line 1293: l_interim_rec ar_journal_interim%ROWTYPE;

1289: LOOP
1290: -- bug3718694 Call CreateInterim procedure to insert record into
1291: -- ar_journal_interim .
1292: DECLARE
1293: l_interim_rec ar_journal_interim%ROWTYPE;
1294:
1295: BEGIN
1296: l_interim_rec.status := 'NEW';
1297: l_interim_rec.actual_flag := 'A';

Line 1736: -- ar_journal_interim .

1732: RCrh CCrh%ROWTYPE;
1733: l_Count NUMBER :=0;
1734: --
1735: -- bug3718694 Call CreateInterim procedure to insert record into
1736: -- ar_journal_interim .
1737: PROCEDURE InsertIntoAR( RCrh IN CCrh%ROWTYPE ) IS
1738: l_interim_rec ar_journal_interim%ROWTYPE;
1739: BEGIN
1740: l_interim_rec.status := 'NEW';

Line 1738: l_interim_rec ar_journal_interim%ROWTYPE;

1734: --
1735: -- bug3718694 Call CreateInterim procedure to insert record into
1736: -- ar_journal_interim .
1737: PROCEDURE InsertIntoAR( RCrh IN CCrh%ROWTYPE ) IS
1738: l_interim_rec ar_journal_interim%ROWTYPE;
1739: BEGIN
1740: l_interim_rec.status := 'NEW';
1741: l_interim_rec.actual_flag := 'A';
1742: l_interim_rec.request_id := p_Report.ReqId;

Line 1894: l_interim_rec ar_journal_interim%ROWTYPE;

1890: --
1891: l_Count NUMBER :=0;
1892:
1893: -- bug3718694
1894: l_interim_rec ar_journal_interim%ROWTYPE;
1895: l_interim_rec_null ar_journal_interim%ROWTYPE;
1896: BEGIN
1897: arp_standard.debug( ' ' );
1898: arp_standard.debug( ' AR_MISC_CASH_DISTRIBUTIONS...' );

Line 1895: l_interim_rec_null ar_journal_interim%ROWTYPE;

1891: l_Count NUMBER :=0;
1892:
1893: -- bug3718694
1894: l_interim_rec ar_journal_interim%ROWTYPE;
1895: l_interim_rec_null ar_journal_interim%ROWTYPE;
1896: BEGIN
1897: arp_standard.debug( ' ' );
1898: arp_standard.debug( ' AR_MISC_CASH_DISTRIBUTIONS...' );
1899: FOR RMcd IN CMcd

Line 1902: -- ar_journal_interim .

1898: arp_standard.debug( ' AR_MISC_CASH_DISTRIBUTIONS...' );
1899: FOR RMcd IN CMcd
1900: LOOP
1901: -- bug3718694 Call CreateInterim procedure to insert record into
1902: -- ar_journal_interim .
1903: l_interim_rec := l_interim_rec_null ;
1904:
1905: l_interim_rec.status := 'NEW';
1906: l_interim_rec.actual_flag := 'A';

Line 1981: DELETE FROM ar_journal_interim

1977: p_BalanceId IN NUMBER,
1978: p_CategoryCode IN VARCHAR2 ) IS
1979: BEGIN
1980: --
1981: DELETE FROM ar_journal_interim
1982: WHERE reference22 = p_BalanceId
1983: AND reference28 = p_CategoryCode
1984: AND set_of_books_id = p_Report.SetOfBooksId
1985: AND request_id = p_Report.ReqId;

Line 2003: | Checks that the records inserted into ar_journal_interim balance for each |

1999: /*---------------------------------------------------------------------------*
2000: | PRIVATE PROCEDURE |
2001: | CheckBalance |
2002: | DESCRIPTION |
2003: | Checks that the records inserted into ar_journal_interim balance for each |
2004: | BalanceId (reference22). |
2005: | Any BalanceId that fails to balance will be reported on |
2006: | (via arp_standard.debug), and will be deleted with ClearOOB |
2007: | PARAMETERS |

Line 2029: FROM ar_journal_interim i

2025: SUM(nvl(i.entered_dr,0)) SumEnteredDr,
2026: SUM(nvl(i.entered_cr,0)) SumEnteredCr,
2027: SUM(nvl(i.accounted_dr,0)) SumAccountedDr,
2028: SUM(nvl(i.accounted_cr,0)) SumAccountedCr
2029: FROM ar_journal_interim i
2030: WHERE i.request_id = p_Report.ReqId
2031: AND i.set_of_books_id = p_Report.SetOfBooksId
2032: GROUP BY i.reference28,
2033: i.reference22

Line 2044: FROM ar_journal_interim i

2040: i.accounted_dr AccountedDr,
2041: i.accounted_cr AccountedCr,
2042: i.reference30 TableName,
2043: i.reference23 Id
2044: FROM ar_journal_interim i
2045: WHERE i.request_id = p_Report.ReqId
2046: AND i.set_of_books_id = p_Report.SetOfBooksId
2047: AND i.reference22 = p_BalanceId
2048: AND i.reference28 = p_CategoryCode