DBA Data[Home] [Help]

APPS.INV_COST_GROUP_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 790: FROM mtl_txn_request_lines

786: l_subinventory_code,
787: l_transfer_subinventory,
788: l_from_locator_id,
789: l_to_locator_id
790: FROM mtl_txn_request_lines
791: WHERE line_id = l_line_id;
792: END IF;
793:
794: IF l_transfer_organization_id IS NOT NULL THEN

Line 1023: print_debug('update the mtl_txn_request_lines with cost group ' ||

1019: transfer_cost_group_id = Nvl(transfer_cost_group_id, l_transfer_cost_group_id)
1020: where transaction_temp_id = l_line_id;
1021: ELSIF p_input_type = G_INPUT_MOLINE THEN
1022: IF (l_debug = 1) THEN
1023: print_debug('update the mtl_txn_request_lines with cost group ' ||
1024: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1025: END IF;
1026: update mtl_txn_request_lines
1027: set from_cost_Group_id = l_cost_group_id,

Line 1026: update mtl_txn_request_lines

1022: IF (l_debug = 1) THEN
1023: print_debug('update the mtl_txn_request_lines with cost group ' ||
1024: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1025: END IF;
1026: update mtl_txn_request_lines
1027: set from_cost_Group_id = l_cost_group_id,
1028: to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)
1029: where line_id = l_line_id;
1030: end if;

Line 1062: print_debug('update the mtl_txn_request_lines with to cost group null');

1058: SET transfer_cost_group_id = NULL
1059: WHERE transaction_temp_id = l_line_id;
1060: ELSIF p_input_type = G_INPUT_MOLINE THEN
1061: IF (l_debug = 1) THEN
1062: print_debug('update the mtl_txn_request_lines with to cost group null');
1063: END IF;
1064: UPDATE mtl_txn_request_lines
1065: SET to_cost_group_id = null
1066: WHERE line_id = l_line_id;

Line 1064: UPDATE mtl_txn_request_lines

1060: ELSIF p_input_type = G_INPUT_MOLINE THEN
1061: IF (l_debug = 1) THEN
1062: print_debug('update the mtl_txn_request_lines with to cost group null');
1063: END IF;
1064: UPDATE mtl_txn_request_lines
1065: SET to_cost_group_id = null
1066: WHERE line_id = l_line_id;
1067: END IF;
1068: ELSE

Line 1104: print_debug('update the mtl_txn_request_lines with cost group ' ||

1100: SET cost_group_id = l_cost_group_id
1101: WHERE transaction_temp_id = l_line_id;
1102: ELSIF p_input_type = G_INPUT_MOLINE THEN
1103: IF (l_debug = 1) THEN
1104: print_debug('update the mtl_txn_request_lines with cost group ' ||
1105: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1106: END IF;
1107: UPDATE mtl_txn_request_lines
1108: SET from_cost_group_id = l_cost_group_id

Line 1107: UPDATE mtl_txn_request_lines

1103: IF (l_debug = 1) THEN
1104: print_debug('update the mtl_txn_request_lines with cost group ' ||
1105: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1106: END IF;
1107: UPDATE mtl_txn_request_lines
1108: SET from_cost_group_id = l_cost_group_id
1109: WHERE line_id = l_line_id;
1110: END IF;
1111: END IF;-- for org transfer ,dest locator is project

Line 1156: print_debug('update the mtl_txn_request_lines with cost group ' || l_cost_group_id);

1152: --transfer_cost_group_id = Nvl(transfer_cost_group_id, l_transfer_cost_group_id)
1153: WHERE transaction_temp_id = l_line_id;
1154: ELSIF p_input_type = G_INPUT_MOLINE THEN
1155: IF (l_debug = 1) THEN
1156: print_debug('update the mtl_txn_request_lines with cost group ' || l_cost_group_id);
1157: END IF;
1158: UPDATE mtl_txn_request_lines
1159: SET from_cost_group_id = l_cost_group_id
1160: --to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)

Line 1158: UPDATE mtl_txn_request_lines

1154: ELSIF p_input_type = G_INPUT_MOLINE THEN
1155: IF (l_debug = 1) THEN
1156: print_debug('update the mtl_txn_request_lines with cost group ' || l_cost_group_id);
1157: END IF;
1158: UPDATE mtl_txn_request_lines
1159: SET from_cost_group_id = l_cost_group_id
1160: --to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)
1161: WHERE line_id = l_line_id;
1162: END IF;

Line 1178: print_debug('update the mtl_txn_request_lines with cost group ' ||

1174: transfer_cost_group_id = Nvl(transfer_cost_group_id, l_transfer_cost_group_id)
1175: WHERE transaction_temp_id = l_line_id;
1176: ELSIF p_input_type = G_INPUT_MOLINE THEN
1177: IF (l_debug = 1) THEN
1178: print_debug('update the mtl_txn_request_lines with cost group ' ||
1179: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1180: END IF;
1181: UPDATE mtl_txn_request_lines
1182: SET from_cost_group_id = l_cost_group_id,

Line 1181: UPDATE mtl_txn_request_lines

1177: IF (l_debug = 1) THEN
1178: print_debug('update the mtl_txn_request_lines with cost group ' ||
1179: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1180: END IF;
1181: UPDATE mtl_txn_request_lines
1182: SET from_cost_group_id = l_cost_group_id,
1183: to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)
1184: WHERE line_id = l_line_id;
1185: END IF;

Line 1238: print_debug('update the mtl_txn_request_lines with from cost group null');

1234: WHERE transaction_temp_id = l_line_id;
1235:
1236: ELSIF p_input_type = G_INPUT_MOLINE THEN
1237: IF (l_debug = 1) THEN
1238: print_debug('update the mtl_txn_request_lines with from cost group null');
1239: print_debug('update the mtl_txn_request_lines with tfr cost group null');
1240: END IF;
1241:
1242: UPDATE mtl_txn_request_lines

Line 1239: print_debug('update the mtl_txn_request_lines with tfr cost group null');

1235:
1236: ELSIF p_input_type = G_INPUT_MOLINE THEN
1237: IF (l_debug = 1) THEN
1238: print_debug('update the mtl_txn_request_lines with from cost group null');
1239: print_debug('update the mtl_txn_request_lines with tfr cost group null');
1240: END IF;
1241:
1242: UPDATE mtl_txn_request_lines
1243: SET to_cost_group_id = NULL,

Line 1242: UPDATE mtl_txn_request_lines

1238: print_debug('update the mtl_txn_request_lines with from cost group null');
1239: print_debug('update the mtl_txn_request_lines with tfr cost group null');
1240: END IF;
1241:
1242: UPDATE mtl_txn_request_lines
1243: SET to_cost_group_id = NULL,
1244: from_cost_group_id = null
1245: WHERE line_id = l_line_id;
1246: END IF;

Line 1260: print_debug('before calling wms_costgroupengine_pvt for mtl_txn_request_lines record');

1256: END IF;
1257:
1258: IF (p_input_type = g_input_moline) THEN -- Input type is MMTT
1259: IF (l_debug = 1) THEN
1260: print_debug('before calling wms_costgroupengine_pvt for mtl_txn_request_lines record');
1261: END IF;
1262: wms_costgroupengine_pvt.assign_cost_group
1263: (p_api_version => 1.0,
1264: p_init_msg_list => fnd_api.g_false,

Line 1288: UPDATE mtl_txn_request_lines

1284: IF (l_debug = 1) THEN
1285: print_debug('Setting from cost group as null ');
1286: END IF;
1287:
1288: UPDATE mtl_txn_request_lines
1289: SET
1290: from_cost_group_id = null
1291: WHERE line_id = l_line_id;
1292:

Line 1345: UPDATE mtl_txn_request_lines

1341: IF (l_debug = 1) THEN
1342: print_debug('Setting cost group as null ');
1343: END IF;
1344:
1345: UPDATE mtl_txn_request_lines
1346: SET
1347: from_cost_group_id = null
1348: WHERE line_id = l_line_id;
1349:

Line 1380: print_debug('update the mtl_txn_request_lines with transfer cost group null');

1376: SET transfer_cost_group_id = NULL
1377: WHERE transaction_temp_id = l_line_id;
1378: ELSIF p_input_type = G_INPUT_MOLINE THEN
1379: IF (l_debug = 1) THEN
1380: print_debug('update the mtl_txn_request_lines with transfer cost group null');
1381: END IF;
1382: UPDATE mtl_txn_request_lines
1383: SET to_cost_group_id = null
1384: WHERE line_id = l_line_id;

Line 1382: UPDATE mtl_txn_request_lines

1378: ELSIF p_input_type = G_INPUT_MOLINE THEN
1379: IF (l_debug = 1) THEN
1380: print_debug('update the mtl_txn_request_lines with transfer cost group null');
1381: END IF;
1382: UPDATE mtl_txn_request_lines
1383: SET to_cost_group_id = null
1384: WHERE line_id = l_line_id;
1385: END IF;
1386: -- Added by cjandhya

Line 1430: print_debug('update the mtl_txn_request_lines with cost group ' ||

1426: SET transfer_cost_group_id = l_transfer_cost_group_id
1427: WHERE transaction_temp_id = l_line_id;
1428: ELSIF p_input_type = G_INPUT_MOLINE THEN
1429: IF (l_debug = 1) THEN
1430: print_debug('update the mtl_txn_request_lines with cost group ' ||
1431: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1432: END IF;
1433: UPDATE mtl_txn_request_lines
1434: SET to_cost_group_id = l_transfer_cost_group_id

Line 1433: UPDATE mtl_txn_request_lines

1429: IF (l_debug = 1) THEN
1430: print_debug('update the mtl_txn_request_lines with cost group ' ||
1431: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1432: END IF;
1433: UPDATE mtl_txn_request_lines
1434: SET to_cost_group_id = l_transfer_cost_group_id
1435: WHERE line_id = l_line_id;
1436: END IF;
1437: END IF;

Line 1550: print_debug('before calling wms_costgroupengine_pvt for mtl_txn_request_lines record');

1546: END IF;
1547: END IF;
1548: ELSIF (p_input_type = g_input_moline) THEN
1549: IF (l_debug = 1) THEN
1550: print_debug('before calling wms_costgroupengine_pvt for mtl_txn_request_lines record');
1551: END IF;
1552: wms_costgroupengine_pvt.assign_cost_group
1553: (
1554: p_api_version => 1.0,