The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT costing_group_id
INTO l_xfr_cost_group_id
FROM mrp_project_parameters
WHERE organization_id = p_FM_ORG_ID
AND project_id = p_SOURCE_PROJECT_ID ;
SELECT default_cost_group_id INTO l_xfr_cost_group_id from
mtl_parameters WHERE organization_id = p_fm_org_id;
SELECT costing_group_id
INTO l_cost_group_id
FROM mrp_project_parameters
WHERE organization_id = p_FM_ORG_ID
AND project_id = p_FM_PROJECT_ID ;
SELECT default_cost_group_id INTO l_cost_group_id from
mtl_parameters WHERE organization_id = p_fm_org_id;
SELECT costing_group_id
INTO l_xfr_cost_group_id
FROM mrp_project_parameters
WHERE organization_id = x_to_org_id
AND project_id = p_TO_PROJECT_ID ;
SELECT default_cost_group_id INTO l_xfr_cost_group_id from
mtl_parameters WHERE organization_id = x_to_org_id;
SELECT NVL(type_class,2)
INTO v_type_class
FROM mtl_transaction_types
WHERE transaction_type_id = p_TRX_TYPE_ID ;
cost_det_new_insert
*/
if ( ((v_txn_src_type_id IN (3,6,13)) OR (v_txn_src_type_id > 100) ) AND
(v_txn_action_id IN (1,27)) ) then
CSTPACIT.cost_det_new_insert(
V_TRANSACTION_ID,
V_TXN_ACTION_ID,
V_ORG_ID,
V_ITEM_ID,
V_COST_GROUP_ID,
V_TXN_COST,
V_NEW_AVG_COST,
V_PER_CHANGE,
V_VAL_CHANGE,
V_MAT_ACCNT,
V_MAT_OVHD_ACCNT,
V_RES_ACCNT,
V_OSP_ACCNT,
V_OVHD_ACCNT,
V_USER_ID,
V_LOGIN_ID,
V_REQUEST_ID,
V_PROG_APPL_ID,
V_PROG_ID,
V_ERR_NUM,
V_ERR_CODE,
V_ERR_MESG);
* not insert a row if we are doing a intrasnsit receipt or
* intransit shipment. Also not to insert if it is cost
* update transaction. (Fix bug 842532)
*/
/*Bug 8760375,If transaction is a subinv transfer transaction,should NOT insert a record into MCTCD.*/
if ( v_txn_action_id NOT IN (12, 21, 24, 2)) then
INSERT INTO MTL_CST_TXN_COST_DETAILS (
TRANSACTION_ID,
ORGANIZATION_ID,
INVENTORY_ITEM_ID,
COST_ELEMENT_ID,
LEVEL_TYPE,
TRANSACTION_COST,
NEW_AVERAGE_COST,
PERCENTAGE_CHANGE,
VALUE_CHANGE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE
)
values (
v_transaction_id,
v_org_id,
v_item_id,
1, /* Hard coded to This level Material */
1,
v_txn_cost,
v_new_avg_cost,
v_per_change,
v_val_change,
sysdate,
v_user_id,
sysdate,
v_user_id,
v_login_id,
v_request_id,
v_prog_appl_id,
v_prog_id,
sysdate);