APPS.GMP_APS_DS_PULL dependencies on MSC_ST_RESOURCE_CHARGES

Line 1302: -- Msc_st_resource_charges

1298: log_message('Batches Resource size is = '|| to_char(grsrc_size) );
1299: time_stamp ;
1300:
1301: -- NAVIN: START Operation Charges Data needs to be transferred to APS in to
1302: -- Msc_st_resource_charges
1303: stp_chg_cursor:=
1304: ' SELECT '
1305: ||' ((gbsc.batch_id*2)+1) x_batch_id,'
1306: ||' ((gbsc.batchstep_id*2)+1),' /* B5461922 */

Line 1724: to APS in to Msc_st_resource_charges */

1720: END IF;
1721:
1722: IF rsrc_tab(r).scale_type = 3 AND found_chrg_rsrc = 1 THEN -- APS decoded value as per DECODE(rsrc_tab(r).scale_type,0,2,1,1,2,3);
1723: /* NAVIN: END Operation Charges Data needs to be transferred
1724: to APS in to Msc_st_resource_charges */
1725: IF rsrc_tab(r).org_step_status = 2 THEN
1726: l_charges_remaining := CEIL(((rsrc_tab(r).plan_rsrc_usage -
1727: rsrc_tab(r).actual_rsrc_usage) * rsrc_tab(r).plan_charges) /
1728: rsrc_tab(r).plan_rsrc_usage);

Line 2748: INSERT INTO msc_st_resource_charges

2744: /* NAVIN: Operation Charges */
2745: i := 1 ;
2746: IF stp_chg_resource_id.FIRST > 0 THEN
2747: FORALL i IN stp_chg_resource_id.FIRST..stp_chg_resource_id.LAST
2748: INSERT INTO msc_st_resource_charges
2749: (
2750: sr_instance_id ,
2751: resource_id ,
2752: organization_id ,