DBA Data[Home] [Help]

APPS.IGIRCBAP dependencies on GL_INTERFACE

Line 542: | igi_ar_cash_basis_dists, and a record into gl_interface |

538: | PRIVATE PROCEDURE |
539: | CreateDistribution |
540: | DESCRIPTION |
541: | Creates a distribution by inserting a record into |
542: | igi_ar_cash_basis_dists, and a record into gl_interface |
543: | PARAMETERS |
544: | |
545: | EXCEPTIONS RAISED |
546: | |

Line 628: INSERT INTO gl_interface

624: RAISE;
625: END;
626: --
627: BEGIN
628: INSERT INTO gl_interface
629: (
630: created_by,
631: date_created,
632: status,

Line 1147: INSERT INTO gl_interface

1143: WritetoLog( l_state_level, 'PostNonDistApplications',' AR_RECEIVABLE_APPLICATIONS (non-app)...' );
1144: FOR RRa IN CRa
1145: LOOP
1146: BEGIN
1147: INSERT INTO gl_interface
1148: (
1149: created_by,
1150: date_created,
1151: status,

Line 1594: INSERT INTO gl_interface

1590: l_Count NUMBER :=0;
1591: --
1592: PROCEDURE InsertIntoGl( RCrh IN CCrh%ROWTYPE ) IS
1593: BEGIN
1594: INSERT INTO gl_interface
1595: (
1596: created_by,
1597: date_created,
1598: status,

Line 1682: WriteToLog ( l_state_level, 'InsertIntoGL','Insert into GL interface okay!');

1678: RCrh.ModifiedType||'_'||RCrh.SourceType, -- reference29
1679: 'AR_CASH_RECEIPT_HISTORY' -- reference30
1680: );
1681: if sql%found then
1682: WriteToLog ( l_state_level, 'InsertIntoGL','Insert into GL interface okay!');
1683: end if;
1684: EXCEPTION
1685: WHEN OTHERS THEN
1686: WritetoLog( l_excep_level, 'InsertIntoGL','InsertIntoGl:' );

Line 1770: -- first create the debit in gl_interface to the account_code_combination_id

1766: WritetoLog( l_state_level, 'PostMiscCashDistributions',' ' );
1767: WritetoLog( l_state_level, 'PostMiscCashDistributions',' AR_MISC_CASH_DISTRIBUTIONS...' );
1768: FOR RMcd IN CMcd
1769: LOOP
1770: -- first create the debit in gl_interface to the account_code_combination_id
1771: INSERT INTO gl_interface
1772: (
1773: created_by,
1774: date_created,

Line 1771: INSERT INTO gl_interface

1767: WritetoLog( l_state_level, 'PostMiscCashDistributions',' AR_MISC_CASH_DISTRIBUTIONS...' );
1768: FOR RMcd IN CMcd
1769: LOOP
1770: -- first create the debit in gl_interface to the account_code_combination_id
1771: INSERT INTO gl_interface
1772: (
1773: created_by,
1774: date_created,
1775: status,

Line 1957: FROM gl_interface

1953: --
1954: DELETE FROM igi_ar_cash_basis_dists
1955: WHERE cash_basis_distribution_id IN (
1956: SELECT reference23
1957: FROM gl_interface
1958: WHERE reference22 = p_BalanceId
1959: AND reference28 = p_CategoryCode
1960: AND set_of_books_id = p_Post.CashSetOfBooksId
1961: AND group_id = p_Post.PostingControlId

Line 1967: DELETE FROM gl_interface

1963: AND reference30 = 'AR_CASH_BASIS_DISTRIBUTIONS'
1964: );
1965: END IF;
1966: --
1967: DELETE FROM gl_interface
1968: WHERE reference22 = p_BalanceId
1969: AND reference28 = p_CategoryCode
1970: AND set_of_books_id = p_Post.CashSetOfBooksId
1971: AND group_id = p_Post.PostingControlId

Line 1988: | Checks that the records inserted into gl_interface balance for each |

1984: /*---------------------------------------------------------------------------*
1985: | PRIVATE PROCEDURE |
1986: | CheckBalance |
1987: | DESCRIPTION |
1988: | Checks that the records inserted into gl_interface balance for each |
1989: | BalanceId (reference22). |
1990: | Any BalanceId that fails to balance will be reported on |
1991: | (via WritetoLog), and will be deleted with ClearOOB |
1992: | PARAMETERS |

Line 2015: FROM gl_interface i

2011: SUM(nvl(i.entered_dr,0)) SumEnteredDr,
2012: SUM(nvl(i.entered_cr,0)) SumEnteredCr,
2013: SUM(nvl(i.accounted_dr,0)) SumAccountedDr,
2014: SUM(nvl(i.accounted_cr,0)) SumAccountedCr
2015: FROM gl_interface i
2016: WHERE i.group_id = p_Post.PostingControlId
2017: AND i.user_je_source_name = p_Post.UserSource
2018: AND i.set_of_books_id = p_Post.CashSetOfBooksId
2019: AND i.accounting_date BETWEEN p_Post.GlDateFrom

Line 2035: FROM gl_interface i

2031: i.accounted_dr AccountedDr,
2032: i.accounted_cr AccountedCr,
2033: i.reference30 TableName,
2034: i.reference23 Id
2035: FROM gl_interface i
2036: WHERE i.group_id = p_Post.PostingControlId
2037: AND i.user_je_source_name = p_Post.UserSource
2038: AND set_of_books_id = p_Post.CashSetOfBooksId
2039: AND i.reference22 = p_BalanceId

Line 2169: FROM gl_interface

2165: RETURN BOOLEAN IS
2166:
2167: CURSOR c_gl IS
2168: SELECT distinct 'x'
2169: FROM gl_interface
2170: WHERE set_of_books_id = fp_cash_sob_id
2171: AND group_id = fp_posting_control_id
2172: AND user_je_source_name = fp_user_source;
2173:

Line 2414: l_cash_gl_interface_run_id NUMBER;

2410: , p_post_thru_date IN DATE
2411: )
2412: AS
2413: l_cash_set_of_books_id NUMBER;
2414: l_cash_gl_interface_run_id NUMBER;
2415: l_cash_gllezl_request_id NUMBER;
2416: l_arc_summary_flag VARCHAR2(1):= 'N';
2417: l_arc_run_gl_import VARCHAR2(1):='N';
2418: l_je_source_name GL_JE_SOURCES.JE_SOURCE_NAME%TYPE;

Line 2424: INTO l_cash_gl_interface_run_id

2420: -- Submit Cash GL Journal Import
2421: SELECT GL_JOURNAL_IMPORT_S.nextval
2422: , sp.ARC_cash_sob_id
2423: , nvl(sp.arc_je_source_name, 'Receivables') arc_je_source_name
2424: INTO l_cash_gl_interface_run_id
2425: , l_cash_set_of_books_id
2426: , l_je_source_name
2427: FROM igi_ar_system_options sp
2428: , ar_system_parameters asp

Line 2444: INSERT INTO gl_interface_control

2440: IF l_arc_run_gl_import <> 'Y' THEN
2441: return;
2442: END IF;
2443:
2444: INSERT INTO gl_interface_control
2445: ( je_source_name
2446: , status
2447: , interface_run_id
2448: , group_id

Line 2452: , l_cash_gl_interface_run_id

2448: , group_id
2449: , set_of_books_id)
2450: VALUES ( l_je_source_name
2451: , 'S'
2452: , l_cash_gl_interface_run_id
2453: , p_posting_control_id
2454: , l_cash_set_of_books_id
2455: );
2456:

Line 2464: , l_cash_gl_interface_run_id

2460: , 'GLLEZL'
2461: , null
2462: , null
2463: , FALSE
2464: , l_cash_gl_interface_run_id
2465: , l_cash_set_of_books_id
2466: , 'N' -- post_errors_to_suspense
2467: , to_char(p_start_date,'YYYY/MM/DD')
2468: , to_char(p_post_thru_date,'YYYY/MM/DD')