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 175: INSERT INTO cm_adjs_dtl

171: );
172: END IF;
173:
174: BEGIN
175: INSERT INTO cm_adjs_dtl
176: (
177: ORGANIZATION_ID
178: , INVENTORY_ITEM_ID
179: , COST_TYPE_ID

Line 426: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;

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

Line 471: UPDATE cm_adjs_dtl

467: log_msg ( 'Updating Actual Cost Adjustment Record for Cost Adjustment Id ' || p_adjustment_rec.cost_adjust_id);
468: END IF;
469:
470: BEGIN
471: UPDATE cm_adjs_dtl
472: SET cost_cmpntcls_id = p_adjustment_rec.cost_cmpntcls_id,
473: cost_analysis_code = p_adjustment_rec.cost_analysis_code,
474: adjust_qty = p_adjustment_rec.adjust_qty,
475: adjust_qty_uom = p_adjustment_rec.adjust_qty_uom,

Line 590: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;

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

Line 635: DELETE cm_adjs_dtl

631: log_msg ( 'Deleting Actual Cost Adjustment Record for Cost Adjustment Id ' || p_adjustment_rec.cost_adjust_id);
632: END IF;
633: BEGIN
634: /* bug 9005515, update the adjustment with delete mark =1, through form we are not deleting the adjustments
635: DELETE cm_adjs_dtl
636: WHERE cost_adjust_id = p_adjustment_rec.cost_adjust_id
637: AND adjust_status <> 1; bug 9005515 */
638:
639: UPDATE cm_adjs_dtl

Line 639: UPDATE cm_adjs_dtl

635: DELETE cm_adjs_dtl
636: WHERE cost_adjust_id = p_adjustment_rec.cost_adjust_id
637: AND adjust_status <> 1; bug 9005515 */
638:
639: UPDATE cm_adjs_dtl
640: SET delete_mark = 1,
641: last_update_date = sysdate,
642: last_updated_by = FND_GLOBAL.USER_ID,
643: last_update_login = FND_GLOBAL.LOGIN_ID

Line 751: l_cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE;

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

Line 761: p_cost_adjust_id IN CM_ADJS_DTL.COST_ADJUST_ID%TYPE,

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

Line 762: p_organization_id IN CM_ADJS_DTL.ORGANIZATION_ID%TYPE,

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

Line 763: p_inventory_item_id IN CM_ADJS_DTL.INVENTORY_ITEM_ID%TYPE,

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

Line 764: p_cost_type_id IN CM_ADJS_DTL.COST_TYPE_ID%TYPE,

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

Line 765: p_period_id IN CM_ADJS_DTL.PERIOD_ID%TYPE,

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

Line 766: p_cost_cmpntcls_id IN CM_ADJS_DTL.COST_CMPNTCLS_ID%TYPE,

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

Line 767: p_cost_analysis_code IN CM_ADJS_DTL.COST_ANALYSIS_CODE%TYPE,

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

Line 768: p_adjustment_ind IN CM_ADJS_DTL.ADJUSTMENT_IND%TYPE

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

Line 779: FROM cm_adjs_dtl

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

Line 791: FROM cm_adjs_dtl

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