APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_DESIGNATORS

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

1105:
1106: d_index NUMBER := 0 ;
1107:
1108: /* ---------------- Designator declaration ----------------------*/
1109: TYPE designator IS TABLE OF msc_st_designators.designator%TYPE INDEX BY BINARY_INTEGER;
1110: i_designator designator ;
1111: e_designator designator ;/* akaruppa B5007729 */
1112:
1113: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;

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

1109: TYPE designator IS TABLE OF msc_st_designators.designator%TYPE INDEX BY BINARY_INTEGER;
1110: i_designator designator ;
1111: e_designator designator ;/* akaruppa B5007729 */
1112:
1113: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
1114: i_forecast_set forecast_set;
1115: e_forecast_set forecast_set;/* akaruppa B5007729 */
1116:
1117: TYPE description IS TABLE OF msc_st_designators.description%TYPE INDEX BY BINARY_INTEGER;

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

1113: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
1114: i_forecast_set forecast_set;
1115: e_forecast_set forecast_set;/* akaruppa B5007729 */
1116:
1117: TYPE description IS TABLE OF msc_st_designators.description%TYPE INDEX BY BINARY_INTEGER;
1118: i_description description ;
1119: e_description description ;/* akaruppa B5007729 */
1120:
1121: i_disable_date date_idx_tbl ;/* akaruppa B5007729 */

Line 12312: ' INSERT INTO msc_st_designators ( '

12308: || ' and d.trans_qty <> 0 '
12309: || ' ORDER BY wm.mtl_organization_id ,FSET DESC,h.forecast_id ' ;
12310:
12311: l_insert_set_stmt :=
12312: ' INSERT INTO msc_st_designators ( '
12313: ||' designator,forecast_set, organization_id, sr_instance_id, '
12314: ||' description, mps_relief, inventory_atp_flag, '
12315: ||' designator_type,disable_date,consume_forecast, '
12316: ||' update_type,backward_update_time_fence,forward_update_time_fence, '

Line 12652: INSERT INTO msc_st_designators (

12648: i := 1 ;
12649: log_message(i_organization_id.FIRST || ' *Designator*' || i_organization_id.LAST );
12650: IF i_organization_id.FIRST > 0 THEN
12651: FORALL i IN i_organization_id.FIRST..i_organization_id.LAST
12652: INSERT INTO msc_st_designators (
12653: designator,
12654: forecast_set,
12655: organization_id,
12656: sr_instance_id,

Line 13299: ' INSERT INTO msc_st_designators ( '

13295: i := 1 ;
13296: st_designators := NULL ;
13297: g_delimiter := '/';
13298: st_designators :=
13299: ' INSERT INTO msc_st_designators ( '
13300: ||' designator, organization_id, sr_instance_id, '
13301: ||' description, mps_relief, inventory_atp_flag, '
13302: ||' designator_type ) '
13303: ||' VALUES '