eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_SETUP_PULL dependencies on MSC_CL_PULL

Line 28: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

24: BEGIN
25:
26: --=================== Net Change Mode: Delete ==================
27:
28: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
29:
30: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_CHANGES';
31: MSC_CL_PULL.v_view_name := 'MRP_AD_RESOURCE_CHANGES_V';
32:

Line 30: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_CHANGES';

26: --=================== Net Change Mode: Delete ==================
27:
28: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
29:
30: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_CHANGES';
31: MSC_CL_PULL.v_view_name := 'MRP_AD_RESOURCE_CHANGES_V';
32:
33: v_sql_stmt:=
34: ' INSERT INTO MSC_ST_RESOURCE_CHANGES'

Line 31: MSC_CL_PULL.v_view_name := 'MRP_AD_RESOURCE_CHANGES_V';

27:
28: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
29:
30: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_CHANGES';
31: MSC_CL_PULL.v_view_name := 'MRP_AD_RESOURCE_CHANGES_V';
32:
33: v_sql_stmt:=
34: ' INSERT INTO MSC_ST_RESOURCE_CHANGES'
35: ||' ( DEPARTMENT_ID,'

Line 60: ||' FROM MRP_AD_RESOURCE_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'

56: ||' x.ACTION_TYPE,'
57: ||' 1,'
58: ||' :v_refresh_id,'
59: ||' :v_instance_id'
60: ||' FROM MRP_AD_RESOURCE_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
61: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn;
62:
63: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
64:

Line 61: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn;

57: ||' 1,'
58: ||' :v_refresh_id,'
59: ||' :v_instance_id'
60: ||' FROM MRP_AD_RESOURCE_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
61: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn;
62:
63: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
64:
65: COMMIT;

Line 63: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

59: ||' :v_instance_id'
60: ||' FROM MRP_AD_RESOURCE_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
61: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn;
62:
63: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
64:
65: COMMIT;
66:
67: END IF;

Line 71: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN --when not net collection

67: END IF;
68:
69:
70:
71: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN --when not net collection
72:
73:
74: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_ASSIGNMENTS';
75: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_ASSIGNMENTS_V';

Line 74: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_ASSIGNMENTS';

70:
71: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN --when not net collection
72:
73:
74: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_ASSIGNMENTS';
75: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_ASSIGNMENTS_V';
76:
77: v_sql_stmt:=
78: ' INSERT INTO MSC_ST_CALENDAR_ASSIGNMENTS'

Line 75: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_ASSIGNMENTS_V';

71: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN --when not net collection
72:
73:
74: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_ASSIGNMENTS';
75: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_ASSIGNMENTS_V';
76:
77: v_sql_stmt:=
78: ' INSERT INTO MSC_ST_CALENDAR_ASSIGNMENTS'
79: ||' ( ASSOCIATION_TYPE,'

Line 104: ||' FROM MRP_AP_CAL_ASSIGNMENTS_V'||MSC_CL_PULL.v_dblink||' x';

100: ||' x.PARTNER_TYPE,'
101: ||' decode(x.ASSOCIATION_TYPE,11,1,10,1,9,3,8,3,7,3,6,2,5,2,4,4,3,4,2,4,1,4),'
102: ||' x.SHIP_METHOD_CODE,'
103: ||' :v_refresh_id'
104: ||' FROM MRP_AP_CAL_ASSIGNMENTS_V'||MSC_CL_PULL.v_dblink||' x';
105:
106: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_refresh_id;
107:
108: COMMIT;

Line 106: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_refresh_id;

102: ||' x.SHIP_METHOD_CODE,'
103: ||' :v_refresh_id'
104: ||' FROM MRP_AP_CAL_ASSIGNMENTS_V'||MSC_CL_PULL.v_dblink||' x';
105:
106: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_refresh_id;
107:
108: COMMIT;
109:
110: END IF;

Line 112: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_DATES';

108: COMMIT;
109:
110: END IF;
111:
112: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_DATES';
113: MSC_CL_PULL.v_view_name := 'MRP_AP_CALENDAR_DATES_V';
114: v_sql_stmt:=
115: 'insert into MSC_ST_CALENDAR_DATES'
116: ||' ( CALENDAR_DATE,'

Line 113: MSC_CL_PULL.v_view_name := 'MRP_AP_CALENDAR_DATES_V';

109:
110: END IF;
111:
112: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_DATES';
113: MSC_CL_PULL.v_view_name := 'MRP_AP_CALENDAR_DATES_V';
114: v_sql_stmt:=
115: 'insert into MSC_ST_CALENDAR_DATES'
116: ||' ( CALENDAR_DATE,'
117: ||' CALENDAR_CODE,'

Line 145: ||' from MRP_AP_CALENDAR_DATES_V'||MSC_CL_PULL.v_dblink||' x'

141: ||' x.DESCRIPTION,'
142: ||' 2,'
143: ||' :v_refresh_id,'
144: ||' :v_instance_id'
145: ||' from MRP_AP_CALENDAR_DATES_V'||MSC_CL_PULL.v_dblink||' x'
146: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
147: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
148: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
149: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn;

Line 146: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

142: ||' 2,'
143: ||' :v_refresh_id,'
144: ||' :v_instance_id'
145: ||' from MRP_AP_CALENDAR_DATES_V'||MSC_CL_PULL.v_dblink||' x'
146: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
147: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
148: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
149: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn;
150:

Line 147: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

143: ||' :v_refresh_id,'
144: ||' :v_instance_id'
145: ||' from MRP_AP_CALENDAR_DATES_V'||MSC_CL_PULL.v_dblink||' x'
146: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
147: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
148: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
149: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn;
150:
151: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 148: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn

144: ||' :v_instance_id'
145: ||' from MRP_AP_CALENDAR_DATES_V'||MSC_CL_PULL.v_dblink||' x'
146: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
147: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
148: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
149: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn;
150:
151: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
152:

Line 149: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn;

145: ||' from MRP_AP_CALENDAR_DATES_V'||MSC_CL_PULL.v_dblink||' x'
146: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
147: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
148: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
149: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn;
150:
151: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
152:
153: COMMIT;

Line 151: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

147: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
148: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
149: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn;
150:
151: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
152:
153: COMMIT;
154:
155: MSC_CL_PULL.v_table_name:= 'MSC_ST_PERIOD_START_DATES';

Line 155: MSC_CL_PULL.v_table_name:= 'MSC_ST_PERIOD_START_DATES';

151: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
152:
153: COMMIT;
154:
155: MSC_CL_PULL.v_table_name:= 'MSC_ST_PERIOD_START_DATES';
156: MSC_CL_PULL.v_view_name := 'MRP_AP_PERIOD_START_DATES_V';
157:
158: v_sql_stmt:=
159: ' INSERT INTO MSC_ST_PERIOD_START_DATES'

Line 156: MSC_CL_PULL.v_view_name := 'MRP_AP_PERIOD_START_DATES_V';

152:
153: COMMIT;
154:
155: MSC_CL_PULL.v_table_name:= 'MSC_ST_PERIOD_START_DATES';
156: MSC_CL_PULL.v_view_name := 'MRP_AP_PERIOD_START_DATES_V';
157:
158: v_sql_stmt:=
159: ' INSERT INTO MSC_ST_PERIOD_START_DATES'
160: ||' ( CALENDAR_CODE,'

Line 181: ||' FROM MRP_AP_PERIOD_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'

177: ||' x.PRIOR_DATE,'
178: ||' 2,'
179: ||' :v_refresh_id,'
180: ||' :v_instance_id'
181: ||' FROM MRP_AP_PERIOD_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
182: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
183: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
184: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
185:

Line 182: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

178: ||' 2,'
179: ||' :v_refresh_id,'
180: ||' :v_instance_id'
181: ||' FROM MRP_AP_PERIOD_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
182: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
183: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
184: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
185:
186: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 183: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

179: ||' :v_refresh_id,'
180: ||' :v_instance_id'
181: ||' FROM MRP_AP_PERIOD_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
182: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
183: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
184: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
185:
186: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
187:

Line 184: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;

180: ||' :v_instance_id'
181: ||' FROM MRP_AP_PERIOD_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
182: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
183: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
184: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
185:
186: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
187:
188: COMMIT;

Line 186: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

182: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
183: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
184: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
185:
186: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
187:
188: COMMIT;
189:
190: MSC_CL_PULL.v_table_name:= 'MSC_ST_CAL_YEAR_START_DATES';

Line 190: MSC_CL_PULL.v_table_name:= 'MSC_ST_CAL_YEAR_START_DATES';

186: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
187:
188: COMMIT;
189:
190: MSC_CL_PULL.v_table_name:= 'MSC_ST_CAL_YEAR_START_DATES';
191: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_YEAR_START_DATES_V';
192:
193: v_sql_stmt:=
194: ' INSERT INTO MSC_ST_CAL_YEAR_START_DATES'

Line 191: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_YEAR_START_DATES_V';

187:
188: COMMIT;
189:
190: MSC_CL_PULL.v_table_name:= 'MSC_ST_CAL_YEAR_START_DATES';
191: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_YEAR_START_DATES_V';
192:
193: v_sql_stmt:=
194: ' INSERT INTO MSC_ST_CAL_YEAR_START_DATES'
195: ||' ( CALENDAR_CODE,'

Line 208: ||' FROM MRP_AP_CAL_YEAR_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'

204: ||' x.YEAR_START_DATE,'
205: ||' 2,'
206: ||' :v_refresh_id,'
207: ||' :v_instance_id'
208: ||' FROM MRP_AP_CAL_YEAR_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
209: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
210: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
211: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
212:

Line 209: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

205: ||' 2,'
206: ||' :v_refresh_id,'
207: ||' :v_instance_id'
208: ||' FROM MRP_AP_CAL_YEAR_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
209: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
210: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
211: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
212:
213: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 210: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

206: ||' :v_refresh_id,'
207: ||' :v_instance_id'
208: ||' FROM MRP_AP_CAL_YEAR_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
209: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
210: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
211: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
212:
213: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
214:

Line 211: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;

207: ||' :v_instance_id'
208: ||' FROM MRP_AP_CAL_YEAR_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
209: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
210: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
211: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
212:
213: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
214:
215: COMMIT;

Line 213: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

209: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
210: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
211: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
212:
213: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
214:
215: COMMIT;
216:
217: MSC_CL_PULL.v_table_name:= 'MSC_ST_CAL_WEEK_START_DATES';

Line 217: MSC_CL_PULL.v_table_name:= 'MSC_ST_CAL_WEEK_START_DATES';

213: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
214:
215: COMMIT;
216:
217: MSC_CL_PULL.v_table_name:= 'MSC_ST_CAL_WEEK_START_DATES';
218: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_WEEK_START_DATES_V';
219:
220: v_sql_stmt:=
221: ' INSERT INTO MSC_ST_CAL_WEEK_START_DATES'

Line 218: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_WEEK_START_DATES_V';

214:
215: COMMIT;
216:
217: MSC_CL_PULL.v_table_name:= 'MSC_ST_CAL_WEEK_START_DATES';
218: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_WEEK_START_DATES_V';
219:
220: v_sql_stmt:=
221: ' INSERT INTO MSC_ST_CAL_WEEK_START_DATES'
222: ||' ( CALENDAR_CODE,'

Line 241: ||' FROM MRP_AP_CAL_WEEK_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'

237: ||' x.SEQ_NUM,'
238: ||' 2,'
239: ||' :v_refresh_id,'
240: ||' :v_instance_id'
241: ||' FROM MRP_AP_CAL_WEEK_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
242: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
243: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
244: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
245:

Line 242: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

238: ||' 2,'
239: ||' :v_refresh_id,'
240: ||' :v_instance_id'
241: ||' FROM MRP_AP_CAL_WEEK_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
242: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
243: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
244: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
245:
246: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 243: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

239: ||' :v_refresh_id,'
240: ||' :v_instance_id'
241: ||' FROM MRP_AP_CAL_WEEK_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
242: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
243: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
244: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
245:
246: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
247:

Line 244: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;

240: ||' :v_instance_id'
241: ||' FROM MRP_AP_CAL_WEEK_START_DATES_V'||MSC_CL_PULL.v_dblink||' x'
242: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
243: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
244: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
245:
246: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
247:
248: COMMIT;

Line 246: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

242: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
243: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
244: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
245:
246: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
247:
248: COMMIT;
249:
250: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_SHIFTS';

Line 250: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_SHIFTS';

246: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
247:
248: COMMIT;
249:
250: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_SHIFTS';
251: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_SHIFTS_V';
252:
253: Begin
254:

Line 251: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_SHIFTS_V';

247:
248: COMMIT;
249:
250: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_SHIFTS';
251: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_SHIFTS_V';
252:
253: Begin
254:
255:

Line 256: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

252:
253: Begin
254:
255:
256: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
257: v_temp_sql:= 'x.capacity_units , ' ;
258: ELSE
259: v_temp_sql:=' NULL, ' ;
260: END IF ;

Line 282: ||' FROM MRP_AP_RESOURCE_SHIFTS_V'||MSC_CL_PULL.v_dblink||' x'

278: ||' 2,'
279: || v_temp_sql
280: ||' :v_refresh_id,'
281: ||' :v_instance_id'
282: ||' FROM MRP_AP_RESOURCE_SHIFTS_V'||MSC_CL_PULL.v_dblink||' x'
283: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
284: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
285: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
286:

Line 284: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn

280: ||' :v_refresh_id,'
281: ||' :v_instance_id'
282: ||' FROM MRP_AP_RESOURCE_SHIFTS_V'||MSC_CL_PULL.v_dblink||' x'
283: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
284: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
285: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
286:
287: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
288:

Line 285: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';

281: ||' :v_instance_id'
282: ||' FROM MRP_AP_RESOURCE_SHIFTS_V'||MSC_CL_PULL.v_dblink||' x'
283: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
284: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
285: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
286:
287: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
288:
289: COMMIT;

Line 287: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

283: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
284: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
285: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
286:
287: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
288:
289: COMMIT;
290:
291: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_SHIFTS';

Line 291: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_SHIFTS';

287: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
288:
289: COMMIT;
290:
291: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_SHIFTS';
292: MSC_CL_PULL.v_view_name := 'MRP_AP_CALENDAR_SHIFTS_V';
293:
294: v_sql_stmt:=
295: ' INSERT INTO MSC_ST_CALENDAR_SHIFTS'

Line 292: MSC_CL_PULL.v_view_name := 'MRP_AP_CALENDAR_SHIFTS_V';

288:
289: COMMIT;
290:
291: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_SHIFTS';
292: MSC_CL_PULL.v_view_name := 'MRP_AP_CALENDAR_SHIFTS_V';
293:
294: v_sql_stmt:=
295: ' INSERT INTO MSC_ST_CALENDAR_SHIFTS'
296: ||' ( CALENDAR_CODE,'

Line 313: ||' FROM MRP_AP_CALENDAR_SHIFTS_V'||MSC_CL_PULL.v_dblink||' x'

309: ||' x.DESCRIPTION,'
310: ||' 2,'
311: ||' :v_refresh_id,'
312: ||' :v_instance_id'
313: ||' FROM MRP_AP_CALENDAR_SHIFTS_V'||MSC_CL_PULL.v_dblink||' x'
314: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
315: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
316: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
317:

Line 314: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

310: ||' 2,'
311: ||' :v_refresh_id,'
312: ||' :v_instance_id'
313: ||' FROM MRP_AP_CALENDAR_SHIFTS_V'||MSC_CL_PULL.v_dblink||' x'
314: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
315: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
316: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
317:
318: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 315: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

311: ||' :v_refresh_id,'
312: ||' :v_instance_id'
313: ||' FROM MRP_AP_CALENDAR_SHIFTS_V'||MSC_CL_PULL.v_dblink||' x'
314: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
315: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
316: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
317:
318: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
319:

Line 316: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;

312: ||' :v_instance_id'
313: ||' FROM MRP_AP_CALENDAR_SHIFTS_V'||MSC_CL_PULL.v_dblink||' x'
314: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
315: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
316: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
317:
318: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
319:
320: COMMIT;

Line 318: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

314: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
315: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
316: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
317:
318: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
319:
320: COMMIT;
321:
322: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_DATES';

Line 322: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_DATES';

318: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
319:
320: COMMIT;
321:
322: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_DATES';
323: MSC_CL_PULL.v_view_name := 'MRP_AP_SHIFT_DATES_V';
324:
325: v_sql_stmt:=
326: ' INSERT INTO MSC_ST_SHIFT_DATES'

Line 323: MSC_CL_PULL.v_view_name := 'MRP_AP_SHIFT_DATES_V';

319:
320: COMMIT;
321:
322: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_DATES';
323: MSC_CL_PULL.v_view_name := 'MRP_AP_SHIFT_DATES_V';
324:
325: v_sql_stmt:=
326: ' INSERT INTO MSC_ST_SHIFT_DATES'
327: ||' ( CALENDAR_CODE,'

Line 352: ||' FROM MRP_AP_SHIFT_DATES_V'||MSC_CL_PULL.v_dblink||' x'

348: ||' x.PRIOR_DATE,'
349: ||' 2,'
350: ||' :v_refresh_id,'
351: ||' :v_instance_id'
352: ||' FROM MRP_AP_SHIFT_DATES_V'||MSC_CL_PULL.v_dblink||' x'
353: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
354: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
355: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
356:

Line 353: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

349: ||' 2,'
350: ||' :v_refresh_id,'
351: ||' :v_instance_id'
352: ||' FROM MRP_AP_SHIFT_DATES_V'||MSC_CL_PULL.v_dblink||' x'
353: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
354: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
355: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
356:
357: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 354: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

350: ||' :v_refresh_id,'
351: ||' :v_instance_id'
352: ||' FROM MRP_AP_SHIFT_DATES_V'||MSC_CL_PULL.v_dblink||' x'
353: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
354: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
355: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
356:
357: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
358:

Line 355: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;

351: ||' :v_instance_id'
352: ||' FROM MRP_AP_SHIFT_DATES_V'||MSC_CL_PULL.v_dblink||' x'
353: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
354: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
355: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
356:
357: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
358:
359: COMMIT;

Line 357: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

353: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
354: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
355: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
356:
357: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
358:
359: COMMIT;
360:
361: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_CHANGES';

Line 361: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_CHANGES';

357: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
358:
359: COMMIT;
360:
361: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_CHANGES';
362: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_CHANGES_V';
363:
364: v_sql_stmt:=
365: ' INSERT INTO MSC_ST_RESOURCE_CHANGES'

Line 362: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_CHANGES_V';

358:
359: COMMIT;
360:
361: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_CHANGES';
362: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_CHANGES_V';
363:
364: v_sql_stmt:=
365: ' INSERT INTO MSC_ST_RESOURCE_CHANGES'
366: ||' ( DEPARTMENT_ID,'

Line 393: ||' FROM MRP_AP_RESOURCE_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'

389: ||' x.ACTION_TYPE,'
390: ||' 2,'
391: ||' :v_refresh_id,'
392: ||' :v_instance_id'
393: ||' FROM MRP_AP_RESOURCE_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
394: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
395: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn;
396:
397: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 394: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

390: ||' 2,'
391: ||' :v_refresh_id,'
392: ||' :v_instance_id'
393: ||' FROM MRP_AP_RESOURCE_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
394: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
395: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn;
396:
397: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
398:

Line 395: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn;

391: ||' :v_refresh_id,'
392: ||' :v_instance_id'
393: ||' FROM MRP_AP_RESOURCE_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
394: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
395: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn;
396:
397: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
398:
399: COMMIT;

Line 397: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

393: ||' FROM MRP_AP_RESOURCE_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
394: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
395: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn;
396:
397: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
398:
399: COMMIT;
400:
401: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_TIMES';

Line 401: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_TIMES';

397: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
398:
399: COMMIT;
400:
401: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_TIMES';
402: MSC_CL_PULL.v_view_name := 'MRP_AP_SHIFT_TIMES_V';
403:
404: v_sql_stmt:=
405: ' INSERT INTO MSC_ST_SHIFT_TIMES'

Line 402: MSC_CL_PULL.v_view_name := 'MRP_AP_SHIFT_TIMES_V';

398:
399: COMMIT;
400:
401: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_TIMES';
402: MSC_CL_PULL.v_view_name := 'MRP_AP_SHIFT_TIMES_V';
403:
404: v_sql_stmt:=
405: ' INSERT INTO MSC_ST_SHIFT_TIMES'
406: ||' ( CALENDAR_CODE,'

Line 421: ||' FROM MRP_AP_SHIFT_TIMES_V'||MSC_CL_PULL.v_dblink||' x'

417: ||' x.TO_TIME,'
418: ||' 2,'
419: ||' :v_refresh_id,'
420: ||' :v_instance_id'
421: ||' FROM MRP_AP_SHIFT_TIMES_V'||MSC_CL_PULL.v_dblink||' x'
422: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
423: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
424: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
425:

Line 422: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

418: ||' 2,'
419: ||' :v_refresh_id,'
420: ||' :v_instance_id'
421: ||' FROM MRP_AP_SHIFT_TIMES_V'||MSC_CL_PULL.v_dblink||' x'
422: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
423: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
424: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
425:
426: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 423: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

419: ||' :v_refresh_id,'
420: ||' :v_instance_id'
421: ||' FROM MRP_AP_SHIFT_TIMES_V'||MSC_CL_PULL.v_dblink||' x'
422: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
423: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
424: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
425:
426: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
427:

Line 424: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;

420: ||' :v_instance_id'
421: ||' FROM MRP_AP_SHIFT_TIMES_V'||MSC_CL_PULL.v_dblink||' x'
422: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
423: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
424: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
425:
426: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
427:
428: COMMIT;

Line 426: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

422: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
423: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
424: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
425:
426: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
427:
428: COMMIT;
429:
430: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_EXCEPTIONS';

Line 430: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_EXCEPTIONS';

426: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
427:
428: COMMIT;
429:
430: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_EXCEPTIONS';
431: MSC_CL_PULL.v_view_name := 'MRP_AP_SHIFT_EXCEPTIONS_V';
432:
433: v_sql_stmt:=
434: ' INSERT INTO MSC_ST_SHIFT_EXCEPTIONS'

Line 431: MSC_CL_PULL.v_view_name := 'MRP_AP_SHIFT_EXCEPTIONS_V';

427:
428: COMMIT;
429:
430: MSC_CL_PULL.v_table_name:= 'MSC_ST_SHIFT_EXCEPTIONS';
431: MSC_CL_PULL.v_view_name := 'MRP_AP_SHIFT_EXCEPTIONS_V';
432:
433: v_sql_stmt:=
434: ' INSERT INTO MSC_ST_SHIFT_EXCEPTIONS'
435: ||' ( CALENDAR_CODE,'

Line 452: ||' FROM MRP_AP_SHIFT_EXCEPTIONS_V'||MSC_CL_PULL.v_dblink||' x'

448: ||' x.EXCEPTION_TYPE,'
449: ||' 2,'
450: ||' :v_refresh_id,'
451: ||' :v_instance_id'
452: ||' FROM MRP_AP_SHIFT_EXCEPTIONS_V'||MSC_CL_PULL.v_dblink||' x'
453: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
454: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
455: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
456:

Line 453: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

449: ||' 2,'
450: ||' :v_refresh_id,'
451: ||' :v_instance_id'
452: ||' FROM MRP_AP_SHIFT_EXCEPTIONS_V'||MSC_CL_PULL.v_dblink||' x'
453: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
454: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
455: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
456:
457: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 454: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

450: ||' :v_refresh_id,'
451: ||' :v_instance_id'
452: ||' FROM MRP_AP_SHIFT_EXCEPTIONS_V'||MSC_CL_PULL.v_dblink||' x'
453: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
454: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
455: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
456:
457: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
458:

Line 455: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;

451: ||' :v_instance_id'
452: ||' FROM MRP_AP_SHIFT_EXCEPTIONS_V'||MSC_CL_PULL.v_dblink||' x'
453: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
454: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
455: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
456:
457: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
458:
459: COMMIT;

Line 457: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

453: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
454: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
455: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
456:
457: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
458:
459: COMMIT;
460:
461: -- =============================== NETCHAGE OF DELETE ======================

Line 465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

461: -- =============================== NETCHAGE OF DELETE ======================
462:
463: /* ds change start */
464:
465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
466: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
467: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';
468: MSC_CL_PULL.v_view_name := 'MRP_AD_RES_INST_CHANGES_V';
469: v_sql_stmt:=

Line 466: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

462:
463: /* ds change start */
464:
465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
466: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
467: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';
468: MSC_CL_PULL.v_view_name := 'MRP_AD_RES_INST_CHANGES_V';
469: v_sql_stmt:=
470: ' INSERT INTO MSC_ST_RES_INSTANCE_CHANGES'

Line 467: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';

463: /* ds change start */
464:
465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
466: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
467: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';
468: MSC_CL_PULL.v_view_name := 'MRP_AD_RES_INST_CHANGES_V';
469: v_sql_stmt:=
470: ' INSERT INTO MSC_ST_RES_INSTANCE_CHANGES'
471: ||' ( DEPARTMENT_ID,'

Line 468: MSC_CL_PULL.v_view_name := 'MRP_AD_RES_INST_CHANGES_V';

464:
465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
466: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
467: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';
468: MSC_CL_PULL.v_view_name := 'MRP_AD_RES_INST_CHANGES_V';
469: v_sql_stmt:=
470: ' INSERT INTO MSC_ST_RES_INSTANCE_CHANGES'
471: ||' ( DEPARTMENT_ID,'
472: ||' RESOURCE_ID,'

Line 500: ||' FROM MRP_AD_RES_INST_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'

496: ||' x.ACTION_TYPE,'
497: ||' 1,'
498: ||' :v_refresh_id,'
499: ||' :v_instance_id'
500: ||' FROM MRP_AD_RES_INST_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
501: ||' WHERE x.RN >' ||MSC_CL_PULL.v_lrn;
502:
503: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: res_instance change sql = '||v_sql_stmt);
504: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 501: ||' WHERE x.RN >' ||MSC_CL_PULL.v_lrn;

497: ||' 1,'
498: ||' :v_refresh_id,'
499: ||' :v_instance_id'
500: ||' FROM MRP_AD_RES_INST_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
501: ||' WHERE x.RN >' ||MSC_CL_PULL.v_lrn;
502:
503: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: res_instance change sql = '||v_sql_stmt);
504: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
505:

Line 504: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

500: ||' FROM MRP_AD_RES_INST_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
501: ||' WHERE x.RN >' ||MSC_CL_PULL.v_lrn;
502:
503: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: res_instance change sql = '||v_sql_stmt);
504: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
505:
506: COMMIT;
507:
508: END IF; /* MSC_CL_PULL.v_lrnn<> -1 */

Line 508: END IF; /* MSC_CL_PULL.v_lrnn<> -1 */

504: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
505:
506: COMMIT;
507:
508: END IF; /* MSC_CL_PULL.v_lrnn<> -1 */
509:
510: IF MSC_CL_PULL.v_lrnn= -1 THEN /* if it i not net change */
511: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';
512: MSC_CL_PULL.v_view_name := 'MRP_AP_RES_INST_CHANGES_V';

Line 510: IF MSC_CL_PULL.v_lrnn= -1 THEN /* if it i not net change */

506: COMMIT;
507:
508: END IF; /* MSC_CL_PULL.v_lrnn<> -1 */
509:
510: IF MSC_CL_PULL.v_lrnn= -1 THEN /* if it i not net change */
511: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';
512: MSC_CL_PULL.v_view_name := 'MRP_AP_RES_INST_CHANGES_V';
513:
514: v_sql_stmt:=

Line 511: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';

507:
508: END IF; /* MSC_CL_PULL.v_lrnn<> -1 */
509:
510: IF MSC_CL_PULL.v_lrnn= -1 THEN /* if it i not net change */
511: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';
512: MSC_CL_PULL.v_view_name := 'MRP_AP_RES_INST_CHANGES_V';
513:
514: v_sql_stmt:=
515: ' INSERT INTO MSC_ST_RES_INSTANCE_CHANGES'

Line 512: MSC_CL_PULL.v_view_name := 'MRP_AP_RES_INST_CHANGES_V';

508: END IF; /* MSC_CL_PULL.v_lrnn<> -1 */
509:
510: IF MSC_CL_PULL.v_lrnn= -1 THEN /* if it i not net change */
511: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';
512: MSC_CL_PULL.v_view_name := 'MRP_AP_RES_INST_CHANGES_V';
513:
514: v_sql_stmt:=
515: ' INSERT INTO MSC_ST_RES_INSTANCE_CHANGES'
516: ||' ( DEPARTMENT_ID,'

Line 549: ||' FROM MRP_AP_RES_INST_CHANGES_V' ||MSC_CL_PULL.v_dblink ||' x'

545: ||' x.ACTION_TYPE,'
546: ||' 2,'
547: ||' :v_refresh_id,'
548: ||' :v_instance_id'
549: ||' FROM MRP_AP_RES_INST_CHANGES_V' ||MSC_CL_PULL.v_dblink ||' x'
550: ||' WHERE x.RN1>' ||MSC_CL_PULL.v_lrn
551: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn;
552:
553: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: res_instance changes sql = '||v_sql_stmt);

Line 550: ||' WHERE x.RN1>' ||MSC_CL_PULL.v_lrn

546: ||' 2,'
547: ||' :v_refresh_id,'
548: ||' :v_instance_id'
549: ||' FROM MRP_AP_RES_INST_CHANGES_V' ||MSC_CL_PULL.v_dblink ||' x'
550: ||' WHERE x.RN1>' ||MSC_CL_PULL.v_lrn
551: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn;
552:
553: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: res_instance changes sql = '||v_sql_stmt);
554: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 551: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn;

547: ||' :v_refresh_id,'
548: ||' :v_instance_id'
549: ||' FROM MRP_AP_RES_INST_CHANGES_V' ||MSC_CL_PULL.v_dblink ||' x'
550: ||' WHERE x.RN1>' ||MSC_CL_PULL.v_lrn
551: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn;
552:
553: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: res_instance changes sql = '||v_sql_stmt);
554: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
555: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RES_INST_CHANGES_V='|| SQL%ROWCOUNT);

Line 554: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

550: ||' WHERE x.RN1>' ||MSC_CL_PULL.v_lrn
551: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn;
552:
553: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: res_instance changes sql = '||v_sql_stmt);
554: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
555: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RES_INST_CHANGES_V='|| SQL%ROWCOUNT);
556:
557: COMMIT;
558: END IF; /* MSC_CL_PULL.v_lrnn= -1 */

Line 558: END IF; /* MSC_CL_PULL.v_lrnn= -1 */

554: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
555: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RES_INST_CHANGES_V='|| SQL%ROWCOUNT);
556:
557: COMMIT;
558: END IF; /* MSC_CL_PULL.v_lrnn= -1 */
559:
560: END IF; /* MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 */
561:
562: END LOAD_CALENDAR_DATE;

Line 560: END IF; /* MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 */

556:
557: COMMIT;
558: END IF; /* MSC_CL_PULL.v_lrnn= -1 */
559:
560: END IF; /* MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 */
561:
562: END LOAD_CALENDAR_DATE;
563:
564:

Line 572: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh

568:
569: BEGIN
570:
571:
572: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
573: --IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN /* PREPLACE START */
574:
575: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';
576: MSC_CL_PULL.v_view_name := 'MRP_AP_BUYER_CONTACTS_V';

Line 573: --IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN /* PREPLACE START */

569: BEGIN
570:
571:
572: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
573: --IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN /* PREPLACE START */
574:
575: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';
576: MSC_CL_PULL.v_view_name := 'MRP_AP_BUYER_CONTACTS_V';
577:

Line 575: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';

571:
572: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
573: --IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN /* PREPLACE START */
574:
575: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';
576: MSC_CL_PULL.v_view_name := 'MRP_AP_BUYER_CONTACTS_V';
577:
578: v_sql_stmt :=
579: 'INSERT INTO MSC_ST_PARTNER_CONTACTS'

Line 576: MSC_CL_PULL.v_view_name := 'MRP_AP_BUYER_CONTACTS_V';

572: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
573: --IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN /* PREPLACE START */
574:
575: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';
576: MSC_CL_PULL.v_view_name := 'MRP_AP_BUYER_CONTACTS_V';
577:
578: v_sql_stmt :=
579: 'INSERT INTO MSC_ST_PARTNER_CONTACTS'
580: ||' ( NAME,'

Line 603: ||' FROM MRP_AP_BUYER_CONTACTS_V'||MSC_CL_PULL.v_dblink||' x'

599: ||' ENABLED_FLAG,'
600: ||' 2,'
601: ||' :v_refresh_id,'
602: ||' :v_instance_id'
603: ||' FROM MRP_AP_BUYER_CONTACTS_V'||MSC_CL_PULL.v_dblink||' x'
604: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str;
605:
606: EXECUTE IMMEDIATE v_sql_stmt
607: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 607: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

603: ||' FROM MRP_AP_BUYER_CONTACTS_V'||MSC_CL_PULL.v_dblink||' x'
604: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str;
605:
606: EXECUTE IMMEDIATE v_sql_stmt
607: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
608:
609: COMMIT;
610:
611:

Line 613: --END IF; -- MSC_CL_PULL.ITEM_ENABLED /* PREPLACE END */

609: COMMIT;
610:
611:
612: END IF; -- complete refresh
613: --END IF; -- MSC_CL_PULL.ITEM_ENABLED /* PREPLACE END */
614:
615: END LOAD_BUYER_CONTACT;
616:
617:

Line 629: v_sql_stmt := ' select nvl(FND_PROFILE.VALUE'||MSC_CL_PULL.v_dblink||'(''BOM:CONFIG_INHERIT_OP_SEQ''),2) '

625:
626: -- select the in INHERIT_OPTION_CLASS_OP_SEQ profile option in source instance
627:
628: BEGIN
629: v_sql_stmt := ' select nvl(FND_PROFILE.VALUE'||MSC_CL_PULL.v_dblink||'(''BOM:CONFIG_INHERIT_OP_SEQ''),2) '
630: ||' from dual';
631: execute immediate v_sql_stmt into lv_profile_inherit_op_seq;
632: EXCEPTION
633: WHEN OTHERS THEN

Line 644: IF MSC_CL_PULL.VENDOR_ENABLED= MSC_UTIL.SYS_YES THEN

640: ELSE
641: v_temp_tp_sql := ' AND x.LAST_UPDATE_DATE > SYSDATE - :v_msc_tp_coll_window';
642: END IF;
643:
644: IF MSC_CL_PULL.VENDOR_ENABLED= MSC_UTIL.SYS_YES THEN
645:
646: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
647: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDORS_V';
648:

Line 646: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';

642: END IF;
643:
644: IF MSC_CL_PULL.VENDOR_ENABLED= MSC_UTIL.SYS_YES THEN
645:
646: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
647: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDORS_V';
648:
649: v_sql_stmt:=
650: 'insert into MSC_ST_TRADING_PARTNERS'

Line 647: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDORS_V';

643:
644: IF MSC_CL_PULL.VENDOR_ENABLED= MSC_UTIL.SYS_YES THEN
645:
646: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
647: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDORS_V';
648:
649: v_sql_stmt:=
650: 'insert into MSC_ST_TRADING_PARTNERS'
651: ||' ( SR_TP_ID,'

Line 668: ||' from MRP_AP_VENDORS_V'||MSC_CL_PULL.v_dblink||' x'

664: ||' x.PARTNER_NUMBER,'
665: ||' 2,'
666: ||' :v_refresh_id,'
667: ||' :v_instance_id'
668: ||' from MRP_AP_VENDORS_V'||MSC_CL_PULL.v_dblink||' x'
669: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
670: ||v_temp_tp_sql;
671:
672: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

Line 669: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

665: ||' 2,'
666: ||' :v_refresh_id,'
667: ||' :v_instance_id'
668: ||' from MRP_AP_VENDORS_V'||MSC_CL_PULL.v_dblink||' x'
669: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
670: ||v_temp_tp_sql;
671:
672: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
673: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 673: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

669: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
670: ||v_temp_tp_sql;
671:
672: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
673: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
674: ELSE
675: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
676: END IF;
677:

Line 675: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;

671:
672: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
673: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
674: ELSE
675: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
676: END IF;
677:
678: COMMIT;
679:

Line 680: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';

676: END IF;
677:
678: COMMIT;
679:
680: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
681: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDOR_SITES_V';
682:
683: /* for bug: 2459612, added code to collect OPERATING_UNIT from Vendor sites for 11i source instance */
684: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

Line 681: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDOR_SITES_V';

677:
678: COMMIT;
679:
680: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
681: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDOR_SITES_V';
682:
683: /* for bug: 2459612, added code to collect OPERATING_UNIT from Vendor sites for 11i source instance */
684: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
685: v_temp_sql := ' x.OPERATING_UNIT,x.shipping_control, ';

Line 684: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

680: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
681: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDOR_SITES_V';
682:
683: /* for bug: 2459612, added code to collect OPERATING_UNIT from Vendor sites for 11i source instance */
684: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
685: v_temp_sql := ' x.OPERATING_UNIT,x.shipping_control, ';
686: ELSE
687: v_temp_sql := ' NULL,NULL,';
688: END IF;

Line 743: ||' from MRP_AP_VENDOR_SITES_V'||MSC_CL_PULL.v_dblink||' x'

739: ||' x.PROVINCE,'
740: ||' x.COUNTRY,'
741: /* SCE Change Ends */
742: ||' :v_instance_id'
743: ||' from MRP_AP_VENDOR_SITES_V'||MSC_CL_PULL.v_dblink||' x'
744: ||' WHERE (x.RN1>'||MSC_CL_PULL.v_lrn
745: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')'
746: ||v_temp_tp_sql;
747:

Line 744: ||' WHERE (x.RN1>'||MSC_CL_PULL.v_lrn

740: ||' x.COUNTRY,'
741: /* SCE Change Ends */
742: ||' :v_instance_id'
743: ||' from MRP_AP_VENDOR_SITES_V'||MSC_CL_PULL.v_dblink||' x'
744: ||' WHERE (x.RN1>'||MSC_CL_PULL.v_lrn
745: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')'
746: ||v_temp_tp_sql;
747:
748: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

Line 745: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')'

741: /* SCE Change Ends */
742: ||' :v_instance_id'
743: ||' from MRP_AP_VENDOR_SITES_V'||MSC_CL_PULL.v_dblink||' x'
744: ||' WHERE (x.RN1>'||MSC_CL_PULL.v_lrn
745: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')'
746: ||v_temp_tp_sql;
747:
748: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
749: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 749: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

745: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')'
746: ||v_temp_tp_sql;
747:
748: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
749: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
750: ELSE
751: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
752: END IF;
753:

Line 751: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;

747:
748: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
749: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
750: ELSE
751: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
752: END IF;
753:
754: COMMIT;
755:

Line 756: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh

752: END IF;
753:
754: COMMIT;
755:
756: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
757:
758: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
759: v_temp_sql := 'x.ORGANIZATION_ID, ';
760: ELSE

Line 758: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

754: COMMIT;
755:
756: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
757:
758: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
759: v_temp_sql := 'x.ORGANIZATION_ID, ';
760: ELSE
761: v_temp_sql := ' NULL, ';
762: END IF;

Line 764: MSC_CL_PULL.v_table_name:= 'MSC_ST_LOCATION_ASSOCIATIONS';

760: ELSE
761: v_temp_sql := ' NULL, ';
762: END IF;
763:
764: MSC_CL_PULL.v_table_name:= 'MSC_ST_LOCATION_ASSOCIATIONS';
765: MSC_CL_PULL.v_view_name := 'MRP_AP_LOCATION_ASSOCIATIONS_V';
766:
767: v_sql_stmt:=
768: 'INSERT INTO MSC_ST_LOCATION_ASSOCIATIONS'

Line 765: MSC_CL_PULL.v_view_name := 'MRP_AP_LOCATION_ASSOCIATIONS_V';

761: v_temp_sql := ' NULL, ';
762: END IF;
763:
764: MSC_CL_PULL.v_table_name:= 'MSC_ST_LOCATION_ASSOCIATIONS';
765: MSC_CL_PULL.v_view_name := 'MRP_AP_LOCATION_ASSOCIATIONS_V';
766:
767: v_sql_stmt:=
768: 'INSERT INTO MSC_ST_LOCATION_ASSOCIATIONS'
769: ||' ( LOCATION_ID,'

Line 786: ||' FROM MRP_AP_LOCATION_ASSOCIATIONS_V'||MSC_CL_PULL.v_dblink||' x'

782: ||' 1,'
783: || v_temp_sql
784: ||' :v_refresh_id,'
785: ||' :v_instance_id'
786: ||' FROM MRP_AP_LOCATION_ASSOCIATIONS_V'||MSC_CL_PULL.v_dblink||' x'
787: ||' WHERE x.PARTNER_TYPE= 1';
788:
789: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
790:

Line 789: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

785: ||' :v_instance_id'
786: ||' FROM MRP_AP_LOCATION_ASSOCIATIONS_V'||MSC_CL_PULL.v_dblink||' x'
787: ||' WHERE x.PARTNER_TYPE= 1';
788:
789: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
790:
791: COMMIT;
792:
793: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';

Line 793: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';

789: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
790:
791: COMMIT;
792:
793: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';
794: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDOR_CONTACTS_V';
795:
796: v_sql_stmt:=
797: 'INSERT INTO MSC_ST_PARTNER_CONTACTS'

Line 794: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDOR_CONTACTS_V';

790:
791: COMMIT;
792:
793: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';
794: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDOR_CONTACTS_V';
795:
796: v_sql_stmt:=
797: 'INSERT INTO MSC_ST_PARTNER_CONTACTS'
798: ||' ( NAME,'

Line 821: ||' FROM MRP_AP_VENDOR_CONTACTS_V'||MSC_CL_PULL.v_dblink||' x';

817: ||' ENABLED_FLAG,'
818: ||' 2,'
819: ||' :v_refresh_id,'
820: ||' :v_instance_id'
821: ||' FROM MRP_AP_VENDOR_CONTACTS_V'||MSC_CL_PULL.v_dblink||' x';
822:
823: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
824:
825: COMMIT;

Line 823: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

819: ||' :v_refresh_id,'
820: ||' :v_instance_id'
821: ||' FROM MRP_AP_VENDOR_CONTACTS_V'||MSC_CL_PULL.v_dblink||' x';
822:
823: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
824:
825: COMMIT;
826:
827: END IF; -- complete refresh

Line 829: END IF; -- MSC_CL_PULL.VENDOR_ENABLED

825: COMMIT;
826:
827: END IF; -- complete refresh
828:
829: END IF; -- MSC_CL_PULL.VENDOR_ENABLED
830:
831:
832: IF MSC_CL_PULL.CUSTOMER_ENABLED= MSC_UTIL.SYS_YES THEN
833:

Line 832: IF MSC_CL_PULL.CUSTOMER_ENABLED= MSC_UTIL.SYS_YES THEN

828:
829: END IF; -- MSC_CL_PULL.VENDOR_ENABLED
830:
831:
832: IF MSC_CL_PULL.CUSTOMER_ENABLED= MSC_UTIL.SYS_YES THEN
833:
834: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
835: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMERS_V';
836:

Line 834: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';

830:
831:
832: IF MSC_CL_PULL.CUSTOMER_ENABLED= MSC_UTIL.SYS_YES THEN
833:
834: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
835: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMERS_V';
836:
837: BEGIN
838:

Line 835: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMERS_V';

831:
832: IF MSC_CL_PULL.CUSTOMER_ENABLED= MSC_UTIL.SYS_YES THEN
833:
834: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
835: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMERS_V';
836:
837: BEGIN
838:
839: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

Line 839: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

835: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMERS_V';
836:
837: BEGIN
838:
839: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
840: v_temp_sql2 := ' x.AGGREGATE_DEMAND_FLAG, ';
841: ELSE
842: v_temp_sql2 := ' NULL,';
843: END IF;

Line 844: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN

840: v_temp_sql2 := ' x.AGGREGATE_DEMAND_FLAG, ';
841: ELSE
842: v_temp_sql2 := ' NULL,';
843: END IF;
844: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN
845: v_temp_sql1 := ' NULL,';
846: ELSE
847: v_temp_sql1 := ' x.CUSTOMER_CLASS_CODE,';
848: END IF;

Line 857: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

853: ELSE
854: v_temp_sql2 := v_temp_sql2||' NULL,';
855: END IF;
856:
857: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
858: v_temp_sql2 := v_temp_sql2 || ' x.customer_type, x.CUST_ACCOUNT_NUMBER, ';
859: ELSE
860: v_temp_sql2 := v_temp_sql2 || ' NULL, NULL, ';
861: END IF;

Line 891: ||' from MRP_AP_CUSTOMERS_V'||MSC_CL_PULL.v_dblink||' x'

887: || v_temp_sql2
888: ||' 2,'
889: ||' :v_refresh_id,'
890: ||' :v_instance_id'
891: ||' from MRP_AP_CUSTOMERS_V'||MSC_CL_PULL.v_dblink||' x'
892: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
893: ||v_temp_tp_sql;
894:
895: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

Line 892: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

888: ||' 2,'
889: ||' :v_refresh_id,'
890: ||' :v_instance_id'
891: ||' from MRP_AP_CUSTOMERS_V'||MSC_CL_PULL.v_dblink||' x'
892: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
893: ||v_temp_tp_sql;
894:
895: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
896: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 896: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

892: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
893: ||v_temp_tp_sql;
894:
895: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
896: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
897: ELSE
898: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
899: END IF;
900:

Line 898: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;

894:
895: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
896: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
897: ELSE
898: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
899: END IF;
900:
901: COMMIT;
902:

Line 903: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';

899: END IF;
900:
901: COMMIT;
902:
903: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
904: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMER_SITES_V';
905:
906: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
907: v_temp_sql := ' x.POSTAL_CODE, x.CITY, x.STATE, x.COUNTRY,x.LOCATION_ID,x.SHIPPING_CONTROL, ';

Line 904: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMER_SITES_V';

900:
901: COMMIT;
902:
903: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
904: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMER_SITES_V';
905:
906: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
907: v_temp_sql := ' x.POSTAL_CODE, x.CITY, x.STATE, x.COUNTRY,x.LOCATION_ID,x.SHIPPING_CONTROL, ';
908: ELSE

Line 906: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

902:
903: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
904: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMER_SITES_V';
905:
906: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
907: v_temp_sql := ' x.POSTAL_CODE, x.CITY, x.STATE, x.COUNTRY,x.LOCATION_ID,x.SHIPPING_CONTROL, ';
908: ELSE
909: v_temp_sql := ' NULL,NULL,NULL,NULL,NULL,NULL, ';
910: END IF;

Line 965: ||' from MRP_AP_CUSTOMER_SITES_V'||MSC_CL_PULL.v_dblink||' x'

961: ||' x.COUNTY,'
962: ||' substr(x.PARTNER_SITE_NUMBER,1,30), '
963: /* SCE Change Ends */
964: ||' :v_instance_id'
965: ||' from MRP_AP_CUSTOMER_SITES_V'||MSC_CL_PULL.v_dblink||' x'
966: ||' WHERE (x.RN1>'||MSC_CL_PULL.v_lrn
967: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
968: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')'
969: ||v_temp_tp_sql;

Line 966: ||' WHERE (x.RN1>'||MSC_CL_PULL.v_lrn

962: ||' substr(x.PARTNER_SITE_NUMBER,1,30), '
963: /* SCE Change Ends */
964: ||' :v_instance_id'
965: ||' from MRP_AP_CUSTOMER_SITES_V'||MSC_CL_PULL.v_dblink||' x'
966: ||' WHERE (x.RN1>'||MSC_CL_PULL.v_lrn
967: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
968: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')'
969: ||v_temp_tp_sql;
970:

Line 967: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

963: /* SCE Change Ends */
964: ||' :v_instance_id'
965: ||' from MRP_AP_CUSTOMER_SITES_V'||MSC_CL_PULL.v_dblink||' x'
966: ||' WHERE (x.RN1>'||MSC_CL_PULL.v_lrn
967: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
968: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')'
969: ||v_temp_tp_sql;
970:
971: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

Line 968: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')'

964: ||' :v_instance_id'
965: ||' from MRP_AP_CUSTOMER_SITES_V'||MSC_CL_PULL.v_dblink||' x'
966: ||' WHERE (x.RN1>'||MSC_CL_PULL.v_lrn
967: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
968: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')'
969: ||v_temp_tp_sql;
970:
971: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
972: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 972: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

968: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')'
969: ||v_temp_tp_sql;
970:
971: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
972: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
973: ELSE
974: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
975: END IF;
976:

Line 974: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;

970:
971: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
972: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
973: ELSE
974: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
975: END IF;
976:
977: COMMIT;
978:

Line 979: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh

975: END IF;
976:
977: COMMIT;
978:
979: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
980:
981: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
982: v_temp_sql := 'x.ORGANIZATION_ID, ';
983: ELSE

Line 981: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

977: COMMIT;
978:
979: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
980:
981: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
982: v_temp_sql := 'x.ORGANIZATION_ID, ';
983: ELSE
984: v_temp_sql := ' NULL, ';
985: END IF;

Line 987: MSC_CL_PULL.v_table_name:= 'MSC_ST_LOCATION_ASSOCIATIONS';

983: ELSE
984: v_temp_sql := ' NULL, ';
985: END IF;
986:
987: MSC_CL_PULL.v_table_name:= 'MSC_ST_LOCATION_ASSOCIATIONS';
988: MSC_CL_PULL.v_view_name := 'MRP_AP_LOCATION_ASSOCIATIONS_V';
989:
990: v_sql_stmt:=
991: 'INSERT INTO MSC_ST_LOCATION_ASSOCIATIONS'

Line 988: MSC_CL_PULL.v_view_name := 'MRP_AP_LOCATION_ASSOCIATIONS_V';

984: v_temp_sql := ' NULL, ';
985: END IF;
986:
987: MSC_CL_PULL.v_table_name:= 'MSC_ST_LOCATION_ASSOCIATIONS';
988: MSC_CL_PULL.v_view_name := 'MRP_AP_LOCATION_ASSOCIATIONS_V';
989:
990: v_sql_stmt:=
991: 'INSERT INTO MSC_ST_LOCATION_ASSOCIATIONS'
992: ||' ( LOCATION_ID,'

Line 1009: ||' FROM MRP_AP_LOCATION_ASSOCIATIONS_V'||MSC_CL_PULL.v_dblink||' x'

1005: ||' 2,'
1006: || v_temp_sql
1007: ||' :v_refresh_id,'
1008: ||' :v_instance_id'
1009: ||' FROM MRP_AP_LOCATION_ASSOCIATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1010: ||' WHERE x.PARTNER_TYPE= 2';
1011:
1012: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1013:

Line 1012: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1008: ||' :v_instance_id'
1009: ||' FROM MRP_AP_LOCATION_ASSOCIATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1010: ||' WHERE x.PARTNER_TYPE= 2';
1011:
1012: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1013:
1014: COMMIT;
1015:
1016: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';

Line 1016: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';

1012: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1013:
1014: COMMIT;
1015:
1016: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';
1017: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMER_CONTACTS_V';
1018:
1019: v_sql_stmt:=
1020: 'INSERT INTO MSC_ST_PARTNER_CONTACTS'

Line 1017: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMER_CONTACTS_V';

1013:
1014: COMMIT;
1015:
1016: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';
1017: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMER_CONTACTS_V';
1018:
1019: v_sql_stmt:=
1020: 'INSERT INTO MSC_ST_PARTNER_CONTACTS'
1021: ||' ( NAME,'

Line 1044: ||' FROM MRP_AP_CUSTOMER_CONTACTS_V'||MSC_CL_PULL.v_dblink||' x';

1040: ||' ENABLED_FLAG,'
1041: ||' 2,'
1042: ||' :v_refresh_id,'
1043: ||' :v_instance_id'
1044: ||' FROM MRP_AP_CUSTOMER_CONTACTS_V'||MSC_CL_PULL.v_dblink||' x';
1045:
1046: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1047:
1048: COMMIT;

Line 1046: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1042: ||' :v_refresh_id,'
1043: ||' :v_instance_id'
1044: ||' FROM MRP_AP_CUSTOMER_CONTACTS_V'||MSC_CL_PULL.v_dblink||' x';
1045:
1046: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1047:
1048: COMMIT;
1049:
1050: END IF; -- complete refresh

Line 1054: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';

1050: END IF; -- complete refresh
1051:
1052: END IF; -- CUSTOMER ENABLED
1053:
1054: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
1055: MSC_CL_PULL.v_view_name := 'MRP_AP_ORGANIZATIONS_V';
1056:
1057: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1058: v_temp_sql:= 'x.BUSINESS_GROUP_ID,x.LEGAL_ENTITY, x.SET_OF_BOOKS_ID, x.CHART_OF_ACCOUNTS_ID, x.BUSINESS_GROUP_NAME,x.LEGAL_ENTITY_NAME, x.OPERATING_UNIT_NAME, ';

Line 1055: MSC_CL_PULL.v_view_name := 'MRP_AP_ORGANIZATIONS_V';

1051:
1052: END IF; -- CUSTOMER ENABLED
1053:
1054: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
1055: MSC_CL_PULL.v_view_name := 'MRP_AP_ORGANIZATIONS_V';
1056:
1057: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1058: v_temp_sql:= 'x.BUSINESS_GROUP_ID,x.LEGAL_ENTITY, x.SET_OF_BOOKS_ID, x.CHART_OF_ACCOUNTS_ID, x.BUSINESS_GROUP_NAME,x.LEGAL_ENTITY_NAME, x.OPERATING_UNIT_NAME, ';
1059: ELSE

Line 1057: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1053:
1054: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
1055: MSC_CL_PULL.v_view_name := 'MRP_AP_ORGANIZATIONS_V';
1056:
1057: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1058: v_temp_sql:= 'x.BUSINESS_GROUP_ID,x.LEGAL_ENTITY, x.SET_OF_BOOKS_ID, x.CHART_OF_ACCOUNTS_ID, x.BUSINESS_GROUP_NAME,x.LEGAL_ENTITY_NAME, x.OPERATING_UNIT_NAME, ';
1059: ELSE
1060: v_temp_sql := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1061: END IF;

Line 1205: ||' from MRP_AP_ORGANIZATIONS_V'||MSC_CL_PULL.v_dblink||' x'

1201: ||' 2,'
1202: ||' :v_refresh_id,'
1203: ||' :v_instance_id,'
1204: ||' :lv_profile_inherit_op_seq'
1205: ||' from MRP_AP_ORGANIZATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1206: ||' where NVL( x.LANGUAGE, :v_lang)= :v_lang'
1207: ||' AND x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1208: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
1209: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

Line 1208: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn

1204: ||' :lv_profile_inherit_op_seq'
1205: ||' from MRP_AP_ORGANIZATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1206: ||' where NVL( x.LANGUAGE, :v_lang)= :v_lang'
1207: ||' AND x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1208: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
1209: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1210: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1211:
1212: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,

Line 1209: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

1205: ||' from MRP_AP_ORGANIZATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1206: ||' where NVL( x.LANGUAGE, :v_lang)= :v_lang'
1207: ||' AND x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1208: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
1209: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1210: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1211:
1212: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1213: MSC_CL_PULL.V_ICODE,

Line 1210: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';

1206: ||' where NVL( x.LANGUAGE, :v_lang)= :v_lang'
1207: ||' AND x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1208: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
1209: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1210: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1211:
1212: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1213: MSC_CL_PULL.V_ICODE,
1214: MSC_CL_PULL.V_ICODE,

Line 1212: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,

1208: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
1209: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1210: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1211:
1212: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1213: MSC_CL_PULL.V_ICODE,
1214: MSC_CL_PULL.V_ICODE,
1215: MSC_CL_PULL.v_mso_org_dmd_penalty,
1216: MSC_CL_PULL.v_mso_org_item_penalty,

Line 1213: MSC_CL_PULL.V_ICODE,

1209: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1210: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1211:
1212: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1213: MSC_CL_PULL.V_ICODE,
1214: MSC_CL_PULL.V_ICODE,
1215: MSC_CL_PULL.v_mso_org_dmd_penalty,
1216: MSC_CL_PULL.v_mso_org_item_penalty,
1217: MSC_CL_PULL.v_mso_org_res_penalty,

Line 1214: MSC_CL_PULL.V_ICODE,

1210: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1211:
1212: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1213: MSC_CL_PULL.V_ICODE,
1214: MSC_CL_PULL.V_ICODE,
1215: MSC_CL_PULL.v_mso_org_dmd_penalty,
1216: MSC_CL_PULL.v_mso_org_item_penalty,
1217: MSC_CL_PULL.v_mso_org_res_penalty,
1218: MSC_CL_PULL.v_mso_org_trsp_penalty,

Line 1215: MSC_CL_PULL.v_mso_org_dmd_penalty,

1211:
1212: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1213: MSC_CL_PULL.V_ICODE,
1214: MSC_CL_PULL.V_ICODE,
1215: MSC_CL_PULL.v_mso_org_dmd_penalty,
1216: MSC_CL_PULL.v_mso_org_item_penalty,
1217: MSC_CL_PULL.v_mso_org_res_penalty,
1218: MSC_CL_PULL.v_mso_org_trsp_penalty,
1219: MSC_CL_PULL.v_refresh_id,

Line 1216: MSC_CL_PULL.v_mso_org_item_penalty,

1212: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1213: MSC_CL_PULL.V_ICODE,
1214: MSC_CL_PULL.V_ICODE,
1215: MSC_CL_PULL.v_mso_org_dmd_penalty,
1216: MSC_CL_PULL.v_mso_org_item_penalty,
1217: MSC_CL_PULL.v_mso_org_res_penalty,
1218: MSC_CL_PULL.v_mso_org_trsp_penalty,
1219: MSC_CL_PULL.v_refresh_id,
1220: MSC_CL_PULL.v_instance_id,

Line 1217: MSC_CL_PULL.v_mso_org_res_penalty,

1213: MSC_CL_PULL.V_ICODE,
1214: MSC_CL_PULL.V_ICODE,
1215: MSC_CL_PULL.v_mso_org_dmd_penalty,
1216: MSC_CL_PULL.v_mso_org_item_penalty,
1217: MSC_CL_PULL.v_mso_org_res_penalty,
1218: MSC_CL_PULL.v_mso_org_trsp_penalty,
1219: MSC_CL_PULL.v_refresh_id,
1220: MSC_CL_PULL.v_instance_id,
1221: lv_profile_inherit_op_seq,

Line 1218: MSC_CL_PULL.v_mso_org_trsp_penalty,

1214: MSC_CL_PULL.V_ICODE,
1215: MSC_CL_PULL.v_mso_org_dmd_penalty,
1216: MSC_CL_PULL.v_mso_org_item_penalty,
1217: MSC_CL_PULL.v_mso_org_res_penalty,
1218: MSC_CL_PULL.v_mso_org_trsp_penalty,
1219: MSC_CL_PULL.v_refresh_id,
1220: MSC_CL_PULL.v_instance_id,
1221: lv_profile_inherit_op_seq,
1222: MSC_CL_PULL.v_lang,

Line 1219: MSC_CL_PULL.v_refresh_id,

1215: MSC_CL_PULL.v_mso_org_dmd_penalty,
1216: MSC_CL_PULL.v_mso_org_item_penalty,
1217: MSC_CL_PULL.v_mso_org_res_penalty,
1218: MSC_CL_PULL.v_mso_org_trsp_penalty,
1219: MSC_CL_PULL.v_refresh_id,
1220: MSC_CL_PULL.v_instance_id,
1221: lv_profile_inherit_op_seq,
1222: MSC_CL_PULL.v_lang,
1223: MSC_CL_PULL.v_lang;

Line 1220: MSC_CL_PULL.v_instance_id,

1216: MSC_CL_PULL.v_mso_org_item_penalty,
1217: MSC_CL_PULL.v_mso_org_res_penalty,
1218: MSC_CL_PULL.v_mso_org_trsp_penalty,
1219: MSC_CL_PULL.v_refresh_id,
1220: MSC_CL_PULL.v_instance_id,
1221: lv_profile_inherit_op_seq,
1222: MSC_CL_PULL.v_lang,
1223: MSC_CL_PULL.v_lang;
1224:

Line 1222: MSC_CL_PULL.v_lang,

1218: MSC_CL_PULL.v_mso_org_trsp_penalty,
1219: MSC_CL_PULL.v_refresh_id,
1220: MSC_CL_PULL.v_instance_id,
1221: lv_profile_inherit_op_seq,
1222: MSC_CL_PULL.v_lang,
1223: MSC_CL_PULL.v_lang;
1224:
1225: COMMIT;
1226:

Line 1223: MSC_CL_PULL.v_lang;

1219: MSC_CL_PULL.v_refresh_id,
1220: MSC_CL_PULL.v_instance_id,
1221: lv_profile_inherit_op_seq,
1222: MSC_CL_PULL.v_lang,
1223: MSC_CL_PULL.v_lang;
1224:
1225: COMMIT;
1226:
1227: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';

Line 1227: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';

1223: MSC_CL_PULL.v_lang;
1224:
1225: COMMIT;
1226:
1227: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
1228: MSC_CL_PULL.v_view_name := 'MRP_AP_ORGANIZATION_SITES_V';
1229:
1230: /* For bug: 2564735 , added substr for 60 chars on the columns COUNTY and STATE becos these columns
1231: are of higher size in the views */

Line 1228: MSC_CL_PULL.v_view_name := 'MRP_AP_ORGANIZATION_SITES_V';

1224:
1225: COMMIT;
1226:
1227: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
1228: MSC_CL_PULL.v_view_name := 'MRP_AP_ORGANIZATION_SITES_V';
1229:
1230: /* For bug: 2564735 , added substr for 60 chars on the columns COUNTY and STATE becos these columns
1231: are of higher size in the views */
1232: v_sql_stmt:=

Line 1275: ||' from MRP_AP_ORGANIZATION_SITES_V'||MSC_CL_PULL.v_dblink||' x'

1271: ||' x.PARTNER_TYPE,'
1272: ||' 2,'
1273: ||' :v_refresh_id,'
1274: ||' :v_instance_id'
1275: ||' from MRP_AP_ORGANIZATION_SITES_V'||MSC_CL_PULL.v_dblink||' x'
1276: ||' WHERE x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1277: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1278: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1279: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';

Line 1277: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn

1273: ||' :v_refresh_id,'
1274: ||' :v_instance_id'
1275: ||' from MRP_AP_ORGANIZATION_SITES_V'||MSC_CL_PULL.v_dblink||' x'
1276: ||' WHERE x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1277: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1278: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1279: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1280:
1281: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1278: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

1274: ||' :v_instance_id'
1275: ||' from MRP_AP_ORGANIZATION_SITES_V'||MSC_CL_PULL.v_dblink||' x'
1276: ||' WHERE x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1277: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1278: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1279: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1280:
1281: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1282:

Line 1279: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';

1275: ||' from MRP_AP_ORGANIZATION_SITES_V'||MSC_CL_PULL.v_dblink||' x'
1276: ||' WHERE x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1277: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1278: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1279: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1280:
1281: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1282:
1283: COMMIT;

Line 1281: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1277: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1278: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1279: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1280:
1281: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1282:
1283: COMMIT;
1284:
1285: /* added this fix for bug # 2198339 to collect location associations for the Orgs */

Line 1286: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete,targeted refresh

1282:
1283: COMMIT;
1284:
1285: /* added this fix for bug # 2198339 to collect location associations for the Orgs */
1286: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete,targeted refresh
1287:
1288: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1289: v_temp_sql := 'x.ORGANIZATION_ID, ';
1290: ELSE

Line 1288: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1284:
1285: /* added this fix for bug # 2198339 to collect location associations for the Orgs */
1286: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete,targeted refresh
1287:
1288: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1289: v_temp_sql := 'x.ORGANIZATION_ID, ';
1290: ELSE
1291: v_temp_sql := ' NULL, ';
1292: END IF;

Line 1294: MSC_CL_PULL.v_table_name:= 'MSC_ST_LOCATION_ASSOCIATIONS';

1290: ELSE
1291: v_temp_sql := ' NULL, ';
1292: END IF;
1293:
1294: MSC_CL_PULL.v_table_name:= 'MSC_ST_LOCATION_ASSOCIATIONS';
1295: MSC_CL_PULL.v_view_name := 'MRP_AP_LOCATION_ASSOCIATIONS_V';
1296:
1297: v_sql_stmt:=
1298: 'INSERT INTO MSC_ST_LOCATION_ASSOCIATIONS'

Line 1295: MSC_CL_PULL.v_view_name := 'MRP_AP_LOCATION_ASSOCIATIONS_V';

1291: v_temp_sql := ' NULL, ';
1292: END IF;
1293:
1294: MSC_CL_PULL.v_table_name:= 'MSC_ST_LOCATION_ASSOCIATIONS';
1295: MSC_CL_PULL.v_view_name := 'MRP_AP_LOCATION_ASSOCIATIONS_V';
1296:
1297: v_sql_stmt:=
1298: 'INSERT INTO MSC_ST_LOCATION_ASSOCIATIONS'
1299: ||' ( LOCATION_ID,'

Line 1316: ||' FROM MRP_AP_LOCATION_ASSOCIATIONS_V'||MSC_CL_PULL.v_dblink||' x'

1312: ||' 3,'
1313: || v_temp_sql
1314: ||' :v_refresh_id,'
1315: ||' :v_instance_id'
1316: ||' FROM MRP_AP_LOCATION_ASSOCIATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1317: ||' WHERE x.PARTNER_TYPE= 3';
1318:
1319: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1320:

Line 1319: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1315: ||' :v_instance_id'
1316: ||' FROM MRP_AP_LOCATION_ASSOCIATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1317: ||' WHERE x.PARTNER_TYPE= 3';
1318:
1319: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1320:
1321: END IF; -- complete refresh
1322:
1323: COMMIT;

Line 1333: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh

1329:
1330: PROCEDURE LOAD_PARAMETER IS
1331: BEGIN
1332:
1333: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
1334:
1335: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARAMETERS';
1336: MSC_CL_PULL.v_view_name := 'MRP_AP_PARAMETERS_V';
1337:

Line 1335: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARAMETERS';

1331: BEGIN
1332:
1333: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
1334:
1335: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARAMETERS';
1336: MSC_CL_PULL.v_view_name := 'MRP_AP_PARAMETERS_V';
1337:
1338: v_sql_stmt:=
1339: ' insert into MSC_ST_PARAMETERS'

Line 1336: MSC_CL_PULL.v_view_name := 'MRP_AP_PARAMETERS_V';

1332:
1333: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
1334:
1335: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARAMETERS';
1336: MSC_CL_PULL.v_view_name := 'MRP_AP_PARAMETERS_V';
1337:
1338: v_sql_stmt:=
1339: ' insert into MSC_ST_PARAMETERS'
1340: ||' ( ORGANIZATION_ID,'

Line 1391: ||' from MRP_AP_PARAMETERS_V'||MSC_CL_PULL.v_dblink||' x'

1387: ||' x.REPETITIVE_ANCHOR_DATE,'
1388: ||' 2,'
1389: ||' :v_refresh_id,'
1390: ||' :v_instance_id'
1391: ||' from MRP_AP_PARAMETERS_V'||MSC_CL_PULL.v_dblink||' x'
1392: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1393:
1394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1395:

Line 1394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1390: ||' :v_instance_id'
1391: ||' from MRP_AP_PARAMETERS_V'||MSC_CL_PULL.v_dblink||' x'
1392: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1393:
1394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1395:
1396: COMMIT;
1397:
1398: END IF;

Line 1407: IF MSC_CL_PULL.UOM_ENABLED= MSC_UTIL.SYS_YES THEN

1403:
1404: PROCEDURE LOAD_UOM IS
1405: BEGIN
1406:
1407: IF MSC_CL_PULL.UOM_ENABLED= MSC_UTIL.SYS_YES THEN
1408:
1409: MSC_CL_PULL.v_table_name:= 'MSC_ST_UNITS_OF_MEASURE';
1410: MSC_CL_PULL.v_view_name := 'MRP_AP_UNITS_OF_MEASURE_V';
1411:

Line 1409: MSC_CL_PULL.v_table_name:= 'MSC_ST_UNITS_OF_MEASURE';

1405: BEGIN
1406:
1407: IF MSC_CL_PULL.UOM_ENABLED= MSC_UTIL.SYS_YES THEN
1408:
1409: MSC_CL_PULL.v_table_name:= 'MSC_ST_UNITS_OF_MEASURE';
1410: MSC_CL_PULL.v_view_name := 'MRP_AP_UNITS_OF_MEASURE_V';
1411:
1412: v_sql_stmt:=
1413: ' insert into MSC_ST_UNITS_OF_MEASURE'

Line 1410: MSC_CL_PULL.v_view_name := 'MRP_AP_UNITS_OF_MEASURE_V';

1406:
1407: IF MSC_CL_PULL.UOM_ENABLED= MSC_UTIL.SYS_YES THEN
1408:
1409: MSC_CL_PULL.v_table_name:= 'MSC_ST_UNITS_OF_MEASURE';
1410: MSC_CL_PULL.v_view_name := 'MRP_AP_UNITS_OF_MEASURE_V';
1411:
1412: v_sql_stmt:=
1413: ' insert into MSC_ST_UNITS_OF_MEASURE'
1414: ||' ( UNIT_OF_MEASURE,'

Line 1433: ||' from MRP_AP_UNITS_OF_MEASURE_V'||MSC_CL_PULL.v_dblink||' x'

1429: ||' x.DESCRIPTION,'
1430: ||' 2,'
1431: ||' :v_refresh_id,'
1432: ||' :v_instance_id'
1433: ||' from MRP_AP_UNITS_OF_MEASURE_V'||MSC_CL_PULL.v_dblink||' x'
1434: ||' where NVL(x.LANGUAGE, :v_lang)= :v_lang'
1435: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
1436:
1437: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lang, MSC_CL_PULL.v_lang;

Line 1435: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;

1431: ||' :v_refresh_id,'
1432: ||' :v_instance_id'
1433: ||' from MRP_AP_UNITS_OF_MEASURE_V'||MSC_CL_PULL.v_dblink||' x'
1434: ||' where NVL(x.LANGUAGE, :v_lang)= :v_lang'
1435: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
1436:
1437: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lang, MSC_CL_PULL.v_lang;
1438:
1439: /* Removed the forked code for 11i source as the column LANGUAGE is again added in

Line 1437: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lang, MSC_CL_PULL.v_lang;

1433: ||' from MRP_AP_UNITS_OF_MEASURE_V'||MSC_CL_PULL.v_dblink||' x'
1434: ||' where NVL(x.LANGUAGE, :v_lang)= :v_lang'
1435: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
1436:
1437: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lang, MSC_CL_PULL.v_lang;
1438:
1439: /* Removed the forked code for 11i source as the column LANGUAGE is again added in
1440: the view mtl_units_of_measures_vl by the Oracle Inventory team
1441: */

Line 1445: MSC_CL_PULL.v_table_name:= 'MSC_ST_UOM_CLASS_CONVERSIONS';

1441: */
1442:
1443: COMMIT;
1444:
1445: MSC_CL_PULL.v_table_name:= 'MSC_ST_UOM_CLASS_CONVERSIONS';
1446: MSC_CL_PULL.v_view_name := 'MRP_AP_UOM_CLASS_CONVERSIONS_V';
1447:
1448: v_sql_stmt:=
1449: ' insert into MSC_ST_UOM_CLASS_CONVERSIONS'

Line 1446: MSC_CL_PULL.v_view_name := 'MRP_AP_UOM_CLASS_CONVERSIONS_V';

1442:
1443: COMMIT;
1444:
1445: MSC_CL_PULL.v_table_name:= 'MSC_ST_UOM_CLASS_CONVERSIONS';
1446: MSC_CL_PULL.v_view_name := 'MRP_AP_UOM_CLASS_CONVERSIONS_V';
1447:
1448: v_sql_stmt:=
1449: ' insert into MSC_ST_UOM_CLASS_CONVERSIONS'
1450: ||' ( INVENTORY_ITEM_ID,'

Line 1475: ||' from MRP_AP_UOM_CLASS_CONVERSIONS_V'||MSC_CL_PULL.v_dblink||' x'

1471: ||' x.DISABLE_DATE- :v_dgmt,'
1472: ||' 2,'
1473: ||' :v_refresh_id,'
1474: ||' :v_instance_id'
1475: ||' from MRP_AP_UOM_CLASS_CONVERSIONS_V'||MSC_CL_PULL.v_dblink||' x'
1476: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
1477: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1478: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
1479:

Line 1476: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

1472: ||' 2,'
1473: ||' :v_refresh_id,'
1474: ||' :v_instance_id'
1475: ||' from MRP_AP_UOM_CLASS_CONVERSIONS_V'||MSC_CL_PULL.v_dblink||' x'
1476: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
1477: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1478: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
1479:
1480: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1477: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

1473: ||' :v_refresh_id,'
1474: ||' :v_instance_id'
1475: ||' from MRP_AP_UOM_CLASS_CONVERSIONS_V'||MSC_CL_PULL.v_dblink||' x'
1476: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
1477: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1478: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
1479:
1480: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1481:

Line 1478: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;

1474: ||' :v_instance_id'
1475: ||' from MRP_AP_UOM_CLASS_CONVERSIONS_V'||MSC_CL_PULL.v_dblink||' x'
1476: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
1477: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1478: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
1479:
1480: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1481:
1482: COMMIT;

Line 1480: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1476: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
1477: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1478: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
1479:
1480: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1481:
1482: COMMIT;
1483:
1484: MSC_CL_PULL.v_table_name:= 'MSC_ST_UOM_CONVERSIONS';

Line 1484: MSC_CL_PULL.v_table_name:= 'MSC_ST_UOM_CONVERSIONS';

1480: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1481:
1482: COMMIT;
1483:
1484: MSC_CL_PULL.v_table_name:= 'MSC_ST_UOM_CONVERSIONS';
1485: MSC_CL_PULL.v_view_name := 'MRP_AP_UOM_CONVERSIONS_V';
1486:
1487: v_sql_stmt:=
1488: ' insert into MSC_ST_UOM_CONVERSIONS'

Line 1485: MSC_CL_PULL.v_view_name := 'MRP_AP_UOM_CONVERSIONS_V';

1481:
1482: COMMIT;
1483:
1484: MSC_CL_PULL.v_table_name:= 'MSC_ST_UOM_CONVERSIONS';
1485: MSC_CL_PULL.v_view_name := 'MRP_AP_UOM_CONVERSIONS_V';
1486:
1487: v_sql_stmt:=
1488: ' insert into MSC_ST_UOM_CONVERSIONS'
1489: ||' ( UNIT_OF_MEASURE,'

Line 1510: ||' from MRP_AP_UOM_CONVERSIONS_V'||MSC_CL_PULL.v_dblink||' x'

1506: ||' DISABLE_DATE,'
1507: ||' 2,'
1508: ||' :v_refresh_id,'
1509: ||' :v_instance_id'
1510: ||' from MRP_AP_UOM_CONVERSIONS_V'||MSC_CL_PULL.v_dblink||' x'
1511: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
1512: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1513: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
1514:

Line 1511: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn

1507: ||' 2,'
1508: ||' :v_refresh_id,'
1509: ||' :v_instance_id'
1510: ||' from MRP_AP_UOM_CONVERSIONS_V'||MSC_CL_PULL.v_dblink||' x'
1511: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
1512: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1513: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
1514:
1515: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1512: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

1508: ||' :v_refresh_id,'
1509: ||' :v_instance_id'
1510: ||' from MRP_AP_UOM_CONVERSIONS_V'||MSC_CL_PULL.v_dblink||' x'
1511: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
1512: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1513: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
1514:
1515: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1516:

Line 1513: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;

1509: ||' :v_instance_id'
1510: ||' from MRP_AP_UOM_CONVERSIONS_V'||MSC_CL_PULL.v_dblink||' x'
1511: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
1512: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1513: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
1514:
1515: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1516:
1517: COMMIT;

Line 1515: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1511: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
1512: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1513: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn;
1514:
1515: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1516:
1517: COMMIT;
1518:
1519: END IF;