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

Line 335: sql_curs :=dbms_sql.open_cursor;

331: BEGIN
332: --
333: hr_utility.set_location('pytrgl.trans_pay_costs',10);
334: --
335: sql_curs :=dbms_sql.open_cursor;
336: --
337: OPEN transfer_payrolls (i_payroll_action_id);
338: --
339: hr_utility.set_location('pytrgl.trans_pay_costs',20);

Line 500: dbms_sql.parse(sql_curs,

496: --
497:
498: -- For Post 11i
499: if (PAY_ADHOC_UTILS_PKG.chk_post_r11i = 'Y') then
500: dbms_sql.parse(sql_curs,
501: 'INSERT INTO gl_interface
502: (status,
503: ledger_id,
504: set_of_books_id,

Line 703: dbms_sql.v7);

699: AND et.effective_end_date
700: GROUP BY cst.cost_allocation_keyflex_id,
701: cst.debit_or_credit,
702: decode (IV.uom, ''M'', et.output_currency_code, ''STAT'')',
703: dbms_sql.v7);
704:
705: else
706: dbms_sql.parse(sql_curs,
707: 'INSERT INTO gl_interface

Line 706: dbms_sql.parse(sql_curs,

702: decode (IV.uom, ''M'', et.output_currency_code, ''STAT'')',
703: dbms_sql.v7);
704:
705: else
706: dbms_sql.parse(sql_curs,
707: 'INSERT INTO gl_interface
708: (status,
709: set_of_books_id,
710: user_je_source_name,

Line 907: dbms_sql.v7);

903: AND et.effective_end_date
904: GROUP BY cst.cost_allocation_keyflex_id,
905: cst.debit_or_credit,
906: decode (IV.uom, ''M'', et.output_currency_code, ''STAT'')',
907: dbms_sql.v7);
908: end if;
909: --
910: hr_utility.set_location('pytrgl.trans_pay_costs',80);
911: --

Line 914: dbms_sql.bind_variable(sql_curs,'c_run_action_id',

910: hr_utility.set_location('pytrgl.trans_pay_costs',80);
911: --
912: -- Bind the variable values to the cursor values.
913: --
914: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
915: c_run_action_id);
916: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
917: c_cost_action_id);
918: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);

Line 916: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',

912: -- Bind the variable values to the cursor values.
913: --
914: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
915: c_run_action_id);
916: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
917: c_cost_action_id);
918: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);
919: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
920: dbms_sql.bind_variable(sql_curs,'c_conversion_date',

Line 918: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);

914: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
915: c_run_action_id);
916: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
917: c_cost_action_id);
918: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);
919: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
920: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
921: c_conversion_date);
922: dbms_sql.bind_variable(sql_curs,'c_accounting_date',

Line 919: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);

915: c_run_action_id);
916: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
917: c_cost_action_id);
918: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);
919: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
920: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
921: c_conversion_date);
922: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
923: c_accounting_date);

Line 920: dbms_sql.bind_variable(sql_curs,'c_conversion_date',

916: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
917: c_cost_action_id);
918: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);
919: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
920: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
921: c_conversion_date);
922: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
923: c_accounting_date);
924: dbms_sql.bind_variable(sql_curs,'c_run_date',

Line 922: dbms_sql.bind_variable(sql_curs,'c_accounting_date',

918: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);
919: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
920: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
921: c_conversion_date);
922: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
923: c_accounting_date);
924: dbms_sql.bind_variable(sql_curs,'c_run_date',
925: c_run_date);
926: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',

Line 924: dbms_sql.bind_variable(sql_curs,'c_run_date',

920: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
921: c_conversion_date);
922: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
923: c_accounting_date);
924: dbms_sql.bind_variable(sql_curs,'c_run_date',
925: c_run_date);
926: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
927: c_run_date_earned);
928: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',

Line 926: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',

922: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
923: c_accounting_date);
924: dbms_sql.bind_variable(sql_curs,'c_run_date',
925: c_run_date);
926: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
927: c_run_date_earned);
928: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
929: c_set_of_books_id);
930: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',

Line 928: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',

924: dbms_sql.bind_variable(sql_curs,'c_run_date',
925: c_run_date);
926: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
927: c_run_date_earned);
928: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
929: c_set_of_books_id);
930: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
931: i_payroll_action_id);
932: dbms_sql.bind_variable(sql_curs,'l_source_name',

Line 930: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',

926: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
927: c_run_date_earned);
928: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
929: c_set_of_books_id);
930: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
931: i_payroll_action_id);
932: dbms_sql.bind_variable(sql_curs,'l_source_name',
933: l_source_name);
934: dbms_sql.bind_variable(sql_curs,'l_category_name',

Line 932: dbms_sql.bind_variable(sql_curs,'l_source_name',

928: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
929: c_set_of_books_id);
930: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
931: i_payroll_action_id);
932: dbms_sql.bind_variable(sql_curs,'l_source_name',
933: l_source_name);
934: dbms_sql.bind_variable(sql_curs,'l_category_name',
935: l_category_name);
936: dbms_sql.bind_variable(sql_curs,'l_group_id',

Line 934: dbms_sql.bind_variable(sql_curs,'l_category_name',

930: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
931: i_payroll_action_id);
932: dbms_sql.bind_variable(sql_curs,'l_source_name',
933: l_source_name);
934: dbms_sql.bind_variable(sql_curs,'l_category_name',
935: l_category_name);
936: dbms_sql.bind_variable(sql_curs,'l_group_id',
937: l_group_id);
938: --

Line 936: dbms_sql.bind_variable(sql_curs,'l_group_id',

932: dbms_sql.bind_variable(sql_curs,'l_source_name',
933: l_source_name);
934: dbms_sql.bind_variable(sql_curs,'l_category_name',
935: l_category_name);
936: dbms_sql.bind_variable(sql_curs,'l_group_id',
937: l_group_id);
938: --
939: -- Execute the insert statment.
940: --

Line 941: rows_processed := dbms_sql.execute(sql_curs);

937: l_group_id);
938: --
939: -- Execute the insert statment.
940: --
941: rows_processed := dbms_sql.execute(sql_curs);
942: --
943: hr_utility.set_location('pytrgl.trans_pay_costs',90);
944: --
945: -- Update the assignment actions. Mark as processed.

Line 982: dbms_sql.close_cursor(sql_curs);

978: hr_utility.set_location('pytrgl.trans_pay_costs',110);
979: --
980: CLOSE transfer_payrolls;
981: --
982: dbms_sql.close_cursor(sql_curs);
983: --
984: hr_utility.set_location('pytrgl.trans_pay_costs',120);
985: --
986: END trans_pay_costs;

Line 1135: sql_curs := dbms_sql.open_cursor;

1131: BEGIN
1132: --
1133: hr_utility.set_location('pytrgl.trans_pay_costs_mt',10);
1134: --
1135: sql_curs := dbms_sql.open_cursor;
1136: --
1137: OPEN transfer_payrolls (i_payroll_action_id);
1138: --
1139: hr_utility.set_location('pytrgl.trans_pay_costs_mt',20);

Line 1349: dbms_sql.parse(sql_curs,

1345: -- the segment list is so we cannot bind to variables.
1346: --
1347: -- For post 11i
1348: if (PAY_ADHOC_UTILS_PKG.chk_post_r11i = 'Y') then
1349: dbms_sql.parse(sql_curs,
1350: 'INSERT INTO gl_interface
1351: (status,
1352: ledger_id,
1353: set_of_books_id,

Line 1418: dbms_sql.v7);

1414: GROUP BY pgl.cost_allocation_keyflex_id,
1415: decode(nvl(pgl.entered_dr,0), 0, 0, 1),
1416: nvl(pgl.accounting_date, :c_accounting_date),
1417: pgl.currency_code',
1418: dbms_sql.v7);
1419: else
1420: dbms_sql.parse(sql_curs,
1421: 'INSERT INTO gl_interface
1422: (status,

Line 1420: dbms_sql.parse(sql_curs,

1416: nvl(pgl.accounting_date, :c_accounting_date),
1417: pgl.currency_code',
1418: dbms_sql.v7);
1419: else
1420: dbms_sql.parse(sql_curs,
1421: 'INSERT INTO gl_interface
1422: (status,
1423: set_of_books_id,
1424: user_je_source_name,

Line 1487: dbms_sql.v7);

1483: GROUP BY pgl.cost_allocation_keyflex_id,
1484: decode(nvl(pgl.entered_dr,0), 0, 0, 1),
1485: nvl(pgl.accounting_date, :c_accounting_date),
1486: pgl.currency_code',
1487: dbms_sql.v7);
1488: end if;
1489: --
1490: hr_utility.set_location('pytrgl.trans_pay_costs_mt',80);
1491: --

Line 1494: dbms_sql.bind_variable(sql_curs,'c_run_action_id',

1490: hr_utility.set_location('pytrgl.trans_pay_costs_mt',80);
1491: --
1492: -- Bind the variable values to the cursor values.
1493: --
1494: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
1495: c_run_action_id);
1496: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
1497: c_cost_action_id);
1498: dbms_sql.bind_variable(sql_curs,'c_action_type',

Line 1496: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',

1492: -- Bind the variable values to the cursor values.
1493: --
1494: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
1495: c_run_action_id);
1496: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
1497: c_cost_action_id);
1498: dbms_sql.bind_variable(sql_curs,'c_action_type',
1499: c_action_type);
1500: dbms_sql.bind_variable(sql_curs,'c_accounting_date',

Line 1498: dbms_sql.bind_variable(sql_curs,'c_action_type',

1494: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
1495: c_run_action_id);
1496: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
1497: c_cost_action_id);
1498: dbms_sql.bind_variable(sql_curs,'c_action_type',
1499: c_action_type);
1500: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
1501: c_accounting_date);
1502: dbms_sql.bind_variable(sql_curs,'c_run_date',

Line 1500: dbms_sql.bind_variable(sql_curs,'c_accounting_date',

1496: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
1497: c_cost_action_id);
1498: dbms_sql.bind_variable(sql_curs,'c_action_type',
1499: c_action_type);
1500: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
1501: c_accounting_date);
1502: dbms_sql.bind_variable(sql_curs,'c_run_date',
1503: c_run_date);
1504: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',

Line 1502: dbms_sql.bind_variable(sql_curs,'c_run_date',

1498: dbms_sql.bind_variable(sql_curs,'c_action_type',
1499: c_action_type);
1500: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
1501: c_accounting_date);
1502: dbms_sql.bind_variable(sql_curs,'c_run_date',
1503: c_run_date);
1504: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
1505: c_run_date_earned);
1506: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',

Line 1504: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',

1500: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
1501: c_accounting_date);
1502: dbms_sql.bind_variable(sql_curs,'c_run_date',
1503: c_run_date);
1504: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
1505: c_run_date_earned);
1506: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
1507: c_set_of_books_id);
1508: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',

Line 1506: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',

1502: dbms_sql.bind_variable(sql_curs,'c_run_date',
1503: c_run_date);
1504: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
1505: c_run_date_earned);
1506: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
1507: c_set_of_books_id);
1508: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
1509: i_payroll_action_id);
1510: dbms_sql.bind_variable(sql_curs,'l_source_name',

Line 1508: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',

1504: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
1505: c_run_date_earned);
1506: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
1507: c_set_of_books_id);
1508: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
1509: i_payroll_action_id);
1510: dbms_sql.bind_variable(sql_curs,'l_source_name',
1511: l_source_name);
1512: dbms_sql.bind_variable(sql_curs,'l_category_name',

Line 1510: dbms_sql.bind_variable(sql_curs,'l_source_name',

1506: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
1507: c_set_of_books_id);
1508: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
1509: i_payroll_action_id);
1510: dbms_sql.bind_variable(sql_curs,'l_source_name',
1511: l_source_name);
1512: dbms_sql.bind_variable(sql_curs,'l_category_name',
1513: l_category_name);
1514: dbms_sql.bind_variable(sql_curs,'l_group_id',

Line 1512: dbms_sql.bind_variable(sql_curs,'l_category_name',

1508: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
1509: i_payroll_action_id);
1510: dbms_sql.bind_variable(sql_curs,'l_source_name',
1511: l_source_name);
1512: dbms_sql.bind_variable(sql_curs,'l_category_name',
1513: l_category_name);
1514: dbms_sql.bind_variable(sql_curs,'l_group_id',
1515: l_group_id);
1516: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);

Line 1514: dbms_sql.bind_variable(sql_curs,'l_group_id',

1510: dbms_sql.bind_variable(sql_curs,'l_source_name',
1511: l_source_name);
1512: dbms_sql.bind_variable(sql_curs,'l_category_name',
1513: l_category_name);
1514: dbms_sql.bind_variable(sql_curs,'l_group_id',
1515: l_group_id);
1516: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
1517: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
1518: c_conversion_date);

Line 1516: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);

1512: dbms_sql.bind_variable(sql_curs,'l_category_name',
1513: l_category_name);
1514: dbms_sql.bind_variable(sql_curs,'l_group_id',
1515: l_group_id);
1516: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
1517: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
1518: c_conversion_date);
1519:
1520: /* Bug 7401269: Variable wasn't bound for costing of payments.

Line 1517: dbms_sql.bind_variable(sql_curs,'c_conversion_date',

1513: l_category_name);
1514: dbms_sql.bind_variable(sql_curs,'l_group_id',
1515: l_group_id);
1516: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
1517: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
1518: c_conversion_date);
1519:
1520: /* Bug 7401269: Variable wasn't bound for costing of payments.
1521: Added an OR condition for binding variable in case of

Line 1526: dbms_sql.bind_variable(sql_curs,'c_payroll_id',

1522: costing of payment run before transfer to GL */
1523:
1524: if ((c_action_type = 'EC' or c_action_type = 'CP') and
1525: c_pay_id is null) then
1526: dbms_sql.bind_variable(sql_curs,'c_payroll_id',
1527: c_payroll_id);
1528: end if;
1529: --
1530: -- Execute the insert statment.

Line 1532: rows_processed := dbms_sql.execute(sql_curs);

1528: end if;
1529: --
1530: -- Execute the insert statment.
1531: --
1532: rows_processed := dbms_sql.execute(sql_curs);
1533: --
1534: hr_utility.set_location('pytrgl.trans_pay_costs_mt',90);
1535: --
1536: END LOOP;

Line 1542: dbms_sql.close_cursor(sql_curs);

1538: hr_utility.set_location('pytrgl.trans_pay_costs_mt',100);
1539: --
1540: CLOSE transfer_payrolls;
1541: --
1542: dbms_sql.close_cursor(sql_curs);
1543: --
1544: hr_utility.set_location('pytrgl.trans_pay_costs_mt',110);
1545: --
1546: COMMIT;