DBA Data[Home] [Help]

APPS.JL_ZZ_GL_INFL_ADJ_PKG dependencies on GL_INTERFACE

Line 440: -- GL_INTERFACE. --

436:
437:
438: ------------------------------------------------------------
439: -- Get group Id for the Journal Entries to be inserted in --
440: -- GL_INTERFACE. --
441: -- It also returns the inflation adjustment gain and loss --
442: -- account template and the index value for the particular--
443: -- period (the 'to' period). --
444: ------------------------------------------------------------

Line 459: SELECT gl_interface_control_s.nextval

455: statement VARCHAR2 (20);
456:
457: BEGIN
458: statement := 'GROUP ID';
459: SELECT gl_interface_control_s.nextval
460: INTO p_group_id
461: FROM sys.dual;
462:
463: statement := 'REI ACCOUNT';

Line 889: -- Inserts in GL_INTERFACE the lines passed as parameters.--

885: END get_cursor_values;
886:
887:
888: ------------------------------------------------------------
889: -- Inserts in GL_INTERFACE the lines passed as parameters.--
890: -- If the amount is 0 then do not insert any row. --
891: -- --
892: ------------------------------------------------------------
893: FUNCTION insert_gl_interface (p_set_of_books_id IN NUMBER

Line 893: FUNCTION insert_gl_interface (p_set_of_books_id IN NUMBER

889: -- Inserts in GL_INTERFACE the lines passed as parameters.--
890: -- If the amount is 0 then do not insert any row. --
891: -- --
892: ------------------------------------------------------------
893: FUNCTION insert_gl_interface (p_set_of_books_id IN NUMBER
894: , p_code_combination_id IN NUMBER
895: , p_accounting_date IN DATE
896: , p_currency_code IN VARCHAR2
897: , p_amount IN NUMBER

Line 910: INSERT INTO gl_interface (status

906: ------------------------------------------------------------
907: -- If there's nothing to adjust, then do nothing... --
908: ------------------------------------------------------------
909: IF p_amount <> 0 THEN
910: INSERT INTO gl_interface (status
911: , set_of_books_id
912: , accounting_date
913: , currency_code
914: , date_created

Line 953: END insert_gl_interface;

949: p_err_msg_name := substr (SQLERRM, 1, 100);
950: p_err_msg_code := 'ORA';
951: RETURN FALSE;
952:
953: END insert_gl_interface;
954:
955:
956: ------------------------------------------------------------
957: -- Gets the inflation adjustment gain and loss account --

Line 1310: -- Rounding before inserting in GL_INTERFACE and before --

1306: IF NOT same_value (to_char (c_code_combination_id)
1307: , previous_code_combination_id) THEN
1308:
1309: ------------------------------------------------------------
1310: -- Rounding before inserting in GL_INTERFACE and before --
1311: -- adding to the balancing segment total avoids unbalanced--
1312: -- journal entries. --
1313: ------------------------------------------------------------
1314: acct_total_adj_amount := round ((acct_total_adj_amount +

Line 1318: IF NOT insert_gl_interface (p_set_of_books_id

1314: acct_total_adj_amount := round ((acct_total_adj_amount +
1315: acct_begin_YTD_adj_amount)
1316: , currency_precision);
1317:
1318: IF NOT insert_gl_interface (p_set_of_books_id
1319: , previous_code_combination_id
1320: , accounting_date
1321: , set_of_books_currency_code
1322: , acct_total_adj_amount

Line 1389: IF NOT insert_gl_interface (p_set_of_books_id

1385:
1386: RAISE program_abort;
1387: END IF;
1388:
1389: IF NOT insert_gl_interface (p_set_of_books_id
1390: , infl_adj_gla
1391: , accounting_date
1392: , set_of_books_currency_code
1393: , balancing_segment_tot_amount

Line 1508: -- Rounding before inserting in GL_INTERFACE and before --

1504: ------------------------------------------------------------
1505: -- Insert the last JE's last account. --
1506: ------------------------------------------------------------
1507: ------------------------------------------------------------
1508: -- Rounding before inserting in GL_INTERFACE and before --
1509: -- adding to the balancing segment total avoids unbalanced--
1510: -- journal entries. --
1511: ------------------------------------------------------------
1512: acct_total_adj_amount := round ((acct_total_adj_amount

Line 1516: IF NOT insert_gl_interface (p_set_of_books_id

1512: acct_total_adj_amount := round ((acct_total_adj_amount
1513: + acct_begin_YTD_adj_amount)
1514: , currency_precision);
1515:
1516: IF NOT insert_gl_interface (p_set_of_books_id
1517: , previous_code_combination_id
1518: , accounting_date
1519: , set_of_books_currency_code
1520: , acct_total_adj_amount

Line 1561: IF NOT insert_gl_interface (p_set_of_books_id

1557: RAISE program_abort;
1558:
1559: END IF;
1560:
1561: IF NOT insert_gl_interface (p_set_of_books_id
1562: , infl_adj_gla
1563: , accounting_date
1564: , set_of_books_currency_code
1565: , balancing_segment_tot_amount