APPS.GMF_LC_ADJ_TRANSACTIONS_PKG dependencies on CM_ALYS_MST

Line 25: cost_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE, -- bug14480540

21: component_name VARCHAR2(30),
22: parent_table_name VARCHAR2(30),
23: parent_table_id NUMBER,
24: cost_cmpntcls_id NUMBER,
25: cost_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE, -- bug14480540
26: transaction_date DATE,
27: transaction_quantity NUMBER,
28: transaction_uom_code VARCHAR2(25),
29: primary_quantity NUMBER,

Line 106: CURSOR cur_analysis_cd_exists (cp_cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE) IS

102: FROM cm_cmpt_mst
103: WHERE cost_cmpntcls_id = cp_cost_cmpntcls_id;
104:
105: -- check analysis code exists in analysis table
106: CURSOR cur_analysis_cd_exists (cp_cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE) IS
107: SELECT 1
108: FROM CM_ALYS_MST
109: WHERE cost_analysis_code = cp_cost_analysis_code;
110:

Line 108: FROM CM_ALYS_MST

104:
105: -- check analysis code exists in analysis table
106: CURSOR cur_analysis_cd_exists (cp_cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE) IS
107: SELECT 1
108: FROM CM_ALYS_MST
109: WHERE cost_analysis_code = cp_cost_analysis_code;
110:
111: -- get the material cost component class id and analysis code from
112: -- material cost component table and fiscal policies table

Line 206: l_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; -- bug14480540

202: l_proc_name CONSTANT VARCHAR2(100) := 'Validate_Adjustments';
203: l_lcm_flag VARCHAR2(1);
204: l_inventory_item_id NUMBER;
205: l_cost_cmpntcls_id NUMBER;
206: l_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; -- bug14480540
207: l_asset_inventory NUMBER;
208: l_dummy NUMBER;
209: l_dummy1 VARCHAR2(100);
210: l_destination_type_code VARCHAR2(100);

Line 412: -- Validate cost analysis code, cost analysis code should exists in CM_ALYS_MST table

408: IF l_debug_level >= l_debug_level_medium THEN
409: fnd_file.put_line(fnd_file.log,'Open cursor to validate Cost Analysis Code');
410: END IF;
411:
412: -- Validate cost analysis code, cost analysis code should exists in CM_ALYS_MST table
413: OPEN cur_analysis_cd_exists (p_adjustment_row.cost_analysis_code);
414: FETCH cur_analysis_cd_exists INTO l_exists;
415: IF cur_analysis_cd_exists%NOTFOUND THEN
416: fnd_file.put_line(fnd_file.log,'Cost Analysis code is not valid, not exists in cost components table');