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 167: UPDATE cst_item_cost_details CICD

163: IF O_RETURN_CODE <> 0 THEN
164: raise_application_error(-20001, 'CSTPAPOR->CSTPEIIC: '||SQLERRM);
165: END IF;
166:
167: UPDATE cst_item_cost_details CICD
168: SET (
169: usage_rate_or_amount
170: , item_cost
171: , last_update_date

Line 323: UPDATE cst_item_cost_details CICD

319:
320: /*==================================================================*/
321: /* update item cost details */
322: /*==================================================================*/
323: UPDATE cst_item_cost_details CICD
324: SET
325: (
326: item_cost
327: , usage_rate_or_amount

Line 576: UPDATE cst_item_cost_details A

572:
573: /*=============================================================================*/
574: /* Update CICD using the data in the global temporary table cst_open_pos_temp. */
575: /*=============================================================================*/
576: UPDATE cst_item_cost_details A
577: SET (
578: usage_rate_or_amount
579: , item_cost
580: , last_update_date

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

615: FROM cst_open_pos_temp
616: )
617: ;
618:
619: fnd_file.put_line(fnd_file.log,'Updated '||to_char(SQL%ROWCOUNT)||' rows in cst_item_cost_details.');
620:
621: O_RETURN_CODE := 0;
622:
623: EXCEPTION

Line 684: UPDATE CST_ITEM_COST_DETAILS A

680: ;
681:
682: L_LOCATION := 2;
683:
684: UPDATE CST_ITEM_COST_DETAILS A
685: SET NET_YIELD_OR_SHRINKAGE_FACTOR = 1/(1 - DECODE(I_FIXED_RATE,-1,0,I_FIXED_RATE))
686: , ITEM_COST = ROUND(((USAGE_RATE_OR_AMOUNT * BASIS_FACTOR *
687: NVL(RESOURCE_RATE,1)) / (1 - DECODE(I_FIXED_RATE,-1,0,I_FIXED_RATE))), EXT_PREC)
688: , LAST_UPDATE_DATE = SYSDATE

Line 749: UPDATE CST_ITEM_COST_DETAILS A

745: CSTPUTIL.CSTPUGCI(I_ORG_ID, ROUND_UNIT, PRECISION, EXT_PREC);
746:
747: O_RETURN_CODE := 9999;
748:
749: UPDATE CST_ITEM_COST_DETAILS A
750: SET USAGE_RATE_OR_AMOUNT =
751: (DECODE(I_FIXED_RATE,-1,USAGE_RATE_OR_AMOUNT,I_FIXED_RATE) *
752: (1 + I_PER_INC/100) + I_AMT_INC),
753: ITEM_COST =

Line 828: UPDATE CST_ITEM_COST_DETAILS A

824: O_RETURN_CODE := 9999;
825:
826: CSTPUTIL.CSTPUGCI(I_ORG_ID, ROUND_UNIT, PRECISION, EXT_PREC);
827:
828: UPDATE CST_ITEM_COST_DETAILS A
829: SET USAGE_RATE_OR_AMOUNT =
830: (DECODE(I_FIXED_RATE,-1,USAGE_RATE_OR_AMOUNT,I_FIXED_RATE) *
831: (1 + I_PER_INC/100) + I_AMT_INC),
832: ITEM_COST =

Line 929: UPDATE CST_ITEM_COST_DETAILS A

925: AND L.ENTITY_ID = A.INVENTORY_ITEM_ID
926: )
927: ;
928:
929: UPDATE CST_ITEM_COST_DETAILS A
930: SET (NET_YIELD_OR_SHRINKAGE_FACTOR,
931: ITEM_COST,
932: LAST_UPDATE_DATE,
933: LAST_UPDATED_BY,

Line 1099: UPDATE cst_item_cost_details CICD

1095: IF O_RETURN_CODE <> 0 THEN
1096: raise_application_error(-20001, 'CSTPULMC: '||SQLERRM);
1097: END IF;
1098:
1099: UPDATE cst_item_cost_details CICD
1100: SET (
1101: usage_rate_or_amount
1102: , item_cost
1103: , last_update_date