APPS.CSP_MTL_TRANSACTIONS_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 215: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP(

211: OPEN C2;
212: FETCH C2 INTO px_TRANSACTION_TEMP_ID;
213: CLOSE C2;
214: End If;
215: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP(
216: TRANSACTION_HEADER_ID,
217: TRANSACTION_TEMP_ID,
218: SOURCE_CODE,
219: SOURCE_LINE_ID,

Line 797: Update MTL_MATERIAL_TRANSACTIONS_TEMP

793: -- P_SOURCE_LOT_NUMBER NUMBER)
794:
795: IS
796: BEGIN
797: Update MTL_MATERIAL_TRANSACTIONS_TEMP
798: SET
799: TRANSACTION_HEADER_ID = decode( p_TRANSACTION_HEADER_ID, FND_API.G_MISS_NUM, TRANSACTION_HEADER_ID, p_TRANSACTION_HEADER_ID),
800: SOURCE_CODE = decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, SOURCE_CODE, p_SOURCE_CODE),
801: SOURCE_LINE_ID = decode( p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, SOURCE_LINE_ID, p_SOURCE_LINE_ID),

Line 1000: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP

996: PROCEDURE Delete_Row(
997: p_TRANSACTION_TEMP_ID NUMBER)
998: IS
999: BEGIN
1000: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1001: WHERE TRANSACTION_TEMP_ID = p_TRANSACTION_TEMP_ID;
1002: If (SQL%NOTFOUND) then
1003: RAISE NO_DATA_FOUND;
1004: End If;

Line 1203: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

1199:
1200: IS
1201: CURSOR C IS
1202: SELECT *
1203: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1204: WHERE TRANSACTION_TEMP_ID = p_TRANSACTION_TEMP_ID
1205: FOR UPDATE of TRANSACTION_TEMP_ID NOWAIT;
1206: Recinfo C%ROWTYPE;
1207: BEGIN