APPS.INV_RECEIVING_TRANSACTION dependencies on WMS_LPN_CONTENTS

Line 178: UPDATE wms_lpn_contents

174: SET lpn_context = 6,
175: organization_id = l_organization_id
176: WHERE lpn_id = l_lpn_id;
177:
178: UPDATE wms_lpn_contents
179: SET organization_id = l_organization_id
180: WHERE parent_lpn_id = l_lpn_id;
181:
182: UPDATE mtl_serial_numbers

Line 1095: UPDATE wms_lpn_contents

1091: CLOSE c_mmtt_txn_temp_id;
1092: END;
1093:
1094: BEGIN
1095: UPDATE wms_lpn_contents
1096: SET txn_error_flag = 'Y'
1097: WHERE source_header_id = p_group_id;
1098: EXCEPTION
1099: WHEN no_data_found THEN

Line 1103: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Exception while updating wms_lpn_contents to error : 200',4);

1099: WHEN no_data_found THEN
1100: NULL;
1101: WHEN OTHERS THEN
1102: IF (l_debug = 1) THEN
1103: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Exception while updating wms_lpn_contents to error : 200',4);
1104: END IF;
1105: END;
1106:
1107: BEGIN