APPS.HXC_RETRIEVAL_ROLLBACK dependencies on PAY_BATCH_LINES

Line 921: -- Takes in one line ( rowtype of table PAY_BATCH_LINES)

917:
918:
919:
920: -- Function to reverse a given line for any batch.
921: -- Takes in one line ( rowtype of table PAY_BATCH_LINES)
922: -- and returns with reversed Hours
923: -- Eg. -8 for 8
924:
925: FUNCTION reversed_line(p_lines PAY_BATCH_LINES%ROWTYPE)

Line 925: FUNCTION reversed_line(p_lines PAY_BATCH_LINES%ROWTYPE)

921: -- Takes in one line ( rowtype of table PAY_BATCH_LINES)
922: -- and returns with reversed Hours
923: -- Eg. -8 for 8
924:
925: FUNCTION reversed_line(p_lines PAY_BATCH_LINES%ROWTYPE)
926: RETURN pay_batch_lines%ROWTYPE
927: IS
928:
929: CURSOR get_sequence(p_element_type_id IN NUMBER)

Line 926: RETURN pay_batch_lines%ROWTYPE

922: -- and returns with reversed Hours
923: -- Eg. -8 for 8
924:
925: FUNCTION reversed_line(p_lines PAY_BATCH_LINES%ROWTYPE)
926: RETURN pay_batch_lines%ROWTYPE
927: IS
928:
929: CURSOR get_sequence(p_element_type_id IN NUMBER)
930: IS SELECT display_sequence

Line 937: l_out_lines pay_batch_lines%ROWTYPE;

933: AND name = 'Hours';
934:
935:
936: l_sequence NUMBER;
937: l_out_lines pay_batch_lines%ROWTYPE;
938:
939: BEGIN
940:
941: -- If we already saw this element type id before, we know its

Line 1174: FROM pay_batch_lines pbl,

1170: /*
1171: CURSOR get_lines
1172: IS SELECT batch_line_id,
1173: object_version_number
1174: FROM pay_batch_lines pbl,
1175: TABLE(return_ids(l_lines)) list
1176: WHERE list.column_value = pbl.batch_line_id;
1177: */ -- Commented for the bug 13832327
1178:

Line 1182: FROM pay_batch_lines

1178:
1179: -- Bug 16446212
1180: l_sql VARCHAR2(32000) :=
1181: 'SELECT *
1182: FROM pay_batch_lines
1183: WHERE batch_line_id IN ';
1184:
1185: l_sql2 VARCHAR2(32000) :=
1186: 'SELECT *

Line 1187: FROM pay_batch_lines

1183: WHERE batch_line_id IN ';
1184:
1185: l_sql2 VARCHAR2(32000) :=
1186: 'SELECT *
1187: FROM pay_batch_lines
1188: WHERE batch_line_id IN ';
1189:
1190: l_lines_list VARCHAR2(32000) := '(';
1191: l_lines_list2 VARCHAR2(32000) := '(';

Line 1193: TYPE LINESTAB IS TABLE OF pay_batch_lines%ROWTYPE;

1189:
1190: l_lines_list VARCHAR2(32000) := '(';
1191: l_lines_list2 VARCHAR2(32000) := '(';
1192:
1193: TYPE LINESTAB IS TABLE OF pay_batch_lines%ROWTYPE;
1194:
1195: l_status VARCHAR2(5);
1196: line_tab LINESTAB;
1197: ovn_tab NUMTAB;