[Home] [Help]
1168: rr_sequence_id number_idx_tbl ;
1169: rr_sequence_number number_idx_tbl ;
1170: rr_setup_id number_idx_tbl ;
1171:
1172: TYPE rsrc_firm_type IS TABLE OF msc_st_resource_requirements.firm_flag %TYPE
1173: INDEX BY BINARY_INTEGER;
1174: rr_firm_type rsrc_firm_type;
1175:
1176: /* NAVIN: new column for Operation Charges*/
7948: * Navin 21-APR-2003 B3577871 ST:OSFME2: collections failing in planning data pull.
7949: * Added handling of NO_DATA_FOUND Exception.
7950: * And return the return_status as TRUE.
7951: * Sulipta 25-JAN-2006 B4612203 Populating supply_type as 1 in
7952: * MSC_ST_RESOURCE_REQUIREMENTS table
7953: ************************************************************************/
7954:
7955: PROCEDURE production_orders(
7956: pdblink IN VARCHAR2,
8337: || ' DECODE(NVL(o.break_ind,0), 1, 1, 2) breakable_activity_flag , '
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'
9266: i := 1 ;
9267: log_message(rr_organization_id.FIRST || ' *rr*' || rr_organization_id.LAST );
9268: IF rr_organization_id.FIRST > 0 THEN
9269: FORALL i IN rr_organization_id.FIRST..rr_organization_id.LAST
9270: INSERT INTO msc_st_resource_requirements (
9271: organization_id,
9272: sr_instance_id,
9273: supply_id,
9274: supply_type, /* sultripa B4612203 Need to populate supply_type field */
10049: * insert_resource_requirements
10050: *
10051: * DESCRIPTION
10052: * This procedure wil insert a row into the table
10053: * msc_st_resource_requirements using the parameters passed in
10054: * HISTORY
10055: * M Craig
10056: * 10/13/99 - Added deleted_flag in the insert statement
10057: * 13-SEP-2002 - firm_flag = 1 for WIP steps B2266934
10076: st_resource_requirements VARCHAR2(32000) ;
10077:
10078: BEGIN
10079: st_resource_requirements :=
10080: ' INSERT INTO msc_st_resource_requirements ( '
10081: ||' organization_id, sr_instance_id, supply_id, resource_seq_num,'
10082: ||' resource_id, start_date, end_date, operation_hours_required,'
10083: ||' assigned_units, department_id, wip_entity_id, operation_seq_num, '
10084: ||' deleted_flag, firm_flag, minimum_transfer_quantity, '
10110: pschedule_flag ;
10111:
10112: EXCEPTION
10113: WHEN OTHERS THEN
10114: log_message('Failure occured during the insert into msc_st_resource_requirements');
10115: log_message(sqlerrm);
10116: RAISE;
10117:
10118: END insert_resource_requirements;