DBA Data[Home] [Help]

APPS.AHL_WIP_JOB_PVT dependencies on WIP_COST_TXN_INTERFACE

Line 1167: l_wip_cost_txn_rec wip_cost_txn_interface%ROWTYPE;

1163: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_RESOURCE_TXN';
1164: l_api_version CONSTANT NUMBER := 1.0;
1165: l_msg_count NUMBER;
1166: l_return_status VARCHAR2(1);
1167: l_wip_cost_txn_rec wip_cost_txn_interface%ROWTYPE;
1168:
1169: CURSOR get_user_name (c_user_id NUMBER) IS
1170: SELECT user_name
1171: FROM fnd_user

Line 1401: --insert resource transaction record into table WIP_COST_TXN_INTERFACE

1397: FND_MSG_PUB.ADD;
1398: END IF;
1399: Close get_instance_sernum;
1400: END IF;
1401: --insert resource transaction record into table WIP_COST_TXN_INTERFACE
1402: -- Adithya added code for populating charge_deparment_id if the input deparment
1403: -- is different from opeartion deparemt.Bug # 6326254
1404:
1405: OPEN get_operation_dept(l_wip_cost_txn_rec.wip_entity_id, l_wip_cost_txn_rec.operation_seq_num);

Line 1413: --insert resource transaction record into table WIP_COST_TXN_INTERFACE

1409: IF l_op_dept_id <> l_wip_cost_txn_rec.department_id
1410: THEN
1411: l_wip_cost_txn_rec.charge_department_id := l_wip_cost_txn_rec.department_id;
1412: END IF;
1413: --insert resource transaction record into table WIP_COST_TXN_INTERFACE
1414:
1415: BEGIN
1416: INSERT INTO wip_cost_txn_interface
1417: ( last_update_date,

Line 1416: INSERT INTO wip_cost_txn_interface

1412: END IF;
1413: --insert resource transaction record into table WIP_COST_TXN_INTERFACE
1414:
1415: BEGIN
1416: INSERT INTO wip_cost_txn_interface
1417: ( last_update_date,
1418: last_updated_by,
1419: last_updated_by_name,
1420: creation_date,