APPS.GMF_LOTCOSTADJUSTMENT_PUB dependencies on GMF_LOT_COST_ADJUSTMENTS

Line 78: --| into table GMF_LOT_COST_ADJUSTMENTS |

74: --+========================================================================+
75: --| API Name : Create_LotCost_Adjustment |
76: --| TYPE : Public |
77: --| Function : Creates Lot Cost Adjustment based on the input |
78: --| into table GMF_LOT_COST_ADJUSTMENTS |
79: --| Pre-reqa : None |
80: --| Parameters : |
81: --| IN : |
82: --| p_api_version IN NUMBER |

Line 297: --| into table GMF_LOT_COST_ADJUSTMENTS |

293: --+========================================================================+
294: --| API Name : Update_LotCost_Adjustment |
295: --| TYPE : Public |
296: --| Function : Updates Lot Cost Adjustment based on the input |
297: --| into table GMF_LOT_COST_ADJUSTMENTS |
298: --| Pre-reqa : None |
299: --| Parameters : |
300: --| IN : |
301: --| p_api_version IN NUMBER |

Line 515: --| from table GMF_LOT_COST_ADJUSTMENTS |

511: --+========================================================================+
512: --| API Name : Delete_LotCost_Adjustment |
513: --| TYPE : Public |
514: --| Function : Deletes Lot Cost Adjustment based on the input |
515: --| from table GMF_LOT_COST_ADJUSTMENTS |
516: --| Pre-reqa : None |
517: --| Parameters : |
518: --| IN : |
519: --| p_api_version IN NUMBER |

Line 732: --| from table GMF_LOT_COST_ADJUSTMENTS |

728: --+========================================================================+
729: --| API Name : Get_LotCost_Adjustment |
730: --| TYPE : Public |
731: --| Function : Fetchs Lot Cost Adjustment based on the input |
732: --| from table GMF_LOT_COST_ADJUSTMENTS |
733: --| Pre-reqa : None |
734: --| Parameters : |
735: --| IN : |
736: --| p_api_version IN NUMBER |

Line 958: l_adjustment_date GMF_LOT_COST_ADJUSTMENTS.adjustment_date%TYPE;

954: , x_user_id OUT NOCOPY fnd_user.user_id%TYPE
955: , x_return_status OUT NOCOPY VARCHAR2
956: )
957: IS
958: l_adjustment_date GMF_LOT_COST_ADJUSTMENTS.adjustment_date%TYPE;
959: l_reason_cnt NUMBER;
960: l_text_cnt NUMBER;
961: l_header_cnt NUMBER;
962: l_detail_cnt NUMBER;

Line 963: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.adjustment_id%TYPE;

959: l_reason_cnt NUMBER;
960: l_text_cnt NUMBER;
961: l_header_cnt NUMBER;
962: l_detail_cnt NUMBER;
963: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.adjustment_id%TYPE;
964: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.adjustment_dtl_id%TYPE;
965: l_adjustment_cost GMF_LOT_COST_ADJUSTMENT_DTLS.adjustment_cost%TYPE;
966: l_applied_ind GMF_LOT_COST_ADJUSTMENTS.applied_ind%TYPE;
967: l_cost_category_id NUMBER;

Line 966: l_applied_ind GMF_LOT_COST_ADJUSTMENTS.applied_ind%TYPE;

962: l_detail_cnt NUMBER;
963: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.adjustment_id%TYPE;
964: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.adjustment_dtl_id%TYPE;
965: l_adjustment_cost GMF_LOT_COST_ADJUSTMENT_DTLS.adjustment_cost%TYPE;
966: l_applied_ind GMF_LOT_COST_ADJUSTMENTS.applied_ind%TYPE;
967: l_cost_category_id NUMBER;
968: l_lot_costed_items_cnt NUMBER;
969: --l_itemcost_class IC_ITEM_MST.itemcost_class%TYPE;
970: --l_itemcost_class_cnt NUMBER;

Line 983: FROM gmf_lot_cost_adjustments

979: THEN
980: BEGIN
981: SELECT applied_ind
982: INTO l_applied_ind
983: FROM gmf_lot_cost_adjustments
984: WHERE adjustment_id = p_header_rec.adjustment_id
985: AND ROWNUM = 1;
986: EXCEPTION
987: WHEN NO_DATA_FOUND

Line 1462: FROM gmf_lot_cost_adjustments

1458:
1459: BEGIN
1460: SELECT adjustment_id, applied_ind
1461: INTO p_header_Rec.adjustment_id, l_applied_ind
1462: FROM gmf_lot_cost_adjustments
1463: WHERE legal_entity_id = p_header_rec.legal_entity_id
1464: AND cost_type_id = p_header_rec.cost_type_id
1465: AND organization_id = p_header_rec.organization_id
1466: AND inventory_item_id = p_header_rec.item_id