APPS.CSD_HV_WIP_JOB_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1017: p_srl_nmbrs_interface_rec IN mtl_serial_numbers_interface%ROWTYPE,

1013:
1014:
1015: PROCEDURE insert_upd_serial_numbers
1016: (
1017: p_srl_nmbrs_interface_rec IN mtl_serial_numbers_interface%ROWTYPE,
1018: x_return_status OUT NOCOPY VARCHAR2
1019: )
1020: IS
1021:

Line 1047: Select count(*) into l_row_exists from mtl_serial_numbers_interface

1043: END IF;
1044:
1045: x_return_status := FND_API.G_RET_STS_SUCCESS;
1046:
1047: Select count(*) into l_row_exists from mtl_serial_numbers_interface
1048: where transaction_interface_id =
1049: p_srl_nmbrs_interface_rec.transaction_interface_id;
1050:
1051: IF l_row_exists = 1 THEN

Line 1055: UPDATE mtl_serial_numbers_interface

1051: IF l_row_exists = 1 THEN
1052:
1053: BEGIN
1054:
1055: UPDATE mtl_serial_numbers_interface
1056: SET
1057: fm_serial_number = p_srl_nmbrs_interface_rec.fm_serial_number
1058: where transaction_interface_id =
1059: p_srl_nmbrs_interface_rec.transaction_interface_id;

Line 1083: INSERT INTO mtl_serial_numbers_interface

1079:
1080: --insert into table mtl_transactions_interface
1081: BEGIN
1082:
1083: INSERT INTO mtl_serial_numbers_interface
1084: ( last_updated_by,
1085: last_update_date,
1086: last_update_login,
1087: created_by,

Line 2528: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;

2524: -- Records to hold the Job header,details
2525: -- and mtl_transactions_interface data
2526:
2527: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
2528: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
2529: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
2530: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
2531:
2532:

Line 3502: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;

3498:
3499: -- Records to hold mtl_transactions_interface data
3500: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
3501: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3502: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3503:
3504: CURSOR get_mtl_header_id IS
3505: SELECT mtl_material_transactions_s.nextval from dual;
3506:

Line 5491: select current_status, current_subinventory_code from mtl_serial_numbers

5487: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
5488:
5489:
5490: Cursor c_get_serial_info(p_item_id number, p_serial_number varchar2, p_org_id number) is
5491: select current_status, current_subinventory_code from mtl_serial_numbers
5492: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
5493:
5494:
5495: -- Cursor c_get_min_operation_seq(p_wip_entity_id number) is

Line 6164: select current_status, current_subinventory_code from mtl_serial_numbers

6160: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
6161:
6162:
6163: Cursor c_get_serial_info(p_item_id number, p_serial_number varchar2, p_org_id number) is
6164: select current_status, current_subinventory_code from mtl_serial_numbers
6165: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
6166:
6167:
6168: Cursor c_get_min_operation_seq(p_wip_entity_id number) is