APPS.WIP_RES_UTIL dependencies on WIP_COST_TXN_INTERFACE

Line 357: UPDATE WIP_COST_TXN_INTERFACE

353: )
354: IS
355: BEGIN
356:
357: UPDATE WIP_COST_TXN_INTERFACE
358: SET ACCT_PERIOD_ID = p_Res_rec.acct_period_id
359: , ACTIVITY_ID = p_Res_rec.activity_id
360: , ACTIVITY_NAME = p_Res_rec.activity_name
361: , ACTUAL_RESOURCE_RATE = p_Res_rec.actual_resource_rate

Line 469: INSERT INTO WIP_COST_TXN_INTERFACE

465: )
466: IS
467: BEGIN
468:
469: INSERT INTO WIP_COST_TXN_INTERFACE
470: ( ACCT_PERIOD_ID
471: , ACTIVITY_ID
472: , ACTIVITY_NAME
473: , ACTUAL_RESOURCE_RATE

Line 666: DELETE FROM WIP_COST_TXN_INTERFACE

662: )
663: IS
664: BEGIN
665:
666: DELETE FROM WIP_COST_TXN_INTERFACE
667: WHERE PO_HEADER_ID = p_po_header_id
668: ;
669:
670: EXCEPTION

Line 797: FROM WIP_COST_TXN_INTERFACE

793: , TRANSACTION_UOM
794: , USAGE_RATE_OR_AMOUNT
795: , WIP_ENTITY_ID
796: , WIP_ENTITY_NAME
797: FROM WIP_COST_TXN_INTERFACE
798: WHERE ( PO_HEADER_ID = nvl(p_po_header_id,FND_API.G_MISS_NUM)
799: );
800:
801: BEGIN

Line 1108: FROM WIP_COST_TXN_INTERFACE

1104: , l_Res_rec.transaction_uom
1105: , l_Res_rec.usage_rate_or_amount
1106: , l_Res_rec.wip_entity_id
1107: , l_Res_rec.wip_entity_name
1108: FROM WIP_COST_TXN_INTERFACE
1109: WHERE PO_HEADER_ID = p_Res_rec.po_header_id
1110: FOR UPDATE NOWAIT;
1111:
1112: -- Row locked. Compare IN attributes to DB attributes.