APPS.GMP_APS_DS_PULL dependencies on MSC_ST_DESIGNATORS

Line 442: TYPE designator IS TABLE OF msc_st_designators.designator%TYPE INDEX BY BINARY_INTEGER;

438:
439: d_index NUMBER := 0 ;
440:
441: /* ---------------- Designator declaration ----------------------*/
442: TYPE designator IS TABLE OF msc_st_designators.designator%TYPE INDEX BY BINARY_INTEGER;
443: i_designator designator ;
444:
445: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
446: i_forecast_set forecast_set;

Line 445: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;

441: /* ---------------- Designator declaration ----------------------*/
442: TYPE designator IS TABLE OF msc_st_designators.designator%TYPE INDEX BY BINARY_INTEGER;
443: i_designator designator ;
444:
445: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
446: i_forecast_set forecast_set;
447:
448: TYPE description IS TABLE OF msc_st_designators.description%TYPE INDEX BY BINARY_INTEGER;
449: i_description description ;

Line 448: TYPE description IS TABLE OF msc_st_designators.description%TYPE INDEX BY BINARY_INTEGER;

444:
445: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
446: i_forecast_set forecast_set;
447:
448: TYPE description IS TABLE OF msc_st_designators.description%TYPE INDEX BY BINARY_INTEGER;
449: i_description description ;
450:
451: i_disable_date date_idx_tbl;
452: i_consume_forecast number_idx_tbl;

Line 4386: ' INSERT INTO msc_st_designators ( '

4382: || ' and d.trans_qty <> 0 '
4383: || ' ORDER BY wm.mtl_organization_id ,FSET DESC,h.forecast_id ' ;
4384:
4385: l_insert_set_stmt :=
4386: ' INSERT INTO msc_st_designators ( '
4387: ||' designator,forecast_set, organization_id, sr_instance_id, '
4388: ||' description, mps_relief, inventory_atp_flag, '
4389: ||' designator_type,disable_date,consume_forecast, '
4390: ||' update_type,backward_update_time_fence,forward_update_time_fence, '

Line 4726: INSERT INTO msc_st_designators (

4722: i := 1 ;
4723: log_message(i_organization_id.FIRST || ' *Designator*' || i_organization_id.LAST );
4724: IF i_organization_id.FIRST > 0 THEN
4725: FORALL i IN i_organization_id.FIRST..i_organization_id.LAST
4726: INSERT INTO msc_st_designators (
4727: designator,
4728: forecast_set,
4729: organization_id,
4730: sr_instance_id,

Line 5377: ' INSERT INTO msc_st_designators ( '

5373: BEGIN
5374:
5375: g_delimiter := '/';
5376: st_designators :=
5377: ' INSERT INTO msc_st_designators ( '
5378: ||' designator, organization_id, sr_instance_id, '
5379: ||' description, mps_relief, inventory_atp_flag, '
5380: ||' designator_type ) '
5381: ||' VALUES '