DBA Data[Home] [Help]

APPS.GMP_CALENDAR_PKG dependencies on MSC_ST_RESOURCE_GROUPS

Line 402: /* Insert into MSC_ST_RESOURCE_GROUPS for Bottleneck Resources

398: END IF;
399: /*sowsubra - ME changes - end*/
400: EXECUTE IMMEDIATE ins_dept_res USING p_instance_id, p_instance_id;
401:
402: /* Insert into MSC_ST_RESOURCE_GROUPS for Bottleneck Resources
403: Sending only those resources that are used in Planning for APS
404: */
405: -- Commented for BUG 14619874 VKINDURI Start
406: /*ins_res_group := ' INSERT INTO msc_st_resource_groups '

Line 406: /*ins_res_group := ' INSERT INTO msc_st_resource_groups '

402: /* Insert into MSC_ST_RESOURCE_GROUPS for Bottleneck Resources
403: Sending only those resources that are used in Planning for APS
404: */
405: -- Commented for BUG 14619874 VKINDURI Start
406: /*ins_res_group := ' INSERT INTO msc_st_resource_groups '
407: || ' ( group_code, '
408: || ' meaning, '
409: || ' description, '
410: || ' from_date, '

Line 511: INSERT INTO msc_st_resource_groups

507: LIMIT 1000;
508: EXIT WHEN rsrc_groups_tab.COUNT = 0;
509:
510: FORALL i IN 1..rsrc_groups_tab.COUNT
511: INSERT INTO msc_st_resource_groups
512: VALUES rsrc_groups_tab(i);
513:
514: END LOOP;
515: CLOSE cur_rsrc_groups;