APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_JOB_OPERATIONS

Line 555: step_start_date DATE, /* msc_st_job_operations.reco_start_date */

551: usage_uom VARCHAR2(4), /*Sowmya - As Per the latest FDD changes */
552: step_qty_uom VARCHAR2(3),
553: equp_item_id NUMBER ,
554: gmd_rsrc_count NUMBER,
555: step_start_date DATE, /* msc_st_job_operations.reco_start_date */
556: step_end_date DATE, /* msc_st_job_operations.reco_completion_date */
557: efficiency NUMBER /*B4320561 - sowsubra */
558: );
559: TYPE rsrc_dtl_tbl IS TABLE OF rsrc_rec INDEX by BINARY_INTEGER;

Line 556: step_end_date DATE, /* msc_st_job_operations.reco_completion_date */

552: step_qty_uom VARCHAR2(3),
553: equp_item_id NUMBER ,
554: gmd_rsrc_count NUMBER,
555: step_start_date DATE, /* msc_st_job_operations.reco_start_date */
556: step_end_date DATE, /* msc_st_job_operations.reco_completion_date */
557: efficiency NUMBER /*B4320561 - sowsubra */
558: );
559: TYPE rsrc_dtl_tbl IS TABLE OF rsrc_rec INDEX by BINARY_INTEGER;
560: rsrc_tab rsrc_dtl_tbl;

Line 979: jo_index NUMBER := 0; /* NAMIT :- For msc_st_job_operations */

975: rr_index NUMBER := 0 ;
976: arr_index NUMBER := 0 ;
977: si_index NUMBER := 0 ;
978: inst_indx NUMBER := 0 ; /* NAVIN :- - For Resource Instance */
979: jo_index NUMBER := 0; /* NAMIT :- For msc_st_job_operations */
980:
981: /* ------------------- Supply declaration ---------------------*/
982:
983: /* akaruppa B5007729 */

Line 8342: || ' r.plan_start_date, ' /* populate msc_st_job_operations.reco_start_date */

8338: || ' uom.uom_code ,'
8339: || ' uom2.uom_code ,'
8340: || ' gri.equipment_item_id ,' /* SOWMYA - As Per latest FDD changes */
8341: || ' gs.plan_rsrc_count gmd_rsrc_count,' /*passed on msc_st_resource_requirements*/
8342: || ' r.plan_start_date, ' /* populate msc_st_job_operations.reco_start_date */
8343: || ' r.plan_cmplt_date, ' /* populate msc_st_job_operations.reco_completion_date */
8344: || ' NVL(c.efficiency,100) ' /*B4320561 - If null then resource is 100%efficient */
8345: || ' FROM'
8346: || ' mtl_units_of_measure'||pdblink||' uom, '

Line 8343: || ' r.plan_cmplt_date, ' /* populate msc_st_job_operations.reco_completion_date */

8339: || ' uom2.uom_code ,'
8340: || ' gri.equipment_item_id ,' /* SOWMYA - As Per latest FDD changes */
8341: || ' gs.plan_rsrc_count gmd_rsrc_count,' /*passed on msc_st_resource_requirements*/
8342: || ' r.plan_start_date, ' /* populate msc_st_job_operations.reco_start_date */
8343: || ' r.plan_cmplt_date, ' /* populate msc_st_job_operations.reco_completion_date */
8344: || ' NVL(c.efficiency,100) ' /*B4320561 - If null then resource is 100%efficient */
8345: || ' FROM'
8346: || ' mtl_units_of_measure'||pdblink||' uom, '
8347: || ' mtl_units_of_measure'||pdblink||' uom2, '

Line 8653: /* nsinghi APSK - Insert Step related information in msc_st_job_operations

8649: V_ACTIVITY_GROUP_ID := 0; /* B3995361 rpatangy */
8650: v_seq_dep_usage := 0;
8651: found_chrg_rsrc := 0;
8652: chrg_activity := -1;
8653: /* nsinghi APSK - Insert Step related information in msc_st_job_operations
8654: every time step changes. */
8655:
8656: jo_index := jo_index + 1;
8657: jo_wip_entity_id(jo_index) := rsrc_tab(r).x_batch_id;

Line 9877: INSERT INTO msc_st_job_operations

9873: i := 1 ;
9874: log_message(jo_wip_entity_id.FIRST || ' *jo*' || jo_wip_entity_id.LAST );
9875: IF jo_wip_entity_id.FIRST > 0 THEN
9876: FORALL i IN jo_wip_entity_id.FIRST..jo_wip_entity_id.LAST
9877: INSERT INTO msc_st_job_operations
9878: (
9879: wip_entity_id,
9880: sr_instance_id,
9881: operation_seq_num,