APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_DESIGNATORS

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

1125:
1126: d_index NUMBER := 0 ;
1127:
1128: /* ---------------- Designator declaration ----------------------*/
1129: TYPE designator IS TABLE OF msc_st_designators.designator%TYPE INDEX BY BINARY_INTEGER;
1130: i_designator designator ;
1131: e_designator designator ;/* akaruppa B5007729 */
1132:
1133: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;

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

1129: TYPE designator IS TABLE OF msc_st_designators.designator%TYPE INDEX BY BINARY_INTEGER;
1130: i_designator designator ;
1131: e_designator designator ;/* akaruppa B5007729 */
1132:
1133: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
1134: i_forecast_set forecast_set;
1135: e_forecast_set forecast_set;/* akaruppa B5007729 */
1136:
1137: TYPE description IS TABLE OF msc_st_designators.description%TYPE INDEX BY BINARY_INTEGER;

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

1133: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
1134: i_forecast_set forecast_set;
1135: e_forecast_set forecast_set;/* akaruppa B5007729 */
1136:
1137: TYPE description IS TABLE OF msc_st_designators.description%TYPE INDEX BY BINARY_INTEGER;
1138: i_description description ;
1139: e_description description ;/* akaruppa B5007729 */
1140:
1141: i_disable_date date_idx_tbl ;/* akaruppa B5007729 */

Line 11573: stmt_design := 'INSERT into msc_st_designators ( '

11569: -- Bug: 6030499 Vpedarla added based on bug: 5665290
11570: /* B5665290, Same as 11.5.9 MDS demand needs to be sent to APS */
11571: BEGIN
11572: /* Abhay Now we should put an insert into the Designator table too */
11573: stmt_design := 'INSERT into msc_st_designators ( '
11574: || ' designator, '
11575: || ' forecast_set, '
11576: || ' organization_id, '
11577: || ' sr_instance_id, '

Line 13097: ' INSERT INTO msc_st_designators ( '

13093: || ' and d.trans_qty <> 0 '
13094: || ' ORDER BY wm.mtl_organization_id ,FSET DESC,h.forecast_id ' ;
13095:
13096: l_insert_set_stmt :=
13097: ' INSERT INTO msc_st_designators ( '
13098: ||' designator,forecast_set, organization_id, sr_instance_id, '
13099: ||' description, mps_relief, inventory_atp_flag, '
13100: ||' designator_type,disable_date,consume_forecast, '
13101: ||' update_type,backward_update_time_fence,forward_update_time_fence, '

Line 13444: INSERT INTO msc_st_designators (

13440: i := 1 ;
13441: log_message(i_organization_id.FIRST || ' *Designator*' || i_organization_id.LAST );
13442: IF i_organization_id.FIRST > 0 THEN
13443: FORALL i IN i_organization_id.FIRST..i_organization_id.LAST
13444: INSERT INTO msc_st_designators (
13445: designator,
13446: forecast_set,
13447: organization_id,
13448: sr_instance_id,

Line 14093: ' INSERT INTO msc_st_designators ( '

14089: i := 1 ;
14090: st_designators := NULL ;
14091: g_delimiter := '/';
14092: st_designators :=
14093: ' INSERT INTO msc_st_designators ( '
14094: ||' designator, organization_id, sr_instance_id, '
14095: ||' description, mps_relief, inventory_atp_flag, '
14096: ||' designator_type ) '
14097: ||' VALUES '