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.JL_ZZ_GL_INFL_ADJ_PKG dependencies on DBMS_SQL

Line 790: dbms_sql.parse (p_main_cursor, rtrim (cursor_string), dbms_sql.NATIVE);

786: ------------------------------------------------------------
787: -- Dynamic sql operations to parse the select statement --
788: -- and to define columns datatypes. --
789: ------------------------------------------------------------
790: dbms_sql.parse (p_main_cursor, rtrim (cursor_string), dbms_sql.NATIVE);
791: dbms_sql.bind_variable (p_main_cursor, ':1', p_set_of_books_id);
792: dbms_sql.bind_variable (p_main_cursor, ':2', set_of_books_currency_code);
793: dbms_sql.bind_variable (p_main_cursor, ':3', period_year_from);
794: dbms_sql.bind_variable (p_main_cursor, ':4', period_year_to);

Line 791: dbms_sql.bind_variable (p_main_cursor, ':1', p_set_of_books_id);

787: -- Dynamic sql operations to parse the select statement --
788: -- and to define columns datatypes. --
789: ------------------------------------------------------------
790: dbms_sql.parse (p_main_cursor, rtrim (cursor_string), dbms_sql.NATIVE);
791: dbms_sql.bind_variable (p_main_cursor, ':1', p_set_of_books_id);
792: dbms_sql.bind_variable (p_main_cursor, ':2', set_of_books_currency_code);
793: dbms_sql.bind_variable (p_main_cursor, ':3', period_year_from);
794: dbms_sql.bind_variable (p_main_cursor, ':4', period_year_to);
795: dbms_sql.bind_variable (p_main_cursor, ':5', period_num_from);

Line 792: dbms_sql.bind_variable (p_main_cursor, ':2', set_of_books_currency_code);

788: -- and to define columns datatypes. --
789: ------------------------------------------------------------
790: dbms_sql.parse (p_main_cursor, rtrim (cursor_string), dbms_sql.NATIVE);
791: dbms_sql.bind_variable (p_main_cursor, ':1', p_set_of_books_id);
792: dbms_sql.bind_variable (p_main_cursor, ':2', set_of_books_currency_code);
793: dbms_sql.bind_variable (p_main_cursor, ':3', period_year_from);
794: dbms_sql.bind_variable (p_main_cursor, ':4', period_year_to);
795: dbms_sql.bind_variable (p_main_cursor, ':5', period_num_from);
796: dbms_sql.bind_variable (p_main_cursor, ':6', period_num_to);

Line 793: dbms_sql.bind_variable (p_main_cursor, ':3', period_year_from);

789: ------------------------------------------------------------
790: dbms_sql.parse (p_main_cursor, rtrim (cursor_string), dbms_sql.NATIVE);
791: dbms_sql.bind_variable (p_main_cursor, ':1', p_set_of_books_id);
792: dbms_sql.bind_variable (p_main_cursor, ':2', set_of_books_currency_code);
793: dbms_sql.bind_variable (p_main_cursor, ':3', period_year_from);
794: dbms_sql.bind_variable (p_main_cursor, ':4', period_year_to);
795: dbms_sql.bind_variable (p_main_cursor, ':5', period_num_from);
796: dbms_sql.bind_variable (p_main_cursor, ':6', period_num_to);
797: dbms_sql.bind_variable (p_main_cursor, ':7', p_axi_run_id);

Line 794: dbms_sql.bind_variable (p_main_cursor, ':4', period_year_to);

790: dbms_sql.parse (p_main_cursor, rtrim (cursor_string), dbms_sql.NATIVE);
791: dbms_sql.bind_variable (p_main_cursor, ':1', p_set_of_books_id);
792: dbms_sql.bind_variable (p_main_cursor, ':2', set_of_books_currency_code);
793: dbms_sql.bind_variable (p_main_cursor, ':3', period_year_from);
794: dbms_sql.bind_variable (p_main_cursor, ':4', period_year_to);
795: dbms_sql.bind_variable (p_main_cursor, ':5', period_num_from);
796: dbms_sql.bind_variable (p_main_cursor, ':6', period_num_to);
797: dbms_sql.bind_variable (p_main_cursor, ':7', p_axi_run_id);
798:

Line 795: dbms_sql.bind_variable (p_main_cursor, ':5', period_num_from);

791: dbms_sql.bind_variable (p_main_cursor, ':1', p_set_of_books_id);
792: dbms_sql.bind_variable (p_main_cursor, ':2', set_of_books_currency_code);
793: dbms_sql.bind_variable (p_main_cursor, ':3', period_year_from);
794: dbms_sql.bind_variable (p_main_cursor, ':4', period_year_to);
795: dbms_sql.bind_variable (p_main_cursor, ':5', period_num_from);
796: dbms_sql.bind_variable (p_main_cursor, ':6', period_num_to);
797: dbms_sql.bind_variable (p_main_cursor, ':7', p_axi_run_id);
798:
799: dbms_sql.define_column (p_main_cursor, 1, code_combination_id);

Line 796: dbms_sql.bind_variable (p_main_cursor, ':6', period_num_to);

792: dbms_sql.bind_variable (p_main_cursor, ':2', set_of_books_currency_code);
793: dbms_sql.bind_variable (p_main_cursor, ':3', period_year_from);
794: dbms_sql.bind_variable (p_main_cursor, ':4', period_year_to);
795: dbms_sql.bind_variable (p_main_cursor, ':5', period_num_from);
796: dbms_sql.bind_variable (p_main_cursor, ':6', period_num_to);
797: dbms_sql.bind_variable (p_main_cursor, ':7', p_axi_run_id);
798:
799: dbms_sql.define_column (p_main_cursor, 1, code_combination_id);
800: dbms_sql.define_column (p_main_cursor, 2, segment, 25);

Line 797: dbms_sql.bind_variable (p_main_cursor, ':7', p_axi_run_id);

793: dbms_sql.bind_variable (p_main_cursor, ':3', period_year_from);
794: dbms_sql.bind_variable (p_main_cursor, ':4', period_year_to);
795: dbms_sql.bind_variable (p_main_cursor, ':5', period_num_from);
796: dbms_sql.bind_variable (p_main_cursor, ':6', period_num_to);
797: dbms_sql.bind_variable (p_main_cursor, ':7', p_axi_run_id);
798:
799: dbms_sql.define_column (p_main_cursor, 1, code_combination_id);
800: dbms_sql.define_column (p_main_cursor, 2, segment, 25);
801: dbms_sql.define_column (p_main_cursor, 3, balance);

Line 799: dbms_sql.define_column (p_main_cursor, 1, code_combination_id);

795: dbms_sql.bind_variable (p_main_cursor, ':5', period_num_from);
796: dbms_sql.bind_variable (p_main_cursor, ':6', period_num_to);
797: dbms_sql.bind_variable (p_main_cursor, ':7', p_axi_run_id);
798:
799: dbms_sql.define_column (p_main_cursor, 1, code_combination_id);
800: dbms_sql.define_column (p_main_cursor, 2, segment, 25);
801: dbms_sql.define_column (p_main_cursor, 3, balance);
802: dbms_sql.define_column (p_main_cursor, 4, balance);
803: dbms_sql.define_column (p_main_cursor, 5, period_name, 15);

Line 800: dbms_sql.define_column (p_main_cursor, 2, segment, 25);

796: dbms_sql.bind_variable (p_main_cursor, ':6', period_num_to);
797: dbms_sql.bind_variable (p_main_cursor, ':7', p_axi_run_id);
798:
799: dbms_sql.define_column (p_main_cursor, 1, code_combination_id);
800: dbms_sql.define_column (p_main_cursor, 2, segment, 25);
801: dbms_sql.define_column (p_main_cursor, 3, balance);
802: dbms_sql.define_column (p_main_cursor, 4, balance);
803: dbms_sql.define_column (p_main_cursor, 5, period_name, 15);
804: dbms_sql.define_column (p_main_cursor, 6, period_year_to);

Line 801: dbms_sql.define_column (p_main_cursor, 3, balance);

797: dbms_sql.bind_variable (p_main_cursor, ':7', p_axi_run_id);
798:
799: dbms_sql.define_column (p_main_cursor, 1, code_combination_id);
800: dbms_sql.define_column (p_main_cursor, 2, segment, 25);
801: dbms_sql.define_column (p_main_cursor, 3, balance);
802: dbms_sql.define_column (p_main_cursor, 4, balance);
803: dbms_sql.define_column (p_main_cursor, 5, period_name, 15);
804: dbms_sql.define_column (p_main_cursor, 6, period_year_to);
805: dbms_sql.define_column (p_main_cursor, 7, period_num_to);

Line 802: dbms_sql.define_column (p_main_cursor, 4, balance);

798:
799: dbms_sql.define_column (p_main_cursor, 1, code_combination_id);
800: dbms_sql.define_column (p_main_cursor, 2, segment, 25);
801: dbms_sql.define_column (p_main_cursor, 3, balance);
802: dbms_sql.define_column (p_main_cursor, 4, balance);
803: dbms_sql.define_column (p_main_cursor, 5, period_name, 15);
804: dbms_sql.define_column (p_main_cursor, 6, period_year_to);
805: dbms_sql.define_column (p_main_cursor, 7, period_num_to);
806:

Line 803: dbms_sql.define_column (p_main_cursor, 5, period_name, 15);

799: dbms_sql.define_column (p_main_cursor, 1, code_combination_id);
800: dbms_sql.define_column (p_main_cursor, 2, segment, 25);
801: dbms_sql.define_column (p_main_cursor, 3, balance);
802: dbms_sql.define_column (p_main_cursor, 4, balance);
803: dbms_sql.define_column (p_main_cursor, 5, period_name, 15);
804: dbms_sql.define_column (p_main_cursor, 6, period_year_to);
805: dbms_sql.define_column (p_main_cursor, 7, period_num_to);
806:
807: RETURN TRUE;

Line 804: dbms_sql.define_column (p_main_cursor, 6, period_year_to);

800: dbms_sql.define_column (p_main_cursor, 2, segment, 25);
801: dbms_sql.define_column (p_main_cursor, 3, balance);
802: dbms_sql.define_column (p_main_cursor, 4, balance);
803: dbms_sql.define_column (p_main_cursor, 5, period_name, 15);
804: dbms_sql.define_column (p_main_cursor, 6, period_year_to);
805: dbms_sql.define_column (p_main_cursor, 7, period_num_to);
806:
807: RETURN TRUE;
808:

Line 805: dbms_sql.define_column (p_main_cursor, 7, period_num_to);

801: dbms_sql.define_column (p_main_cursor, 3, balance);
802: dbms_sql.define_column (p_main_cursor, 4, balance);
803: dbms_sql.define_column (p_main_cursor, 5, period_name, 15);
804: dbms_sql.define_column (p_main_cursor, 6, period_year_to);
805: dbms_sql.define_column (p_main_cursor, 7, period_num_to);
806:
807: RETURN TRUE;
808:
809: EXCEPTION

Line 838: dbms_sql.column_value (p_main_cursor, 1, p_code_combination_id);

834: non_func_ytd NUMBER;
835: non_func_ptd NUMBER;
836:
837: BEGIN
838: dbms_sql.column_value (p_main_cursor, 1, p_code_combination_id);
839: dbms_sql.column_value (p_main_cursor, 2, p_balancing_segment);
840: dbms_sql.column_value (p_main_cursor, 3, p_ytd_balance);
841: dbms_sql.column_value (p_main_cursor, 4, p_ptd_balance);
842: dbms_sql.column_value (p_main_cursor, 5, p_period_name);

Line 839: dbms_sql.column_value (p_main_cursor, 2, p_balancing_segment);

835: non_func_ptd NUMBER;
836:
837: BEGIN
838: dbms_sql.column_value (p_main_cursor, 1, p_code_combination_id);
839: dbms_sql.column_value (p_main_cursor, 2, p_balancing_segment);
840: dbms_sql.column_value (p_main_cursor, 3, p_ytd_balance);
841: dbms_sql.column_value (p_main_cursor, 4, p_ptd_balance);
842: dbms_sql.column_value (p_main_cursor, 5, p_period_name);
843: /*

Line 840: dbms_sql.column_value (p_main_cursor, 3, p_ytd_balance);

836:
837: BEGIN
838: dbms_sql.column_value (p_main_cursor, 1, p_code_combination_id);
839: dbms_sql.column_value (p_main_cursor, 2, p_balancing_segment);
840: dbms_sql.column_value (p_main_cursor, 3, p_ytd_balance);
841: dbms_sql.column_value (p_main_cursor, 4, p_ptd_balance);
842: dbms_sql.column_value (p_main_cursor, 5, p_period_name);
843: /*
844: IF profile_country_code = 'CL' THEN

Line 841: dbms_sql.column_value (p_main_cursor, 4, p_ptd_balance);

837: BEGIN
838: dbms_sql.column_value (p_main_cursor, 1, p_code_combination_id);
839: dbms_sql.column_value (p_main_cursor, 2, p_balancing_segment);
840: dbms_sql.column_value (p_main_cursor, 3, p_ytd_balance);
841: dbms_sql.column_value (p_main_cursor, 4, p_ptd_balance);
842: dbms_sql.column_value (p_main_cursor, 5, p_period_name);
843: /*
844: IF profile_country_code = 'CL' THEN
845: IF NOT get_non_func_amt(p_set_of_books_id

Line 842: dbms_sql.column_value (p_main_cursor, 5, p_period_name);

838: dbms_sql.column_value (p_main_cursor, 1, p_code_combination_id);
839: dbms_sql.column_value (p_main_cursor, 2, p_balancing_segment);
840: dbms_sql.column_value (p_main_cursor, 3, p_ytd_balance);
841: dbms_sql.column_value (p_main_cursor, 4, p_ptd_balance);
842: dbms_sql.column_value (p_main_cursor, 5, p_period_name);
843: /*
844: IF profile_country_code = 'CL' THEN
845: IF NOT get_non_func_amt(p_set_of_books_id
846: , p_code_combination_id

Line 1243: main_cursor := dbms_sql.open_cursor;

1239:
1240: ------------------------------------------------------------
1241: -- Open accounts cursor using dynamic SQL statements. --
1242: ------------------------------------------------------------
1243: main_cursor := dbms_sql.open_cursor;
1244:
1245: ------------------------------------------------------------
1246: -- Creates the accounts cursor ordering the rows by --
1247: -- balancing segment (i.e. the order for fetching the --

Line 1262: number_records := dbms_sql.execute (main_cursor);

1258:
1259: RAISE program_abort;
1260: END IF;
1261:
1262: number_records := dbms_sql.execute (main_cursor);
1263: ------------------------------------------------------------
1264: -- Set Flag to Yes before While loop. --
1265: ------------------------------------------------------------
1266:

Line 1271: WHILE dbms_sql.fetch_rows (main_cursor) > 0 LOOP

1267: zero_main_records := 'YES';
1268:
1269: consider_YTD_amount := 'Y';
1270:
1271: WHILE dbms_sql.fetch_rows (main_cursor) > 0 LOOP
1272:
1273: zero_main_records := 'NO';
1274: ------------------------------------------------------------
1275: -- Read the values from the cursor's columns --

Line 1483: dbms_sql.close_cursor (main_cursor);

1479: -- If no record to adjust then return from procedure. --
1480: ------------------------------------------------------------
1481:
1482: IF zero_main_records = 'YES' THEN
1483: dbms_sql.close_cursor (main_cursor);
1484: COMMIT;
1485: RETURN 0;
1486: END IF;
1487:

Line 1558: dbms_sql.close_cursor (main_cursor);

1554:
1555: RAISE program_abort;
1556: END IF;
1557:
1558: dbms_sql.close_cursor (main_cursor);
1559:
1560: COMMIT;
1561:
1562: RETURN 0;