[Home] [Help]
1188: rr_sequence_id pls_idx_tbl ;
1189: rr_sequence_number pls_idx_tbl ;
1190: rr_setup_id pls_idx_tbl ;
1191:
1192: TYPE rsrc_firm_type IS TABLE OF msc_st_resource_requirements.firm_flag %TYPE
1193: INDEX BY BINARY_INTEGER;
1194: rr_firm_type rsrc_firm_type;
1195:
1196: /* NAVIN: new column for Operation Charges*/
8468: * Navin 21-APR-2003 B3577871 ST:OSFME2: collections failing in planning data pull.
8469: * Added handling of NO_DATA_FOUND Exception.
8470: * And return the return_status as TRUE.
8471: * Sulipta 25-JAN-2006 B4612203 Populating supply_type as 1 in
8472: * MSC_ST_RESOURCE_REQUIREMENTS table
8473: ************************************************************************/
8474:
8475: PROCEDURE production_orders(
8476: pdblink IN VARCHAR2,
8891: || ' DECODE(NVL(o.break_ind,0), 1, 1, 2) breakable_activity_flag , '
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
9887: i := 1 ;
9888: log_message(rr_organization_id.FIRST || ' *rr*' || rr_organization_id.LAST );
9889: IF rr_organization_id.FIRST > 0 THEN
9890: FORALL i IN rr_organization_id.FIRST..rr_organization_id.LAST
9891: INSERT INTO msc_st_resource_requirements (
9892: organization_id,
9893: sr_instance_id,
9894: supply_id,
9895: supply_type, /* sultripa B4612203 Need to populate supply_type field */
10694: * insert_resource_requirements
10695: *
10696: * DESCRIPTION
10697: * This procedure wil insert a row into the table
10698: * msc_st_resource_requirements using the parameters passed in
10699: * HISTORY
10700: * M Craig
10701: * 10/13/99 - Added deleted_flag in the insert statement
10702: * 13-SEP-2002 - firm_flag = 1 for WIP steps B2266934
10721: st_resource_requirements VARCHAR2(32000) ;
10722:
10723: BEGIN
10724: st_resource_requirements :=
10725: ' INSERT INTO msc_st_resource_requirements ( '
10726: ||' organization_id, sr_instance_id, supply_id, resource_seq_num,'
10727: ||' resource_id, start_date, end_date, operation_hours_required,'
10728: ||' assigned_units, department_id, wip_entity_id, operation_seq_num, '
10729: ||' deleted_flag, firm_flag, minimum_transfer_quantity, '
10755: pschedule_flag ;
10756:
10757: EXCEPTION
10758: WHEN OTHERS THEN
10759: log_message('Failure occured during the insert into msc_st_resource_requirements');
10760: log_message(sqlerrm);
10761: RAISE;
10762:
10763: END insert_resource_requirements;