APPS.GMF_LOTCOSTADJUSTMENT_PVT dependencies on GMF_LOT_COST_ADJUSTMENTS

Line 63: --| into table GMF_LOT_COST_ADJUSTMENTS |

59: --+========================================================================+
60: --| API Name : Create_LotCost_Adjustment |
61: --| TYPE : Private |
62: --| Function : Creates Lot Cost Adjustment based on the input |
63: --| into table GMF_LOT_COST_ADJUSTMENTS |
64: --| Pre-reqa : None |
65: --| Parameters : |
66: --| IN : |
67: --| p_api_version IN NUMBER |

Line 111: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;

107: )
108: IS
109: l_api_name CONSTANT VARCHAR2(30) := 'Create_LotCost_Adjustment' ;
110: l_api_version CONSTANT NUMBER := 2.0 ;
111: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;
112: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.ADJUSTMENT_DTL_ID%TYPE;
113: BEGIN
114:
115: -- Standard Start of API savepoint

Line 159: INSERT INTO gmf_lot_cost_adjustments

155: ) ;
156: END IF;
157:
158: BEGIN
159: INSERT INTO gmf_lot_cost_adjustments
160: (
161: ADJUSTMENT_ID
162: , legal_entity_id
163: , cost_type_id

Line 405: --| in table GMF_LOT_COST_ADJUSTMENTS |

401: --+========================================================================+
402: --| API Name : Update_LotCost_Adjustment |
403: --| TYPE : Private |
404: --| Function : Updates Lot Cost Adjustment based on the input |
405: --| in table GMF_LOT_COST_ADJUSTMENTS |
406: --| Pre-reqa : None |
407: --| Parameters : |
408: --| IN : |
409: --| p_api_version IN NUMBER |

Line 449: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;

445: )
446: IS
447: l_api_name CONSTANT VARCHAR2(30) := 'Update_LotCost_Adjustment' ;
448: l_api_version CONSTANT NUMBER := 2.0 ;
449: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;
450: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.ADJUSTMENT_DTL_ID%TYPE;
451: BEGIN
452:
453: -- Standard Start of API savepoint

Line 559: --| in table GMF_LOT_COST_ADJUSTMENTS |

555: --+========================================================================+
556: --| API Name : Delete_LotCost_Adjustment |
557: --| TYPE : Private |
558: --| Function : Deletes Lot Cost Adjustment based on the input |
559: --| in table GMF_LOT_COST_ADJUSTMENTS |
560: --| Pre-reqa : None |
561: --| Parameters : |
562: --| IN : |
563: --| p_api_version IN NUMBER |

Line 601: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;

597: )
598: IS
599: l_api_name CONSTANT VARCHAR2(30) := 'Delete_LotCost_Adjustment' ;
600: l_api_version CONSTANT NUMBER := 2.0 ;
601: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;
602: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.ADJUSTMENT_DTL_ID%TYPE;
603: l_adjustment_dtl_cnt NUMBER := 0;
604: BEGIN
605:

Line 686: DELETE gmf_lot_cost_adjustments

682: END;
683:
684: IF NVL(l_adjustment_dtl_cnt,0) = 0 THEN
685: BEGIN
686: DELETE gmf_lot_cost_adjustments
687: WHERE adjustment_id = p_header_Rec.adjustment_id
688: AND nvl(applied_ind,'N') <> 'Y';
689: IF SQL%NOTFOUND THEN
690: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_FAILED');

Line 769: --| from table GMF_LOT_COST_ADJUSTMENTS |

765: --+========================================================================+
766: --| API Name : Get_LotCost_Adjustment |
767: --| TYPE : Private |
768: --| Function : Get Lot Cost Adjustment based on the input |
769: --| from table GMF_LOT_COST_ADJUSTMENTS |
770: --| Pre-reqa : None |
771: --| Parameters : |
772: --| IN : |
773: --| p_api_version IN NUMBER |

Line 852: FROM gmf_lot_cost_adjustments a

848: , a.ATTRIBUTE28
849: , a.ATTRIBUTE29
850: , a.ATTRIBUTE30
851: , a.ATTRIBUTE_CATEGORY
852: FROM gmf_lot_cost_adjustments a
853: , mtl_system_items_b b
854: , mtl_lot_numbers c
855: WHERE a.adjustment_id = nvl(p_header_rec.adjustment_id, a.adjustment_id)
856: AND a.legal_entity_id = decode(p_header_rec.adjustment_id, NULL, p_header_rec.legal_entity_id, a.legal_entity_id)