APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_JOB_OPERATIONS

Line 546: step_start_date DATE, /* populate msc_st_job_operations.reco_start_date */

542: usage_uom VARCHAR2(4), /*Sowmya - As Per the latest FDD changes */
543: step_qty_uom VARCHAR2(3),
544: equp_item_id PLS_INTEGER ,
545: gmd_rsrc_count PLS_INTEGER,
546: step_start_date DATE, /* populate msc_st_job_operations.reco_start_date */
547: step_end_date DATE /* populate msc_st_job_operations.reco_completion_date */
548: );
549: TYPE rsrc_dtl_tbl IS TABLE OF rsrc_rec INDEX by BINARY_INTEGER;
550: rsrc_tab rsrc_dtl_tbl;

Line 547: step_end_date DATE /* populate msc_st_job_operations.reco_completion_date */

543: step_qty_uom VARCHAR2(3),
544: equp_item_id PLS_INTEGER ,
545: gmd_rsrc_count PLS_INTEGER,
546: step_start_date DATE, /* populate msc_st_job_operations.reco_start_date */
547: step_end_date DATE /* populate msc_st_job_operations.reco_completion_date */
548: );
549: TYPE rsrc_dtl_tbl IS TABLE OF rsrc_rec INDEX by BINARY_INTEGER;
550: rsrc_tab rsrc_dtl_tbl;
551:

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

994: rr_index NUMBER := 0 ;
995: arr_index NUMBER := 0 ;
996: si_index NUMBER := 0 ;
997: inst_indx NUMBER := 0 ; /* NAVIN :- - For Resource Instance */
998: jo_index NUMBER := 0; /* NAMIT :- For msc_st_job_operations */
999:
1000: /* ------------------- Supply declaration ---------------------*/
1001:
1002: /* akaruppa B5007729 */

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

8892: || ' uom.uom_code ,'
8893: || ' uom2.uom_code ,'
8894: || ' gri.equipment_item_id ,' /* SOWMYA - As Per latest FDD changes */
8895: || ' gs.plan_rsrc_count gmd_rsrc_count,' /*passed on msc_st_resource_requirements*/
8896: || ' r.plan_start_date, ' /* populate msc_st_job_operations.reco_start_date */
8897: || ' r.plan_cmplt_date ' /* populate msc_st_job_operations.reco_completion_date */
8898: || ' FROM'
8899: --Bug 9760218. Use sy_uoms_mst instead of mtl_units_of_measure
8900: -- || ' mtl_units_of_measure'||pdblink||' uom, '

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

8893: || ' uom2.uom_code ,'
8894: || ' gri.equipment_item_id ,' /* SOWMYA - As Per latest FDD changes */
8895: || ' gs.plan_rsrc_count gmd_rsrc_count,' /*passed on msc_st_resource_requirements*/
8896: || ' r.plan_start_date, ' /* populate msc_st_job_operations.reco_start_date */
8897: || ' r.plan_cmplt_date ' /* populate msc_st_job_operations.reco_completion_date */
8898: || ' FROM'
8899: --Bug 9760218. Use sy_uoms_mst instead of mtl_units_of_measure
8900: -- || ' mtl_units_of_measure'||pdblink||' uom, '
8901: -- || ' mtl_units_of_measure'||pdblink||' uom2, '

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

9237: V_ACTIVITY_GROUP_ID := 0; /* B3995361 rpatangy */
9238: v_seq_dep_usage := 0;
9239: found_chrg_rsrc := 0;
9240: chrg_activity := -1;
9241: /* nsinghi APSK - Insert Step related information in msc_st_job_operations
9242: every time step changes. */
9243:
9244: jo_index := jo_index + 1;
9245: jo_wip_entity_id(jo_index) := rsrc_tab(r).x_batch_id;

Line 10518: INSERT INTO msc_st_job_operations

10514: i := 1 ;
10515: log_message(jo_wip_entity_id.FIRST || ' *jo*' || jo_wip_entity_id.LAST );
10516: IF jo_wip_entity_id.FIRST > 0 THEN
10517: FORALL i IN jo_wip_entity_id.FIRST..jo_wip_entity_id.LAST
10518: INSERT INTO msc_st_job_operations
10519: (
10520: wip_entity_id,
10521: sr_instance_id,
10522: operation_seq_num,