APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_RESOURCE_CHARGES

Line 1154: TYPE stp_charge_start_dt_time IS TABLE OF msc_st_resource_charges.charge_start_datetime%TYPE

1150: stp_chg_charge_quanitity number_idx_tbl ;
1151:
1152: -- Rajesh Patangya 02-MAY-2006 Ends
1153:
1154: TYPE stp_charge_start_dt_time IS TABLE OF msc_st_resource_charges.charge_start_datetime%TYPE
1155: INDEX BY BINARY_INTEGER;
1156: stpe_chg_charge_start_dt_time stp_charge_start_dt_time ;
1157: stp_chg_charge_start_dt_time stp_charge_start_dt_time ;
1158:

Line 1159: TYPE stp_charge_end_dt_time IS TABLE OF msc_st_resource_charges.charge_end_datetime%TYPE

1155: INDEX BY BINARY_INTEGER;
1156: stpe_chg_charge_start_dt_time stp_charge_start_dt_time ;
1157: stp_chg_charge_start_dt_time stp_charge_start_dt_time ;
1158:
1159: TYPE stp_charge_end_dt_time IS TABLE OF msc_st_resource_charges.charge_end_datetime%TYPE
1160: INDEX BY BINARY_INTEGER;
1161: stpe_chg_charge_end_dt_time stp_charge_end_dt_time ;
1162: stp_chg_charge_end_dt_time stp_charge_end_dt_time ;
1163:

Line 8414: -- NAVIN: START Operation Charges Data needs to be transferred to APS in to Msc_st_resource_charges

8410: log_message('Batches Resource size is = '|| to_char(grsrc_size) );
8411: time_stamp ;
8412:
8413: -- Get all the Operation Charges for the batch step
8414: -- NAVIN: START Operation Charges Data needs to be transferred to APS in to Msc_st_resource_charges
8415: stp_chg_cursor:=
8416: ' SELECT '
8417: ||' ((gbsc.batch_id*2)+1) x_batch_id,'
8418: ||' ((gbsc.batchstep_id*2)+1),' /* B5461922 */

Line 8470: -- NAVIN: END Operation Charges Data needs to be transferred to APS in to Msc_st_resource_charges

8466: stp_chg_count := stp_chg_count - 1;
8467: log_message('Batch Step charge size is = '|| to_char(stp_chg_count) );
8468: time_stamp ;
8469:
8470: -- NAVIN: END Operation Charges Data needs to be transferred to APS in to Msc_st_resource_charges
8471:
8472: /* NAVIN :- alternate resource */
8473: /* NAVIN: In Procedure production_orders just before starting the looping for prod_dtl cursor
8474: try to get all the alternate Resources.*/

Line 8768: to APS in to Msc_st_resource_charges */

8764:
8765: IF rsrc_tab(r).scale_type = 3 AND found_chrg_rsrc = 1 THEN
8766: -- APS decoded value as per DECODE(rsrc_tab(r).scale_type,0,2,1,1,2,3);
8767: /* NAVIN: END Operation Charges Data needs to be transferred
8768: to APS in to Msc_st_resource_charges */
8769: IF rsrc_tab(r).org_step_status = 2 THEN
8770: l_charges_remaining := CEIL(((rsrc_tab(r).plan_rsrc_usage -
8771: rsrc_tab(r).actual_rsrc_usage) * rsrc_tab(r).plan_charges) /
8772: rsrc_tab(r).plan_rsrc_usage);

Line 9661: INSERT INTO msc_st_resource_charges

9657: log_message(stp_chg_organization_id.FIRST || ' *STEPCHARGE*' ||
9658: stp_chg_organization_id.LAST );
9659: IF stp_chg_organization_id.FIRST > 0 THEN
9660: FORALL i IN stp_chg_organization_id.FIRST..stp_chg_organization_id.LAST
9661: INSERT INTO msc_st_resource_charges
9662: (
9663: sr_instance_id ,
9664: resource_id ,
9665: organization_id ,