APPS.WIP_RES_UTIL dependencies on WIP_COST_TXN_INTERFACE

Line 375: UPDATE WIP_COST_TXN_INTERFACE

371: )
372: IS
373: BEGIN
374:
375: UPDATE WIP_COST_TXN_INTERFACE
376: SET ACCT_PERIOD_ID = p_Res_rec.acct_period_id
377: , ACTIVITY_ID = p_Res_rec.activity_id
378: , ACTIVITY_NAME = p_Res_rec.activity_name
379: , ACTUAL_RESOURCE_RATE = p_Res_rec.actual_resource_rate

Line 487: INSERT INTO WIP_COST_TXN_INTERFACE

483: )
484: IS
485: BEGIN
486:
487: INSERT INTO WIP_COST_TXN_INTERFACE
488: ( ACCT_PERIOD_ID
489: , ACTIVITY_ID
490: , ACTIVITY_NAME
491: , ACTUAL_RESOURCE_RATE

Line 694: DELETE FROM WIP_COST_TXN_INTERFACE

690: )
691: IS
692: BEGIN
693:
694: DELETE FROM WIP_COST_TXN_INTERFACE
695: WHERE PO_HEADER_ID = p_po_header_id
696: ;
697:
698: EXCEPTION

Line 825: FROM WIP_COST_TXN_INTERFACE

821: , TRANSACTION_UOM
822: , USAGE_RATE_OR_AMOUNT
823: , WIP_ENTITY_ID
824: , WIP_ENTITY_NAME
825: FROM WIP_COST_TXN_INTERFACE
826: WHERE ( PO_HEADER_ID = nvl(p_po_header_id,FND_API.G_MISS_NUM)
827: );
828:
829: BEGIN

Line 1136: FROM WIP_COST_TXN_INTERFACE

1132: , l_Res_rec.transaction_uom
1133: , l_Res_rec.usage_rate_or_amount
1134: , l_Res_rec.wip_entity_id
1135: , l_Res_rec.wip_entity_name
1136: FROM WIP_COST_TXN_INTERFACE
1137: WHERE PO_HEADER_ID = p_Res_rec.po_header_id
1138: FOR UPDATE NOWAIT;
1139:
1140: -- Row locked. Compare IN attributes to DB attributes.