APPS.HXT_BATCH_PROCESS dependencies on PAY_BATCH_LINES

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

970: --
971: PROCEDURE dtl_to_BEE(p_values_rec IN HXT_BATCH_VALUES_V%ROWTYPE,
972: p_sum_retcode IN OUT NOCOPY NUMBER,
973: p_batch_sequence IN NUMBER) IS
974: --l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
975: l_batch_line_id PAY_BATCH_LINES.BATCH_LINE_ID%TYPE;
976: l_value_meaning hr_lookups.meaning%TYPE;
977: l_return NUMBER;
978: l_line_ovn number;

Line 975: l_batch_line_id PAY_BATCH_LINES.BATCH_LINE_ID%TYPE;

971: PROCEDURE dtl_to_BEE(p_values_rec IN HXT_BATCH_VALUES_V%ROWTYPE,
972: p_sum_retcode IN OUT NOCOPY NUMBER,
973: p_batch_sequence IN NUMBER) IS
974: --l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
975: l_batch_line_id PAY_BATCH_LINES.BATCH_LINE_ID%TYPE;
976: l_value_meaning hr_lookups.meaning%TYPE;
977: l_return NUMBER;
978: l_line_ovn number;
979: TYPE input_value_record IS RECORD

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

982: lookup PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE);
983: TYPE input_values_table IS TABLE OF input_value_record
984: INDEX BY BINARY_INTEGER;
985: hxt_value input_values_table;
986: TYPE pbl_values_table IS TABLE OF PAY_BATCH_LINES.VALUE_1%TYPE
987: INDEX BY BINARY_INTEGER;
988: pbl_value pbl_values_table;
989: CURSOR c_date_input_value(cp_element_type_id NUMBER
990: ,cp_assignment_id NUMBER

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

1354: ,p_value_15 => pbl_value(15)
1355: ,p_batch_line_id => l_batch_line_id
1356: ,p_object_version_number => l_line_ovn
1357: );
1358: HXT_UTIL.DEBUG('Successful INSERT INTO pay_batch_lines'); --HXT115
1359: -- Update OTM detail row to show BEE line entry id
1360: IF p_values_rec.hrw_rowid IS NOT NULL THEN
1361: UPDATE HXT_DET_HOURS_WORKED_F
1362: set PBL_LINE_ID = l_batch_line_id

Line 1399: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;

1395: WHERE batch_id = p_batch_id;
1396: l_values_rec hxt_values_cur%ROWTYPE;
1397: we_have_lines BOOLEAN;
1398: l_return NUMBER;
1399: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
1400: BEGIN
1401: p_sum_retcode := 0;
1402: --
1403: -- If profile value set to 'Y', sum hours only to send to BEE

Line 1652: FROM pay_batch_lines line

1648: --
1649: --HXT11 not needed. declared in FOR loop batch_line_rec batch_line_cur%ROWTYPE;
1650: CURSOR batch_line_cur IS
1651: SELECT line.assignment_number, line.effective_date, line.batch_line_id,line.OBJECT_VERSION_NUMBER
1652: FROM pay_batch_lines line
1653: WHERE line.batch_id = p_batch_id;
1654: cursor c_get_batch_lines(p_batch_id number) is
1655: select batch_line_id,object_version_number
1656: from pay_batch_lines

Line 1656: from pay_batch_lines

1652: FROM pay_batch_lines line
1653: WHERE line.batch_id = p_batch_id;
1654: cursor c_get_batch_lines(p_batch_id number) is
1655: select batch_line_id,object_version_number
1656: from pay_batch_lines
1657: where batch_id = p_batch_id;
1658: cursor c_get_retro_batch_ids(p_batch_id number) is
1659: SELECT distinct(hrw.retro_batch_id) retro_batch_id,pbh.object_version_number
1660: FROM hxt_det_hours_worked_f hrw,

Line 1672: l_batch_line_id pay_batch_lines.batch_line_id%type;

1668: select object_version_number
1669: from pay_batch_headers
1670: where batch_id = p_batch_id;
1671: l_batch_ovn pay_batch_headers.object_version_number%type;
1672: l_batch_line_id pay_batch_lines.batch_line_id%type;
1673: l_line_ovn pay_batch_headers.object_version_number%type;
1674: BEGIN
1675: -- if no time period is specified, delete all PayMIX entries
1676: IF p_time_period_id IS NULL THEN