APPS.GMP_APS_DS_PULL dependencies on MSC_ST_RESOURCE_CHARGES

Line 1205: -- Msc_st_resource_charges

1201: log_message('Batches Resource size is = '|| to_char(grsrc_size) );
1202: time_stamp ;
1203:
1204: -- NAVIN: START Operation Charges Data needs to be transferred to APS in to
1205: -- Msc_st_resource_charges
1206: stp_chg_cursor:=
1207: ' SELECT '
1208: ||' ((gbsc.batch_id*2)+1) x_batch_id,'
1209: ||' ((gbsc.batchstep_id*2)+1),' /* B5461922 */

Line 1567: to APS in to Msc_st_resource_charges */

1563: END IF;
1564:
1565: 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);
1566: /* NAVIN: END Operation Charges Data needs to be transferred
1567: to APS in to Msc_st_resource_charges */
1568: IF rsrc_tab(r).org_step_status = 2 THEN
1569: l_charges_remaining := CEIL(((rsrc_tab(r).plan_rsrc_usage -
1570: rsrc_tab(r).actual_rsrc_usage) * rsrc_tab(r).plan_charges) /
1571: rsrc_tab(r).plan_rsrc_usage);

Line 2502: INSERT INTO msc_st_resource_charges

2498: /* NAVIN: Operation Charges */
2499: i := 1 ;
2500: IF stp_chg_resource_id.FIRST > 0 THEN
2501: FORALL i IN stp_chg_resource_id.FIRST..stp_chg_resource_id.LAST
2502: INSERT INTO msc_st_resource_charges
2503: (
2504: sr_instance_id ,
2505: resource_id ,
2506: organization_id ,