APPS.GMF_LOTCOSTADJUSTMENT_PVT dependencies on GMF_LOT_COST_ADJUSTMENT_DTLS

Line 112: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.ADJUSTMENT_DTL_ID%TYPE;

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
116: SAVEPOINT Create_LotCost_Adjustment_PVT ;

Line 312: INSERT INTO gmf_lot_cost_adjustment_dtls

308: ' Cost Analysis Code ' || p_dtl_tbl(i).cost_analysis_code
309: );
310: END IF;
311: BEGIN
312: INSERT INTO gmf_lot_cost_adjustment_dtls
313: (
314: ADJUSTMENT_DTL_ID
315: , ADJUSTMENT_ID
316: , COST_CMPNTCLS_ID

Line 450: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.ADJUSTMENT_DTL_ID%TYPE;

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
454: SAVEPOINT Update_LotCost_Adjustment_PVT ;

Line 484: UPDATE gmf_lot_cost_adjustment_dtls

480: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
481: log_msg ( 'Updating Detail Record for Adjustment Detail Id ' || p_dtl_tbl(i).adjustment_dtl_id );
482: END IF;
483: BEGIN
484: UPDATE gmf_lot_cost_adjustment_dtls
485: SET ADJUSTMENT_COST = p_dtl_tbl(i).ADJUSTMENT_COST
486: , TEXT_CODE = decode( p_dtl_tbl(i).TEXT_CODE, FND_API.G_MISS_NUM, NULL, NULL, TEXT_CODE, p_dtl_tbl(i).TEXT_CODE )
487: , LAST_UPDATED_BY = p_user_id
488: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 602: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.ADJUSTMENT_DTL_ID%TYPE;

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:
606: -- Standard Start of API savepoint

Line 640: DELETE gmf_lot_cost_adjustment_dtls

636: log_msg ( 'Deleting Detail Record for Adjustment Detail Id ' || p_dtl_tbl(i).adjustment_dtl_id);
637: END IF;
638:
639: BEGIN
640: DELETE gmf_lot_cost_adjustment_dtls
641: WHERE adjustment_dtl_id = p_dtl_tbl(i).adjustment_dtl_id;
642: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
643: log_msg ( SQL%ROWCOUNT || ' Detail Record(s) deleted for Adjustment Detail Id ' || p_dtl_tbl(i).adjustment_dtl_id);
644: END IF;

Line 677: FROM gmf_lot_cost_adjustment_dtls

673:
674: BEGIN
675: SELECT count(1)
676: INTO l_adjustment_dtl_cnt
677: FROM gmf_lot_cost_adjustment_dtls
678: WHERE adjustment_id = p_header_Rec.adjustment_id;
679: EXCEPTION
680: WHEN NO_DATA_FOUND THEN
681: l_adjustment_dtl_cnt := 0;

Line 879: FROM gmf_lot_cost_adjustment_dtls a

875: , a.COST_CMPNTCLS_ID
876: , a.COST_ANALYSIS_CODE
877: , a.ADJUSTMENT_COST
878: , a.TEXT_CODE
879: FROM gmf_lot_cost_adjustment_dtls a
880: WHERE a.adjustment_id = NVL(p_adjustment_id, a.adjustment_id);
881:
882: l_api_name CONSTANT VARCHAR2(30) := 'Get_LotCost_Adjustment' ;
883: l_api_version CONSTANT NUMBER := 2.0 ;