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 328: sql_curs :=dbms_sql.open_cursor;

324: BEGIN
325: --
326: hr_utility.set_location('pytrgl.trans_pay_costs',10);
327: --
328: sql_curs :=dbms_sql.open_cursor;
329: --
330: OPEN transfer_payrolls (i_payroll_action_id);
331: --
332: hr_utility.set_location('pytrgl.trans_pay_costs',20);

Line 493: dbms_sql.parse(sql_curs,

489: --
490:
491: -- For Post 11i
492: if (PAY_ADHOC_UTILS_PKG.chk_post_r11i = 'Y') then
493: dbms_sql.parse(sql_curs,
494: 'INSERT INTO gl_interface
495: (status,
496: ledger_id,
497: set_of_books_id,

Line 696: dbms_sql.v7);

692: AND et.effective_end_date
693: GROUP BY cst.cost_allocation_keyflex_id,
694: cst.debit_or_credit,
695: decode (IV.uom, ''M'', et.output_currency_code, ''STAT'')',
696: dbms_sql.v7);
697:
698: else
699: dbms_sql.parse(sql_curs,
700: 'INSERT INTO gl_interface

Line 699: dbms_sql.parse(sql_curs,

695: decode (IV.uom, ''M'', et.output_currency_code, ''STAT'')',
696: dbms_sql.v7);
697:
698: else
699: dbms_sql.parse(sql_curs,
700: 'INSERT INTO gl_interface
701: (status,
702: set_of_books_id,
703: user_je_source_name,

Line 900: dbms_sql.v7);

896: AND et.effective_end_date
897: GROUP BY cst.cost_allocation_keyflex_id,
898: cst.debit_or_credit,
899: decode (IV.uom, ''M'', et.output_currency_code, ''STAT'')',
900: dbms_sql.v7);
901: end if;
902: --
903: hr_utility.set_location('pytrgl.trans_pay_costs',80);
904: --

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

903: hr_utility.set_location('pytrgl.trans_pay_costs',80);
904: --
905: -- Bind the variable values to the cursor values.
906: --
907: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
908: c_run_action_id);
909: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
910: c_cost_action_id);
911: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);

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

905: -- Bind the variable values to the cursor values.
906: --
907: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
908: c_run_action_id);
909: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
910: c_cost_action_id);
911: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);
912: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
913: dbms_sql.bind_variable(sql_curs,'c_conversion_date',

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

907: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
908: c_run_action_id);
909: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
910: c_cost_action_id);
911: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);
912: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
913: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
914: c_conversion_date);
915: dbms_sql.bind_variable(sql_curs,'c_accounting_date',

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

908: c_run_action_id);
909: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
910: c_cost_action_id);
911: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);
912: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
913: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
914: c_conversion_date);
915: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
916: c_accounting_date);

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

909: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
910: c_cost_action_id);
911: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);
912: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
913: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
914: c_conversion_date);
915: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
916: c_accounting_date);
917: dbms_sql.bind_variable(sql_curs,'c_run_date',

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

911: dbms_sql.bind_variable(sql_curs,'c_payroll_id', c_payroll_id);
912: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
913: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
914: c_conversion_date);
915: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
916: c_accounting_date);
917: dbms_sql.bind_variable(sql_curs,'c_run_date',
918: c_run_date);
919: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',

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

913: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
914: c_conversion_date);
915: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
916: c_accounting_date);
917: dbms_sql.bind_variable(sql_curs,'c_run_date',
918: c_run_date);
919: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
920: c_run_date_earned);
921: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',

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

915: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
916: c_accounting_date);
917: dbms_sql.bind_variable(sql_curs,'c_run_date',
918: c_run_date);
919: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
920: c_run_date_earned);
921: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
922: c_set_of_books_id);
923: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',

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

917: dbms_sql.bind_variable(sql_curs,'c_run_date',
918: c_run_date);
919: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
920: c_run_date_earned);
921: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
922: c_set_of_books_id);
923: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
924: i_payroll_action_id);
925: dbms_sql.bind_variable(sql_curs,'l_source_name',

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

919: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
920: c_run_date_earned);
921: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
922: c_set_of_books_id);
923: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
924: i_payroll_action_id);
925: dbms_sql.bind_variable(sql_curs,'l_source_name',
926: l_source_name);
927: dbms_sql.bind_variable(sql_curs,'l_category_name',

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

921: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
922: c_set_of_books_id);
923: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
924: i_payroll_action_id);
925: dbms_sql.bind_variable(sql_curs,'l_source_name',
926: l_source_name);
927: dbms_sql.bind_variable(sql_curs,'l_category_name',
928: l_category_name);
929: dbms_sql.bind_variable(sql_curs,'l_group_id',

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

923: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
924: i_payroll_action_id);
925: dbms_sql.bind_variable(sql_curs,'l_source_name',
926: l_source_name);
927: dbms_sql.bind_variable(sql_curs,'l_category_name',
928: l_category_name);
929: dbms_sql.bind_variable(sql_curs,'l_group_id',
930: l_group_id);
931: --

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

925: dbms_sql.bind_variable(sql_curs,'l_source_name',
926: l_source_name);
927: dbms_sql.bind_variable(sql_curs,'l_category_name',
928: l_category_name);
929: dbms_sql.bind_variable(sql_curs,'l_group_id',
930: l_group_id);
931: --
932: -- Execute the insert statment.
933: --

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

930: l_group_id);
931: --
932: -- Execute the insert statment.
933: --
934: rows_processed := dbms_sql.execute(sql_curs);
935: --
936: hr_utility.set_location('pytrgl.trans_pay_costs',90);
937: --
938: -- Update the assignment actions. Mark as processed.

Line 975: dbms_sql.close_cursor(sql_curs);

971: hr_utility.set_location('pytrgl.trans_pay_costs',110);
972: --
973: CLOSE transfer_payrolls;
974: --
975: dbms_sql.close_cursor(sql_curs);
976: --
977: hr_utility.set_location('pytrgl.trans_pay_costs',120);
978: --
979: END trans_pay_costs;

Line 1116: sql_curs := dbms_sql.open_cursor;

1112: BEGIN
1113: --
1114: hr_utility.set_location('pytrgl.trans_pay_costs_mt',10);
1115: --
1116: sql_curs := dbms_sql.open_cursor;
1117: --
1118: OPEN transfer_payrolls (i_payroll_action_id);
1119: --
1120: hr_utility.set_location('pytrgl.trans_pay_costs_mt',20);

Line 1330: dbms_sql.parse(sql_curs,

1326: -- the segment list is so we cannot bind to variables.
1327: --
1328: -- For post 11i
1329: if (PAY_ADHOC_UTILS_PKG.chk_post_r11i = 'Y') then
1330: dbms_sql.parse(sql_curs,
1331: 'INSERT INTO gl_interface
1332: (status,
1333: ledger_id,
1334: set_of_books_id,

Line 1399: dbms_sql.v7);

1395: GROUP BY pgl.cost_allocation_keyflex_id,
1396: decode(pgl.entered_dr, 0, 0, 1),
1397: nvl(pgl.accounting_date, :c_accounting_date),
1398: pgl.currency_code',
1399: dbms_sql.v7);
1400: else
1401: dbms_sql.parse(sql_curs,
1402: 'INSERT INTO gl_interface
1403: (status,

Line 1401: dbms_sql.parse(sql_curs,

1397: nvl(pgl.accounting_date, :c_accounting_date),
1398: pgl.currency_code',
1399: dbms_sql.v7);
1400: else
1401: dbms_sql.parse(sql_curs,
1402: 'INSERT INTO gl_interface
1403: (status,
1404: set_of_books_id,
1405: user_je_source_name,

Line 1468: dbms_sql.v7);

1464: GROUP BY pgl.cost_allocation_keyflex_id,
1465: decode(pgl.entered_dr, 0, 0, 1),
1466: nvl(pgl.accounting_date, :c_accounting_date),
1467: pgl.currency_code',
1468: dbms_sql.v7);
1469: end if;
1470: --
1471: hr_utility.set_location('pytrgl.trans_pay_costs_mt',80);
1472: --

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

1471: hr_utility.set_location('pytrgl.trans_pay_costs_mt',80);
1472: --
1473: -- Bind the variable values to the cursor values.
1474: --
1475: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
1476: c_run_action_id);
1477: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
1478: c_cost_action_id);
1479: dbms_sql.bind_variable(sql_curs,'c_action_type',

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

1473: -- Bind the variable values to the cursor values.
1474: --
1475: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
1476: c_run_action_id);
1477: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
1478: c_cost_action_id);
1479: dbms_sql.bind_variable(sql_curs,'c_action_type',
1480: c_action_type);
1481: dbms_sql.bind_variable(sql_curs,'c_accounting_date',

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

1475: dbms_sql.bind_variable(sql_curs,'c_run_action_id',
1476: c_run_action_id);
1477: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
1478: c_cost_action_id);
1479: dbms_sql.bind_variable(sql_curs,'c_action_type',
1480: c_action_type);
1481: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
1482: c_accounting_date);
1483: dbms_sql.bind_variable(sql_curs,'c_run_date',

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

1477: dbms_sql.bind_variable(sql_curs,'c_cost_action_id',
1478: c_cost_action_id);
1479: dbms_sql.bind_variable(sql_curs,'c_action_type',
1480: c_action_type);
1481: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
1482: c_accounting_date);
1483: dbms_sql.bind_variable(sql_curs,'c_run_date',
1484: c_run_date);
1485: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',

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

1479: dbms_sql.bind_variable(sql_curs,'c_action_type',
1480: c_action_type);
1481: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
1482: c_accounting_date);
1483: dbms_sql.bind_variable(sql_curs,'c_run_date',
1484: c_run_date);
1485: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
1486: c_run_date_earned);
1487: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',

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

1481: dbms_sql.bind_variable(sql_curs,'c_accounting_date',
1482: c_accounting_date);
1483: dbms_sql.bind_variable(sql_curs,'c_run_date',
1484: c_run_date);
1485: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
1486: c_run_date_earned);
1487: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
1488: c_set_of_books_id);
1489: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',

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

1483: dbms_sql.bind_variable(sql_curs,'c_run_date',
1484: c_run_date);
1485: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
1486: c_run_date_earned);
1487: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
1488: c_set_of_books_id);
1489: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
1490: i_payroll_action_id);
1491: dbms_sql.bind_variable(sql_curs,'l_source_name',

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

1485: dbms_sql.bind_variable(sql_curs,'c_run_date_earned',
1486: c_run_date_earned);
1487: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
1488: c_set_of_books_id);
1489: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
1490: i_payroll_action_id);
1491: dbms_sql.bind_variable(sql_curs,'l_source_name',
1492: l_source_name);
1493: dbms_sql.bind_variable(sql_curs,'l_category_name',

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

1487: dbms_sql.bind_variable(sql_curs,'c_set_of_books_id',
1488: c_set_of_books_id);
1489: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
1490: i_payroll_action_id);
1491: dbms_sql.bind_variable(sql_curs,'l_source_name',
1492: l_source_name);
1493: dbms_sql.bind_variable(sql_curs,'l_category_name',
1494: l_category_name);
1495: dbms_sql.bind_variable(sql_curs,'l_group_id',

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

1489: dbms_sql.bind_variable(sql_curs,'i_payroll_action_id',
1490: i_payroll_action_id);
1491: dbms_sql.bind_variable(sql_curs,'l_source_name',
1492: l_source_name);
1493: dbms_sql.bind_variable(sql_curs,'l_category_name',
1494: l_category_name);
1495: dbms_sql.bind_variable(sql_curs,'l_group_id',
1496: l_group_id);
1497: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);

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

1491: dbms_sql.bind_variable(sql_curs,'l_source_name',
1492: l_source_name);
1493: dbms_sql.bind_variable(sql_curs,'l_category_name',
1494: l_category_name);
1495: dbms_sql.bind_variable(sql_curs,'l_group_id',
1496: l_group_id);
1497: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
1498: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
1499: c_conversion_date);

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

1493: dbms_sql.bind_variable(sql_curs,'l_category_name',
1494: l_category_name);
1495: dbms_sql.bind_variable(sql_curs,'l_group_id',
1496: l_group_id);
1497: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
1498: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
1499: c_conversion_date);
1500:
1501: /* Bug 7401269: Variable wasn't bound for costing of payments.

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

1494: l_category_name);
1495: dbms_sql.bind_variable(sql_curs,'l_group_id',
1496: l_group_id);
1497: dbms_sql.bind_variable(sql_curs,'l_currency_type', l_currency_type);
1498: dbms_sql.bind_variable(sql_curs,'c_conversion_date',
1499: c_conversion_date);
1500:
1501: /* Bug 7401269: Variable wasn't bound for costing of payments.
1502: Added an OR condition for binding variable in case of

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

1503: costing of payment run before transfer to GL */
1504:
1505: if ((c_action_type = 'EC' or c_action_type = 'CP') and
1506: c_pay_id is null) then
1507: dbms_sql.bind_variable(sql_curs,'c_payroll_id',
1508: c_payroll_id);
1509: end if;
1510: --
1511: -- Execute the insert statment.

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

1509: end if;
1510: --
1511: -- Execute the insert statment.
1512: --
1513: rows_processed := dbms_sql.execute(sql_curs);
1514: --
1515: hr_utility.set_location('pytrgl.trans_pay_costs_mt',90);
1516: --
1517: END LOOP;

Line 1523: dbms_sql.close_cursor(sql_curs);

1519: hr_utility.set_location('pytrgl.trans_pay_costs_mt',100);
1520: --
1521: CLOSE transfer_payrolls;
1522: --
1523: dbms_sql.close_cursor(sql_curs);
1524: --
1525: hr_utility.set_location('pytrgl.trans_pay_costs_mt',110);
1526: --
1527: COMMIT;