APPS.HXT_BATCH_PROCESS dependencies on PAY_BATCH_LINES

Line 1466: --l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;

1462: PROCEDURE dtl_to_BEE(p_values_rec IN HXT_BATCH_VALUES_V%ROWTYPE,
1463: p_sum_retcode IN OUT NOCOPY NUMBER,
1464: p_batch_sequence IN NUMBER)
1465: IS
1466: --l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
1467: l_batch_line_id PAY_BATCH_LINES.BATCH_LINE_ID%TYPE;
1468: l_value_meaning hr_lookups.meaning%TYPE;
1469: l_return NUMBER;
1470: l_line_ovn number;

Line 1467: l_batch_line_id PAY_BATCH_LINES.BATCH_LINE_ID%TYPE;

1463: p_sum_retcode IN OUT NOCOPY NUMBER,
1464: p_batch_sequence IN NUMBER)
1465: IS
1466: --l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
1467: l_batch_line_id PAY_BATCH_LINES.BATCH_LINE_ID%TYPE;
1468: l_value_meaning hr_lookups.meaning%TYPE;
1469: l_return NUMBER;
1470: l_line_ovn number;
1471:

Line 1483: TYPE pbl_values_table IS TABLE OF PAY_BATCH_LINES.VALUE_1%TYPE

1479: TYPE input_values_table IS TABLE OF input_value_record
1480: INDEX BY BINARY_INTEGER;
1481: hxt_value input_values_table;
1482:
1483: TYPE pbl_values_table IS TABLE OF PAY_BATCH_LINES.VALUE_1%TYPE
1484: INDEX BY BINARY_INTEGER;
1485: pbl_value pbl_values_table;
1486:
1487: CURSOR c_date_input_value(cp_element_type_id NUMBER

Line 2254: HXT_UTIL.DEBUG('Successful INSERT INTO pay_batch_lines'); --HXT115

2250: ,p_batch_line_id => l_batch_line_id
2251: ,p_object_version_number => l_line_ovn
2252: ,p_iv_all_internal_format => g_IV_format -- Bug 8888777
2253: );
2254: HXT_UTIL.DEBUG('Successful INSERT INTO pay_batch_lines'); --HXT115
2255: -- Update OTM detail row to show BEE line entry id
2256: IF p_values_rec.hrw_rowid IS NOT NULL THEN
2257: UPDATE HXT_DET_HOURS_WORKED_F
2258: set PBL_LINE_ID = l_batch_line_id

Line 2446: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;

2442: WHERE batch_id = p_batch_id;
2443: l_values_rec hxt_values_cur%ROWTYPE;
2444: we_have_lines BOOLEAN;
2445: l_return NUMBER;
2446: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
2447: BEGIN
2448: p_sum_retcode := 0;
2449:
2450: -- Bug 8888777

Line 2731: FROM pay_batch_lines line

2727: --
2728: --HXT11 not needed. declared in FOR loop batch_line_rec batch_line_cur%ROWTYPE;
2729: CURSOR batch_line_cur IS
2730: SELECT line.assignment_number, line.effective_date, line.batch_line_id,line.OBJECT_VERSION_NUMBER
2731: FROM pay_batch_lines line
2732: WHERE line.batch_id = p_batch_id;
2733: cursor c_get_batch_lines(p_batch_id number) is
2734: select batch_line_id,object_version_number
2735: from pay_batch_lines

Line 2735: from pay_batch_lines

2731: FROM pay_batch_lines line
2732: WHERE line.batch_id = p_batch_id;
2733: cursor c_get_batch_lines(p_batch_id number) is
2734: select batch_line_id,object_version_number
2735: from pay_batch_lines
2736: where batch_id = p_batch_id;
2737: -- Bug 13388573
2738: /*
2739: cursor c_get_retro_batch_ids(p_batch_id number) is

Line 2766: l_batch_line_id pay_batch_lines.batch_line_id%type;

2762: select object_version_number
2763: from pay_batch_headers
2764: where batch_id = p_batch_id;
2765: l_batch_ovn pay_batch_headers.object_version_number%type;
2766: l_batch_line_id pay_batch_lines.batch_line_id%type;
2767: l_line_ovn pay_batch_headers.object_version_number%type;
2768: l_num VARCHAR2(5);
2769: BEGIN
2770: -- if no time period is specified, delete all PayMIX entries

Line 3082: -- batch upto lines in pay_batch_lines to the tables for

3078: END get_upgrade_status;
3079:
3080: -- Bug 9494444
3081: -- Added this new procedure to snap the details of this
3082: -- batch upto lines in pay_batch_lines to the tables for
3083: -- recording this for Dashboard.
3084:
3085: PROCEDURE snap_retrieval_details(p_batch_id IN NUMBER)
3086: IS