APPS.GMF_LOT_COSTING_PUB dependencies on CM_ALYS_MST

Line 606: cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE;

602: l_residual_qty NUMBER;
603: l_flg_ind VARCHAR2(1);
604:
605: component_class_id cm_cmpt_mst.cost_cmpntcls_id%TYPE;
606: cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE;
607:
608: /*l_uncostable_lots_tab num_tab; INVCONV sschinch*/
609: /*l_uncostable_lots_tab char_tab; jboppana */
610:

Line 622: , COST_ANALYSIS_CODE CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE --bug14480540

618: (
619: LOT_BURDEN_LINE_ID NUMBER(15)
620: , RESOURCES VARCHAR2(32)
621: , COST_CMPNTCLS_ID NUMBER(10)
622: , COST_ANALYSIS_CODE CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE --bug14480540
623: , BURDEN_FACTOR NUMBER
624: , BURDEN_COST NUMBER
625: );
626:

Line 656: l_mtl_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; --bug14480540

652: l_prior_step_id NUMBER;
653:
654: l_final_run_flag NUMBER(1); -- 1 for final run and 0 for trial run
655: -- Bug 13038249
656: l_mtl_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; --bug14480540
657: l_mtl_cmpntcls_id NUMBER;
658: cost_alloc_profile NUMBER;
659: l_dtl_inserted NUMBER;
660:

Line 2662: , COST_ANALYSIS_CODE CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE -- bug14480540

2658:
2659: /* Begin 3824810 sschinch */
2660: TYPE acquistion_rec IS RECORD
2661: ( COST_CMPNTCLS_ID NUMBER(15)
2662: , COST_ANALYSIS_CODE CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE -- bug14480540
2663: , COMPONENT_COST NUMBER
2664: , RECEIPT_UOM VARCHAR2(3)
2665: , LCM_FLAG NUMBER
2666: );

Line 2717: l_cost_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; -- bug14480540

2713:
2714: l_acq_tab acq_tab_type;
2715: l_from_uom VARCHAR2(25); --(This variable stores po or receipt unit of measure)
2716: l_cmpntcls_id NUMBER;
2717: l_cost_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; -- bug14480540
2718: l_component_cost NUMBER;
2719: l_acquisition_cost NUMBER;
2720: procedure_name VARCHAR2(100);
2721:

Line 3548: --Expand l_a_code size from VARCHAR2(4) to CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE for POSCO fileds widen project

3544: l_onhand_qty NUMBER;
3545: l_method VARCHAR2(10);
3546: l_ccc_id NUMBER;
3547: --Bug 14749657
3548: --Expand l_a_code size from VARCHAR2(4) to CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE for POSCO fileds widen project
3549: l_a_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE;
3550: l_no_of_rows NUMBER;
3551: i NUMBER;
3552: retval NUMBER;

Line 3549: l_a_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE;

3545: l_method VARCHAR2(10);
3546: l_ccc_id NUMBER;
3547: --Bug 14749657
3548: --Expand l_a_code size from VARCHAR2(4) to CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE for POSCO fileds widen project
3549: l_a_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE;
3550: l_no_of_rows NUMBER;
3551: i NUMBER;
3552: retval NUMBER;
3553: l_msg_data VARCHAR2(100);

Line 4707: l_cost_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; -- bug14480540

4703: l_item_no VARCHAR2(2000);
4704: -- l_batch_no VARCHAR2(32);
4705: l_plant_code VARCHAR2(4);
4706: l_resources VARCHAR2(32);
4707: l_cost_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; -- bug14480540
4708: l_cost_component_class_code VARCHAR2(16);
4709: procedure_name VARCHAR2(100);
4710:
4711:

Line 5098: x_mtl_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; /* B9131983 and bug14480540*/

5094: ORDER BY batchstep_id
5095: ;
5096:
5097: /***** Bug 4053149 Dinesh Vadivel - End *****/
5098: x_mtl_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; /* B9131983 and bug14480540*/
5099: x_mtl_cmpntcls_id NUMBER; /* B9131983 */
5100: BEGIN
5101:
5102: procedure_name := 'Process Batch';

Line 8388: x_mtl_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; /* B9131983 and bug14480540*/

8384:
8385: PROCEDURE process_wip_batch
8386: IS
8387: procedure_name VARCHAR2(100);
8388: x_mtl_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; /* B9131983 and bug14480540*/
8389: x_mtl_cmpntcls_id NUMBER; /* B9131983 */
8390:
8391: BEGIN
8392: procedure_name := 'Process WIP Batch';

Line 9489: --Expand l_a_code size from VARCHAR2(4) to CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE for POSCO fileds widen project

9485:
9486: PROCEDURE process_consigned_inventory IS
9487: l_ccc_id NUMBER;
9488: --Bug 14749657
9489: --Expand l_a_code size from VARCHAR2(4) to CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE for POSCO fileds widen project
9490: l_a_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE;
9491: l_new_cost NUMBER;
9492: procedure_name VARCHAR2(100);
9493: BEGIN

Line 9490: l_a_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE;

9486: PROCEDURE process_consigned_inventory IS
9487: l_ccc_id NUMBER;
9488: --Bug 14749657
9489: --Expand l_a_code size from VARCHAR2(4) to CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE for POSCO fileds widen project
9490: l_a_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE;
9491: l_new_cost NUMBER;
9492: procedure_name VARCHAR2(100);
9493: BEGIN
9494: procedure_name := 'Process Consigned Inventory';

Line 9602: --Expand l_a_code size from VARCHAR2(4) to CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE for POSCO fileds widen project

9598: l_trp_cost NUMBER;
9599: l_txf_price NUMBER;
9600: l_ccc_id NUMBER;
9601: --Bug 14749657
9602: --Expand l_a_code size from VARCHAR2(4) to CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE for POSCO fileds widen project
9603: l_a_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE;
9604: l_trans_id NUMBER;
9605: l_header_id NUMBER;
9606: l_cost_count NUMBER := 0; -- PK Bug 9669214

Line 9603: l_a_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE;

9599: l_txf_price NUMBER;
9600: l_ccc_id NUMBER;
9601: --Bug 14749657
9602: --Expand l_a_code size from VARCHAR2(4) to CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE for POSCO fileds widen project
9603: l_a_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE;
9604: l_trans_id NUMBER;
9605: l_header_id NUMBER;
9606: l_cost_count NUMBER := 0; -- PK Bug 9669214
9607:

Line 9609: l_cost_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; -- bug14480540

9605: l_header_id NUMBER;
9606: l_cost_count NUMBER := 0; -- PK Bug 9669214
9607:
9608: l_cmpntcls_id NUMBER;
9609: l_cost_analysis_code CM_ALYS_MST.COST_ANALYSIS_CODE%TYPE; -- bug14480540
9610: l_cost_level NUMBER(1);
9611: l_component_cost NUMBER;
9612: l_burden_ind NUMBER(1);
9613: procedure_name VARCHAR2(100);