APPS.CSTPMECS dependencies on CST_ITEM_COST_DETAILS

Line 36: UPDATE cst_item_cost_details CICD

32: O_RETURN_CODE := 9999;
33:
34: CSTPUTIL.CSTPUGCI(I_ORG_ID, ROUND_UNIT, PRECISION, EXT_PREC);
35:
36: UPDATE cst_item_cost_details CICD
37: SET (
38: usage_rate_or_amount,
39: item_cost,
40: last_update_date,

Line 190: UPDATE cst_item_cost_details CICD

186: IF O_RETURN_CODE <> 0 THEN
187: raise_application_error(-20001, 'CSTPAPOR->CSTPEIIC: '||SQLERRM);
188: END IF;
189:
190: UPDATE cst_item_cost_details CICD
191: SET (
192: usage_rate_or_amount
193: , item_cost
194: , last_update_date

Line 369: UPDATE cst_item_cost_details CICD

365:
366: /*==================================================================*/
367: /* update item cost details */
368: /*==================================================================*/
369: UPDATE cst_item_cost_details CICD
370: SET
371: (
372: item_cost
373: , usage_rate_or_amount

Line 640: UPDATE cst_item_cost_details A

636:
637: /*=============================================================================*/
638: /* Update CICD using the data in the global temporary table cst_open_pos_temp. */
639: /*=============================================================================*/
640: UPDATE cst_item_cost_details A
641: SET (
642: usage_rate_or_amount
643: , item_cost
644: , last_update_date

Line 683: fnd_file.put_line(fnd_file.log,'Updated '||to_char(SQL%ROWCOUNT)||' rows in cst_item_cost_details.');

679: FROM cst_open_pos_temp
680: )
681: ;
682:
683: fnd_file.put_line(fnd_file.log,'Updated '||to_char(SQL%ROWCOUNT)||' rows in cst_item_cost_details.');
684:
685: O_RETURN_CODE := 0;
686:
687: EXCEPTION

Line 748: UPDATE CST_ITEM_COST_DETAILS A

744: ;
745:
746: L_LOCATION := 2;
747:
748: UPDATE CST_ITEM_COST_DETAILS A
749: SET NET_YIELD_OR_SHRINKAGE_FACTOR = 1/(1 - DECODE(I_FIXED_RATE,-1,0,I_FIXED_RATE))
750: , ITEM_COST = ROUND(((USAGE_RATE_OR_AMOUNT * BASIS_FACTOR *
751: NVL(RESOURCE_RATE,1)) / (1 - DECODE(I_FIXED_RATE,-1,0,I_FIXED_RATE))), EXT_PREC)
752: , LAST_UPDATE_DATE = SYSDATE

Line 813: UPDATE CST_ITEM_COST_DETAILS A

809: CSTPUTIL.CSTPUGCI(I_ORG_ID, ROUND_UNIT, PRECISION, EXT_PREC);
810:
811: O_RETURN_CODE := 9999;
812:
813: UPDATE CST_ITEM_COST_DETAILS A
814: SET USAGE_RATE_OR_AMOUNT =
815: (DECODE(I_FIXED_RATE,-1,USAGE_RATE_OR_AMOUNT,I_FIXED_RATE) *
816: (1 + I_PER_INC/100) + I_AMT_INC),
817: ITEM_COST =

Line 892: UPDATE CST_ITEM_COST_DETAILS A

888: O_RETURN_CODE := 9999;
889:
890: CSTPUTIL.CSTPUGCI(I_ORG_ID, ROUND_UNIT, PRECISION, EXT_PREC);
891:
892: UPDATE CST_ITEM_COST_DETAILS A
893: SET USAGE_RATE_OR_AMOUNT =
894: (DECODE(I_FIXED_RATE,-1,USAGE_RATE_OR_AMOUNT,I_FIXED_RATE) *
895: (1 + I_PER_INC/100) + I_AMT_INC),
896: ITEM_COST =

Line 993: UPDATE CST_ITEM_COST_DETAILS A

989: AND L.ENTITY_ID = A.INVENTORY_ITEM_ID
990: )
991: ;
992:
993: UPDATE CST_ITEM_COST_DETAILS A
994: SET (NET_YIELD_OR_SHRINKAGE_FACTOR,
995: ITEM_COST,
996: LAST_UPDATE_DATE,
997: LAST_UPDATED_BY,

Line 1134: UPDATE cst_item_cost_details CICD

1130: IF O_RETURN_CODE <> 0 THEN
1131: raise_application_error(-20001, 'CSTPULMC: '||SQLERRM);
1132: END IF;
1133:
1134: UPDATE cst_item_cost_details CICD
1135: SET (
1136: usage_rate_or_amount
1137: , item_cost
1138: , last_update_date