APPS.CSD_HV_WIP_JOB_PVT dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 1057: p_srl_nmbrs_interface_rec IN mtl_serial_numbers_interface%ROWTYPE,

1053:
1054:
1055: PROCEDURE insert_upd_serial_numbers
1056: (
1057: p_srl_nmbrs_interface_rec IN mtl_serial_numbers_interface%ROWTYPE,
1058: x_return_status OUT NOCOPY VARCHAR2
1059: )
1060: IS
1061:

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

1083: END IF;
1084:
1085: x_return_status := FND_API.G_RET_STS_SUCCESS;
1086:
1087: Select count(*) into l_row_exists from mtl_serial_numbers_interface
1088: where transaction_interface_id =
1089: p_srl_nmbrs_interface_rec.transaction_interface_id;
1090:
1091: IF l_row_exists = 1 THEN

Line 1095: UPDATE mtl_serial_numbers_interface

1091: IF l_row_exists = 1 THEN
1092:
1093: BEGIN
1094:
1095: UPDATE mtl_serial_numbers_interface
1096: SET
1097: fm_serial_number = p_srl_nmbrs_interface_rec.fm_serial_number
1098: where transaction_interface_id =
1099: p_srl_nmbrs_interface_rec.transaction_interface_id;

Line 1123: INSERT INTO mtl_serial_numbers_interface

1119:
1120: --insert into table mtl_transactions_interface
1121: BEGIN
1122:
1123: INSERT INTO mtl_serial_numbers_interface
1124: ( last_updated_by,
1125: last_update_date,
1126: last_update_login,
1127: created_by,

Line 2866: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;

2862: -- Records to hold the Job header,details
2863: -- and mtl_transactions_interface data
2864:
2865: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
2866: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
2867: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
2868: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
2869:
2870:

Line 3939: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;

3935:
3936: -- Records to hold mtl_transactions_interface data
3937: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
3938: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3939: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3940:
3941: CURSOR get_mtl_header_id IS
3942: SELECT mtl_material_transactions_s.nextval from dual;
3943: