eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_ACTUAL_COST_ADJUSTMENT_PVT dependencies on CM_ADJS_DTL

Line 115: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;

111: * Local Variables *
112: ******************/
113: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ACTUAL_COST_ADJUSTMENT';
114: l_api_version CONSTANT NUMBER := 1.0 ;
115: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;
116:
117: BEGIN
118:
119: /**********************************

Line 178: INSERT INTO cm_adjs_dtl

174: );
175: END IF;
176:
177: BEGIN
178: INSERT INTO cm_adjs_dtl
179: (
180: ORGANIZATION_ID
181: , INVENTORY_ITEM_ID
182: , COST_TYPE_ID

Line 429: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;

425: * Local Variables *
426: ******************/
427: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ACTUAL_COST_ADJUSTMENT';
428: l_api_version CONSTANT NUMBER := 1.0 ;
429: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;
430:
431: BEGIN
432:
433: /**********************************

Line 478: UPDATE cm_adjs_dtl

474: log_msg ( 'Updating Actual Cost Adjustment Record for Cost Adjustment Id ' || p_adjustment_rec.cost_adjust_id);
475: END IF;
476:
477: BEGIN
478: UPDATE cm_adjs_dtl
479: SET cost_cmpntcls_id = p_adjustment_rec.cost_cmpntcls_id,
480: cost_analysis_code = p_adjustment_rec.cost_analysis_code,
481: adjust_qty = p_adjustment_rec.adjust_qty,
482: adjust_qty_uom = p_adjustment_rec.adjust_qty_uom,

Line 593: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;

589: * Local Variables *
590: ******************/
591: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ACTUAL_COST_ADJUSTMENT';
592: l_api_version CONSTANT NUMBER := 1.0 ;
593: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;
594:
595: BEGIN
596:
597: /**********************************

Line 641: DELETE cm_adjs_dtl

637: THEN
638: log_msg ( 'Deleting Actual Cost Adjustment Record for Cost Adjustment Id ' || p_adjustment_rec.cost_adjust_id);
639: END IF;
640: BEGIN
641: DELETE cm_adjs_dtl
642: WHERE cost_adjust_id = p_adjustment_rec.cost_adjust_id
643: AND adjust_status <> 1;
644:
645: IF SQL%NOTFOUND THEN

Line 752: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;

748: * Local Variables *
749: ******************/
750: l_api_name CONSTANT VARCHAR2(30) := 'GET_ACTUAL_COST_ADJUSTMENT';
751: l_api_version CONSTANT NUMBER := 1.0 ;
752: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;
753: l_type NUMBER := 0;
754:
755: /**********
756: * Cursors *

Line 762: p_cost_adjust_id IN CM_ADJS_DTL.COST_ADJUST_ID%TYPE,

758:
759: CURSOR CUR_ADJS_DTL
760: (
761: p_type IN NUMBER,
762: p_cost_adjust_id IN CM_ADJS_DTL.COST_ADJUST_ID%TYPE,
763: p_organization_id IN CM_ADJS_DTL.ORGANIZATION_ID%TYPE,
764: p_inventory_item_id IN CM_ADJS_DTL.INVENTORY_ITEM_ID%TYPE,
765: p_cost_type_id IN CM_ADJS_DTL.COST_TYPE_ID%TYPE,
766: p_period_id IN CM_ADJS_DTL.PERIOD_ID%TYPE,

Line 763: p_organization_id IN CM_ADJS_DTL.ORGANIZATION_ID%TYPE,

759: CURSOR CUR_ADJS_DTL
760: (
761: p_type IN NUMBER,
762: p_cost_adjust_id IN CM_ADJS_DTL.COST_ADJUST_ID%TYPE,
763: p_organization_id IN CM_ADJS_DTL.ORGANIZATION_ID%TYPE,
764: p_inventory_item_id IN CM_ADJS_DTL.INVENTORY_ITEM_ID%TYPE,
765: p_cost_type_id IN CM_ADJS_DTL.COST_TYPE_ID%TYPE,
766: p_period_id IN CM_ADJS_DTL.PERIOD_ID%TYPE,
767: p_cost_cmpntcls_id IN CM_ADJS_DTL.COST_CMPNTCLS_ID%TYPE,

Line 764: p_inventory_item_id IN CM_ADJS_DTL.INVENTORY_ITEM_ID%TYPE,

760: (
761: p_type IN NUMBER,
762: p_cost_adjust_id IN CM_ADJS_DTL.COST_ADJUST_ID%TYPE,
763: p_organization_id IN CM_ADJS_DTL.ORGANIZATION_ID%TYPE,
764: p_inventory_item_id IN CM_ADJS_DTL.INVENTORY_ITEM_ID%TYPE,
765: p_cost_type_id IN CM_ADJS_DTL.COST_TYPE_ID%TYPE,
766: p_period_id IN CM_ADJS_DTL.PERIOD_ID%TYPE,
767: p_cost_cmpntcls_id IN CM_ADJS_DTL.COST_CMPNTCLS_ID%TYPE,
768: p_cost_analysis_code IN CM_ADJS_DTL.COST_ANALYSIS_CODE%TYPE,

Line 765: p_cost_type_id IN CM_ADJS_DTL.COST_TYPE_ID%TYPE,

761: p_type IN NUMBER,
762: p_cost_adjust_id IN CM_ADJS_DTL.COST_ADJUST_ID%TYPE,
763: p_organization_id IN CM_ADJS_DTL.ORGANIZATION_ID%TYPE,
764: p_inventory_item_id IN CM_ADJS_DTL.INVENTORY_ITEM_ID%TYPE,
765: p_cost_type_id IN CM_ADJS_DTL.COST_TYPE_ID%TYPE,
766: p_period_id IN CM_ADJS_DTL.PERIOD_ID%TYPE,
767: p_cost_cmpntcls_id IN CM_ADJS_DTL.COST_CMPNTCLS_ID%TYPE,
768: p_cost_analysis_code IN CM_ADJS_DTL.COST_ANALYSIS_CODE%TYPE,
769: p_adjustment_ind IN CM_ADJS_DTL.ADJUSTMENT_IND%TYPE

Line 766: p_period_id IN CM_ADJS_DTL.PERIOD_ID%TYPE,

762: p_cost_adjust_id IN CM_ADJS_DTL.COST_ADJUST_ID%TYPE,
763: p_organization_id IN CM_ADJS_DTL.ORGANIZATION_ID%TYPE,
764: p_inventory_item_id IN CM_ADJS_DTL.INVENTORY_ITEM_ID%TYPE,
765: p_cost_type_id IN CM_ADJS_DTL.COST_TYPE_ID%TYPE,
766: p_period_id IN CM_ADJS_DTL.PERIOD_ID%TYPE,
767: p_cost_cmpntcls_id IN CM_ADJS_DTL.COST_CMPNTCLS_ID%TYPE,
768: p_cost_analysis_code IN CM_ADJS_DTL.COST_ANALYSIS_CODE%TYPE,
769: p_adjustment_ind IN CM_ADJS_DTL.ADJUSTMENT_IND%TYPE
770: )

Line 767: p_cost_cmpntcls_id IN CM_ADJS_DTL.COST_CMPNTCLS_ID%TYPE,

763: p_organization_id IN CM_ADJS_DTL.ORGANIZATION_ID%TYPE,
764: p_inventory_item_id IN CM_ADJS_DTL.INVENTORY_ITEM_ID%TYPE,
765: p_cost_type_id IN CM_ADJS_DTL.COST_TYPE_ID%TYPE,
766: p_period_id IN CM_ADJS_DTL.PERIOD_ID%TYPE,
767: p_cost_cmpntcls_id IN CM_ADJS_DTL.COST_CMPNTCLS_ID%TYPE,
768: p_cost_analysis_code IN CM_ADJS_DTL.COST_ANALYSIS_CODE%TYPE,
769: p_adjustment_ind IN CM_ADJS_DTL.ADJUSTMENT_IND%TYPE
770: )
771: IS

Line 768: p_cost_analysis_code IN CM_ADJS_DTL.COST_ANALYSIS_CODE%TYPE,

764: p_inventory_item_id IN CM_ADJS_DTL.INVENTORY_ITEM_ID%TYPE,
765: p_cost_type_id IN CM_ADJS_DTL.COST_TYPE_ID%TYPE,
766: p_period_id IN CM_ADJS_DTL.PERIOD_ID%TYPE,
767: p_cost_cmpntcls_id IN CM_ADJS_DTL.COST_CMPNTCLS_ID%TYPE,
768: p_cost_analysis_code IN CM_ADJS_DTL.COST_ANALYSIS_CODE%TYPE,
769: p_adjustment_ind IN CM_ADJS_DTL.ADJUSTMENT_IND%TYPE
770: )
771: IS
772: SELECT ORGANIZATION_ID, INVENTORY_ITEM_ID, COST_TYPE_ID, PERIOD_ID, COST_CMPNTCLS_ID, COST_ANALYSIS_CODE,

Line 769: p_adjustment_ind IN CM_ADJS_DTL.ADJUSTMENT_IND%TYPE

765: p_cost_type_id IN CM_ADJS_DTL.COST_TYPE_ID%TYPE,
766: p_period_id IN CM_ADJS_DTL.PERIOD_ID%TYPE,
767: p_cost_cmpntcls_id IN CM_ADJS_DTL.COST_CMPNTCLS_ID%TYPE,
768: p_cost_analysis_code IN CM_ADJS_DTL.COST_ANALYSIS_CODE%TYPE,
769: p_adjustment_ind IN CM_ADJS_DTL.ADJUSTMENT_IND%TYPE
770: )
771: IS
772: SELECT ORGANIZATION_ID, INVENTORY_ITEM_ID, COST_TYPE_ID, PERIOD_ID, COST_CMPNTCLS_ID, COST_ANALYSIS_CODE,
773: COST_ADJUST_ID, ADJUST_QTY, ADJUST_QTY_UOM, ADJUST_COST, REASON_CODE, ADJUST_STATUS, CREATION_DATE,

Line 780: FROM cm_adjs_dtl

776: ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10,
777: ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18,
778: ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26,
779: ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, ADJUSTMENT_IND, SUBLEDGER_IND, ADJUSTMENT_DATE
780: FROM cm_adjs_dtl
781: WHERE p_type = 1
782: AND COST_ADJUST_ID = p_cost_adjust_id
783: UNION
784: SELECT ORGANIZATION_ID, INVENTORY_ITEM_ID, COST_TYPE_ID, PERIOD_ID, COST_CMPNTCLS_ID, COST_ANALYSIS_CODE,

Line 792: FROM cm_adjs_dtl

788: ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10,
789: ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18,
790: ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26,
791: ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, ADJUSTMENT_IND, SUBLEDGER_IND, ADJUSTMENT_DATE
792: FROM cm_adjs_dtl
793: WHERE p_type = 2
794: AND ORGANIZATION_ID = p_organization_id
795: AND INVENTORY_ITEM_ID = p_inventory_item_id
796: AND COST_TYPE_ID = p_cost_type_id