DBA Data[Home] [Help]

APPS.PAY_BEE_SS dependencies on PAY_BATCH_LINES

Line 987: insert into pay_batch_lines (BATCH_LINE_ID,

983: ,p_value_14 => input_values(14)
984: ,p_value_15 => input_values(15),
985: p_batch_line_id => l_batch_line_id,
986: p_object_version_number => l_object_version_number); */
987: insert into pay_batch_lines (BATCH_LINE_ID,
988: COST_ALLOCATION_KEYFLEX_ID,
989: ELEMENT_TYPE_ID,
990: ASSIGNMENT_ID,
991: BATCH_ID,

Line 1014: values(pay_batch_lines_s.nextval,

1010: VALUE_13,
1011: VALUE_14,
1012: VALUE_15,
1013: OBJECT_VERSION_NUMBER)
1014: values(pay_batch_lines_s.nextval,
1015: l_costing_flex_id,
1016: l_element_type_id,
1017: l_assignment_id,
1018: l_batch_id,

Line 1076: select batch_line_id from pay_batch_lines where batch_id=l_batch_id;

1072: l_validation_count number :=0;
1073:
1074:
1075: cursor batch_lines_cur is
1076: select batch_line_id from pay_batch_lines where batch_id=l_batch_id;
1077:
1078: cursor batch_validation_messages_cur is
1079: SELECT source_type_meaning
1080: , line_text

Line 1167: delete from pay_batch_lines where batch_line_id=l_batch_line_id;

1163: exit when batch_lines_cur%notfound;
1164: -- bee_trace('Deleting batch line');
1165: --pay_batch_element_entry_api.delete_batch_line(p_batch_line_id=>l_batch_line_id,p_object_version_number=>1);
1166:
1167: delete from pay_batch_lines where batch_line_id=l_batch_line_id;
1168: end loop;
1169:
1170: close batch_lines_cur;
1171:

Line 1407: insert into pay_batch_lines (BATCH_LINE_ID,

1403: ,p_value_15 => input_values(15),
1404: p_batch_line_id => l_batch_line_id,
1405: p_object_version_number => l_object_version_number); */
1406:
1407: insert into pay_batch_lines (BATCH_LINE_ID,
1408: COST_ALLOCATION_KEYFLEX_ID,
1409: ELEMENT_TYPE_ID,
1410: ASSIGNMENT_ID,
1411: BATCH_ID,

Line 1434: values(pay_batch_lines_s.nextval,

1430: VALUE_13,
1431: VALUE_14,
1432: VALUE_15,
1433: OBJECT_VERSION_NUMBER)
1434: values(pay_batch_lines_s.nextval,
1435: l_costing_flex_id,
1436: l_element_type_id,
1437: l_assignment_id,
1438: l_batch_id,