[Home] [Help]
1170: stp_chg_charge_quanitity number_idx_tbl ;
1171:
1172: -- Rajesh Patangya 02-MAY-2006 Ends
1173:
1174: TYPE stp_charge_start_dt_time IS TABLE OF msc_st_resource_charges.charge_start_datetime%TYPE
1175: INDEX BY BINARY_INTEGER;
1176: stpe_chg_charge_start_dt_time stp_charge_start_dt_time ;
1177: stp_chg_charge_start_dt_time stp_charge_start_dt_time ;
1178:
1175: INDEX BY BINARY_INTEGER;
1176: stpe_chg_charge_start_dt_time stp_charge_start_dt_time ;
1177: stp_chg_charge_start_dt_time stp_charge_start_dt_time ;
1178:
1179: TYPE stp_charge_end_dt_time IS TABLE OF msc_st_resource_charges.charge_end_datetime%TYPE
1180: INDEX BY BINARY_INTEGER;
1181: stpe_chg_charge_end_dt_time stp_charge_end_dt_time ;
1182: stp_chg_charge_end_dt_time stp_charge_end_dt_time ;
1183:
8985:
8986: IF collect_ps_data THEN
8987:
8988: -- Get all the Operation Charges for the batch step
8989: -- NAVIN: START Operation Charges Data needs to be transferred to APS in to Msc_st_resource_charges
8990: stp_chg_cursor:=
8991: ' SELECT /*+ DRIVING_SITE(gbsc) DRIVING_SITE(crd) DRIVING_SITE(iwm) DRIVING_SITE(v) '
8992: ||' DRIVING_SITE(gbs) DRIVING_SITE(h) */ '
8993: ||' ((gbsc.batch_id*2)+1) x_batch_id,'
9050: and sn.NAME in ('session pga memory');
9051: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
9052:
9053:
9054: -- NAVIN: END Operation Charges Data needs to be transferred to APS in to Msc_st_resource_charges
9055:
9056: /* NAVIN :- alternate resource */
9057: /* NAVIN: In Procedure production_orders just before starting the looping for prod_dtl cursor
9058: try to get all the alternate Resources.*/
9362:
9363: IF rsrc_tab(r).scale_type = 3 AND found_chrg_rsrc = 1 THEN
9364: -- APS decoded value as per DECODE(rsrc_tab(r).scale_type,0,2,1,1,2,3);
9365: /* NAVIN: END Operation Charges Data needs to be transferred
9366: to APS in to Msc_st_resource_charges */
9367: IF rsrc_tab(r).org_step_status = 2 THEN
9368: l_charges_remaining := CEIL(((rsrc_tab(r).plan_rsrc_usage -
9369: rsrc_tab(r).actual_rsrc_usage) * rsrc_tab(r).plan_charges) /
9370: rsrc_tab(r).plan_rsrc_usage);
10296: /* NAVIN: Operation Charges */
10297: i := 1;
10298: IF stp_chg_resource_id.FIRST > 0 THEN
10299: FORALL i IN stp_chg_resource_id.FIRST..stp_chg_resource_id.LAST
10300: INSERT INTO msc_st_resource_charges
10301: (
10302: sr_instance_id ,
10303: resource_id ,
10304: organization_id ,