DBA Data[Home] [Help]

APPS.WSM_JOBCOSTING_GRP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 85: INSERT INTO mtl_material_transactions

81: END IF;
82:
83: l_stmt_num := 30;
84:
85: INSERT INTO mtl_material_transactions
86: (TRANSACTION_ID,
87: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
88: CREATION_DATE, CREATED_BY, REQUEST_ID,
89: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE,

Line 103: SELECT mtl_material_transactions_s.nextval,

99: OPERATION_SEQ_NUM,
100: ACCT_PERIOD_ID, COSTED_FLAG,
101: COST_GROUP_ID
102: )
103: SELECT mtl_material_transactions_s.nextval,
104: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
105: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_REQUEST_ID,
106: FND_GLOBAL.PROG_APPL_ID, FND_GLOBAL.CONC_PROGRAM_ID, sysdate,
107: WSRJ.primary_item_id, WSMT.organization_id, MTT.transaction_type_id,

Line 148: fnd_message.set_token('ELEMENT', 'mtl_material_transactions');

144:
145: IF (SQL%ROWCOUNT <> 1) THEN
146: x_err_code := -1;
147: fnd_message.set_name('WSM', 'WSM_INS_TBL_FAILED');
148: fnd_message.set_token('ELEMENT', 'mtl_material_transactions');
149: x_err_buf := FND_MESSAGE.GET;
150: fnd_file.put_line(fnd_file.log, 'WSM_JobCosting_GRP.Insert_MaterialTxn('||l_stmt_num||'): '||x_err_buf);
151: GOTO L_ERROR;
152: ELSE