APPS.XNP_SV_ORDERS$SOA_SV dependencies on XNP_WSGL

Line 38: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);

34: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
35: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
36: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
37: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
38: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
39: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
40: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
41: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
42: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';

Line 39: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);

35: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
36: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
37: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
38: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
39: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
40: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
41: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
42: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
43: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';

Line 40: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);

36: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
37: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
38: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
39: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
40: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
41: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
42: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
43: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
44: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';

Line 164: D_SUBSCRIPTION_TYPE XNP_WSGL.typDVRecord;

160: NBT_VAL NBT_REC;
161:
162: ZONE_SQL VARCHAR2(7600) := null;
163:
164: D_SUBSCRIPTION_TYPE XNP_WSGL.typDVRecord;
165: D_STATUS_PHASE XNP_WSGL.typDVRecord;
166: D_ORDER_PRIORITY XNP_WSGL.typDVRecord;
167: D_NEW_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
168: D_OLD_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;

Line 165: D_STATUS_PHASE XNP_WSGL.typDVRecord;

161:
162: ZONE_SQL VARCHAR2(7600) := null;
163:
164: D_SUBSCRIPTION_TYPE XNP_WSGL.typDVRecord;
165: D_STATUS_PHASE XNP_WSGL.typDVRecord;
166: D_ORDER_PRIORITY XNP_WSGL.typDVRecord;
167: D_NEW_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
168: D_OLD_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
169: D_RETAIN_DIR_INFO_FLAG XNP_WSGL.typDVRecord;

Line 166: D_ORDER_PRIORITY XNP_WSGL.typDVRecord;

162: ZONE_SQL VARCHAR2(7600) := null;
163:
164: D_SUBSCRIPTION_TYPE XNP_WSGL.typDVRecord;
165: D_STATUS_PHASE XNP_WSGL.typDVRecord;
166: D_ORDER_PRIORITY XNP_WSGL.typDVRecord;
167: D_NEW_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
168: D_OLD_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
169: D_RETAIN_DIR_INFO_FLAG XNP_WSGL.typDVRecord;
170: D_LOCKED_FLAG XNP_WSGL.typDVRecord;

Line 167: D_NEW_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;

163:
164: D_SUBSCRIPTION_TYPE XNP_WSGL.typDVRecord;
165: D_STATUS_PHASE XNP_WSGL.typDVRecord;
166: D_ORDER_PRIORITY XNP_WSGL.typDVRecord;
167: D_NEW_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
168: D_OLD_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
169: D_RETAIN_DIR_INFO_FLAG XNP_WSGL.typDVRecord;
170: D_LOCKED_FLAG XNP_WSGL.typDVRecord;
171: D_CONCURRENCE_FLAG XNP_WSGL.typDVRecord;

Line 168: D_OLD_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;

164: D_SUBSCRIPTION_TYPE XNP_WSGL.typDVRecord;
165: D_STATUS_PHASE XNP_WSGL.typDVRecord;
166: D_ORDER_PRIORITY XNP_WSGL.typDVRecord;
167: D_NEW_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
168: D_OLD_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
169: D_RETAIN_DIR_INFO_FLAG XNP_WSGL.typDVRecord;
170: D_LOCKED_FLAG XNP_WSGL.typDVRecord;
171: D_CONCURRENCE_FLAG XNP_WSGL.typDVRecord;
172: D_PTO_FLAG XNP_WSGL.typDVRecord;

Line 169: D_RETAIN_DIR_INFO_FLAG XNP_WSGL.typDVRecord;

165: D_STATUS_PHASE XNP_WSGL.typDVRecord;
166: D_ORDER_PRIORITY XNP_WSGL.typDVRecord;
167: D_NEW_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
168: D_OLD_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
169: D_RETAIN_DIR_INFO_FLAG XNP_WSGL.typDVRecord;
170: D_LOCKED_FLAG XNP_WSGL.typDVRecord;
171: D_CONCURRENCE_FLAG XNP_WSGL.typDVRecord;
172: D_PTO_FLAG XNP_WSGL.typDVRecord;
173: D_RETAIN_TN_FLAG XNP_WSGL.typDVRecord;

Line 170: D_LOCKED_FLAG XNP_WSGL.typDVRecord;

166: D_ORDER_PRIORITY XNP_WSGL.typDVRecord;
167: D_NEW_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
168: D_OLD_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
169: D_RETAIN_DIR_INFO_FLAG XNP_WSGL.typDVRecord;
170: D_LOCKED_FLAG XNP_WSGL.typDVRecord;
171: D_CONCURRENCE_FLAG XNP_WSGL.typDVRecord;
172: D_PTO_FLAG XNP_WSGL.typDVRecord;
173: D_RETAIN_TN_FLAG XNP_WSGL.typDVRecord;
174: D_BLOCKED_FLAG XNP_WSGL.typDVRecord;

Line 171: D_CONCURRENCE_FLAG XNP_WSGL.typDVRecord;

167: D_NEW_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
168: D_OLD_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
169: D_RETAIN_DIR_INFO_FLAG XNP_WSGL.typDVRecord;
170: D_LOCKED_FLAG XNP_WSGL.typDVRecord;
171: D_CONCURRENCE_FLAG XNP_WSGL.typDVRecord;
172: D_PTO_FLAG XNP_WSGL.typDVRecord;
173: D_RETAIN_TN_FLAG XNP_WSGL.typDVRecord;
174: D_BLOCKED_FLAG XNP_WSGL.typDVRecord;
175: --------------------------------------------------------------------------------

Line 172: D_PTO_FLAG XNP_WSGL.typDVRecord;

168: D_OLD_SP_AUTHORIZATION_FLAG XNP_WSGL.typDVRecord;
169: D_RETAIN_DIR_INFO_FLAG XNP_WSGL.typDVRecord;
170: D_LOCKED_FLAG XNP_WSGL.typDVRecord;
171: D_CONCURRENCE_FLAG XNP_WSGL.typDVRecord;
172: D_PTO_FLAG XNP_WSGL.typDVRecord;
173: D_RETAIN_TN_FLAG XNP_WSGL.typDVRecord;
174: D_BLOCKED_FLAG XNP_WSGL.typDVRecord;
175: --------------------------------------------------------------------------------
176: -- Name: xnp_sv_orders$soa_sv.InitialiseDomain

Line 173: D_RETAIN_TN_FLAG XNP_WSGL.typDVRecord;

169: D_RETAIN_DIR_INFO_FLAG XNP_WSGL.typDVRecord;
170: D_LOCKED_FLAG XNP_WSGL.typDVRecord;
171: D_CONCURRENCE_FLAG XNP_WSGL.typDVRecord;
172: D_PTO_FLAG XNP_WSGL.typDVRecord;
173: D_RETAIN_TN_FLAG XNP_WSGL.typDVRecord;
174: D_BLOCKED_FLAG XNP_WSGL.typDVRecord;
175: --------------------------------------------------------------------------------
176: -- Name: xnp_sv_orders$soa_sv.InitialiseDomain
177: --

Line 174: D_BLOCKED_FLAG XNP_WSGL.typDVRecord;

170: D_LOCKED_FLAG XNP_WSGL.typDVRecord;
171: D_CONCURRENCE_FLAG XNP_WSGL.typDVRecord;
172: D_PTO_FLAG XNP_WSGL.typDVRecord;
173: D_RETAIN_TN_FLAG XNP_WSGL.typDVRecord;
174: D_BLOCKED_FLAG XNP_WSGL.typDVRecord;
175: --------------------------------------------------------------------------------
176: -- Name: xnp_sv_orders$soa_sv.InitialiseDomain
177: --
178: -- Description: Initialises the Domain Record for the given Column Usage

Line 188: D_SUBSCRIPTION_TYPE.ControlType := XNP_WSGL.DV_TEXT;

184: begin
185:
186: if P_ALIAS = 'SUBSCRIPTION_TYPE' and not D_SUBSCRIPTION_TYPE.Initialised then
187: D_SUBSCRIPTION_TYPE.ColAlias := 'SUBSCRIPTION_TYPE';
188: D_SUBSCRIPTION_TYPE.ControlType := XNP_WSGL.DV_TEXT;
189: D_SUBSCRIPTION_TYPE.DispWidth := 30;
190: D_SUBSCRIPTION_TYPE.DispHeight := 1;
191: D_SUBSCRIPTION_TYPE.MaxWidth := 30;
192: D_SUBSCRIPTION_TYPE.UseMeanings := True;

Line 194: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_SUBSCRIPTION_TYPE', D_SUBSCRIPTION_TYPE);

190: D_SUBSCRIPTION_TYPE.DispHeight := 1;
191: D_SUBSCRIPTION_TYPE.MaxWidth := 30;
192: D_SUBSCRIPTION_TYPE.UseMeanings := True;
193: D_SUBSCRIPTION_TYPE.ColOptional := False;
194: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_SUBSCRIPTION_TYPE', D_SUBSCRIPTION_TYPE);
195: D_SUBSCRIPTION_TYPE.Initialised := True;
196: end if;
197:
198: if P_ALIAS = 'STATUS_PHASE' and not D_STATUS_PHASE.Initialised then

Line 200: D_STATUS_PHASE.ControlType := XNP_WSGL.DV_TEXT;

196: end if;
197:
198: if P_ALIAS = 'STATUS_PHASE' and not D_STATUS_PHASE.Initialised then
199: D_STATUS_PHASE.ColAlias := 'STATUS_PHASE';
200: D_STATUS_PHASE.ControlType := XNP_WSGL.DV_TEXT;
201: D_STATUS_PHASE.DispWidth := 10;
202: D_STATUS_PHASE.DispHeight := 1;
203: D_STATUS_PHASE.MaxWidth := 20;
204: D_STATUS_PHASE.UseMeanings := False;

Line 206: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_PHASE_INDICATOR', D_STATUS_PHASE);

202: D_STATUS_PHASE.DispHeight := 1;
203: D_STATUS_PHASE.MaxWidth := 20;
204: D_STATUS_PHASE.UseMeanings := False;
205: D_STATUS_PHASE.ColOptional := False;
206: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_PHASE_INDICATOR', D_STATUS_PHASE);
207: D_STATUS_PHASE.Initialised := True;
208: end if;
209:
210: if P_ALIAS = 'ORDER_PRIORITY' and not D_ORDER_PRIORITY.Initialised then

Line 212: D_ORDER_PRIORITY.ControlType := XNP_WSGL.DV_TEXT;

208: end if;
209:
210: if P_ALIAS = 'ORDER_PRIORITY' and not D_ORDER_PRIORITY.Initialised then
211: D_ORDER_PRIORITY.ColAlias := 'ORDER_PRIORITY';
212: D_ORDER_PRIORITY.ControlType := XNP_WSGL.DV_TEXT;
213: D_ORDER_PRIORITY.DispWidth := 10;
214: D_ORDER_PRIORITY.DispHeight := 1;
215: D_ORDER_PRIORITY.MaxWidth := 10;
216: D_ORDER_PRIORITY.UseMeanings := True;

Line 218: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_ORDER_PRIORITY', D_ORDER_PRIORITY);

214: D_ORDER_PRIORITY.DispHeight := 1;
215: D_ORDER_PRIORITY.MaxWidth := 10;
216: D_ORDER_PRIORITY.UseMeanings := True;
217: D_ORDER_PRIORITY.ColOptional := True;
218: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_ORDER_PRIORITY', D_ORDER_PRIORITY);
219: D_ORDER_PRIORITY.Initialised := True;
220: end if;
221:
222: if P_ALIAS = 'NEW_SP_AUTHORIZATION_FLAG' and not D_NEW_SP_AUTHORIZATION_FLAG.Initialised then

Line 224: D_NEW_SP_AUTHORIZATION_FLAG.ControlType := XNP_WSGL.DV_TEXT;

220: end if;
221:
222: if P_ALIAS = 'NEW_SP_AUTHORIZATION_FLAG' and not D_NEW_SP_AUTHORIZATION_FLAG.Initialised then
223: D_NEW_SP_AUTHORIZATION_FLAG.ColAlias := 'NEW_SP_AUTHORIZATION_FLAG';
224: D_NEW_SP_AUTHORIZATION_FLAG.ControlType := XNP_WSGL.DV_TEXT;
225: D_NEW_SP_AUTHORIZATION_FLAG.DispWidth := 5;
226: D_NEW_SP_AUTHORIZATION_FLAG.DispHeight := 1;
227: D_NEW_SP_AUTHORIZATION_FLAG.MaxWidth := 5;
228: D_NEW_SP_AUTHORIZATION_FLAG.UseMeanings := True;

Line 230: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_NEW_SP_AUTHORIZATION_FLAG);

226: D_NEW_SP_AUTHORIZATION_FLAG.DispHeight := 1;
227: D_NEW_SP_AUTHORIZATION_FLAG.MaxWidth := 5;
228: D_NEW_SP_AUTHORIZATION_FLAG.UseMeanings := True;
229: D_NEW_SP_AUTHORIZATION_FLAG.ColOptional := False;
230: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_NEW_SP_AUTHORIZATION_FLAG);
231: D_NEW_SP_AUTHORIZATION_FLAG.Initialised := True;
232: end if;
233:
234: if P_ALIAS = 'OLD_SP_AUTHORIZATION_FLAG' and not D_OLD_SP_AUTHORIZATION_FLAG.Initialised then

Line 236: D_OLD_SP_AUTHORIZATION_FLAG.ControlType := XNP_WSGL.DV_TEXT;

232: end if;
233:
234: if P_ALIAS = 'OLD_SP_AUTHORIZATION_FLAG' and not D_OLD_SP_AUTHORIZATION_FLAG.Initialised then
235: D_OLD_SP_AUTHORIZATION_FLAG.ColAlias := 'OLD_SP_AUTHORIZATION_FLAG';
236: D_OLD_SP_AUTHORIZATION_FLAG.ControlType := XNP_WSGL.DV_TEXT;
237: D_OLD_SP_AUTHORIZATION_FLAG.DispWidth := 5;
238: D_OLD_SP_AUTHORIZATION_FLAG.DispHeight := 1;
239: D_OLD_SP_AUTHORIZATION_FLAG.MaxWidth := 5;
240: D_OLD_SP_AUTHORIZATION_FLAG.UseMeanings := True;

Line 242: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_OLD_SP_AUTHORIZATION_FLAG);

238: D_OLD_SP_AUTHORIZATION_FLAG.DispHeight := 1;
239: D_OLD_SP_AUTHORIZATION_FLAG.MaxWidth := 5;
240: D_OLD_SP_AUTHORIZATION_FLAG.UseMeanings := True;
241: D_OLD_SP_AUTHORIZATION_FLAG.ColOptional := False;
242: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_OLD_SP_AUTHORIZATION_FLAG);
243: D_OLD_SP_AUTHORIZATION_FLAG.Initialised := True;
244: end if;
245:
246: if P_ALIAS = 'RETAIN_DIR_INFO_FLAG' and not D_RETAIN_DIR_INFO_FLAG.Initialised then

Line 248: D_RETAIN_DIR_INFO_FLAG.ControlType := XNP_WSGL.DV_TEXT;

244: end if;
245:
246: if P_ALIAS = 'RETAIN_DIR_INFO_FLAG' and not D_RETAIN_DIR_INFO_FLAG.Initialised then
247: D_RETAIN_DIR_INFO_FLAG.ColAlias := 'RETAIN_DIR_INFO_FLAG';
248: D_RETAIN_DIR_INFO_FLAG.ControlType := XNP_WSGL.DV_TEXT;
249: D_RETAIN_DIR_INFO_FLAG.DispWidth := 5;
250: D_RETAIN_DIR_INFO_FLAG.DispHeight := 1;
251: D_RETAIN_DIR_INFO_FLAG.MaxWidth := 5;
252: D_RETAIN_DIR_INFO_FLAG.UseMeanings := True;

Line 254: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_RETAIN_DIR_INFO_FLAG);

250: D_RETAIN_DIR_INFO_FLAG.DispHeight := 1;
251: D_RETAIN_DIR_INFO_FLAG.MaxWidth := 5;
252: D_RETAIN_DIR_INFO_FLAG.UseMeanings := True;
253: D_RETAIN_DIR_INFO_FLAG.ColOptional := True;
254: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_RETAIN_DIR_INFO_FLAG);
255: D_RETAIN_DIR_INFO_FLAG.Initialised := True;
256: end if;
257:
258: if P_ALIAS = 'LOCKED_FLAG' and not D_LOCKED_FLAG.Initialised then

Line 260: D_LOCKED_FLAG.ControlType := XNP_WSGL.DV_TEXT;

256: end if;
257:
258: if P_ALIAS = 'LOCKED_FLAG' and not D_LOCKED_FLAG.Initialised then
259: D_LOCKED_FLAG.ColAlias := 'LOCKED_FLAG';
260: D_LOCKED_FLAG.ControlType := XNP_WSGL.DV_TEXT;
261: D_LOCKED_FLAG.DispWidth := 5;
262: D_LOCKED_FLAG.DispHeight := 1;
263: D_LOCKED_FLAG.MaxWidth := 5;
264: D_LOCKED_FLAG.UseMeanings := True;

Line 266: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_LOCKED_FLAG);

262: D_LOCKED_FLAG.DispHeight := 1;
263: D_LOCKED_FLAG.MaxWidth := 5;
264: D_LOCKED_FLAG.UseMeanings := True;
265: D_LOCKED_FLAG.ColOptional := True;
266: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_LOCKED_FLAG);
267: D_LOCKED_FLAG.Initialised := True;
268: end if;
269:
270: if P_ALIAS = 'CONCURRENCE_FLAG' and not D_CONCURRENCE_FLAG.Initialised then

Line 272: D_CONCURRENCE_FLAG.ControlType := XNP_WSGL.DV_TEXT;

268: end if;
269:
270: if P_ALIAS = 'CONCURRENCE_FLAG' and not D_CONCURRENCE_FLAG.Initialised then
271: D_CONCURRENCE_FLAG.ColAlias := 'CONCURRENCE_FLAG';
272: D_CONCURRENCE_FLAG.ControlType := XNP_WSGL.DV_TEXT;
273: D_CONCURRENCE_FLAG.DispWidth := 1;
274: D_CONCURRENCE_FLAG.DispHeight := 1;
275: D_CONCURRENCE_FLAG.MaxWidth := 1;
276: D_CONCURRENCE_FLAG.UseMeanings := False;

Line 278: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_CONCURRENCE_FLAG);

274: D_CONCURRENCE_FLAG.DispHeight := 1;
275: D_CONCURRENCE_FLAG.MaxWidth := 1;
276: D_CONCURRENCE_FLAG.UseMeanings := False;
277: D_CONCURRENCE_FLAG.ColOptional := True;
278: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_CONCURRENCE_FLAG);
279: D_CONCURRENCE_FLAG.Initialised := True;
280: end if;
281:
282: if P_ALIAS = 'PTO_FLAG' and not D_PTO_FLAG.Initialised then

Line 284: D_PTO_FLAG.ControlType := XNP_WSGL.DV_TEXT;

280: end if;
281:
282: if P_ALIAS = 'PTO_FLAG' and not D_PTO_FLAG.Initialised then
283: D_PTO_FLAG.ColAlias := 'PTO_FLAG';
284: D_PTO_FLAG.ControlType := XNP_WSGL.DV_TEXT;
285: D_PTO_FLAG.DispWidth := 5;
286: D_PTO_FLAG.DispHeight := 1;
287: D_PTO_FLAG.MaxWidth := 5;
288: D_PTO_FLAG.UseMeanings := True;

Line 290: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_NO', D_PTO_FLAG);

286: D_PTO_FLAG.DispHeight := 1;
287: D_PTO_FLAG.MaxWidth := 5;
288: D_PTO_FLAG.UseMeanings := True;
289: D_PTO_FLAG.ColOptional := False;
290: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_NO', D_PTO_FLAG);
291: D_PTO_FLAG.Initialised := True;
292: end if;
293:
294: if P_ALIAS = 'RETAIN_TN_FLAG' and not D_RETAIN_TN_FLAG.Initialised then

Line 296: D_RETAIN_TN_FLAG.ControlType := XNP_WSGL.DV_TEXT;

292: end if;
293:
294: if P_ALIAS = 'RETAIN_TN_FLAG' and not D_RETAIN_TN_FLAG.Initialised then
295: D_RETAIN_TN_FLAG.ColAlias := 'RETAIN_TN_FLAG';
296: D_RETAIN_TN_FLAG.ControlType := XNP_WSGL.DV_TEXT;
297: D_RETAIN_TN_FLAG.DispWidth := 5;
298: D_RETAIN_TN_FLAG.DispHeight := 1;
299: D_RETAIN_TN_FLAG.MaxWidth := 5;
300: D_RETAIN_TN_FLAG.UseMeanings := True;

Line 302: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_RETAIN_TN_FLAG);

298: D_RETAIN_TN_FLAG.DispHeight := 1;
299: D_RETAIN_TN_FLAG.MaxWidth := 5;
300: D_RETAIN_TN_FLAG.UseMeanings := True;
301: D_RETAIN_TN_FLAG.ColOptional := True;
302: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_RETAIN_TN_FLAG);
303: D_RETAIN_TN_FLAG.Initialised := True;
304: end if;
305:
306: if P_ALIAS = 'BLOCKED_FLAG' and not D_BLOCKED_FLAG.Initialised then

Line 308: D_BLOCKED_FLAG.ControlType := XNP_WSGL.DV_TEXT;

304: end if;
305:
306: if P_ALIAS = 'BLOCKED_FLAG' and not D_BLOCKED_FLAG.Initialised then
307: D_BLOCKED_FLAG.ColAlias := 'BLOCKED_FLAG';
308: D_BLOCKED_FLAG.ControlType := XNP_WSGL.DV_TEXT;
309: D_BLOCKED_FLAG.DispWidth := 5;
310: D_BLOCKED_FLAG.DispHeight := 1;
311: D_BLOCKED_FLAG.MaxWidth := 5;
312: D_BLOCKED_FLAG.UseMeanings := True;

Line 314: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_BLOCKED_FLAG);

310: D_BLOCKED_FLAG.DispHeight := 1;
311: D_BLOCKED_FLAG.MaxWidth := 5;
312: D_BLOCKED_FLAG.UseMeanings := True;
313: D_BLOCKED_FLAG.ColOptional := True;
314: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_YES_NO_FLAG_DEFAULT_YES', D_BLOCKED_FLAG);
315: D_BLOCKED_FLAG.Initialised := True;
316: end if;
317:
318: exception

Line 320: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

316: end if;
317:
318: exception
319: when others then
320: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
321: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.InitialseDomain');
322: end;
323:
324: --------------------------------------------------------------------------------

Line 338: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.startup');

334: Z_DIRECT_CALL in boolean,
335: Z_CHK in varchar2) is
336: begin
337:
338: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.startup');
339: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
340:
341: if not Z_DIRECT_CALL then
342: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

Line 339: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

335: Z_CHK in varchar2) is
336: begin
337:
338: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.startup');
339: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
340:
341: if not Z_DIRECT_CALL then
342: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
343: return;

Line 342: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

338: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.startup');
339: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
340:
341: if not Z_DIRECT_CALL then
342: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
343: return;
344: end if;
345: end if;
346:

Line 347: XNP_WSGL.StoreURLLink(1, 'Porting Ordering Subscriptions');

343: return;
344: end if;
345: end if;
346:
347: XNP_WSGL.StoreURLLink(1, 'Porting Ordering Subscriptions');
348:
349:
350: FormQuery(
351: Z_DIRECT_CALL=>TRUE);

Line 355: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

351: Z_DIRECT_CALL=>TRUE);
352:
353: exception
354: when others then
355: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
356: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.Startup');
357: end;
358:
359: --------------------------------------------------------------------------------

Line 389: L_CHK := to_char(XNP_WSGL.Checksum(''));

385: L_BUTCHK varchar2(100):= null;
386: begin
387:
388: if Z_DIRECT_CALL then
389: L_CHK := to_char(XNP_WSGL.Checksum(''));
390: else
391: if not XNP_WSGL.ValidateChecksum('', L_CHK) then
392: return;
393: end if;

Line 391: if not XNP_WSGL.ValidateChecksum('', L_CHK) then

387:
388: if Z_DIRECT_CALL then
389: L_CHK := to_char(XNP_WSGL.Checksum(''));
390: else
391: if not XNP_WSGL.ValidateChecksum('', L_CHK) then
392: return;
393: end if;
394: end if;
395:

Line 397: I_PARAM_LIST := I_PARAM_LIST || 'P_PORTING_ID=' || XNP_WSGL.EscapeURLParam(P_PORTING_ID) || '&';

393: end if;
394: end if;
395:
396: if P_PORTING_ID is not null then
397: I_PARAM_LIST := I_PARAM_LIST || 'P_PORTING_ID=' || XNP_WSGL.EscapeURLParam(P_PORTING_ID) || '&';
398: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
399: end if;
400: if P_SUBSCRIPTION_TYPE is not null then
401: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TYPE=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TYPE) || '&';

Line 401: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TYPE=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TYPE) || '&';

397: I_PARAM_LIST := I_PARAM_LIST || 'P_PORTING_ID=' || XNP_WSGL.EscapeURLParam(P_PORTING_ID) || '&';
398: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
399: end if;
400: if P_SUBSCRIPTION_TYPE is not null then
401: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TYPE=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TYPE) || '&';
402: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
403: end if;
404: if P_SUBSCRIPTION_TN is not null then
405: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TN=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TN) || '&';

Line 405: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TN=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TN) || '&';

401: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TYPE=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TYPE) || '&';
402: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
403: end if;
404: if P_SUBSCRIPTION_TN is not null then
405: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TN=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TN) || '&';
406: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
407: end if;
408: if P_STATUS_DISPLAY_NAME is not null then
409: I_PARAM_LIST := I_PARAM_LIST || 'P_STATUS_DISPLAY_NAME=' || XNP_WSGL.EscapeURLParam(P_STATUS_DISPLAY_NAME) || '&';

Line 409: I_PARAM_LIST := I_PARAM_LIST || 'P_STATUS_DISPLAY_NAME=' || XNP_WSGL.EscapeURLParam(P_STATUS_DISPLAY_NAME) || '&';

405: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TN=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TN) || '&';
406: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
407: end if;
408: if P_STATUS_DISPLAY_NAME is not null then
409: I_PARAM_LIST := I_PARAM_LIST || 'P_STATUS_DISPLAY_NAME=' || XNP_WSGL.EscapeURLParam(P_STATUS_DISPLAY_NAME) || '&';
410: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
411: end if;
412: if P_CUSTOMER_ID is not null then
413: I_PARAM_LIST := I_PARAM_LIST || 'P_CUSTOMER_ID=' || XNP_WSGL.EscapeURLParam(P_CUSTOMER_ID) || '&';

Line 413: I_PARAM_LIST := I_PARAM_LIST || 'P_CUSTOMER_ID=' || XNP_WSGL.EscapeURLParam(P_CUSTOMER_ID) || '&';

409: I_PARAM_LIST := I_PARAM_LIST || 'P_STATUS_DISPLAY_NAME=' || XNP_WSGL.EscapeURLParam(P_STATUS_DISPLAY_NAME) || '&';
410: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
411: end if;
412: if P_CUSTOMER_ID is not null then
413: I_PARAM_LIST := I_PARAM_LIST || 'P_CUSTOMER_ID=' || XNP_WSGL.EscapeURLParam(P_CUSTOMER_ID) || '&';
414: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
415: end if;
416: if P_CUSTOMER_NAME is not null then
417: I_PARAM_LIST := I_PARAM_LIST || 'P_CUSTOMER_NAME=' || XNP_WSGL.EscapeURLParam(P_CUSTOMER_NAME) || '&';

Line 417: I_PARAM_LIST := I_PARAM_LIST || 'P_CUSTOMER_NAME=' || XNP_WSGL.EscapeURLParam(P_CUSTOMER_NAME) || '&';

413: I_PARAM_LIST := I_PARAM_LIST || 'P_CUSTOMER_ID=' || XNP_WSGL.EscapeURLParam(P_CUSTOMER_ID) || '&';
414: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
415: end if;
416: if P_CUSTOMER_NAME is not null then
417: I_PARAM_LIST := I_PARAM_LIST || 'P_CUSTOMER_NAME=' || XNP_WSGL.EscapeURLParam(P_CUSTOMER_NAME) || '&';
418: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
419: end if;
420: if P_REC_CODE is not null then
421: I_PARAM_LIST := I_PARAM_LIST || 'P_REC_CODE=' || XNP_WSGL.EscapeURLParam(P_REC_CODE) || '&';

Line 421: I_PARAM_LIST := I_PARAM_LIST || 'P_REC_CODE=' || XNP_WSGL.EscapeURLParam(P_REC_CODE) || '&';

417: I_PARAM_LIST := I_PARAM_LIST || 'P_CUSTOMER_NAME=' || XNP_WSGL.EscapeURLParam(P_CUSTOMER_NAME) || '&';
418: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
419: end if;
420: if P_REC_CODE is not null then
421: I_PARAM_LIST := I_PARAM_LIST || 'P_REC_CODE=' || XNP_WSGL.EscapeURLParam(P_REC_CODE) || '&';
422: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
423: end if;
424: if P_DON_CODE is not null then
425: I_PARAM_LIST := I_PARAM_LIST || 'P_DON_CODE=' || XNP_WSGL.EscapeURLParam(P_DON_CODE) || '&';

Line 425: I_PARAM_LIST := I_PARAM_LIST || 'P_DON_CODE=' || XNP_WSGL.EscapeURLParam(P_DON_CODE) || '&';

421: I_PARAM_LIST := I_PARAM_LIST || 'P_REC_CODE=' || XNP_WSGL.EscapeURLParam(P_REC_CODE) || '&';
422: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
423: end if;
424: if P_DON_CODE is not null then
425: I_PARAM_LIST := I_PARAM_LIST || 'P_DON_CODE=' || XNP_WSGL.EscapeURLParam(P_DON_CODE) || '&';
426: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
427: end if;
428: if P_NRC_CODE is not null then
429: I_PARAM_LIST := I_PARAM_LIST || 'P_NRC_CODE=' || XNP_WSGL.EscapeURLParam(P_NRC_CODE) || '&';

Line 429: I_PARAM_LIST := I_PARAM_LIST || 'P_NRC_CODE=' || XNP_WSGL.EscapeURLParam(P_NRC_CODE) || '&';

425: I_PARAM_LIST := I_PARAM_LIST || 'P_DON_CODE=' || XNP_WSGL.EscapeURLParam(P_DON_CODE) || '&';
426: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
427: end if;
428: if P_NRC_CODE is not null then
429: I_PARAM_LIST := I_PARAM_LIST || 'P_NRC_CODE=' || XNP_WSGL.EscapeURLParam(P_NRC_CODE) || '&';
430: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
431: end if;
432: I_PARAM_LIST := I_PARAM_LIST || 'Z_CHK=' || XNP_WSGL.EscapeURLParam(L_CHK) || '&';
433: I_PARAM_LIST := I_PARAM_LIST||'Z_ACTION=';

Line 432: I_PARAM_LIST := I_PARAM_LIST || 'Z_CHK=' || XNP_WSGL.EscapeURLParam(L_CHK) || '&';

428: if P_NRC_CODE is not null then
429: I_PARAM_LIST := I_PARAM_LIST || 'P_NRC_CODE=' || XNP_WSGL.EscapeURLParam(P_NRC_CODE) || '&';
430: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
431: end if;
432: I_PARAM_LIST := I_PARAM_LIST || 'Z_CHK=' || XNP_WSGL.EscapeURLParam(L_CHK) || '&';
433: I_PARAM_LIST := I_PARAM_LIST||'Z_ACTION=';
434:
435: htp.p('
436:

Line 440: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_INFORMATION, XNP_WSGL.MsgGetText(229,XNP_WSGLM.MSG229_NO_FRAME_SUPPORT),

436:
437:
438: ');
439: htp.noframesOpen;
440: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_INFORMATION, XNP_WSGL.MsgGetText(229,XNP_WSGLM.MSG229_NO_FRAME_SUPPORT),
441: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', DEF_BODY_ATTRIBUTES);
442: htp.noframesClose;
443: htp.p('
444:

Line 456: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

452: --if on the query form and insert is allowed
453:
454: exception
455: when others then
456: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
457: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.ActionQuery');
458: end;
459:
460: --------------------------------------------------------------------------------

Line 491: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

487: end if;
488:
489: L_ONLY_THING_IN_FRAME := (L_TEXT_TYPES = 1);
490:
491: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
492: L_ONLY_THING_IN_FRAME);
493: xnp_sv_orders$.TemplateHeader(TRUE,0);
494: XNP_WSGL.ClosePageHead;
495:

Line 494: XNP_WSGL.ClosePageHead;

490:
491: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
492: L_ONLY_THING_IN_FRAME);
493: xnp_sv_orders$.TemplateHeader(TRUE,0);
494: XNP_WSGL.ClosePageHead;
495:
496: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>TF_BODY_ATTRIBUTES);
497:
498: if Z_HEADER is not null then

Line 496: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>TF_BODY_ATTRIBUTES);

492: L_ONLY_THING_IN_FRAME);
493: xnp_sv_orders$.TemplateHeader(TRUE,0);
494: XNP_WSGL.ClosePageHead;
495:
496: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>TF_BODY_ATTRIBUTES);
497:
498: if Z_HEADER is not null then
499: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
500: end if;

Line 514: XNP_WSGL.ClosePageBody;

510: if Z_FOOTER is not null then
511: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
512: end if;
513:
514: XNP_WSGL.ClosePageBody;
515:
516: exception
517: when others then
518: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

Line 518: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

514: XNP_WSGL.ClosePageBody;
515:
516: exception
517: when others then
518: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
519: TF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.TextFrame');
520: XNP_WSGL.ClosePageBody;
521: end;
522: --------------------------------------------------------------------------------

Line 520: XNP_WSGL.ClosePageBody;

516: exception
517: when others then
518: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
519: TF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.TextFrame');
520: XNP_WSGL.ClosePageBody;
521: end;
522: --------------------------------------------------------------------------------
523: -- Name: xnp_sv_orders$soa_sv.QueryHits
524: --

Line 569: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

565: P_CUSTOMER_NAME,
566: P_REC_CODE,
567: P_DON_CODE,
568: P_NRC_CODE) then
569: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
570: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', DEF_BODY_ATTRIBUTES);
571: return -1;
572: end if;
573:

Line 595: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

591: return I_COUNT;
592:
593: exception
594: when others then
595: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
596: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryHits');
597: return -1;
598: end;--------------------------------------------------------------------------------
599: -- Name: xnp_sv_orders$soa_sv.BuildSQL

Line 625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);

621: InitialiseDomain('SUBSCRIPTION_TYPE');
622:
623: -- Build up the Where clause
624:
625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);

622:
623: -- Build up the Where clause
624:
625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);

623: -- Build up the Where clause
624:
625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);

624:
625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);

625: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SOA_VL.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);

626: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SOA_VL.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
634:

Line 631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

627: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SOA_VL.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
634:
635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,

Line 632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

628: XNP_WSGL.BuildWhere(P_STATUS_DISPLAY_NAME, 'XNP_SV_SOA_VL.STATUS_DISPLAY_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
634:
635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,
636: XNP_SV_SOA_VL.SUBSCRIPTION_TN,

Line 633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

629: XNP_WSGL.BuildWhere(P_CUSTOMER_ID, 'XNP_SV_SOA_VL.CUSTOMER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(P_CUSTOMER_NAME, 'XNP_SV_SOA_VL.CUSTOMER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SOA_VL.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_DON_CODE, 'XNP_SV_SOA_VL.DON_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SOA_VL.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
634:
635: ZONE_SQL := 'SELECT XNP_SV_SOA_VL.PORTING_ID,
636: XNP_SV_SOA_VL.SUBSCRIPTION_TN,
637: XNP_SV_SOA_VL.STATUS_DISPLAY_NAME,

Line 648: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

644: return true;
645:
646: exception
647: when others then
648: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
649: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.BuildSQL');
650: return false;
651: end;
652:

Line 670: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

666: Z_CHK in varchar2) is
667: begin
668:
669: if not Z_DIRECT_CALL then
670: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
671: return;
672: end if;
673: end if;
674:

Line 675: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions');

671: return;
672: end if;
673: end if;
674:
675: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions');
676: CreateQueryJavaScript;
677: xnp_sv_orders$.TemplateHeader(TRUE,0);
678: XNP_WSGL.ClosePageHead;
679:

Line 678: XNP_WSGL.ClosePageHead;

674:
675: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions');
676: CreateQueryJavaScript;
677: xnp_sv_orders$.TemplateHeader(TRUE,0);
678: XNP_WSGL.ClosePageHead;
679:
680: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
681:
682: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));

Line 680: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);

676: CreateQueryJavaScript;
677: xnp_sv_orders$.TemplateHeader(TRUE,0);
678: XNP_WSGL.ClosePageHead;
679:
680: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
681:
682: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
683: xnp_sv_orders$.FirstPage(TRUE);
684: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVORD_DETAILS_TITLE')));

Line 686: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Porting Ordering Subscriptions'));

682: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
683: xnp_sv_orders$.FirstPage(TRUE);
684: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVORD_DETAILS_TITLE')));
685: htp.para;
686: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Porting Ordering Subscriptions'));
687: htp.para;
688:
689: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.actionquery', cattributes => 'NAME="frmZero"');
690:

Line 691: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);

687: htp.para;
688:
689: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.actionquery', cattributes => 'NAME="frmZero"');
690:
691: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
692:
693: XNP_WSGL.LayoutRowStart;
694: for i in 1..QF_NUMBER_OF_COLUMNS loop
695: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);

Line 693: XNP_WSGL.LayoutRowStart;

689: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.actionquery', cattributes => 'NAME="frmZero"');
690:
691: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
692:
693: XNP_WSGL.LayoutRowStart;
694: for i in 1..QF_NUMBER_OF_COLUMNS loop
695: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);
696: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
697: end loop;

Line 695: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);

691: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
692:
693: XNP_WSGL.LayoutRowStart;
694: for i in 1..QF_NUMBER_OF_COLUMNS loop
695: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);
696: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
697: end loop;
698: XNP_WSGL.LayoutRowEnd;
699:

Line 696: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);

692:
693: XNP_WSGL.LayoutRowStart;
694: for i in 1..QF_NUMBER_OF_COLUMNS loop
695: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);
696: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
697: end loop;
698: XNP_WSGL.LayoutRowEnd;
699:
700: XNP_WSGL.LayoutRowStart('TOP');

Line 698: XNP_WSGL.LayoutRowEnd;

694: for i in 1..QF_NUMBER_OF_COLUMNS loop
695: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);
696: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
697: end loop;
698: XNP_WSGL.LayoutRowEnd;
699:
700: XNP_WSGL.LayoutRowStart('TOP');
701: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
702: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));

Line 700: XNP_WSGL.LayoutRowStart('TOP');

696: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
697: end loop;
698: XNP_WSGL.LayoutRowEnd;
699:
700: XNP_WSGL.LayoutRowStart('TOP');
701: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
702: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
703: XNP_WSGL.LayoutRowEnd;
704: XNP_WSGL.LayoutRowStart('TOP');

Line 701: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));

697: end loop;
698: XNP_WSGL.LayoutRowEnd;
699:
700: XNP_WSGL.LayoutRowStart('TOP');
701: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
702: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
703: XNP_WSGL.LayoutRowEnd;
704: XNP_WSGL.LayoutRowStart('TOP');
705: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));

Line 702: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));

698: XNP_WSGL.LayoutRowEnd;
699:
700: XNP_WSGL.LayoutRowStart('TOP');
701: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
702: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
703: XNP_WSGL.LayoutRowEnd;
704: XNP_WSGL.LayoutRowStart('TOP');
705: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
706: InitialiseDomain('SUBSCRIPTION_TYPE');

Line 703: XNP_WSGL.LayoutRowEnd;

699:
700: XNP_WSGL.LayoutRowStart('TOP');
701: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
702: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
703: XNP_WSGL.LayoutRowEnd;
704: XNP_WSGL.LayoutRowStart('TOP');
705: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
706: InitialiseDomain('SUBSCRIPTION_TYPE');
707: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));

Line 704: XNP_WSGL.LayoutRowStart('TOP');

700: XNP_WSGL.LayoutRowStart('TOP');
701: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
702: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
703: XNP_WSGL.LayoutRowEnd;
704: XNP_WSGL.LayoutRowStart('TOP');
705: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
706: InitialiseDomain('SUBSCRIPTION_TYPE');
707: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
708: XNP_WSGL.LayoutRowEnd;

Line 705: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));

701: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
702: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
703: XNP_WSGL.LayoutRowEnd;
704: XNP_WSGL.LayoutRowStart('TOP');
705: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
706: InitialiseDomain('SUBSCRIPTION_TYPE');
707: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
708: XNP_WSGL.LayoutRowEnd;
709: XNP_WSGL.LayoutRowStart('TOP');

Line 707: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));

703: XNP_WSGL.LayoutRowEnd;
704: XNP_WSGL.LayoutRowStart('TOP');
705: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
706: InitialiseDomain('SUBSCRIPTION_TYPE');
707: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
708: XNP_WSGL.LayoutRowEnd;
709: XNP_WSGL.LayoutRowStart('TOP');
710: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
711: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));

Line 708: XNP_WSGL.LayoutRowEnd;

704: XNP_WSGL.LayoutRowStart('TOP');
705: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
706: InitialiseDomain('SUBSCRIPTION_TYPE');
707: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
708: XNP_WSGL.LayoutRowEnd;
709: XNP_WSGL.LayoutRowStart('TOP');
710: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
711: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
712: XNP_WSGL.LayoutRowEnd;

Line 709: XNP_WSGL.LayoutRowStart('TOP');

705: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
706: InitialiseDomain('SUBSCRIPTION_TYPE');
707: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
708: XNP_WSGL.LayoutRowEnd;
709: XNP_WSGL.LayoutRowStart('TOP');
710: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
711: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
712: XNP_WSGL.LayoutRowEnd;
713: XNP_WSGL.LayoutRowStart('TOP');

Line 710: XNP_WSGL.LayoutData(htf.bold('Telephone:'));

706: InitialiseDomain('SUBSCRIPTION_TYPE');
707: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
708: XNP_WSGL.LayoutRowEnd;
709: XNP_WSGL.LayoutRowStart('TOP');
710: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
711: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
712: XNP_WSGL.LayoutRowEnd;
713: XNP_WSGL.LayoutRowStart('TOP');
714: XNP_WSGL.LayoutData(htf.bold('Status:'));

Line 711: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));

707: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
708: XNP_WSGL.LayoutRowEnd;
709: XNP_WSGL.LayoutRowStart('TOP');
710: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
711: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
712: XNP_WSGL.LayoutRowEnd;
713: XNP_WSGL.LayoutRowStart('TOP');
714: XNP_WSGL.LayoutData(htf.bold('Status:'));
715: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('STATUS_DISPLAY_NAME', '20', FALSE));

Line 712: XNP_WSGL.LayoutRowEnd;

708: XNP_WSGL.LayoutRowEnd;
709: XNP_WSGL.LayoutRowStart('TOP');
710: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
711: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
712: XNP_WSGL.LayoutRowEnd;
713: XNP_WSGL.LayoutRowStart('TOP');
714: XNP_WSGL.LayoutData(htf.bold('Status:'));
715: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('STATUS_DISPLAY_NAME', '20', FALSE));
716: XNP_WSGL.LayoutRowEnd;

Line 713: XNP_WSGL.LayoutRowStart('TOP');

709: XNP_WSGL.LayoutRowStart('TOP');
710: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
711: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
712: XNP_WSGL.LayoutRowEnd;
713: XNP_WSGL.LayoutRowStart('TOP');
714: XNP_WSGL.LayoutData(htf.bold('Status:'));
715: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('STATUS_DISPLAY_NAME', '20', FALSE));
716: XNP_WSGL.LayoutRowEnd;
717: XNP_WSGL.LayoutRowStart('TOP');

Line 714: XNP_WSGL.LayoutData(htf.bold('Status:'));

710: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
711: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
712: XNP_WSGL.LayoutRowEnd;
713: XNP_WSGL.LayoutRowStart('TOP');
714: XNP_WSGL.LayoutData(htf.bold('Status:'));
715: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('STATUS_DISPLAY_NAME', '20', FALSE));
716: XNP_WSGL.LayoutRowEnd;
717: XNP_WSGL.LayoutRowStart('TOP');
718: XNP_WSGL.LayoutData(htf.bold('Customer ID:'));

Line 715: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('STATUS_DISPLAY_NAME', '20', FALSE));

711: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
712: XNP_WSGL.LayoutRowEnd;
713: XNP_WSGL.LayoutRowStart('TOP');
714: XNP_WSGL.LayoutData(htf.bold('Status:'));
715: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('STATUS_DISPLAY_NAME', '20', FALSE));
716: XNP_WSGL.LayoutRowEnd;
717: XNP_WSGL.LayoutRowStart('TOP');
718: XNP_WSGL.LayoutData(htf.bold('Customer ID:'));
719: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_ID', '10', FALSE));

Line 716: XNP_WSGL.LayoutRowEnd;

712: XNP_WSGL.LayoutRowEnd;
713: XNP_WSGL.LayoutRowStart('TOP');
714: XNP_WSGL.LayoutData(htf.bold('Status:'));
715: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('STATUS_DISPLAY_NAME', '20', FALSE));
716: XNP_WSGL.LayoutRowEnd;
717: XNP_WSGL.LayoutRowStart('TOP');
718: XNP_WSGL.LayoutData(htf.bold('Customer ID:'));
719: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_ID', '10', FALSE));
720: XNP_WSGL.LayoutRowEnd;

Line 717: XNP_WSGL.LayoutRowStart('TOP');

713: XNP_WSGL.LayoutRowStart('TOP');
714: XNP_WSGL.LayoutData(htf.bold('Status:'));
715: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('STATUS_DISPLAY_NAME', '20', FALSE));
716: XNP_WSGL.LayoutRowEnd;
717: XNP_WSGL.LayoutRowStart('TOP');
718: XNP_WSGL.LayoutData(htf.bold('Customer ID:'));
719: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_ID', '10', FALSE));
720: XNP_WSGL.LayoutRowEnd;
721: XNP_WSGL.LayoutRowStart('TOP');

Line 718: XNP_WSGL.LayoutData(htf.bold('Customer ID:'));

714: XNP_WSGL.LayoutData(htf.bold('Status:'));
715: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('STATUS_DISPLAY_NAME', '20', FALSE));
716: XNP_WSGL.LayoutRowEnd;
717: XNP_WSGL.LayoutRowStart('TOP');
718: XNP_WSGL.LayoutData(htf.bold('Customer ID:'));
719: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_ID', '10', FALSE));
720: XNP_WSGL.LayoutRowEnd;
721: XNP_WSGL.LayoutRowStart('TOP');
722: XNP_WSGL.LayoutData(htf.bold('Customer Name:'));

Line 719: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_ID', '10', FALSE));

715: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('STATUS_DISPLAY_NAME', '20', FALSE));
716: XNP_WSGL.LayoutRowEnd;
717: XNP_WSGL.LayoutRowStart('TOP');
718: XNP_WSGL.LayoutData(htf.bold('Customer ID:'));
719: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_ID', '10', FALSE));
720: XNP_WSGL.LayoutRowEnd;
721: XNP_WSGL.LayoutRowStart('TOP');
722: XNP_WSGL.LayoutData(htf.bold('Customer Name:'));
723: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_NAME', '40', FALSE));

Line 720: XNP_WSGL.LayoutRowEnd;

716: XNP_WSGL.LayoutRowEnd;
717: XNP_WSGL.LayoutRowStart('TOP');
718: XNP_WSGL.LayoutData(htf.bold('Customer ID:'));
719: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_ID', '10', FALSE));
720: XNP_WSGL.LayoutRowEnd;
721: XNP_WSGL.LayoutRowStart('TOP');
722: XNP_WSGL.LayoutData(htf.bold('Customer Name:'));
723: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_NAME', '40', FALSE));
724: XNP_WSGL.LayoutRowEnd;

Line 721: XNP_WSGL.LayoutRowStart('TOP');

717: XNP_WSGL.LayoutRowStart('TOP');
718: XNP_WSGL.LayoutData(htf.bold('Customer ID:'));
719: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_ID', '10', FALSE));
720: XNP_WSGL.LayoutRowEnd;
721: XNP_WSGL.LayoutRowStart('TOP');
722: XNP_WSGL.LayoutData(htf.bold('Customer Name:'));
723: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_NAME', '40', FALSE));
724: XNP_WSGL.LayoutRowEnd;
725: XNP_WSGL.LayoutRowStart('TOP');

Line 722: XNP_WSGL.LayoutData(htf.bold('Customer Name:'));

718: XNP_WSGL.LayoutData(htf.bold('Customer ID:'));
719: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_ID', '10', FALSE));
720: XNP_WSGL.LayoutRowEnd;
721: XNP_WSGL.LayoutRowStart('TOP');
722: XNP_WSGL.LayoutData(htf.bold('Customer Name:'));
723: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_NAME', '40', FALSE));
724: XNP_WSGL.LayoutRowEnd;
725: XNP_WSGL.LayoutRowStart('TOP');
726: XNP_WSGL.LayoutData(htf.bold('Rec. Code:'));

Line 723: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_NAME', '40', FALSE));

719: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_ID', '10', FALSE));
720: XNP_WSGL.LayoutRowEnd;
721: XNP_WSGL.LayoutRowStart('TOP');
722: XNP_WSGL.LayoutData(htf.bold('Customer Name:'));
723: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_NAME', '40', FALSE));
724: XNP_WSGL.LayoutRowEnd;
725: XNP_WSGL.LayoutRowStart('TOP');
726: XNP_WSGL.LayoutData(htf.bold('Rec. Code:'));
727: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '10', FALSE));

Line 724: XNP_WSGL.LayoutRowEnd;

720: XNP_WSGL.LayoutRowEnd;
721: XNP_WSGL.LayoutRowStart('TOP');
722: XNP_WSGL.LayoutData(htf.bold('Customer Name:'));
723: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_NAME', '40', FALSE));
724: XNP_WSGL.LayoutRowEnd;
725: XNP_WSGL.LayoutRowStart('TOP');
726: XNP_WSGL.LayoutData(htf.bold('Rec. Code:'));
727: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '10', FALSE));
728: XNP_WSGL.LayoutRowEnd;

Line 725: XNP_WSGL.LayoutRowStart('TOP');

721: XNP_WSGL.LayoutRowStart('TOP');
722: XNP_WSGL.LayoutData(htf.bold('Customer Name:'));
723: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_NAME', '40', FALSE));
724: XNP_WSGL.LayoutRowEnd;
725: XNP_WSGL.LayoutRowStart('TOP');
726: XNP_WSGL.LayoutData(htf.bold('Rec. Code:'));
727: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '10', FALSE));
728: XNP_WSGL.LayoutRowEnd;
729: XNP_WSGL.LayoutRowStart('TOP');

Line 726: XNP_WSGL.LayoutData(htf.bold('Rec. Code:'));

722: XNP_WSGL.LayoutData(htf.bold('Customer Name:'));
723: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_NAME', '40', FALSE));
724: XNP_WSGL.LayoutRowEnd;
725: XNP_WSGL.LayoutRowStart('TOP');
726: XNP_WSGL.LayoutData(htf.bold('Rec. Code:'));
727: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '10', FALSE));
728: XNP_WSGL.LayoutRowEnd;
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('Don. Code:'));

Line 727: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '10', FALSE));

723: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('CUSTOMER_NAME', '40', FALSE));
724: XNP_WSGL.LayoutRowEnd;
725: XNP_WSGL.LayoutRowStart('TOP');
726: XNP_WSGL.LayoutData(htf.bold('Rec. Code:'));
727: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '10', FALSE));
728: XNP_WSGL.LayoutRowEnd;
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('Don. Code:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('DON_CODE', '10', FALSE));

Line 728: XNP_WSGL.LayoutRowEnd;

724: XNP_WSGL.LayoutRowEnd;
725: XNP_WSGL.LayoutRowStart('TOP');
726: XNP_WSGL.LayoutData(htf.bold('Rec. Code:'));
727: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '10', FALSE));
728: XNP_WSGL.LayoutRowEnd;
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('Don. Code:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('DON_CODE', '10', FALSE));
732: XNP_WSGL.LayoutRowEnd;

Line 729: XNP_WSGL.LayoutRowStart('TOP');

725: XNP_WSGL.LayoutRowStart('TOP');
726: XNP_WSGL.LayoutData(htf.bold('Rec. Code:'));
727: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '10', FALSE));
728: XNP_WSGL.LayoutRowEnd;
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('Don. Code:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('DON_CODE', '10', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');

Line 730: XNP_WSGL.LayoutData(htf.bold('Don. Code:'));

726: XNP_WSGL.LayoutData(htf.bold('Rec. Code:'));
727: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '10', FALSE));
728: XNP_WSGL.LayoutRowEnd;
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('Don. Code:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('DON_CODE', '10', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));

Line 731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('DON_CODE', '10', FALSE));

727: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '10', FALSE));
728: XNP_WSGL.LayoutRowEnd;
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('Don. Code:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('DON_CODE', '10', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));

Line 732: XNP_WSGL.LayoutRowEnd;

728: XNP_WSGL.LayoutRowEnd;
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('Don. Code:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('DON_CODE', '10', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
736: XNP_WSGL.LayoutRowEnd;

Line 733: XNP_WSGL.LayoutRowStart('TOP');

729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('Don. Code:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('DON_CODE', '10', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
736: XNP_WSGL.LayoutRowEnd;
737:

Line 734: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));

730: XNP_WSGL.LayoutData(htf.bold('Don. Code:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('DON_CODE', '10', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
736: XNP_WSGL.LayoutRowEnd;
737:
738: XNP_WSGL.LayoutClose;

Line 735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));

731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('DON_CODE', '10', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
736: XNP_WSGL.LayoutRowEnd;
737:
738: XNP_WSGL.LayoutClose;
739:

Line 736: XNP_WSGL.LayoutRowEnd;

732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
736: XNP_WSGL.LayoutRowEnd;
737:
738: XNP_WSGL.LayoutClose;
739:
740: htp.p ('');
748:
749: if XNP_WSGL.IsSupported ('NOSCRIPT')
750: then
751:
752: htp.p ('

Line 759: XNP_WSGL.HiddenField('Z_CHK',

755:
756: end if;
757: htp.formReset(htf.escape_sc(QF_CLEAR_BUT_CAPTION));
758:
759: XNP_WSGL.HiddenField('Z_CHK',
760: to_char(XNP_WSGL.Checksum('')));
761: htp.formClose;
762:
763: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));

Line 760: to_char(XNP_WSGL.Checksum('')));

756: end if;
757: htp.formReset(htf.escape_sc(QF_CLEAR_BUT_CAPTION));
758:
759: XNP_WSGL.HiddenField('Z_CHK',
760: to_char(XNP_WSGL.Checksum('')));
761: htp.formClose;
762:
763: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
764:

Line 765: XNP_WSGL.ClosePageBody;

761: htp.formClose;
762:
763: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
764:
765: XNP_WSGL.ClosePageBody;
766:
767: exception
768: when others then
769: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

Line 769: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

765: XNP_WSGL.ClosePageBody;
766:
767: exception
768: when others then
769: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
770: QF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.FormQuery');
771: XNP_WSGL.ClosePageBody;
772: end;
773:

Line 771: XNP_WSGL.ClosePageBody;

767: exception
768: when others then
769: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
770: QF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.FormQuery');
771: XNP_WSGL.ClosePageBody;
772: end;
773:
774: --------------------------------------------------------------------------------
775: -- Name: xnp_sv_orders$soa_sv.FormView

Line 790: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions');

786: SOA_ORDERS_CHCK varchar2(10);
787:
788: begin
789:
790: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions');
791: xnp_sv_orders$.TemplateHeader(TRUE,0);
792: XNP_WSGL.ClosePageHead;
793:
794: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);

Line 792: XNP_WSGL.ClosePageHead;

788: begin
789:
790: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions');
791: xnp_sv_orders$.TemplateHeader(TRUE,0);
792: XNP_WSGL.ClosePageHead;
793:
794: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
795:
796: InitialiseDomain('SUBSCRIPTION_TYPE');

Line 794: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);

790: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions');
791: xnp_sv_orders$.TemplateHeader(TRUE,0);
792: XNP_WSGL.ClosePageHead;
793:
794: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
795:
796: InitialiseDomain('SUBSCRIPTION_TYPE');
797: InitialiseDomain('STATUS_PHASE');
798: InitialiseDomain('ORDER_PRIORITY');

Line 811: FORM_VAL.SUBSCRIPTION_TYPE := XNP_WSGL.DomainMeaning(D_SUBSCRIPTION_TYPE, CURR_VAL.SUBSCRIPTION_TYPE);

807:
808:
809:
810: FORM_VAL.PORTING_ID := CURR_VAL.PORTING_ID;
811: FORM_VAL.SUBSCRIPTION_TYPE := XNP_WSGL.DomainMeaning(D_SUBSCRIPTION_TYPE, CURR_VAL.SUBSCRIPTION_TYPE);
812: FORM_VAL.SUBSCRIPTION_TN := CURR_VAL.SUBSCRIPTION_TN;
813: FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN := CURR_VAL.PRE_SPLIT_SUBSCRIPTION_TN;
814: FORM_VAL.ROUTING_NUMBER := CURR_VAL.ROUTING_NUMBER;
815: FORM_VAL.STATUS_PHASE := XNP_WSGL.DomainMeaning(D_STATUS_PHASE, CURR_VAL.STATUS_PHASE);

Line 815: FORM_VAL.STATUS_PHASE := XNP_WSGL.DomainMeaning(D_STATUS_PHASE, CURR_VAL.STATUS_PHASE);

811: FORM_VAL.SUBSCRIPTION_TYPE := XNP_WSGL.DomainMeaning(D_SUBSCRIPTION_TYPE, CURR_VAL.SUBSCRIPTION_TYPE);
812: FORM_VAL.SUBSCRIPTION_TN := CURR_VAL.SUBSCRIPTION_TN;
813: FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN := CURR_VAL.PRE_SPLIT_SUBSCRIPTION_TN;
814: FORM_VAL.ROUTING_NUMBER := CURR_VAL.ROUTING_NUMBER;
815: FORM_VAL.STATUS_PHASE := XNP_WSGL.DomainMeaning(D_STATUS_PHASE, CURR_VAL.STATUS_PHASE);
816: FORM_VAL.STATUS_DISPLAY_NAME := CURR_VAL.STATUS_DISPLAY_NAME;
817: FORM_VAL.DSP_STATUS := NBT_VAL.DSP_STATUS;
818: FORM_VAL.STATUS_CHANGE_DATE := ltrim(to_char(CURR_VAL.STATUS_CHANGE_DATE, 'DD-MON-RRRR'));
819: FORM_VAL.STATUS_CHANGE_CAUSE_CODE := CURR_VAL.STATUS_CHANGE_CAUSE_CODE;

Line 828: FORM_VAL.ORDER_PRIORITY := XNP_WSGL.DomainMeaning(D_ORDER_PRIORITY, CURR_VAL.ORDER_PRIORITY);

824: FORM_VAL.CONTACT_NAME := CURR_VAL.CONTACT_NAME;
825: FORM_VAL.PHONE := CURR_VAL.PHONE;
826: FORM_VAL.EMAIL := CURR_VAL.EMAIL;
827: FORM_VAL.ACTIVATION_DUE_DATE := ltrim(to_char(CURR_VAL.ACTIVATION_DUE_DATE, 'DD-MON-RRRR'));
828: FORM_VAL.ORDER_PRIORITY := XNP_WSGL.DomainMeaning(D_ORDER_PRIORITY, CURR_VAL.ORDER_PRIORITY);
829: FORM_VAL.PREORDER_AUTHORIZATION_CODE := CURR_VAL.PREORDER_AUTHORIZATION_CODE;
830: FORM_VAL.DSP_REC := NBT_VAL.DSP_REC;
831: FORM_VAL.REC_CODE := CURR_VAL.REC_CODE;
832: FORM_VAL.REC_NAME := CURR_VAL.REC_NAME;

Line 842: FORM_VAL.NEW_SP_AUTHORIZATION_FLAG := XNP_WSGL.DomainMeaning(D_NEW_SP_AUTHORIZATION_FLAG, CURR_VAL.NEW_SP_AUTHORIZATION_FLAG);

838: FORM_VAL.DSP_NRC := NBT_VAL.DSP_NRC;
839: FORM_VAL.NRC_CODE := CURR_VAL.NRC_CODE;
840: FORM_VAL.NRC_NAME := CURR_VAL.NRC_NAME;
841: FORM_VAL.NRC_EMAIL := CURR_VAL.NRC_EMAIL;
842: FORM_VAL.NEW_SP_AUTHORIZATION_FLAG := XNP_WSGL.DomainMeaning(D_NEW_SP_AUTHORIZATION_FLAG, CURR_VAL.NEW_SP_AUTHORIZATION_FLAG);
843: FORM_VAL.NEW_SP_DUE_DATE := ltrim(to_char(CURR_VAL.NEW_SP_DUE_DATE, 'DD-MON-RRRR'));
844: FORM_VAL.OLD_SP_AUTHORIZATION_FLAG := XNP_WSGL.DomainMeaning(D_OLD_SP_AUTHORIZATION_FLAG, CURR_VAL.OLD_SP_AUTHORIZATION_FLAG);
845: FORM_VAL.OLD_SP_DUE_DATE := ltrim(to_char(CURR_VAL.OLD_SP_DUE_DATE, 'DD-MON-RRRR'));
846: FORM_VAL.OLD_SP_CUTOFF_DUE_DATE := ltrim(to_char(CURR_VAL.OLD_SP_CUTOFF_DUE_DATE, 'DD-MON-RRRR'));

Line 844: FORM_VAL.OLD_SP_AUTHORIZATION_FLAG := XNP_WSGL.DomainMeaning(D_OLD_SP_AUTHORIZATION_FLAG, CURR_VAL.OLD_SP_AUTHORIZATION_FLAG);

840: FORM_VAL.NRC_NAME := CURR_VAL.NRC_NAME;
841: FORM_VAL.NRC_EMAIL := CURR_VAL.NRC_EMAIL;
842: FORM_VAL.NEW_SP_AUTHORIZATION_FLAG := XNP_WSGL.DomainMeaning(D_NEW_SP_AUTHORIZATION_FLAG, CURR_VAL.NEW_SP_AUTHORIZATION_FLAG);
843: FORM_VAL.NEW_SP_DUE_DATE := ltrim(to_char(CURR_VAL.NEW_SP_DUE_DATE, 'DD-MON-RRRR'));
844: FORM_VAL.OLD_SP_AUTHORIZATION_FLAG := XNP_WSGL.DomainMeaning(D_OLD_SP_AUTHORIZATION_FLAG, CURR_VAL.OLD_SP_AUTHORIZATION_FLAG);
845: FORM_VAL.OLD_SP_DUE_DATE := ltrim(to_char(CURR_VAL.OLD_SP_DUE_DATE, 'DD-MON-RRRR'));
846: FORM_VAL.OLD_SP_CUTOFF_DUE_DATE := ltrim(to_char(CURR_VAL.OLD_SP_CUTOFF_DUE_DATE, 'DD-MON-RRRR'));
847: FORM_VAL.INVOICE_DUE_DATE := ltrim(to_char(CURR_VAL.INVOICE_DUE_DATE, 'DD-MON-RRRR'));
848: FORM_VAL.RETAIN_DIR_INFO_FLAG := XNP_WSGL.DomainMeaning(D_RETAIN_DIR_INFO_FLAG, CURR_VAL.RETAIN_DIR_INFO_FLAG);

Line 848: FORM_VAL.RETAIN_DIR_INFO_FLAG := XNP_WSGL.DomainMeaning(D_RETAIN_DIR_INFO_FLAG, CURR_VAL.RETAIN_DIR_INFO_FLAG);

844: FORM_VAL.OLD_SP_AUTHORIZATION_FLAG := XNP_WSGL.DomainMeaning(D_OLD_SP_AUTHORIZATION_FLAG, CURR_VAL.OLD_SP_AUTHORIZATION_FLAG);
845: FORM_VAL.OLD_SP_DUE_DATE := ltrim(to_char(CURR_VAL.OLD_SP_DUE_DATE, 'DD-MON-RRRR'));
846: FORM_VAL.OLD_SP_CUTOFF_DUE_DATE := ltrim(to_char(CURR_VAL.OLD_SP_CUTOFF_DUE_DATE, 'DD-MON-RRRR'));
847: FORM_VAL.INVOICE_DUE_DATE := ltrim(to_char(CURR_VAL.INVOICE_DUE_DATE, 'DD-MON-RRRR'));
848: FORM_VAL.RETAIN_DIR_INFO_FLAG := XNP_WSGL.DomainMeaning(D_RETAIN_DIR_INFO_FLAG, CURR_VAL.RETAIN_DIR_INFO_FLAG);
849: FORM_VAL.LOCKED_FLAG := XNP_WSGL.DomainMeaning(D_LOCKED_FLAG, CURR_VAL.LOCKED_FLAG);
850: FORM_VAL.CONCURRENCE_FLAG := XNP_WSGL.DomainMeaning(D_CONCURRENCE_FLAG, CURR_VAL.CONCURRENCE_FLAG);
851: FORM_VAL.PTO_FLAG := XNP_WSGL.DomainMeaning(D_PTO_FLAG, CURR_VAL.PTO_FLAG);
852: FORM_VAL.DISCONNECT_DUE_DATE := ltrim(to_char(CURR_VAL.DISCONNECT_DUE_DATE, 'DD-MON-RRRR'));

Line 849: FORM_VAL.LOCKED_FLAG := XNP_WSGL.DomainMeaning(D_LOCKED_FLAG, CURR_VAL.LOCKED_FLAG);

845: FORM_VAL.OLD_SP_DUE_DATE := ltrim(to_char(CURR_VAL.OLD_SP_DUE_DATE, 'DD-MON-RRRR'));
846: FORM_VAL.OLD_SP_CUTOFF_DUE_DATE := ltrim(to_char(CURR_VAL.OLD_SP_CUTOFF_DUE_DATE, 'DD-MON-RRRR'));
847: FORM_VAL.INVOICE_DUE_DATE := ltrim(to_char(CURR_VAL.INVOICE_DUE_DATE, 'DD-MON-RRRR'));
848: FORM_VAL.RETAIN_DIR_INFO_FLAG := XNP_WSGL.DomainMeaning(D_RETAIN_DIR_INFO_FLAG, CURR_VAL.RETAIN_DIR_INFO_FLAG);
849: FORM_VAL.LOCKED_FLAG := XNP_WSGL.DomainMeaning(D_LOCKED_FLAG, CURR_VAL.LOCKED_FLAG);
850: FORM_VAL.CONCURRENCE_FLAG := XNP_WSGL.DomainMeaning(D_CONCURRENCE_FLAG, CURR_VAL.CONCURRENCE_FLAG);
851: FORM_VAL.PTO_FLAG := XNP_WSGL.DomainMeaning(D_PTO_FLAG, CURR_VAL.PTO_FLAG);
852: FORM_VAL.DISCONNECT_DUE_DATE := ltrim(to_char(CURR_VAL.DISCONNECT_DUE_DATE, 'DD-MON-RRRR'));
853: FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE := ltrim(to_char(CURR_VAL.EFFECTIVE_RELEASE_DUE_DATE, 'DD-MON-RRRR'));

Line 850: FORM_VAL.CONCURRENCE_FLAG := XNP_WSGL.DomainMeaning(D_CONCURRENCE_FLAG, CURR_VAL.CONCURRENCE_FLAG);

846: FORM_VAL.OLD_SP_CUTOFF_DUE_DATE := ltrim(to_char(CURR_VAL.OLD_SP_CUTOFF_DUE_DATE, 'DD-MON-RRRR'));
847: FORM_VAL.INVOICE_DUE_DATE := ltrim(to_char(CURR_VAL.INVOICE_DUE_DATE, 'DD-MON-RRRR'));
848: FORM_VAL.RETAIN_DIR_INFO_FLAG := XNP_WSGL.DomainMeaning(D_RETAIN_DIR_INFO_FLAG, CURR_VAL.RETAIN_DIR_INFO_FLAG);
849: FORM_VAL.LOCKED_FLAG := XNP_WSGL.DomainMeaning(D_LOCKED_FLAG, CURR_VAL.LOCKED_FLAG);
850: FORM_VAL.CONCURRENCE_FLAG := XNP_WSGL.DomainMeaning(D_CONCURRENCE_FLAG, CURR_VAL.CONCURRENCE_FLAG);
851: FORM_VAL.PTO_FLAG := XNP_WSGL.DomainMeaning(D_PTO_FLAG, CURR_VAL.PTO_FLAG);
852: FORM_VAL.DISCONNECT_DUE_DATE := ltrim(to_char(CURR_VAL.DISCONNECT_DUE_DATE, 'DD-MON-RRRR'));
853: FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE := ltrim(to_char(CURR_VAL.EFFECTIVE_RELEASE_DUE_DATE, 'DD-MON-RRRR'));
854: FORM_VAL.RETAIN_TN_FLAG := XNP_WSGL.DomainMeaning(D_RETAIN_TN_FLAG, CURR_VAL.RETAIN_TN_FLAG);

Line 851: FORM_VAL.PTO_FLAG := XNP_WSGL.DomainMeaning(D_PTO_FLAG, CURR_VAL.PTO_FLAG);

847: FORM_VAL.INVOICE_DUE_DATE := ltrim(to_char(CURR_VAL.INVOICE_DUE_DATE, 'DD-MON-RRRR'));
848: FORM_VAL.RETAIN_DIR_INFO_FLAG := XNP_WSGL.DomainMeaning(D_RETAIN_DIR_INFO_FLAG, CURR_VAL.RETAIN_DIR_INFO_FLAG);
849: FORM_VAL.LOCKED_FLAG := XNP_WSGL.DomainMeaning(D_LOCKED_FLAG, CURR_VAL.LOCKED_FLAG);
850: FORM_VAL.CONCURRENCE_FLAG := XNP_WSGL.DomainMeaning(D_CONCURRENCE_FLAG, CURR_VAL.CONCURRENCE_FLAG);
851: FORM_VAL.PTO_FLAG := XNP_WSGL.DomainMeaning(D_PTO_FLAG, CURR_VAL.PTO_FLAG);
852: FORM_VAL.DISCONNECT_DUE_DATE := ltrim(to_char(CURR_VAL.DISCONNECT_DUE_DATE, 'DD-MON-RRRR'));
853: FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE := ltrim(to_char(CURR_VAL.EFFECTIVE_RELEASE_DUE_DATE, 'DD-MON-RRRR'));
854: FORM_VAL.RETAIN_TN_FLAG := XNP_WSGL.DomainMeaning(D_RETAIN_TN_FLAG, CURR_VAL.RETAIN_TN_FLAG);
855: FORM_VAL.BLOCKED_FLAG := XNP_WSGL.DomainMeaning(D_BLOCKED_FLAG, CURR_VAL.BLOCKED_FLAG);

Line 854: FORM_VAL.RETAIN_TN_FLAG := XNP_WSGL.DomainMeaning(D_RETAIN_TN_FLAG, CURR_VAL.RETAIN_TN_FLAG);

850: FORM_VAL.CONCURRENCE_FLAG := XNP_WSGL.DomainMeaning(D_CONCURRENCE_FLAG, CURR_VAL.CONCURRENCE_FLAG);
851: FORM_VAL.PTO_FLAG := XNP_WSGL.DomainMeaning(D_PTO_FLAG, CURR_VAL.PTO_FLAG);
852: FORM_VAL.DISCONNECT_DUE_DATE := ltrim(to_char(CURR_VAL.DISCONNECT_DUE_DATE, 'DD-MON-RRRR'));
853: FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE := ltrim(to_char(CURR_VAL.EFFECTIVE_RELEASE_DUE_DATE, 'DD-MON-RRRR'));
854: FORM_VAL.RETAIN_TN_FLAG := XNP_WSGL.DomainMeaning(D_RETAIN_TN_FLAG, CURR_VAL.RETAIN_TN_FLAG);
855: FORM_VAL.BLOCKED_FLAG := XNP_WSGL.DomainMeaning(D_BLOCKED_FLAG, CURR_VAL.BLOCKED_FLAG);
856: FORM_VAL.NUMBER_RETURNED_DUE_DATE := ltrim(to_char(CURR_VAL.NUMBER_RETURNED_DUE_DATE, 'DD-MON-RRRR'));
857: FORM_VAL.DSP_CNAM := NBT_VAL.DSP_CNAM;
858: FORM_VAL.DSP_CLASS := NBT_VAL.DSP_CLASS;

Line 855: FORM_VAL.BLOCKED_FLAG := XNP_WSGL.DomainMeaning(D_BLOCKED_FLAG, CURR_VAL.BLOCKED_FLAG);

851: FORM_VAL.PTO_FLAG := XNP_WSGL.DomainMeaning(D_PTO_FLAG, CURR_VAL.PTO_FLAG);
852: FORM_VAL.DISCONNECT_DUE_DATE := ltrim(to_char(CURR_VAL.DISCONNECT_DUE_DATE, 'DD-MON-RRRR'));
853: FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE := ltrim(to_char(CURR_VAL.EFFECTIVE_RELEASE_DUE_DATE, 'DD-MON-RRRR'));
854: FORM_VAL.RETAIN_TN_FLAG := XNP_WSGL.DomainMeaning(D_RETAIN_TN_FLAG, CURR_VAL.RETAIN_TN_FLAG);
855: FORM_VAL.BLOCKED_FLAG := XNP_WSGL.DomainMeaning(D_BLOCKED_FLAG, CURR_VAL.BLOCKED_FLAG);
856: FORM_VAL.NUMBER_RETURNED_DUE_DATE := ltrim(to_char(CURR_VAL.NUMBER_RETURNED_DUE_DATE, 'DD-MON-RRRR'));
857: FORM_VAL.DSP_CNAM := NBT_VAL.DSP_CNAM;
858: FORM_VAL.DSP_CLASS := NBT_VAL.DSP_CLASS;
859: FORM_VAL.DSP_ISVM := NBT_VAL.DSP_ISVM;

Line 877: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then

873: FORM_VAL.RN_ADDRESS := CURR_VAL.RN_ADDRESS;
874: FORM_VAL.RN_SUBSYSTEM := CURR_VAL.RN_SUBSYSTEM;
875: FORM_VAL.SV_SOA_ID := CURR_VAL.SV_SOA_ID;
876:
877: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
878: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
879: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
880: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
881: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),

Line 878: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

874: FORM_VAL.RN_SUBSYSTEM := CURR_VAL.RN_SUBSYSTEM;
875: FORM_VAL.SV_SOA_ID := CURR_VAL.SV_SOA_ID;
876:
877: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
878: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
879: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
880: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
881: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
882: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);

Line 880: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then

876:
877: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
878: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
879: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
880: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
881: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
882: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
883: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
884: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),

Line 881: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),

877: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
878: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
879: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
880: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
881: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
882: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
883: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
884: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
885: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);

Line 883: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then

879: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
880: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
881: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
882: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
883: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
884: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
885: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
886: end if;
887:

Line 884: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),

880: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
881: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
882: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
883: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
884: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
885: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
886: end if;
887:
888:

Line 889: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);

885: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
886: end if;
887:
888:
889: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
890:
891: XNP_WSGL.LayoutRowStart;
892: for i in 1..VF_NUMBER_OF_COLUMNS loop
893: XNP_WSGL.LayoutHeader(23, 'LEFT', NULL);

Line 891: XNP_WSGL.LayoutRowStart;

887:
888:
889: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
890:
891: XNP_WSGL.LayoutRowStart;
892: for i in 1..VF_NUMBER_OF_COLUMNS loop
893: XNP_WSGL.LayoutHeader(23, 'LEFT', NULL);
894: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
895: end loop;

Line 893: XNP_WSGL.LayoutHeader(23, 'LEFT', NULL);

889: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
890:
891: XNP_WSGL.LayoutRowStart;
892: for i in 1..VF_NUMBER_OF_COLUMNS loop
893: XNP_WSGL.LayoutHeader(23, 'LEFT', NULL);
894: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
895: end loop;
896: XNP_WSGL.LayoutRowEnd;
897:

Line 894: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);

890:
891: XNP_WSGL.LayoutRowStart;
892: for i in 1..VF_NUMBER_OF_COLUMNS loop
893: XNP_WSGL.LayoutHeader(23, 'LEFT', NULL);
894: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
895: end loop;
896: XNP_WSGL.LayoutRowEnd;
897:
898: XNP_WSGL.LayoutRowStart('TOP');

Line 896: XNP_WSGL.LayoutRowEnd;

892: for i in 1..VF_NUMBER_OF_COLUMNS loop
893: XNP_WSGL.LayoutHeader(23, 'LEFT', NULL);
894: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
895: end loop;
896: XNP_WSGL.LayoutRowEnd;
897:
898: XNP_WSGL.LayoutRowStart('TOP');
899: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
900: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));

Line 898: XNP_WSGL.LayoutRowStart('TOP');

894: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
895: end loop;
896: XNP_WSGL.LayoutRowEnd;
897:
898: XNP_WSGL.LayoutRowStart('TOP');
899: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
900: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
901: XNP_WSGL.LayoutRowEnd;
902: XNP_WSGL.LayoutRowStart('TOP');

Line 899: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));

895: end loop;
896: XNP_WSGL.LayoutRowEnd;
897:
898: XNP_WSGL.LayoutRowStart('TOP');
899: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
900: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
901: XNP_WSGL.LayoutRowEnd;
902: XNP_WSGL.LayoutRowStart('TOP');
903: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));

Line 900: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));

896: XNP_WSGL.LayoutRowEnd;
897:
898: XNP_WSGL.LayoutRowStart('TOP');
899: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
900: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
901: XNP_WSGL.LayoutRowEnd;
902: XNP_WSGL.LayoutRowStart('TOP');
903: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
904: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);

Line 901: XNP_WSGL.LayoutRowEnd;

897:
898: XNP_WSGL.LayoutRowStart('TOP');
899: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
900: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
901: XNP_WSGL.LayoutRowEnd;
902: XNP_WSGL.LayoutRowStart('TOP');
903: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
904: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
905: XNP_WSGL.LayoutRowEnd;

Line 902: XNP_WSGL.LayoutRowStart('TOP');

898: XNP_WSGL.LayoutRowStart('TOP');
899: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
900: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
901: XNP_WSGL.LayoutRowEnd;
902: XNP_WSGL.LayoutRowStart('TOP');
903: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
904: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
905: XNP_WSGL.LayoutRowEnd;
906: XNP_WSGL.LayoutRowStart('TOP');

Line 903: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));

899: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
900: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
901: XNP_WSGL.LayoutRowEnd;
902: XNP_WSGL.LayoutRowStart('TOP');
903: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
904: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
905: XNP_WSGL.LayoutRowEnd;
906: XNP_WSGL.LayoutRowStart('TOP');
907: XNP_WSGL.LayoutData(htf.bold('Telephone:'));

Line 904: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);

900: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
901: XNP_WSGL.LayoutRowEnd;
902: XNP_WSGL.LayoutRowStart('TOP');
903: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
904: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
905: XNP_WSGL.LayoutRowEnd;
906: XNP_WSGL.LayoutRowStart('TOP');
907: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
908: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));

Line 905: XNP_WSGL.LayoutRowEnd;

901: XNP_WSGL.LayoutRowEnd;
902: XNP_WSGL.LayoutRowStart('TOP');
903: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
904: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
905: XNP_WSGL.LayoutRowEnd;
906: XNP_WSGL.LayoutRowStart('TOP');
907: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
908: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
909: XNP_WSGL.LayoutRowEnd;

Line 906: XNP_WSGL.LayoutRowStart('TOP');

902: XNP_WSGL.LayoutRowStart('TOP');
903: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
904: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
905: XNP_WSGL.LayoutRowEnd;
906: XNP_WSGL.LayoutRowStart('TOP');
907: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
908: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
909: XNP_WSGL.LayoutRowEnd;
910: XNP_WSGL.LayoutRowStart('TOP');

Line 907: XNP_WSGL.LayoutData(htf.bold('Telephone:'));

903: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
904: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
905: XNP_WSGL.LayoutRowEnd;
906: XNP_WSGL.LayoutRowStart('TOP');
907: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
908: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
909: XNP_WSGL.LayoutRowEnd;
910: XNP_WSGL.LayoutRowStart('TOP');
911: XNP_WSGL.LayoutData(htf.bold('Pre-Split Number:'));

Line 908: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));

904: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
905: XNP_WSGL.LayoutRowEnd;
906: XNP_WSGL.LayoutRowStart('TOP');
907: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
908: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
909: XNP_WSGL.LayoutRowEnd;
910: XNP_WSGL.LayoutRowStart('TOP');
911: XNP_WSGL.LayoutData(htf.bold('Pre-Split Number:'));
912: XNP_WSGL.LayoutData(FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN);

Line 909: XNP_WSGL.LayoutRowEnd;

905: XNP_WSGL.LayoutRowEnd;
906: XNP_WSGL.LayoutRowStart('TOP');
907: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
908: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
909: XNP_WSGL.LayoutRowEnd;
910: XNP_WSGL.LayoutRowStart('TOP');
911: XNP_WSGL.LayoutData(htf.bold('Pre-Split Number:'));
912: XNP_WSGL.LayoutData(FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN);
913: XNP_WSGL.LayoutRowEnd;

Line 910: XNP_WSGL.LayoutRowStart('TOP');

906: XNP_WSGL.LayoutRowStart('TOP');
907: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
908: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
909: XNP_WSGL.LayoutRowEnd;
910: XNP_WSGL.LayoutRowStart('TOP');
911: XNP_WSGL.LayoutData(htf.bold('Pre-Split Number:'));
912: XNP_WSGL.LayoutData(FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN);
913: XNP_WSGL.LayoutRowEnd;
914: XNP_WSGL.LayoutRowStart('TOP');

Line 911: XNP_WSGL.LayoutData(htf.bold('Pre-Split Number:'));

907: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
908: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
909: XNP_WSGL.LayoutRowEnd;
910: XNP_WSGL.LayoutRowStart('TOP');
911: XNP_WSGL.LayoutData(htf.bold('Pre-Split Number:'));
912: XNP_WSGL.LayoutData(FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN);
913: XNP_WSGL.LayoutRowEnd;
914: XNP_WSGL.LayoutRowStart('TOP');
915: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));

Line 912: XNP_WSGL.LayoutData(FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN);

908: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
909: XNP_WSGL.LayoutRowEnd;
910: XNP_WSGL.LayoutRowStart('TOP');
911: XNP_WSGL.LayoutData(htf.bold('Pre-Split Number:'));
912: XNP_WSGL.LayoutData(FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN);
913: XNP_WSGL.LayoutRowEnd;
914: XNP_WSGL.LayoutRowStart('TOP');
915: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
916: XNP_WSGL.LayoutData(FORM_VAL.ROUTING_NUMBER);

Line 913: XNP_WSGL.LayoutRowEnd;

909: XNP_WSGL.LayoutRowEnd;
910: XNP_WSGL.LayoutRowStart('TOP');
911: XNP_WSGL.LayoutData(htf.bold('Pre-Split Number:'));
912: XNP_WSGL.LayoutData(FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN);
913: XNP_WSGL.LayoutRowEnd;
914: XNP_WSGL.LayoutRowStart('TOP');
915: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
916: XNP_WSGL.LayoutData(FORM_VAL.ROUTING_NUMBER);
917: XNP_WSGL.LayoutRowEnd;

Line 914: XNP_WSGL.LayoutRowStart('TOP');

910: XNP_WSGL.LayoutRowStart('TOP');
911: XNP_WSGL.LayoutData(htf.bold('Pre-Split Number:'));
912: XNP_WSGL.LayoutData(FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN);
913: XNP_WSGL.LayoutRowEnd;
914: XNP_WSGL.LayoutRowStart('TOP');
915: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
916: XNP_WSGL.LayoutData(FORM_VAL.ROUTING_NUMBER);
917: XNP_WSGL.LayoutRowEnd;
918: if NBT_VAL.DSP_STATUS is not null then

Line 915: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));

911: XNP_WSGL.LayoutData(htf.bold('Pre-Split Number:'));
912: XNP_WSGL.LayoutData(FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN);
913: XNP_WSGL.LayoutRowEnd;
914: XNP_WSGL.LayoutRowStart('TOP');
915: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
916: XNP_WSGL.LayoutData(FORM_VAL.ROUTING_NUMBER);
917: XNP_WSGL.LayoutRowEnd;
918: if NBT_VAL.DSP_STATUS is not null then
919: XNP_WSGL.LayoutRowStart('TOP');

Line 916: XNP_WSGL.LayoutData(FORM_VAL.ROUTING_NUMBER);

912: XNP_WSGL.LayoutData(FORM_VAL.PRE_SPLIT_SUBSCRIPTION_TN);
913: XNP_WSGL.LayoutRowEnd;
914: XNP_WSGL.LayoutRowStart('TOP');
915: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
916: XNP_WSGL.LayoutData(FORM_VAL.ROUTING_NUMBER);
917: XNP_WSGL.LayoutRowEnd;
918: if NBT_VAL.DSP_STATUS is not null then
919: XNP_WSGL.LayoutRowStart('TOP');
920: XNP_WSGL.LayoutData(htf.bold('Status:'));

Line 917: XNP_WSGL.LayoutRowEnd;

913: XNP_WSGL.LayoutRowEnd;
914: XNP_WSGL.LayoutRowStart('TOP');
915: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
916: XNP_WSGL.LayoutData(FORM_VAL.ROUTING_NUMBER);
917: XNP_WSGL.LayoutRowEnd;
918: if NBT_VAL.DSP_STATUS is not null then
919: XNP_WSGL.LayoutRowStart('TOP');
920: XNP_WSGL.LayoutData(htf.bold('Status:'));
921: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DSP_STATUS));

Line 919: XNP_WSGL.LayoutRowStart('TOP');

915: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
916: XNP_WSGL.LayoutData(FORM_VAL.ROUTING_NUMBER);
917: XNP_WSGL.LayoutRowEnd;
918: if NBT_VAL.DSP_STATUS is not null then
919: XNP_WSGL.LayoutRowStart('TOP');
920: XNP_WSGL.LayoutData(htf.bold('Status:'));
921: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DSP_STATUS));
922: XNP_WSGL.LayoutRowEnd;
923: end if;

Line 920: XNP_WSGL.LayoutData(htf.bold('Status:'));

916: XNP_WSGL.LayoutData(FORM_VAL.ROUTING_NUMBER);
917: XNP_WSGL.LayoutRowEnd;
918: if NBT_VAL.DSP_STATUS is not null then
919: XNP_WSGL.LayoutRowStart('TOP');
920: XNP_WSGL.LayoutData(htf.bold('Status:'));
921: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DSP_STATUS));
922: XNP_WSGL.LayoutRowEnd;
923: end if;
924: if NBT_VAL.DSP_CUSTOMER is not null then

Line 921: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DSP_STATUS));

917: XNP_WSGL.LayoutRowEnd;
918: if NBT_VAL.DSP_STATUS is not null then
919: XNP_WSGL.LayoutRowStart('TOP');
920: XNP_WSGL.LayoutData(htf.bold('Status:'));
921: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DSP_STATUS));
922: XNP_WSGL.LayoutRowEnd;
923: end if;
924: if NBT_VAL.DSP_CUSTOMER is not null then
925: XNP_WSGL.LayoutRowStart('TOP');

Line 922: XNP_WSGL.LayoutRowEnd;

918: if NBT_VAL.DSP_STATUS is not null then
919: XNP_WSGL.LayoutRowStart('TOP');
920: XNP_WSGL.LayoutData(htf.bold('Status:'));
921: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DSP_STATUS));
922: XNP_WSGL.LayoutRowEnd;
923: end if;
924: if NBT_VAL.DSP_CUSTOMER is not null then
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Customer:'));

Line 925: XNP_WSGL.LayoutRowStart('TOP');

921: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DSP_STATUS));
922: XNP_WSGL.LayoutRowEnd;
923: end if;
924: if NBT_VAL.DSP_CUSTOMER is not null then
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Customer:'));
927: XNP_WSGL.LayoutData(FORM_VAL.DSP_CUSTOMER);
928: XNP_WSGL.LayoutRowEnd;
929: end if;

Line 926: XNP_WSGL.LayoutData(htf.bold('Customer:'));

922: XNP_WSGL.LayoutRowEnd;
923: end if;
924: if NBT_VAL.DSP_CUSTOMER is not null then
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Customer:'));
927: XNP_WSGL.LayoutData(FORM_VAL.DSP_CUSTOMER);
928: XNP_WSGL.LayoutRowEnd;
929: end if;
930: if NBT_VAL.DSP_CONTACT is not null then

Line 927: XNP_WSGL.LayoutData(FORM_VAL.DSP_CUSTOMER);

923: end if;
924: if NBT_VAL.DSP_CUSTOMER is not null then
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Customer:'));
927: XNP_WSGL.LayoutData(FORM_VAL.DSP_CUSTOMER);
928: XNP_WSGL.LayoutRowEnd;
929: end if;
930: if NBT_VAL.DSP_CONTACT is not null then
931: XNP_WSGL.LayoutRowStart('TOP');

Line 928: XNP_WSGL.LayoutRowEnd;

924: if NBT_VAL.DSP_CUSTOMER is not null then
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Customer:'));
927: XNP_WSGL.LayoutData(FORM_VAL.DSP_CUSTOMER);
928: XNP_WSGL.LayoutRowEnd;
929: end if;
930: if NBT_VAL.DSP_CONTACT is not null then
931: XNP_WSGL.LayoutRowStart('TOP');
932: XNP_WSGL.LayoutData(htf.bold('Contact:'));

Line 931: XNP_WSGL.LayoutRowStart('TOP');

927: XNP_WSGL.LayoutData(FORM_VAL.DSP_CUSTOMER);
928: XNP_WSGL.LayoutRowEnd;
929: end if;
930: if NBT_VAL.DSP_CONTACT is not null then
931: XNP_WSGL.LayoutRowStart('TOP');
932: XNP_WSGL.LayoutData(htf.bold('Contact:'));
933: XNP_WSGL.LayoutData(FORM_VAL.DSP_CONTACT);
934: XNP_WSGL.LayoutRowEnd;
935: end if;

Line 932: XNP_WSGL.LayoutData(htf.bold('Contact:'));

928: XNP_WSGL.LayoutRowEnd;
929: end if;
930: if NBT_VAL.DSP_CONTACT is not null then
931: XNP_WSGL.LayoutRowStart('TOP');
932: XNP_WSGL.LayoutData(htf.bold('Contact:'));
933: XNP_WSGL.LayoutData(FORM_VAL.DSP_CONTACT);
934: XNP_WSGL.LayoutRowEnd;
935: end if;
936: XNP_WSGL.LayoutRowStart('TOP');

Line 933: XNP_WSGL.LayoutData(FORM_VAL.DSP_CONTACT);

929: end if;
930: if NBT_VAL.DSP_CONTACT is not null then
931: XNP_WSGL.LayoutRowStart('TOP');
932: XNP_WSGL.LayoutData(htf.bold('Contact:'));
933: XNP_WSGL.LayoutData(FORM_VAL.DSP_CONTACT);
934: XNP_WSGL.LayoutRowEnd;
935: end if;
936: XNP_WSGL.LayoutRowStart('TOP');
937: XNP_WSGL.LayoutData(htf.bold('Contact Email:'));

Line 934: XNP_WSGL.LayoutRowEnd;

930: if NBT_VAL.DSP_CONTACT is not null then
931: XNP_WSGL.LayoutRowStart('TOP');
932: XNP_WSGL.LayoutData(htf.bold('Contact:'));
933: XNP_WSGL.LayoutData(FORM_VAL.DSP_CONTACT);
934: XNP_WSGL.LayoutRowEnd;
935: end if;
936: XNP_WSGL.LayoutRowStart('TOP');
937: XNP_WSGL.LayoutData(htf.bold('Contact Email:'));
938: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.EMAIL, FORM_VAL.EMAIL));

Line 936: XNP_WSGL.LayoutRowStart('TOP');

932: XNP_WSGL.LayoutData(htf.bold('Contact:'));
933: XNP_WSGL.LayoutData(FORM_VAL.DSP_CONTACT);
934: XNP_WSGL.LayoutRowEnd;
935: end if;
936: XNP_WSGL.LayoutRowStart('TOP');
937: XNP_WSGL.LayoutData(htf.bold('Contact Email:'));
938: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.EMAIL, FORM_VAL.EMAIL));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');

Line 937: XNP_WSGL.LayoutData(htf.bold('Contact Email:'));

933: XNP_WSGL.LayoutData(FORM_VAL.DSP_CONTACT);
934: XNP_WSGL.LayoutRowEnd;
935: end if;
936: XNP_WSGL.LayoutRowStart('TOP');
937: XNP_WSGL.LayoutData(htf.bold('Contact Email:'));
938: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.EMAIL, FORM_VAL.EMAIL));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Activation Due Date:'));

Line 938: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.EMAIL, FORM_VAL.EMAIL));

934: XNP_WSGL.LayoutRowEnd;
935: end if;
936: XNP_WSGL.LayoutRowStart('TOP');
937: XNP_WSGL.LayoutData(htf.bold('Contact Email:'));
938: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.EMAIL, FORM_VAL.EMAIL));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Activation Due Date:'));
942: XNP_WSGL.LayoutData(FORM_VAL.ACTIVATION_DUE_DATE);

Line 939: XNP_WSGL.LayoutRowEnd;

935: end if;
936: XNP_WSGL.LayoutRowStart('TOP');
937: XNP_WSGL.LayoutData(htf.bold('Contact Email:'));
938: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.EMAIL, FORM_VAL.EMAIL));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Activation Due Date:'));
942: XNP_WSGL.LayoutData(FORM_VAL.ACTIVATION_DUE_DATE);
943: XNP_WSGL.LayoutRowEnd;

Line 940: XNP_WSGL.LayoutRowStart('TOP');

936: XNP_WSGL.LayoutRowStart('TOP');
937: XNP_WSGL.LayoutData(htf.bold('Contact Email:'));
938: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.EMAIL, FORM_VAL.EMAIL));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Activation Due Date:'));
942: XNP_WSGL.LayoutData(FORM_VAL.ACTIVATION_DUE_DATE);
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');

Line 941: XNP_WSGL.LayoutData(htf.bold('Activation Due Date:'));

937: XNP_WSGL.LayoutData(htf.bold('Contact Email:'));
938: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.EMAIL, FORM_VAL.EMAIL));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Activation Due Date:'));
942: XNP_WSGL.LayoutData(FORM_VAL.ACTIVATION_DUE_DATE);
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Priority:'));

Line 942: XNP_WSGL.LayoutData(FORM_VAL.ACTIVATION_DUE_DATE);

938: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.EMAIL, FORM_VAL.EMAIL));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Activation Due Date:'));
942: XNP_WSGL.LayoutData(FORM_VAL.ACTIVATION_DUE_DATE);
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Priority:'));
946: XNP_WSGL.LayoutData(FORM_VAL.ORDER_PRIORITY);

Line 943: XNP_WSGL.LayoutRowEnd;

939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Activation Due Date:'));
942: XNP_WSGL.LayoutData(FORM_VAL.ACTIVATION_DUE_DATE);
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Priority:'));
946: XNP_WSGL.LayoutData(FORM_VAL.ORDER_PRIORITY);
947: XNP_WSGL.LayoutRowEnd;

Line 944: XNP_WSGL.LayoutRowStart('TOP');

940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Activation Due Date:'));
942: XNP_WSGL.LayoutData(FORM_VAL.ACTIVATION_DUE_DATE);
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Priority:'));
946: XNP_WSGL.LayoutData(FORM_VAL.ORDER_PRIORITY);
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');

Line 945: XNP_WSGL.LayoutData(htf.bold('Priority:'));

941: XNP_WSGL.LayoutData(htf.bold('Activation Due Date:'));
942: XNP_WSGL.LayoutData(FORM_VAL.ACTIVATION_DUE_DATE);
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Priority:'));
946: XNP_WSGL.LayoutData(FORM_VAL.ORDER_PRIORITY);
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Auth Code:'));

Line 946: XNP_WSGL.LayoutData(FORM_VAL.ORDER_PRIORITY);

942: XNP_WSGL.LayoutData(FORM_VAL.ACTIVATION_DUE_DATE);
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Priority:'));
946: XNP_WSGL.LayoutData(FORM_VAL.ORDER_PRIORITY);
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Auth Code:'));
950: XNP_WSGL.LayoutData(FORM_VAL.PREORDER_AUTHORIZATION_CODE);

Line 947: XNP_WSGL.LayoutRowEnd;

943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Priority:'));
946: XNP_WSGL.LayoutData(FORM_VAL.ORDER_PRIORITY);
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Auth Code:'));
950: XNP_WSGL.LayoutData(FORM_VAL.PREORDER_AUTHORIZATION_CODE);
951: XNP_WSGL.LayoutRowEnd;

Line 948: XNP_WSGL.LayoutRowStart('TOP');

944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Priority:'));
946: XNP_WSGL.LayoutData(FORM_VAL.ORDER_PRIORITY);
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Auth Code:'));
950: XNP_WSGL.LayoutData(FORM_VAL.PREORDER_AUTHORIZATION_CODE);
951: XNP_WSGL.LayoutRowEnd;
952: if NBT_VAL.DSP_REC is not null then

Line 949: XNP_WSGL.LayoutData(htf.bold('Auth Code:'));

945: XNP_WSGL.LayoutData(htf.bold('Priority:'));
946: XNP_WSGL.LayoutData(FORM_VAL.ORDER_PRIORITY);
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Auth Code:'));
950: XNP_WSGL.LayoutData(FORM_VAL.PREORDER_AUTHORIZATION_CODE);
951: XNP_WSGL.LayoutRowEnd;
952: if NBT_VAL.DSP_REC is not null then
953: XNP_WSGL.LayoutRowStart('TOP');

Line 950: XNP_WSGL.LayoutData(FORM_VAL.PREORDER_AUTHORIZATION_CODE);

946: XNP_WSGL.LayoutData(FORM_VAL.ORDER_PRIORITY);
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Auth Code:'));
950: XNP_WSGL.LayoutData(FORM_VAL.PREORDER_AUTHORIZATION_CODE);
951: XNP_WSGL.LayoutRowEnd;
952: if NBT_VAL.DSP_REC is not null then
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Recipient:'));

Line 951: XNP_WSGL.LayoutRowEnd;

947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Auth Code:'));
950: XNP_WSGL.LayoutData(FORM_VAL.PREORDER_AUTHORIZATION_CODE);
951: XNP_WSGL.LayoutRowEnd;
952: if NBT_VAL.DSP_REC is not null then
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
955: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);

Line 953: XNP_WSGL.LayoutRowStart('TOP');

949: XNP_WSGL.LayoutData(htf.bold('Auth Code:'));
950: XNP_WSGL.LayoutData(FORM_VAL.PREORDER_AUTHORIZATION_CODE);
951: XNP_WSGL.LayoutRowEnd;
952: if NBT_VAL.DSP_REC is not null then
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
955: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
956: XNP_WSGL.LayoutRowEnd;
957: end if;

Line 954: XNP_WSGL.LayoutData(htf.bold('Recipient:'));

950: XNP_WSGL.LayoutData(FORM_VAL.PREORDER_AUTHORIZATION_CODE);
951: XNP_WSGL.LayoutRowEnd;
952: if NBT_VAL.DSP_REC is not null then
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
955: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
956: XNP_WSGL.LayoutRowEnd;
957: end if;
958: XNP_WSGL.LayoutRowStart('TOP');

Line 955: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);

951: XNP_WSGL.LayoutRowEnd;
952: if NBT_VAL.DSP_REC is not null then
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
955: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
956: XNP_WSGL.LayoutRowEnd;
957: end if;
958: XNP_WSGL.LayoutRowStart('TOP');
959: XNP_WSGL.LayoutData(htf.bold('Rec Email:'));

Line 956: XNP_WSGL.LayoutRowEnd;

952: if NBT_VAL.DSP_REC is not null then
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
955: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
956: XNP_WSGL.LayoutRowEnd;
957: end if;
958: XNP_WSGL.LayoutRowStart('TOP');
959: XNP_WSGL.LayoutData(htf.bold('Rec Email:'));
960: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));

Line 958: XNP_WSGL.LayoutRowStart('TOP');

954: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
955: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
956: XNP_WSGL.LayoutRowEnd;
957: end if;
958: XNP_WSGL.LayoutRowStart('TOP');
959: XNP_WSGL.LayoutData(htf.bold('Rec Email:'));
960: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
961: XNP_WSGL.LayoutRowEnd;
962: if NBT_VAL.DSP_DON is not null then

Line 959: XNP_WSGL.LayoutData(htf.bold('Rec Email:'));

955: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
956: XNP_WSGL.LayoutRowEnd;
957: end if;
958: XNP_WSGL.LayoutRowStart('TOP');
959: XNP_WSGL.LayoutData(htf.bold('Rec Email:'));
960: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
961: XNP_WSGL.LayoutRowEnd;
962: if NBT_VAL.DSP_DON is not null then
963: XNP_WSGL.LayoutRowStart('TOP');

Line 960: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));

956: XNP_WSGL.LayoutRowEnd;
957: end if;
958: XNP_WSGL.LayoutRowStart('TOP');
959: XNP_WSGL.LayoutData(htf.bold('Rec Email:'));
960: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
961: XNP_WSGL.LayoutRowEnd;
962: if NBT_VAL.DSP_DON is not null then
963: XNP_WSGL.LayoutRowStart('TOP');
964: XNP_WSGL.LayoutData(htf.bold('Donor:'));

Line 961: XNP_WSGL.LayoutRowEnd;

957: end if;
958: XNP_WSGL.LayoutRowStart('TOP');
959: XNP_WSGL.LayoutData(htf.bold('Rec Email:'));
960: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
961: XNP_WSGL.LayoutRowEnd;
962: if NBT_VAL.DSP_DON is not null then
963: XNP_WSGL.LayoutRowStart('TOP');
964: XNP_WSGL.LayoutData(htf.bold('Donor:'));
965: XNP_WSGL.LayoutData(FORM_VAL.DSP_DON);

Line 963: XNP_WSGL.LayoutRowStart('TOP');

959: XNP_WSGL.LayoutData(htf.bold('Rec Email:'));
960: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
961: XNP_WSGL.LayoutRowEnd;
962: if NBT_VAL.DSP_DON is not null then
963: XNP_WSGL.LayoutRowStart('TOP');
964: XNP_WSGL.LayoutData(htf.bold('Donor:'));
965: XNP_WSGL.LayoutData(FORM_VAL.DSP_DON);
966: XNP_WSGL.LayoutRowEnd;
967: end if;

Line 964: XNP_WSGL.LayoutData(htf.bold('Donor:'));

960: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
961: XNP_WSGL.LayoutRowEnd;
962: if NBT_VAL.DSP_DON is not null then
963: XNP_WSGL.LayoutRowStart('TOP');
964: XNP_WSGL.LayoutData(htf.bold('Donor:'));
965: XNP_WSGL.LayoutData(FORM_VAL.DSP_DON);
966: XNP_WSGL.LayoutRowEnd;
967: end if;
968: XNP_WSGL.LayoutRowStart('TOP');

Line 965: XNP_WSGL.LayoutData(FORM_VAL.DSP_DON);

961: XNP_WSGL.LayoutRowEnd;
962: if NBT_VAL.DSP_DON is not null then
963: XNP_WSGL.LayoutRowStart('TOP');
964: XNP_WSGL.LayoutData(htf.bold('Donor:'));
965: XNP_WSGL.LayoutData(FORM_VAL.DSP_DON);
966: XNP_WSGL.LayoutRowEnd;
967: end if;
968: XNP_WSGL.LayoutRowStart('TOP');
969: XNP_WSGL.LayoutData(htf.bold('Don Email:'));

Line 966: XNP_WSGL.LayoutRowEnd;

962: if NBT_VAL.DSP_DON is not null then
963: XNP_WSGL.LayoutRowStart('TOP');
964: XNP_WSGL.LayoutData(htf.bold('Donor:'));
965: XNP_WSGL.LayoutData(FORM_VAL.DSP_DON);
966: XNP_WSGL.LayoutRowEnd;
967: end if;
968: XNP_WSGL.LayoutRowStart('TOP');
969: XNP_WSGL.LayoutData(htf.bold('Don Email:'));
970: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.DON_EMAIL, FORM_VAL.DON_EMAIL));

Line 968: XNP_WSGL.LayoutRowStart('TOP');

964: XNP_WSGL.LayoutData(htf.bold('Donor:'));
965: XNP_WSGL.LayoutData(FORM_VAL.DSP_DON);
966: XNP_WSGL.LayoutRowEnd;
967: end if;
968: XNP_WSGL.LayoutRowStart('TOP');
969: XNP_WSGL.LayoutData(htf.bold('Don Email:'));
970: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.DON_EMAIL, FORM_VAL.DON_EMAIL));
971: XNP_WSGL.LayoutRowEnd;
972: if NBT_VAL.DSP_NRC is not null then

Line 969: XNP_WSGL.LayoutData(htf.bold('Don Email:'));

965: XNP_WSGL.LayoutData(FORM_VAL.DSP_DON);
966: XNP_WSGL.LayoutRowEnd;
967: end if;
968: XNP_WSGL.LayoutRowStart('TOP');
969: XNP_WSGL.LayoutData(htf.bold('Don Email:'));
970: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.DON_EMAIL, FORM_VAL.DON_EMAIL));
971: XNP_WSGL.LayoutRowEnd;
972: if NBT_VAL.DSP_NRC is not null then
973: XNP_WSGL.LayoutRowStart('TOP');

Line 970: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.DON_EMAIL, FORM_VAL.DON_EMAIL));

966: XNP_WSGL.LayoutRowEnd;
967: end if;
968: XNP_WSGL.LayoutRowStart('TOP');
969: XNP_WSGL.LayoutData(htf.bold('Don Email:'));
970: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.DON_EMAIL, FORM_VAL.DON_EMAIL));
971: XNP_WSGL.LayoutRowEnd;
972: if NBT_VAL.DSP_NRC is not null then
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Mediator:'));

Line 971: XNP_WSGL.LayoutRowEnd;

967: end if;
968: XNP_WSGL.LayoutRowStart('TOP');
969: XNP_WSGL.LayoutData(htf.bold('Don Email:'));
970: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.DON_EMAIL, FORM_VAL.DON_EMAIL));
971: XNP_WSGL.LayoutRowEnd;
972: if NBT_VAL.DSP_NRC is not null then
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
975: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);

Line 973: XNP_WSGL.LayoutRowStart('TOP');

969: XNP_WSGL.LayoutData(htf.bold('Don Email:'));
970: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.DON_EMAIL, FORM_VAL.DON_EMAIL));
971: XNP_WSGL.LayoutRowEnd;
972: if NBT_VAL.DSP_NRC is not null then
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
975: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
976: XNP_WSGL.LayoutRowEnd;
977: end if;

Line 974: XNP_WSGL.LayoutData(htf.bold('Mediator:'));

970: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.DON_EMAIL, FORM_VAL.DON_EMAIL));
971: XNP_WSGL.LayoutRowEnd;
972: if NBT_VAL.DSP_NRC is not null then
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
975: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
976: XNP_WSGL.LayoutRowEnd;
977: end if;
978: XNP_WSGL.LayoutRowStart('TOP');

Line 975: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);

971: XNP_WSGL.LayoutRowEnd;
972: if NBT_VAL.DSP_NRC is not null then
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
975: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
976: XNP_WSGL.LayoutRowEnd;
977: end if;
978: XNP_WSGL.LayoutRowStart('TOP');
979: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));

Line 976: XNP_WSGL.LayoutRowEnd;

972: if NBT_VAL.DSP_NRC is not null then
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
975: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
976: XNP_WSGL.LayoutRowEnd;
977: end if;
978: XNP_WSGL.LayoutRowStart('TOP');
979: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
980: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));

Line 978: XNP_WSGL.LayoutRowStart('TOP');

974: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
975: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
976: XNP_WSGL.LayoutRowEnd;
977: end if;
978: XNP_WSGL.LayoutRowStart('TOP');
979: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
980: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
981: XNP_WSGL.LayoutRowEnd;
982: XNP_WSGL.LayoutRowStart('TOP');

Line 979: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));

975: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
976: XNP_WSGL.LayoutRowEnd;
977: end if;
978: XNP_WSGL.LayoutRowStart('TOP');
979: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
980: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
981: XNP_WSGL.LayoutRowEnd;
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.bold('Rec. Authorized?:'));

Line 980: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));

976: XNP_WSGL.LayoutRowEnd;
977: end if;
978: XNP_WSGL.LayoutRowStart('TOP');
979: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
980: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
981: XNP_WSGL.LayoutRowEnd;
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.bold('Rec. Authorized?:'));
984: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_AUTHORIZATION_FLAG);

Line 981: XNP_WSGL.LayoutRowEnd;

977: end if;
978: XNP_WSGL.LayoutRowStart('TOP');
979: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
980: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
981: XNP_WSGL.LayoutRowEnd;
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.bold('Rec. Authorized?:'));
984: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_AUTHORIZATION_FLAG);
985: XNP_WSGL.LayoutRowEnd;

Line 982: XNP_WSGL.LayoutRowStart('TOP');

978: XNP_WSGL.LayoutRowStart('TOP');
979: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
980: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
981: XNP_WSGL.LayoutRowEnd;
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.bold('Rec. Authorized?:'));
984: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_AUTHORIZATION_FLAG);
985: XNP_WSGL.LayoutRowEnd;
986: XNP_WSGL.LayoutRowStart('TOP');

Line 983: XNP_WSGL.LayoutData(htf.bold('Rec. Authorized?:'));

979: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
980: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
981: XNP_WSGL.LayoutRowEnd;
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.bold('Rec. Authorized?:'));
984: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_AUTHORIZATION_FLAG);
985: XNP_WSGL.LayoutRowEnd;
986: XNP_WSGL.LayoutRowStart('TOP');
987: XNP_WSGL.LayoutData(htf.bold('Rec. Due Date:'));

Line 984: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_AUTHORIZATION_FLAG);

980: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
981: XNP_WSGL.LayoutRowEnd;
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.bold('Rec. Authorized?:'));
984: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_AUTHORIZATION_FLAG);
985: XNP_WSGL.LayoutRowEnd;
986: XNP_WSGL.LayoutRowStart('TOP');
987: XNP_WSGL.LayoutData(htf.bold('Rec. Due Date:'));
988: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_DUE_DATE);

Line 985: XNP_WSGL.LayoutRowEnd;

981: XNP_WSGL.LayoutRowEnd;
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.bold('Rec. Authorized?:'));
984: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_AUTHORIZATION_FLAG);
985: XNP_WSGL.LayoutRowEnd;
986: XNP_WSGL.LayoutRowStart('TOP');
987: XNP_WSGL.LayoutData(htf.bold('Rec. Due Date:'));
988: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_DUE_DATE);
989: XNP_WSGL.LayoutRowEnd;

Line 986: XNP_WSGL.LayoutRowStart('TOP');

982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.bold('Rec. Authorized?:'));
984: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_AUTHORIZATION_FLAG);
985: XNP_WSGL.LayoutRowEnd;
986: XNP_WSGL.LayoutRowStart('TOP');
987: XNP_WSGL.LayoutData(htf.bold('Rec. Due Date:'));
988: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_DUE_DATE);
989: XNP_WSGL.LayoutRowEnd;
990: XNP_WSGL.LayoutRowStart('TOP');

Line 987: XNP_WSGL.LayoutData(htf.bold('Rec. Due Date:'));

983: XNP_WSGL.LayoutData(htf.bold('Rec. Authorized?:'));
984: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_AUTHORIZATION_FLAG);
985: XNP_WSGL.LayoutRowEnd;
986: XNP_WSGL.LayoutRowStart('TOP');
987: XNP_WSGL.LayoutData(htf.bold('Rec. Due Date:'));
988: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_DUE_DATE);
989: XNP_WSGL.LayoutRowEnd;
990: XNP_WSGL.LayoutRowStart('TOP');
991: XNP_WSGL.LayoutData(htf.bold('Don. Authorized?:'));

Line 988: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_DUE_DATE);

984: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_AUTHORIZATION_FLAG);
985: XNP_WSGL.LayoutRowEnd;
986: XNP_WSGL.LayoutRowStart('TOP');
987: XNP_WSGL.LayoutData(htf.bold('Rec. Due Date:'));
988: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_DUE_DATE);
989: XNP_WSGL.LayoutRowEnd;
990: XNP_WSGL.LayoutRowStart('TOP');
991: XNP_WSGL.LayoutData(htf.bold('Don. Authorized?:'));
992: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_AUTHORIZATION_FLAG);

Line 989: XNP_WSGL.LayoutRowEnd;

985: XNP_WSGL.LayoutRowEnd;
986: XNP_WSGL.LayoutRowStart('TOP');
987: XNP_WSGL.LayoutData(htf.bold('Rec. Due Date:'));
988: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_DUE_DATE);
989: XNP_WSGL.LayoutRowEnd;
990: XNP_WSGL.LayoutRowStart('TOP');
991: XNP_WSGL.LayoutData(htf.bold('Don. Authorized?:'));
992: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_AUTHORIZATION_FLAG);
993: XNP_WSGL.LayoutRowEnd;

Line 990: XNP_WSGL.LayoutRowStart('TOP');

986: XNP_WSGL.LayoutRowStart('TOP');
987: XNP_WSGL.LayoutData(htf.bold('Rec. Due Date:'));
988: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_DUE_DATE);
989: XNP_WSGL.LayoutRowEnd;
990: XNP_WSGL.LayoutRowStart('TOP');
991: XNP_WSGL.LayoutData(htf.bold('Don. Authorized?:'));
992: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_AUTHORIZATION_FLAG);
993: XNP_WSGL.LayoutRowEnd;
994: XNP_WSGL.LayoutRowStart('TOP');

Line 991: XNP_WSGL.LayoutData(htf.bold('Don. Authorized?:'));

987: XNP_WSGL.LayoutData(htf.bold('Rec. Due Date:'));
988: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_DUE_DATE);
989: XNP_WSGL.LayoutRowEnd;
990: XNP_WSGL.LayoutRowStart('TOP');
991: XNP_WSGL.LayoutData(htf.bold('Don. Authorized?:'));
992: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_AUTHORIZATION_FLAG);
993: XNP_WSGL.LayoutRowEnd;
994: XNP_WSGL.LayoutRowStart('TOP');
995: XNP_WSGL.LayoutData(htf.bold('Don. Due Date:'));

Line 992: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_AUTHORIZATION_FLAG);

988: XNP_WSGL.LayoutData(FORM_VAL.NEW_SP_DUE_DATE);
989: XNP_WSGL.LayoutRowEnd;
990: XNP_WSGL.LayoutRowStart('TOP');
991: XNP_WSGL.LayoutData(htf.bold('Don. Authorized?:'));
992: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_AUTHORIZATION_FLAG);
993: XNP_WSGL.LayoutRowEnd;
994: XNP_WSGL.LayoutRowStart('TOP');
995: XNP_WSGL.LayoutData(htf.bold('Don. Due Date:'));
996: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_DUE_DATE);

Line 993: XNP_WSGL.LayoutRowEnd;

989: XNP_WSGL.LayoutRowEnd;
990: XNP_WSGL.LayoutRowStart('TOP');
991: XNP_WSGL.LayoutData(htf.bold('Don. Authorized?:'));
992: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_AUTHORIZATION_FLAG);
993: XNP_WSGL.LayoutRowEnd;
994: XNP_WSGL.LayoutRowStart('TOP');
995: XNP_WSGL.LayoutData(htf.bold('Don. Due Date:'));
996: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_DUE_DATE);
997: XNP_WSGL.LayoutRowEnd;

Line 994: XNP_WSGL.LayoutRowStart('TOP');

990: XNP_WSGL.LayoutRowStart('TOP');
991: XNP_WSGL.LayoutData(htf.bold('Don. Authorized?:'));
992: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_AUTHORIZATION_FLAG);
993: XNP_WSGL.LayoutRowEnd;
994: XNP_WSGL.LayoutRowStart('TOP');
995: XNP_WSGL.LayoutData(htf.bold('Don. Due Date:'));
996: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_DUE_DATE);
997: XNP_WSGL.LayoutRowEnd;
998: XNP_WSGL.LayoutRowStart('TOP');

Line 995: XNP_WSGL.LayoutData(htf.bold('Don. Due Date:'));

991: XNP_WSGL.LayoutData(htf.bold('Don. Authorized?:'));
992: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_AUTHORIZATION_FLAG);
993: XNP_WSGL.LayoutRowEnd;
994: XNP_WSGL.LayoutRowStart('TOP');
995: XNP_WSGL.LayoutData(htf.bold('Don. Due Date:'));
996: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_DUE_DATE);
997: XNP_WSGL.LayoutRowEnd;
998: XNP_WSGL.LayoutRowStart('TOP');
999: XNP_WSGL.LayoutData(htf.bold('Don. Cutoff Due Date:'));

Line 996: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_DUE_DATE);

992: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_AUTHORIZATION_FLAG);
993: XNP_WSGL.LayoutRowEnd;
994: XNP_WSGL.LayoutRowStart('TOP');
995: XNP_WSGL.LayoutData(htf.bold('Don. Due Date:'));
996: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_DUE_DATE);
997: XNP_WSGL.LayoutRowEnd;
998: XNP_WSGL.LayoutRowStart('TOP');
999: XNP_WSGL.LayoutData(htf.bold('Don. Cutoff Due Date:'));
1000: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_CUTOFF_DUE_DATE);

Line 997: XNP_WSGL.LayoutRowEnd;

993: XNP_WSGL.LayoutRowEnd;
994: XNP_WSGL.LayoutRowStart('TOP');
995: XNP_WSGL.LayoutData(htf.bold('Don. Due Date:'));
996: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_DUE_DATE);
997: XNP_WSGL.LayoutRowEnd;
998: XNP_WSGL.LayoutRowStart('TOP');
999: XNP_WSGL.LayoutData(htf.bold('Don. Cutoff Due Date:'));
1000: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_CUTOFF_DUE_DATE);
1001: XNP_WSGL.LayoutRowEnd;

Line 998: XNP_WSGL.LayoutRowStart('TOP');

994: XNP_WSGL.LayoutRowStart('TOP');
995: XNP_WSGL.LayoutData(htf.bold('Don. Due Date:'));
996: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_DUE_DATE);
997: XNP_WSGL.LayoutRowEnd;
998: XNP_WSGL.LayoutRowStart('TOP');
999: XNP_WSGL.LayoutData(htf.bold('Don. Cutoff Due Date:'));
1000: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_CUTOFF_DUE_DATE);
1001: XNP_WSGL.LayoutRowEnd;
1002: XNP_WSGL.LayoutRowStart('TOP');

Line 999: XNP_WSGL.LayoutData(htf.bold('Don. Cutoff Due Date:'));

995: XNP_WSGL.LayoutData(htf.bold('Don. Due Date:'));
996: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_DUE_DATE);
997: XNP_WSGL.LayoutRowEnd;
998: XNP_WSGL.LayoutRowStart('TOP');
999: XNP_WSGL.LayoutData(htf.bold('Don. Cutoff Due Date:'));
1000: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_CUTOFF_DUE_DATE);
1001: XNP_WSGL.LayoutRowEnd;
1002: XNP_WSGL.LayoutRowStart('TOP');
1003: XNP_WSGL.LayoutData(htf.bold('Invoice Due Date:'));

Line 1000: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_CUTOFF_DUE_DATE);

996: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_DUE_DATE);
997: XNP_WSGL.LayoutRowEnd;
998: XNP_WSGL.LayoutRowStart('TOP');
999: XNP_WSGL.LayoutData(htf.bold('Don. Cutoff Due Date:'));
1000: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_CUTOFF_DUE_DATE);
1001: XNP_WSGL.LayoutRowEnd;
1002: XNP_WSGL.LayoutRowStart('TOP');
1003: XNP_WSGL.LayoutData(htf.bold('Invoice Due Date:'));
1004: XNP_WSGL.LayoutData(FORM_VAL.INVOICE_DUE_DATE);

Line 1001: XNP_WSGL.LayoutRowEnd;

997: XNP_WSGL.LayoutRowEnd;
998: XNP_WSGL.LayoutRowStart('TOP');
999: XNP_WSGL.LayoutData(htf.bold('Don. Cutoff Due Date:'));
1000: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_CUTOFF_DUE_DATE);
1001: XNP_WSGL.LayoutRowEnd;
1002: XNP_WSGL.LayoutRowStart('TOP');
1003: XNP_WSGL.LayoutData(htf.bold('Invoice Due Date:'));
1004: XNP_WSGL.LayoutData(FORM_VAL.INVOICE_DUE_DATE);
1005: XNP_WSGL.LayoutRowEnd;

Line 1002: XNP_WSGL.LayoutRowStart('TOP');

998: XNP_WSGL.LayoutRowStart('TOP');
999: XNP_WSGL.LayoutData(htf.bold('Don. Cutoff Due Date:'));
1000: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_CUTOFF_DUE_DATE);
1001: XNP_WSGL.LayoutRowEnd;
1002: XNP_WSGL.LayoutRowStart('TOP');
1003: XNP_WSGL.LayoutData(htf.bold('Invoice Due Date:'));
1004: XNP_WSGL.LayoutData(FORM_VAL.INVOICE_DUE_DATE);
1005: XNP_WSGL.LayoutRowEnd;
1006: XNP_WSGL.LayoutRowStart('TOP');

Line 1003: XNP_WSGL.LayoutData(htf.bold('Invoice Due Date:'));

999: XNP_WSGL.LayoutData(htf.bold('Don. Cutoff Due Date:'));
1000: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_CUTOFF_DUE_DATE);
1001: XNP_WSGL.LayoutRowEnd;
1002: XNP_WSGL.LayoutRowStart('TOP');
1003: XNP_WSGL.LayoutData(htf.bold('Invoice Due Date:'));
1004: XNP_WSGL.LayoutData(FORM_VAL.INVOICE_DUE_DATE);
1005: XNP_WSGL.LayoutRowEnd;
1006: XNP_WSGL.LayoutRowStart('TOP');
1007: XNP_WSGL.LayoutData(htf.bold('Retain Dir Info?:'));

Line 1004: XNP_WSGL.LayoutData(FORM_VAL.INVOICE_DUE_DATE);

1000: XNP_WSGL.LayoutData(FORM_VAL.OLD_SP_CUTOFF_DUE_DATE);
1001: XNP_WSGL.LayoutRowEnd;
1002: XNP_WSGL.LayoutRowStart('TOP');
1003: XNP_WSGL.LayoutData(htf.bold('Invoice Due Date:'));
1004: XNP_WSGL.LayoutData(FORM_VAL.INVOICE_DUE_DATE);
1005: XNP_WSGL.LayoutRowEnd;
1006: XNP_WSGL.LayoutRowStart('TOP');
1007: XNP_WSGL.LayoutData(htf.bold('Retain Dir Info?:'));
1008: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_DIR_INFO_FLAG);

Line 1005: XNP_WSGL.LayoutRowEnd;

1001: XNP_WSGL.LayoutRowEnd;
1002: XNP_WSGL.LayoutRowStart('TOP');
1003: XNP_WSGL.LayoutData(htf.bold('Invoice Due Date:'));
1004: XNP_WSGL.LayoutData(FORM_VAL.INVOICE_DUE_DATE);
1005: XNP_WSGL.LayoutRowEnd;
1006: XNP_WSGL.LayoutRowStart('TOP');
1007: XNP_WSGL.LayoutData(htf.bold('Retain Dir Info?:'));
1008: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_DIR_INFO_FLAG);
1009: XNP_WSGL.LayoutRowEnd;

Line 1006: XNP_WSGL.LayoutRowStart('TOP');

1002: XNP_WSGL.LayoutRowStart('TOP');
1003: XNP_WSGL.LayoutData(htf.bold('Invoice Due Date:'));
1004: XNP_WSGL.LayoutData(FORM_VAL.INVOICE_DUE_DATE);
1005: XNP_WSGL.LayoutRowEnd;
1006: XNP_WSGL.LayoutRowStart('TOP');
1007: XNP_WSGL.LayoutData(htf.bold('Retain Dir Info?:'));
1008: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_DIR_INFO_FLAG);
1009: XNP_WSGL.LayoutRowEnd;
1010: XNP_WSGL.LayoutRowStart('TOP');

Line 1007: XNP_WSGL.LayoutData(htf.bold('Retain Dir Info?:'));

1003: XNP_WSGL.LayoutData(htf.bold('Invoice Due Date:'));
1004: XNP_WSGL.LayoutData(FORM_VAL.INVOICE_DUE_DATE);
1005: XNP_WSGL.LayoutRowEnd;
1006: XNP_WSGL.LayoutRowStart('TOP');
1007: XNP_WSGL.LayoutData(htf.bold('Retain Dir Info?:'));
1008: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_DIR_INFO_FLAG);
1009: XNP_WSGL.LayoutRowEnd;
1010: XNP_WSGL.LayoutRowStart('TOP');
1011: XNP_WSGL.LayoutData(htf.bold('Update Allowed?:'));

Line 1008: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_DIR_INFO_FLAG);

1004: XNP_WSGL.LayoutData(FORM_VAL.INVOICE_DUE_DATE);
1005: XNP_WSGL.LayoutRowEnd;
1006: XNP_WSGL.LayoutRowStart('TOP');
1007: XNP_WSGL.LayoutData(htf.bold('Retain Dir Info?:'));
1008: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_DIR_INFO_FLAG);
1009: XNP_WSGL.LayoutRowEnd;
1010: XNP_WSGL.LayoutRowStart('TOP');
1011: XNP_WSGL.LayoutData(htf.bold('Update Allowed?:'));
1012: XNP_WSGL.LayoutData(FORM_VAL.LOCKED_FLAG);

Line 1009: XNP_WSGL.LayoutRowEnd;

1005: XNP_WSGL.LayoutRowEnd;
1006: XNP_WSGL.LayoutRowStart('TOP');
1007: XNP_WSGL.LayoutData(htf.bold('Retain Dir Info?:'));
1008: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_DIR_INFO_FLAG);
1009: XNP_WSGL.LayoutRowEnd;
1010: XNP_WSGL.LayoutRowStart('TOP');
1011: XNP_WSGL.LayoutData(htf.bold('Update Allowed?:'));
1012: XNP_WSGL.LayoutData(FORM_VAL.LOCKED_FLAG);
1013: XNP_WSGL.LayoutRowEnd;

Line 1010: XNP_WSGL.LayoutRowStart('TOP');

1006: XNP_WSGL.LayoutRowStart('TOP');
1007: XNP_WSGL.LayoutData(htf.bold('Retain Dir Info?:'));
1008: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_DIR_INFO_FLAG);
1009: XNP_WSGL.LayoutRowEnd;
1010: XNP_WSGL.LayoutRowStart('TOP');
1011: XNP_WSGL.LayoutData(htf.bold('Update Allowed?:'));
1012: XNP_WSGL.LayoutData(FORM_VAL.LOCKED_FLAG);
1013: XNP_WSGL.LayoutRowEnd;
1014: XNP_WSGL.LayoutRowStart('TOP');

Line 1011: XNP_WSGL.LayoutData(htf.bold('Update Allowed?:'));

1007: XNP_WSGL.LayoutData(htf.bold('Retain Dir Info?:'));
1008: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_DIR_INFO_FLAG);
1009: XNP_WSGL.LayoutRowEnd;
1010: XNP_WSGL.LayoutRowStart('TOP');
1011: XNP_WSGL.LayoutData(htf.bold('Update Allowed?:'));
1012: XNP_WSGL.LayoutData(FORM_VAL.LOCKED_FLAG);
1013: XNP_WSGL.LayoutRowEnd;
1014: XNP_WSGL.LayoutRowStart('TOP');
1015: XNP_WSGL.LayoutData(htf.bold('Porting To Original?:'));

Line 1012: XNP_WSGL.LayoutData(FORM_VAL.LOCKED_FLAG);

1008: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_DIR_INFO_FLAG);
1009: XNP_WSGL.LayoutRowEnd;
1010: XNP_WSGL.LayoutRowStart('TOP');
1011: XNP_WSGL.LayoutData(htf.bold('Update Allowed?:'));
1012: XNP_WSGL.LayoutData(FORM_VAL.LOCKED_FLAG);
1013: XNP_WSGL.LayoutRowEnd;
1014: XNP_WSGL.LayoutRowStart('TOP');
1015: XNP_WSGL.LayoutData(htf.bold('Porting To Original?:'));
1016: XNP_WSGL.LayoutData(FORM_VAL.PTO_FLAG);

Line 1013: XNP_WSGL.LayoutRowEnd;

1009: XNP_WSGL.LayoutRowEnd;
1010: XNP_WSGL.LayoutRowStart('TOP');
1011: XNP_WSGL.LayoutData(htf.bold('Update Allowed?:'));
1012: XNP_WSGL.LayoutData(FORM_VAL.LOCKED_FLAG);
1013: XNP_WSGL.LayoutRowEnd;
1014: XNP_WSGL.LayoutRowStart('TOP');
1015: XNP_WSGL.LayoutData(htf.bold('Porting To Original?:'));
1016: XNP_WSGL.LayoutData(FORM_VAL.PTO_FLAG);
1017: XNP_WSGL.LayoutRowEnd;

Line 1014: XNP_WSGL.LayoutRowStart('TOP');

1010: XNP_WSGL.LayoutRowStart('TOP');
1011: XNP_WSGL.LayoutData(htf.bold('Update Allowed?:'));
1012: XNP_WSGL.LayoutData(FORM_VAL.LOCKED_FLAG);
1013: XNP_WSGL.LayoutRowEnd;
1014: XNP_WSGL.LayoutRowStart('TOP');
1015: XNP_WSGL.LayoutData(htf.bold('Porting To Original?:'));
1016: XNP_WSGL.LayoutData(FORM_VAL.PTO_FLAG);
1017: XNP_WSGL.LayoutRowEnd;
1018: XNP_WSGL.LayoutRowStart('TOP');

Line 1015: XNP_WSGL.LayoutData(htf.bold('Porting To Original?:'));

1011: XNP_WSGL.LayoutData(htf.bold('Update Allowed?:'));
1012: XNP_WSGL.LayoutData(FORM_VAL.LOCKED_FLAG);
1013: XNP_WSGL.LayoutRowEnd;
1014: XNP_WSGL.LayoutRowStart('TOP');
1015: XNP_WSGL.LayoutData(htf.bold('Porting To Original?:'));
1016: XNP_WSGL.LayoutData(FORM_VAL.PTO_FLAG);
1017: XNP_WSGL.LayoutRowEnd;
1018: XNP_WSGL.LayoutRowStart('TOP');
1019: XNP_WSGL.LayoutData(htf.bold('Disconnect Due Date:'));

Line 1016: XNP_WSGL.LayoutData(FORM_VAL.PTO_FLAG);

1012: XNP_WSGL.LayoutData(FORM_VAL.LOCKED_FLAG);
1013: XNP_WSGL.LayoutRowEnd;
1014: XNP_WSGL.LayoutRowStart('TOP');
1015: XNP_WSGL.LayoutData(htf.bold('Porting To Original?:'));
1016: XNP_WSGL.LayoutData(FORM_VAL.PTO_FLAG);
1017: XNP_WSGL.LayoutRowEnd;
1018: XNP_WSGL.LayoutRowStart('TOP');
1019: XNP_WSGL.LayoutData(htf.bold('Disconnect Due Date:'));
1020: XNP_WSGL.LayoutData(FORM_VAL.DISCONNECT_DUE_DATE);

Line 1017: XNP_WSGL.LayoutRowEnd;

1013: XNP_WSGL.LayoutRowEnd;
1014: XNP_WSGL.LayoutRowStart('TOP');
1015: XNP_WSGL.LayoutData(htf.bold('Porting To Original?:'));
1016: XNP_WSGL.LayoutData(FORM_VAL.PTO_FLAG);
1017: XNP_WSGL.LayoutRowEnd;
1018: XNP_WSGL.LayoutRowStart('TOP');
1019: XNP_WSGL.LayoutData(htf.bold('Disconnect Due Date:'));
1020: XNP_WSGL.LayoutData(FORM_VAL.DISCONNECT_DUE_DATE);
1021: XNP_WSGL.LayoutRowEnd;

Line 1018: XNP_WSGL.LayoutRowStart('TOP');

1014: XNP_WSGL.LayoutRowStart('TOP');
1015: XNP_WSGL.LayoutData(htf.bold('Porting To Original?:'));
1016: XNP_WSGL.LayoutData(FORM_VAL.PTO_FLAG);
1017: XNP_WSGL.LayoutRowEnd;
1018: XNP_WSGL.LayoutRowStart('TOP');
1019: XNP_WSGL.LayoutData(htf.bold('Disconnect Due Date:'));
1020: XNP_WSGL.LayoutData(FORM_VAL.DISCONNECT_DUE_DATE);
1021: XNP_WSGL.LayoutRowEnd;
1022: XNP_WSGL.LayoutRowStart('TOP');

Line 1019: XNP_WSGL.LayoutData(htf.bold('Disconnect Due Date:'));

1015: XNP_WSGL.LayoutData(htf.bold('Porting To Original?:'));
1016: XNP_WSGL.LayoutData(FORM_VAL.PTO_FLAG);
1017: XNP_WSGL.LayoutRowEnd;
1018: XNP_WSGL.LayoutRowStart('TOP');
1019: XNP_WSGL.LayoutData(htf.bold('Disconnect Due Date:'));
1020: XNP_WSGL.LayoutData(FORM_VAL.DISCONNECT_DUE_DATE);
1021: XNP_WSGL.LayoutRowEnd;
1022: XNP_WSGL.LayoutRowStart('TOP');
1023: XNP_WSGL.LayoutData(htf.bold('Eff. Release Due Date:'));

Line 1020: XNP_WSGL.LayoutData(FORM_VAL.DISCONNECT_DUE_DATE);

1016: XNP_WSGL.LayoutData(FORM_VAL.PTO_FLAG);
1017: XNP_WSGL.LayoutRowEnd;
1018: XNP_WSGL.LayoutRowStart('TOP');
1019: XNP_WSGL.LayoutData(htf.bold('Disconnect Due Date:'));
1020: XNP_WSGL.LayoutData(FORM_VAL.DISCONNECT_DUE_DATE);
1021: XNP_WSGL.LayoutRowEnd;
1022: XNP_WSGL.LayoutRowStart('TOP');
1023: XNP_WSGL.LayoutData(htf.bold('Eff. Release Due Date:'));
1024: XNP_WSGL.LayoutData(FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE);

Line 1021: XNP_WSGL.LayoutRowEnd;

1017: XNP_WSGL.LayoutRowEnd;
1018: XNP_WSGL.LayoutRowStart('TOP');
1019: XNP_WSGL.LayoutData(htf.bold('Disconnect Due Date:'));
1020: XNP_WSGL.LayoutData(FORM_VAL.DISCONNECT_DUE_DATE);
1021: XNP_WSGL.LayoutRowEnd;
1022: XNP_WSGL.LayoutRowStart('TOP');
1023: XNP_WSGL.LayoutData(htf.bold('Eff. Release Due Date:'));
1024: XNP_WSGL.LayoutData(FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE);
1025: XNP_WSGL.LayoutRowEnd;

Line 1022: XNP_WSGL.LayoutRowStart('TOP');

1018: XNP_WSGL.LayoutRowStart('TOP');
1019: XNP_WSGL.LayoutData(htf.bold('Disconnect Due Date:'));
1020: XNP_WSGL.LayoutData(FORM_VAL.DISCONNECT_DUE_DATE);
1021: XNP_WSGL.LayoutRowEnd;
1022: XNP_WSGL.LayoutRowStart('TOP');
1023: XNP_WSGL.LayoutData(htf.bold('Eff. Release Due Date:'));
1024: XNP_WSGL.LayoutData(FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE);
1025: XNP_WSGL.LayoutRowEnd;
1026: XNP_WSGL.LayoutRowStart('TOP');

Line 1023: XNP_WSGL.LayoutData(htf.bold('Eff. Release Due Date:'));

1019: XNP_WSGL.LayoutData(htf.bold('Disconnect Due Date:'));
1020: XNP_WSGL.LayoutData(FORM_VAL.DISCONNECT_DUE_DATE);
1021: XNP_WSGL.LayoutRowEnd;
1022: XNP_WSGL.LayoutRowStart('TOP');
1023: XNP_WSGL.LayoutData(htf.bold('Eff. Release Due Date:'));
1024: XNP_WSGL.LayoutData(FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE);
1025: XNP_WSGL.LayoutRowEnd;
1026: XNP_WSGL.LayoutRowStart('TOP');
1027: XNP_WSGL.LayoutData(htf.bold('Retain Number?:'));

Line 1024: XNP_WSGL.LayoutData(FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE);

1020: XNP_WSGL.LayoutData(FORM_VAL.DISCONNECT_DUE_DATE);
1021: XNP_WSGL.LayoutRowEnd;
1022: XNP_WSGL.LayoutRowStart('TOP');
1023: XNP_WSGL.LayoutData(htf.bold('Eff. Release Due Date:'));
1024: XNP_WSGL.LayoutData(FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE);
1025: XNP_WSGL.LayoutRowEnd;
1026: XNP_WSGL.LayoutRowStart('TOP');
1027: XNP_WSGL.LayoutData(htf.bold('Retain Number?:'));
1028: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_TN_FLAG);

Line 1025: XNP_WSGL.LayoutRowEnd;

1021: XNP_WSGL.LayoutRowEnd;
1022: XNP_WSGL.LayoutRowStart('TOP');
1023: XNP_WSGL.LayoutData(htf.bold('Eff. Release Due Date:'));
1024: XNP_WSGL.LayoutData(FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE);
1025: XNP_WSGL.LayoutRowEnd;
1026: XNP_WSGL.LayoutRowStart('TOP');
1027: XNP_WSGL.LayoutData(htf.bold('Retain Number?:'));
1028: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_TN_FLAG);
1029: XNP_WSGL.LayoutRowEnd;

Line 1026: XNP_WSGL.LayoutRowStart('TOP');

1022: XNP_WSGL.LayoutRowStart('TOP');
1023: XNP_WSGL.LayoutData(htf.bold('Eff. Release Due Date:'));
1024: XNP_WSGL.LayoutData(FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE);
1025: XNP_WSGL.LayoutRowEnd;
1026: XNP_WSGL.LayoutRowStart('TOP');
1027: XNP_WSGL.LayoutData(htf.bold('Retain Number?:'));
1028: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_TN_FLAG);
1029: XNP_WSGL.LayoutRowEnd;
1030: XNP_WSGL.LayoutRowStart('TOP');

Line 1027: XNP_WSGL.LayoutData(htf.bold('Retain Number?:'));

1023: XNP_WSGL.LayoutData(htf.bold('Eff. Release Due Date:'));
1024: XNP_WSGL.LayoutData(FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE);
1025: XNP_WSGL.LayoutRowEnd;
1026: XNP_WSGL.LayoutRowStart('TOP');
1027: XNP_WSGL.LayoutData(htf.bold('Retain Number?:'));
1028: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_TN_FLAG);
1029: XNP_WSGL.LayoutRowEnd;
1030: XNP_WSGL.LayoutRowStart('TOP');
1031: XNP_WSGL.LayoutData(htf.bold('Number Blocked?:'));

Line 1028: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_TN_FLAG);

1024: XNP_WSGL.LayoutData(FORM_VAL.EFFECTIVE_RELEASE_DUE_DATE);
1025: XNP_WSGL.LayoutRowEnd;
1026: XNP_WSGL.LayoutRowStart('TOP');
1027: XNP_WSGL.LayoutData(htf.bold('Retain Number?:'));
1028: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_TN_FLAG);
1029: XNP_WSGL.LayoutRowEnd;
1030: XNP_WSGL.LayoutRowStart('TOP');
1031: XNP_WSGL.LayoutData(htf.bold('Number Blocked?:'));
1032: XNP_WSGL.LayoutData(FORM_VAL.BLOCKED_FLAG);

Line 1029: XNP_WSGL.LayoutRowEnd;

1025: XNP_WSGL.LayoutRowEnd;
1026: XNP_WSGL.LayoutRowStart('TOP');
1027: XNP_WSGL.LayoutData(htf.bold('Retain Number?:'));
1028: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_TN_FLAG);
1029: XNP_WSGL.LayoutRowEnd;
1030: XNP_WSGL.LayoutRowStart('TOP');
1031: XNP_WSGL.LayoutData(htf.bold('Number Blocked?:'));
1032: XNP_WSGL.LayoutData(FORM_VAL.BLOCKED_FLAG);
1033: XNP_WSGL.LayoutRowEnd;

Line 1030: XNP_WSGL.LayoutRowStart('TOP');

1026: XNP_WSGL.LayoutRowStart('TOP');
1027: XNP_WSGL.LayoutData(htf.bold('Retain Number?:'));
1028: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_TN_FLAG);
1029: XNP_WSGL.LayoutRowEnd;
1030: XNP_WSGL.LayoutRowStart('TOP');
1031: XNP_WSGL.LayoutData(htf.bold('Number Blocked?:'));
1032: XNP_WSGL.LayoutData(FORM_VAL.BLOCKED_FLAG);
1033: XNP_WSGL.LayoutRowEnd;
1034: XNP_WSGL.LayoutRowStart('TOP');

Line 1031: XNP_WSGL.LayoutData(htf.bold('Number Blocked?:'));

1027: XNP_WSGL.LayoutData(htf.bold('Retain Number?:'));
1028: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_TN_FLAG);
1029: XNP_WSGL.LayoutRowEnd;
1030: XNP_WSGL.LayoutRowStart('TOP');
1031: XNP_WSGL.LayoutData(htf.bold('Number Blocked?:'));
1032: XNP_WSGL.LayoutData(FORM_VAL.BLOCKED_FLAG);
1033: XNP_WSGL.LayoutRowEnd;
1034: XNP_WSGL.LayoutRowStart('TOP');
1035: XNP_WSGL.LayoutData(htf.bold('Number Return Due Date:'));

Line 1032: XNP_WSGL.LayoutData(FORM_VAL.BLOCKED_FLAG);

1028: XNP_WSGL.LayoutData(FORM_VAL.RETAIN_TN_FLAG);
1029: XNP_WSGL.LayoutRowEnd;
1030: XNP_WSGL.LayoutRowStart('TOP');
1031: XNP_WSGL.LayoutData(htf.bold('Number Blocked?:'));
1032: XNP_WSGL.LayoutData(FORM_VAL.BLOCKED_FLAG);
1033: XNP_WSGL.LayoutRowEnd;
1034: XNP_WSGL.LayoutRowStart('TOP');
1035: XNP_WSGL.LayoutData(htf.bold('Number Return Due Date:'));
1036: XNP_WSGL.LayoutData(FORM_VAL.NUMBER_RETURNED_DUE_DATE);

Line 1033: XNP_WSGL.LayoutRowEnd;

1029: XNP_WSGL.LayoutRowEnd;
1030: XNP_WSGL.LayoutRowStart('TOP');
1031: XNP_WSGL.LayoutData(htf.bold('Number Blocked?:'));
1032: XNP_WSGL.LayoutData(FORM_VAL.BLOCKED_FLAG);
1033: XNP_WSGL.LayoutRowEnd;
1034: XNP_WSGL.LayoutRowStart('TOP');
1035: XNP_WSGL.LayoutData(htf.bold('Number Return Due Date:'));
1036: XNP_WSGL.LayoutData(FORM_VAL.NUMBER_RETURNED_DUE_DATE);
1037: XNP_WSGL.LayoutRowEnd;

Line 1034: XNP_WSGL.LayoutRowStart('TOP');

1030: XNP_WSGL.LayoutRowStart('TOP');
1031: XNP_WSGL.LayoutData(htf.bold('Number Blocked?:'));
1032: XNP_WSGL.LayoutData(FORM_VAL.BLOCKED_FLAG);
1033: XNP_WSGL.LayoutRowEnd;
1034: XNP_WSGL.LayoutRowStart('TOP');
1035: XNP_WSGL.LayoutData(htf.bold('Number Return Due Date:'));
1036: XNP_WSGL.LayoutData(FORM_VAL.NUMBER_RETURNED_DUE_DATE);
1037: XNP_WSGL.LayoutRowEnd;
1038: if NBT_VAL.DSP_CNAM is not null then

Line 1035: XNP_WSGL.LayoutData(htf.bold('Number Return Due Date:'));

1031: XNP_WSGL.LayoutData(htf.bold('Number Blocked?:'));
1032: XNP_WSGL.LayoutData(FORM_VAL.BLOCKED_FLAG);
1033: XNP_WSGL.LayoutRowEnd;
1034: XNP_WSGL.LayoutRowStart('TOP');
1035: XNP_WSGL.LayoutData(htf.bold('Number Return Due Date:'));
1036: XNP_WSGL.LayoutData(FORM_VAL.NUMBER_RETURNED_DUE_DATE);
1037: XNP_WSGL.LayoutRowEnd;
1038: if NBT_VAL.DSP_CNAM is not null then
1039: XNP_WSGL.LayoutRowStart('TOP');

Line 1036: XNP_WSGL.LayoutData(FORM_VAL.NUMBER_RETURNED_DUE_DATE);

1032: XNP_WSGL.LayoutData(FORM_VAL.BLOCKED_FLAG);
1033: XNP_WSGL.LayoutRowEnd;
1034: XNP_WSGL.LayoutRowStart('TOP');
1035: XNP_WSGL.LayoutData(htf.bold('Number Return Due Date:'));
1036: XNP_WSGL.LayoutData(FORM_VAL.NUMBER_RETURNED_DUE_DATE);
1037: XNP_WSGL.LayoutRowEnd;
1038: if NBT_VAL.DSP_CNAM is not null then
1039: XNP_WSGL.LayoutRowStart('TOP');
1040: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));

Line 1037: XNP_WSGL.LayoutRowEnd;

1033: XNP_WSGL.LayoutRowEnd;
1034: XNP_WSGL.LayoutRowStart('TOP');
1035: XNP_WSGL.LayoutData(htf.bold('Number Return Due Date:'));
1036: XNP_WSGL.LayoutData(FORM_VAL.NUMBER_RETURNED_DUE_DATE);
1037: XNP_WSGL.LayoutRowEnd;
1038: if NBT_VAL.DSP_CNAM is not null then
1039: XNP_WSGL.LayoutRowStart('TOP');
1040: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));
1041: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);

Line 1039: XNP_WSGL.LayoutRowStart('TOP');

1035: XNP_WSGL.LayoutData(htf.bold('Number Return Due Date:'));
1036: XNP_WSGL.LayoutData(FORM_VAL.NUMBER_RETURNED_DUE_DATE);
1037: XNP_WSGL.LayoutRowEnd;
1038: if NBT_VAL.DSP_CNAM is not null then
1039: XNP_WSGL.LayoutRowStart('TOP');
1040: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));
1041: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);
1042: XNP_WSGL.LayoutRowEnd;
1043: end if;

Line 1040: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));

1036: XNP_WSGL.LayoutData(FORM_VAL.NUMBER_RETURNED_DUE_DATE);
1037: XNP_WSGL.LayoutRowEnd;
1038: if NBT_VAL.DSP_CNAM is not null then
1039: XNP_WSGL.LayoutRowStart('TOP');
1040: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));
1041: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);
1042: XNP_WSGL.LayoutRowEnd;
1043: end if;
1044: if NBT_VAL.DSP_CLASS is not null then

Line 1041: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);

1037: XNP_WSGL.LayoutRowEnd;
1038: if NBT_VAL.DSP_CNAM is not null then
1039: XNP_WSGL.LayoutRowStart('TOP');
1040: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));
1041: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);
1042: XNP_WSGL.LayoutRowEnd;
1043: end if;
1044: if NBT_VAL.DSP_CLASS is not null then
1045: XNP_WSGL.LayoutRowStart('TOP');

Line 1042: XNP_WSGL.LayoutRowEnd;

1038: if NBT_VAL.DSP_CNAM is not null then
1039: XNP_WSGL.LayoutRowStart('TOP');
1040: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));
1041: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);
1042: XNP_WSGL.LayoutRowEnd;
1043: end if;
1044: if NBT_VAL.DSP_CLASS is not null then
1045: XNP_WSGL.LayoutRowStart('TOP');
1046: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));

Line 1045: XNP_WSGL.LayoutRowStart('TOP');

1041: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);
1042: XNP_WSGL.LayoutRowEnd;
1043: end if;
1044: if NBT_VAL.DSP_CLASS is not null then
1045: XNP_WSGL.LayoutRowStart('TOP');
1046: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));
1047: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);
1048: XNP_WSGL.LayoutRowEnd;
1049: end if;

Line 1046: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));

1042: XNP_WSGL.LayoutRowEnd;
1043: end if;
1044: if NBT_VAL.DSP_CLASS is not null then
1045: XNP_WSGL.LayoutRowStart('TOP');
1046: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));
1047: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);
1048: XNP_WSGL.LayoutRowEnd;
1049: end if;
1050: if NBT_VAL.DSP_ISVM is not null then

Line 1047: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);

1043: end if;
1044: if NBT_VAL.DSP_CLASS is not null then
1045: XNP_WSGL.LayoutRowStart('TOP');
1046: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));
1047: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);
1048: XNP_WSGL.LayoutRowEnd;
1049: end if;
1050: if NBT_VAL.DSP_ISVM is not null then
1051: XNP_WSGL.LayoutRowStart('TOP');

Line 1048: XNP_WSGL.LayoutRowEnd;

1044: if NBT_VAL.DSP_CLASS is not null then
1045: XNP_WSGL.LayoutRowStart('TOP');
1046: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));
1047: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);
1048: XNP_WSGL.LayoutRowEnd;
1049: end if;
1050: if NBT_VAL.DSP_ISVM is not null then
1051: XNP_WSGL.LayoutRowStart('TOP');
1052: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));

Line 1051: XNP_WSGL.LayoutRowStart('TOP');

1047: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);
1048: XNP_WSGL.LayoutRowEnd;
1049: end if;
1050: if NBT_VAL.DSP_ISVM is not null then
1051: XNP_WSGL.LayoutRowStart('TOP');
1052: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));
1053: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);
1054: XNP_WSGL.LayoutRowEnd;
1055: end if;

Line 1052: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));

1048: XNP_WSGL.LayoutRowEnd;
1049: end if;
1050: if NBT_VAL.DSP_ISVM is not null then
1051: XNP_WSGL.LayoutRowStart('TOP');
1052: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));
1053: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);
1054: XNP_WSGL.LayoutRowEnd;
1055: end if;
1056: if NBT_VAL.DSP_LIDB is not null then

Line 1053: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);

1049: end if;
1050: if NBT_VAL.DSP_ISVM is not null then
1051: XNP_WSGL.LayoutRowStart('TOP');
1052: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));
1053: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);
1054: XNP_WSGL.LayoutRowEnd;
1055: end if;
1056: if NBT_VAL.DSP_LIDB is not null then
1057: XNP_WSGL.LayoutRowStart('TOP');

Line 1054: XNP_WSGL.LayoutRowEnd;

1050: if NBT_VAL.DSP_ISVM is not null then
1051: XNP_WSGL.LayoutRowStart('TOP');
1052: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));
1053: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);
1054: XNP_WSGL.LayoutRowEnd;
1055: end if;
1056: if NBT_VAL.DSP_LIDB is not null then
1057: XNP_WSGL.LayoutRowStart('TOP');
1058: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));

Line 1057: XNP_WSGL.LayoutRowStart('TOP');

1053: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);
1054: XNP_WSGL.LayoutRowEnd;
1055: end if;
1056: if NBT_VAL.DSP_LIDB is not null then
1057: XNP_WSGL.LayoutRowStart('TOP');
1058: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));
1059: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);
1060: XNP_WSGL.LayoutRowEnd;
1061: end if;

Line 1058: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));

1054: XNP_WSGL.LayoutRowEnd;
1055: end if;
1056: if NBT_VAL.DSP_LIDB is not null then
1057: XNP_WSGL.LayoutRowStart('TOP');
1058: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));
1059: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);
1060: XNP_WSGL.LayoutRowEnd;
1061: end if;
1062: if NBT_VAL.DSP_WSMSC is not null then

Line 1059: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);

1055: end if;
1056: if NBT_VAL.DSP_LIDB is not null then
1057: XNP_WSGL.LayoutRowStart('TOP');
1058: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));
1059: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);
1060: XNP_WSGL.LayoutRowEnd;
1061: end if;
1062: if NBT_VAL.DSP_WSMSC is not null then
1063: XNP_WSGL.LayoutRowStart('TOP');

Line 1060: XNP_WSGL.LayoutRowEnd;

1056: if NBT_VAL.DSP_LIDB is not null then
1057: XNP_WSGL.LayoutRowStart('TOP');
1058: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));
1059: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);
1060: XNP_WSGL.LayoutRowEnd;
1061: end if;
1062: if NBT_VAL.DSP_WSMSC is not null then
1063: XNP_WSGL.LayoutRowStart('TOP');
1064: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));

Line 1063: XNP_WSGL.LayoutRowStart('TOP');

1059: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);
1060: XNP_WSGL.LayoutRowEnd;
1061: end if;
1062: if NBT_VAL.DSP_WSMSC is not null then
1063: XNP_WSGL.LayoutRowStart('TOP');
1064: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));
1065: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);
1066: XNP_WSGL.LayoutRowEnd;
1067: end if;

Line 1064: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));

1060: XNP_WSGL.LayoutRowEnd;
1061: end if;
1062: if NBT_VAL.DSP_WSMSC is not null then
1063: XNP_WSGL.LayoutRowStart('TOP');
1064: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));
1065: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);
1066: XNP_WSGL.LayoutRowEnd;
1067: end if;
1068: if NBT_VAL.DSP_RN is not null then

Line 1065: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);

1061: end if;
1062: if NBT_VAL.DSP_WSMSC is not null then
1063: XNP_WSGL.LayoutRowStart('TOP');
1064: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));
1065: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);
1066: XNP_WSGL.LayoutRowEnd;
1067: end if;
1068: if NBT_VAL.DSP_RN is not null then
1069: XNP_WSGL.LayoutRowStart('TOP');

Line 1066: XNP_WSGL.LayoutRowEnd;

1062: if NBT_VAL.DSP_WSMSC is not null then
1063: XNP_WSGL.LayoutRowStart('TOP');
1064: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));
1065: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);
1066: XNP_WSGL.LayoutRowEnd;
1067: end if;
1068: if NBT_VAL.DSP_RN is not null then
1069: XNP_WSGL.LayoutRowStart('TOP');
1070: XNP_WSGL.LayoutData(htf.bold('RN Details:'));

Line 1069: XNP_WSGL.LayoutRowStart('TOP');

1065: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);
1066: XNP_WSGL.LayoutRowEnd;
1067: end if;
1068: if NBT_VAL.DSP_RN is not null then
1069: XNP_WSGL.LayoutRowStart('TOP');
1070: XNP_WSGL.LayoutData(htf.bold('RN Details:'));
1071: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);
1072: XNP_WSGL.LayoutRowEnd;
1073: end if;

Line 1070: XNP_WSGL.LayoutData(htf.bold('RN Details:'));

1066: XNP_WSGL.LayoutRowEnd;
1067: end if;
1068: if NBT_VAL.DSP_RN is not null then
1069: XNP_WSGL.LayoutRowStart('TOP');
1070: XNP_WSGL.LayoutData(htf.bold('RN Details:'));
1071: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);
1072: XNP_WSGL.LayoutRowEnd;
1073: end if;
1074:

Line 1071: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);

1067: end if;
1068: if NBT_VAL.DSP_RN is not null then
1069: XNP_WSGL.LayoutRowStart('TOP');
1070: XNP_WSGL.LayoutData(htf.bold('RN Details:'));
1071: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);
1072: XNP_WSGL.LayoutRowEnd;
1073: end if;
1074:
1075: XNP_WSGL.LayoutClose;

Line 1072: XNP_WSGL.LayoutRowEnd;

1068: if NBT_VAL.DSP_RN is not null then
1069: XNP_WSGL.LayoutRowStart('TOP');
1070: XNP_WSGL.LayoutData(htf.bold('RN Details:'));
1071: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);
1072: XNP_WSGL.LayoutRowEnd;
1073: end if;
1074:
1075: XNP_WSGL.LayoutClose;
1076:

Line 1075: XNP_WSGL.LayoutClose;

1071: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);
1072: XNP_WSGL.LayoutRowEnd;
1073: end if;
1074:
1075: XNP_WSGL.LayoutClose;
1076:
1077:
1078:
1079:

Line 1081: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SOA_ID));

1077:
1078:
1079:
1080: SOA_EVENTS_CHCK :=
1081: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SOA_ID));
1082: SOA_ORDERS_CHCK :=
1083: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SOA_ID));
1084:
1085:

Line 1083: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SOA_ID));

1079:
1080: SOA_EVENTS_CHCK :=
1081: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SOA_ID));
1082: SOA_ORDERS_CHCK :=
1083: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SOA_ID));
1084:
1085:
1086: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Event History',
1087: 0, 'xnp_sv_orders$soa_events.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_EVENTS_CHCK);

Line 1086: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Event History',

1082: SOA_ORDERS_CHCK :=
1083: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SOA_ID));
1084:
1085:
1086: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Event History',
1087: 0, 'xnp_sv_orders$soa_events.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_EVENTS_CHCK);
1088: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
1089: 0, 'xnp_sv_orders$soa_orders.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_ORDERS_CHCK);
1090: XNP_WSGL.NavLinks;

Line 1087: 0, 'xnp_sv_orders$soa_events.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_EVENTS_CHCK);

1083: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SOA_ID));
1084:
1085:
1086: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Event History',
1087: 0, 'xnp_sv_orders$soa_events.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_EVENTS_CHCK);
1088: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
1089: 0, 'xnp_sv_orders$soa_orders.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_ORDERS_CHCK);
1090: XNP_WSGL.NavLinks;
1091:

Line 1088: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',

1084:
1085:
1086: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Event History',
1087: 0, 'xnp_sv_orders$soa_events.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_EVENTS_CHCK);
1088: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
1089: 0, 'xnp_sv_orders$soa_orders.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_ORDERS_CHCK);
1090: XNP_WSGL.NavLinks;
1091:
1092:

Line 1089: 0, 'xnp_sv_orders$soa_orders.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_ORDERS_CHCK);

1085:
1086: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Event History',
1087: 0, 'xnp_sv_orders$soa_events.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_EVENTS_CHCK);
1088: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
1089: 0, 'xnp_sv_orders$soa_orders.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_ORDERS_CHCK);
1090: XNP_WSGL.NavLinks;
1091:
1092:
1093: XNP_WSGL.ClosePageBody;

Line 1090: XNP_WSGL.NavLinks;

1086: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Event History',
1087: 0, 'xnp_sv_orders$soa_events.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_EVENTS_CHCK);
1088: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
1089: 0, 'xnp_sv_orders$soa_orders.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_ORDERS_CHCK);
1090: XNP_WSGL.NavLinks;
1091:
1092:
1093: XNP_WSGL.ClosePageBody;
1094:

Line 1093: XNP_WSGL.ClosePageBody;

1089: 0, 'xnp_sv_orders$soa_orders.startup?P_SV_SOA_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SOA_ID)||'&Z_CHK='||SOA_ORDERS_CHCK);
1090: XNP_WSGL.NavLinks;
1091:
1092:
1093: XNP_WSGL.ClosePageBody;
1094:
1095: exception
1096: when others then
1097: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

Line 1097: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

1093: XNP_WSGL.ClosePageBody;
1094:
1095: exception
1096: when others then
1097: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1098: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.FormView');
1099: XNP_WSGL.ClosePageBody;
1100: end;
1101:

Line 1099: XNP_WSGL.ClosePageBody;

1095: exception
1096: when others then
1097: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1098: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.FormView');
1099: XNP_WSGL.ClosePageBody;
1100: end;
1101:
1102: --------------------------------------------------------------------------------
1103: -- Name: xnp_sv_orders$soa_sv.QueryView

Line 1118: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryview');

1114: Z_DIRECT_CALL in boolean,
1115: Z_CHK in varchar2) is
1116: begin
1117:
1118: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryview');
1119: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
1120: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1121: if not Z_DIRECT_CALL then
1122: if not XNP_WSGL.ValidateChecksum('' ||

Line 1119: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);

1115: Z_CHK in varchar2) is
1116: begin
1117:
1118: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryview');
1119: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
1120: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1121: if not Z_DIRECT_CALL then
1122: if not XNP_WSGL.ValidateChecksum('' ||
1123: P_SV_SOA_ID, Z_CHK) then

Line 1120: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

1116: begin
1117:
1118: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryview');
1119: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
1120: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1121: if not Z_DIRECT_CALL then
1122: if not XNP_WSGL.ValidateChecksum('' ||
1123: P_SV_SOA_ID, Z_CHK) then
1124: return;

Line 1122: if not XNP_WSGL.ValidateChecksum('' ||

1118: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryview');
1119: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
1120: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1121: if not Z_DIRECT_CALL then
1122: if not XNP_WSGL.ValidateChecksum('' ||
1123: P_SV_SOA_ID, Z_CHK) then
1124: return;
1125: end if;
1126: end if;

Line 1266: FormView(XNP_WSGL.FORM_STATUS_ERROR);

1262: NBT_VAL.DSP_WSMSC := ('Address : ' || CURR_VAL.WSMSC_ADDRESS || ' - Subsystem : ' || CURR_VAL.WSMSC_SUBSYSTEM);
1263: NBT_VAL.DSP_RN := ('Address : ' || CURR_VAL.RN_ADDRESS || ' - Subsystem : ' || CURR_VAL.RN_SUBSYSTEM);
1264:
1265: if not PostQuery(Z_POST_DML) then
1266: FormView(XNP_WSGL.FORM_STATUS_ERROR);
1267: else
1268: FormView(Z_FORM_STATUS);
1269: end if;
1270:

Line 1273: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),

1269: end if;
1270:
1271: exception
1272: when NO_DATA_FOUND then
1273: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
1274: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
1275: when others then
1276: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1277: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryView');

Line 1276: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

1272: when NO_DATA_FOUND then
1273: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
1274: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
1275: when others then
1276: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1277: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryView');
1278: end;
1279: --------------------------------------------------------------------------------
1280: -- Name: xnp_sv_orders$soa_sv.QueryList

Line 1339: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.querylist');

1335: L_CHECKSUM varchar2(10);
1336:
1337: begin
1338:
1339: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.querylist');
1340: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1341: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1342: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1343: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);

Line 1340: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);

1336:
1337: begin
1338:
1339: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.querylist');
1340: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1341: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1342: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1343: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1344: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);

Line 1341: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);

1337: begin
1338:
1339: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.querylist');
1340: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1341: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1342: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1343: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1344: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1345: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);

Line 1342: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);

1338:
1339: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.querylist');
1340: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1341: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1342: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1343: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1344: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1345: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1346: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);

Line 1343: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);

1339: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.querylist');
1340: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1341: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1342: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1343: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1344: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1345: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1346: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1347: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);

Line 1344: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);

1340: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1341: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1342: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1343: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1344: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1345: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1346: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1347: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1348: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);

Line 1345: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);

1341: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1342: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1343: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1344: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1345: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1346: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1347: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1348: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1349: XNP_WSGL.AddURLParam('Z_START', Z_START);

Line 1346: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);

1342: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1343: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1344: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1345: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1346: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1347: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1348: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1349: XNP_WSGL.AddURLParam('Z_START', Z_START);
1350: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);

Line 1347: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);

1343: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1344: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1345: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1346: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1347: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1348: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1349: XNP_WSGL.AddURLParam('Z_START', Z_START);
1350: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1351: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

Line 1348: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);

1344: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1345: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1346: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1347: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1348: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1349: XNP_WSGL.AddURLParam('Z_START', Z_START);
1350: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1351: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1352: if not Z_DIRECT_CALL then

Line 1349: XNP_WSGL.AddURLParam('Z_START', Z_START);

1345: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1346: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1347: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1348: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1349: XNP_WSGL.AddURLParam('Z_START', Z_START);
1350: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1351: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1352: if not Z_DIRECT_CALL then
1353: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

Line 1350: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);

1346: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1347: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1348: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1349: XNP_WSGL.AddURLParam('Z_START', Z_START);
1350: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1351: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1352: if not Z_DIRECT_CALL then
1353: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1354: return;

Line 1351: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

1347: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1348: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1349: XNP_WSGL.AddURLParam('Z_START', Z_START);
1350: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1351: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1352: if not Z_DIRECT_CALL then
1353: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1354: return;
1355: end if;

Line 1353: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

1349: XNP_WSGL.AddURLParam('Z_START', Z_START);
1350: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1351: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1352: if not Z_DIRECT_CALL then
1353: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1354: return;
1355: end if;
1356: end if;
1357:

Line 1364: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions');

1360: Z_DIRECT_CALL=>TRUE);
1361: return;
1362: end if;
1363:
1364: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions');
1365: CreateListJavaScript;
1366: xnp_sv_orders$.TemplateHeader(TRUE,0);
1367: XNP_WSGL.ClosePageHead;
1368:

Line 1367: XNP_WSGL.ClosePageHead;

1363:
1364: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions');
1365: CreateListJavaScript;
1366: xnp_sv_orders$.TemplateHeader(TRUE,0);
1367: XNP_WSGL.ClosePageHead;
1368:
1369: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
1370:
1371: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or

Line 1369: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);

1365: CreateListJavaScript;
1366: xnp_sv_orders$.TemplateHeader(TRUE,0);
1367: XNP_WSGL.ClosePageHead;
1368:
1369: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
1370:
1371: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
1372: (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
1373: (RL_TOTAL_COUNT_REQD)

Line 1387: XNP_WSGL.ClosePageBody;

1383: P_REC_CODE,
1384: P_DON_CODE,
1385: P_NRC_CODE);
1386: if I_COUNT = -1 then
1387: XNP_WSGL.ClosePageBody;
1388: return;
1389: end if;
1390: end if;
1391:

Line 1394: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT));

1390: end if;
1391:
1392: if (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
1393: RL_TOTAL_COUNT_REQD then
1394: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT));
1395: end if;
1396:
1397: if Z_START IS NULL or (Z_ACTION = RL_FIRST_BUT_ACTION) or (Z_ACTION = RL_FIRST_BUT_CAPTION) then
1398: I_START := 1;

Line 1408: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),

1404: I_START := 1 + (floor((I_COUNT-1)/RL_RECORD_SET_SIZE)*RL_RECORD_SET_SIZE);
1405: elsif Z_ACTION is null and I_START = 1 then
1406: null;
1407: elsif Z_ACTION IS NULL then
1408: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
1409: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', RL_BODY_ATTRIBUTES);
1410: XNP_WSGL.ClosePageBody;
1411: return;
1412: end if;

Line 1410: XNP_WSGL.ClosePageBody;

1406: null;
1407: elsif Z_ACTION IS NULL then
1408: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
1409: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', RL_BODY_ATTRIBUTES);
1410: XNP_WSGL.ClosePageBody;
1411: return;
1412: end if;
1413:
1414: if I_START < 1 then

Line 1437: XNP_WSGL.ClosePageBody;

1433: P_CUSTOMER_NAME,
1434: P_REC_CODE,
1435: P_DON_CODE,
1436: P_NRC_CODE) then
1437: XNP_WSGL.ClosePageBody;
1438: return;
1439: end if;
1440: end if;
1441:

Line 1452: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

1448: P_CUSTOMER_NAME,
1449: P_REC_CODE,
1450: P_DON_CODE,
1451: P_NRC_CODE) then
1452: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1453: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', RL_BODY_ATTRIBUTES);
1454: return;
1455: end if;
1456:

Line 1475: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);

1471: I_TOTAL_ROWS := I_ROWS_FETCHED;
1472:
1473: if I_ROWS_FETCHED <> 0 then
1474:
1475: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1476:
1477: XNP_WSGL.LayoutRowStart;
1478: for i in 1..RL_NUMBER_OF_COLUMNS loop
1479: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');

Line 1477: XNP_WSGL.LayoutRowStart;

1473: if I_ROWS_FETCHED <> 0 then
1474:
1475: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1476:
1477: XNP_WSGL.LayoutRowStart;
1478: for i in 1..RL_NUMBER_OF_COLUMNS loop
1479: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');
1480: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');
1481: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');

Line 1479: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');

1475: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1476:
1477: XNP_WSGL.LayoutRowStart;
1478: for i in 1..RL_NUMBER_OF_COLUMNS loop
1479: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');
1480: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');
1481: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1482: end loop;
1483: XNP_WSGL.LayoutRowEnd;

Line 1480: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');

1476:
1477: XNP_WSGL.LayoutRowStart;
1478: for i in 1..RL_NUMBER_OF_COLUMNS loop
1479: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');
1480: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');
1481: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1482: end loop;
1483: XNP_WSGL.LayoutRowEnd;
1484:

Line 1481: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');

1477: XNP_WSGL.LayoutRowStart;
1478: for i in 1..RL_NUMBER_OF_COLUMNS loop
1479: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');
1480: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');
1481: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1482: end loop;
1483: XNP_WSGL.LayoutRowEnd;
1484:
1485: while I_ROWS_FETCHED <> 0 loop

Line 1483: XNP_WSGL.LayoutRowEnd;

1479: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');
1480: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');
1481: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1482: end loop;
1483: XNP_WSGL.LayoutRowEnd;
1484:
1485: while I_ROWS_FETCHED <> 0 loop
1486:
1487: if I_TOTAL_ROWS >= I_START then

Line 1492: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SOA_ID));

1488: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);
1489: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);
1490: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);
1491: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1492: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SOA_ID));
1493:
1494:
1495: XNP_WSGL.LayoutRowStart('TOP');
1496: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_orders$soa_sv.queryview?P_SV_SOA_ID='||CURR_VAL.SV_SOA_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));

Line 1495: XNP_WSGL.LayoutRowStart('TOP');

1491: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1492: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SOA_ID));
1493:
1494:
1495: XNP_WSGL.LayoutRowStart('TOP');
1496: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_orders$soa_sv.queryview?P_SV_SOA_ID='||CURR_VAL.SV_SOA_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1497: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1498: XNP_WSGL.LayoutData(CURR_VAL.STATUS_DISPLAY_NAME);
1499: XNP_WSGL.LayoutRowEnd;

Line 1496: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_orders$soa_sv.queryview?P_SV_SOA_ID='||CURR_VAL.SV_SOA_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));

1492: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SOA_ID));
1493:
1494:
1495: XNP_WSGL.LayoutRowStart('TOP');
1496: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_orders$soa_sv.queryview?P_SV_SOA_ID='||CURR_VAL.SV_SOA_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1497: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1498: XNP_WSGL.LayoutData(CURR_VAL.STATUS_DISPLAY_NAME);
1499: XNP_WSGL.LayoutRowEnd;
1500:

Line 1497: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);

1493:
1494:
1495: XNP_WSGL.LayoutRowStart('TOP');
1496: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_orders$soa_sv.queryview?P_SV_SOA_ID='||CURR_VAL.SV_SOA_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1497: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1498: XNP_WSGL.LayoutData(CURR_VAL.STATUS_DISPLAY_NAME);
1499: XNP_WSGL.LayoutRowEnd;
1500:
1501: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 1498: XNP_WSGL.LayoutData(CURR_VAL.STATUS_DISPLAY_NAME);

1494:
1495: XNP_WSGL.LayoutRowStart('TOP');
1496: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_orders$soa_sv.queryview?P_SV_SOA_ID='||CURR_VAL.SV_SOA_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1497: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1498: XNP_WSGL.LayoutData(CURR_VAL.STATUS_DISPLAY_NAME);
1499: XNP_WSGL.LayoutRowEnd;
1500:
1501: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1502: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then

Line 1499: XNP_WSGL.LayoutRowEnd;

1495: XNP_WSGL.LayoutRowStart('TOP');
1496: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_orders$soa_sv.queryview?P_SV_SOA_ID='||CURR_VAL.SV_SOA_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1497: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1498: XNP_WSGL.LayoutData(CURR_VAL.STATUS_DISPLAY_NAME);
1499: XNP_WSGL.LayoutRowEnd;
1500:
1501: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1502: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1503: if I_ROWS_FETCHED <> 0 then

Line 1516: XNP_WSGL.LayoutClose;

1512: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
1513:
1514: end loop;
1515:
1516: XNP_WSGL.LayoutClose;
1517:
1518: if I_START = I_TOTAL_ROWS then
1519: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1520: else

Line 1519: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);

1515:
1516: XNP_WSGL.LayoutClose;
1517:
1518: if I_START = I_TOTAL_ROWS then
1519: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1520: else
1521: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
1522: to_char(I_START), to_char(I_TOTAL_ROWS))||
1523: I_OF_TOTAL_TEXT);

Line 1521: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,

1517:
1518: if I_START = I_TOTAL_ROWS then
1519: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1520: else
1521: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
1522: to_char(I_START), to_char(I_TOTAL_ROWS))||
1523: I_OF_TOTAL_TEXT);
1524: end if;
1525: htp.para;

Line 1527: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));

1523: I_OF_TOTAL_TEXT);
1524: end if;
1525: htp.para;
1526: else
1527: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
1528: end if;
1529:
1530: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1531: dbms_sql.close_cursor(I_CURSOR);

Line 1535: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);

1531: dbms_sql.close_cursor(I_CURSOR);
1532: end if;
1533:
1534: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.querylist', cattributes => 'NAME="frmZero"');
1535: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);
1536: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1537: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1538: XNP_WSGL.HiddenField('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1539: XNP_WSGL.HiddenField('P_CUSTOMER_ID', P_CUSTOMER_ID);

Line 1536: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);

1532: end if;
1533:
1534: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.querylist', cattributes => 'NAME="frmZero"');
1535: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);
1536: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1537: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1538: XNP_WSGL.HiddenField('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1539: XNP_WSGL.HiddenField('P_CUSTOMER_ID', P_CUSTOMER_ID);
1540: XNP_WSGL.HiddenField('P_CUSTOMER_NAME', P_CUSTOMER_NAME);

Line 1537: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);

1533:
1534: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.querylist', cattributes => 'NAME="frmZero"');
1535: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);
1536: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1537: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1538: XNP_WSGL.HiddenField('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1539: XNP_WSGL.HiddenField('P_CUSTOMER_ID', P_CUSTOMER_ID);
1540: XNP_WSGL.HiddenField('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1541: XNP_WSGL.HiddenField('P_REC_CODE', P_REC_CODE);

Line 1538: XNP_WSGL.HiddenField('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);

1534: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.querylist', cattributes => 'NAME="frmZero"');
1535: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);
1536: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1537: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1538: XNP_WSGL.HiddenField('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1539: XNP_WSGL.HiddenField('P_CUSTOMER_ID', P_CUSTOMER_ID);
1540: XNP_WSGL.HiddenField('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1541: XNP_WSGL.HiddenField('P_REC_CODE', P_REC_CODE);
1542: XNP_WSGL.HiddenField('P_DON_CODE', P_DON_CODE);

Line 1539: XNP_WSGL.HiddenField('P_CUSTOMER_ID', P_CUSTOMER_ID);

1535: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);
1536: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1537: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1538: XNP_WSGL.HiddenField('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1539: XNP_WSGL.HiddenField('P_CUSTOMER_ID', P_CUSTOMER_ID);
1540: XNP_WSGL.HiddenField('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1541: XNP_WSGL.HiddenField('P_REC_CODE', P_REC_CODE);
1542: XNP_WSGL.HiddenField('P_DON_CODE', P_DON_CODE);
1543: XNP_WSGL.HiddenField('P_NRC_CODE', P_NRC_CODE);

Line 1540: XNP_WSGL.HiddenField('P_CUSTOMER_NAME', P_CUSTOMER_NAME);

1536: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1537: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1538: XNP_WSGL.HiddenField('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1539: XNP_WSGL.HiddenField('P_CUSTOMER_ID', P_CUSTOMER_ID);
1540: XNP_WSGL.HiddenField('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1541: XNP_WSGL.HiddenField('P_REC_CODE', P_REC_CODE);
1542: XNP_WSGL.HiddenField('P_DON_CODE', P_DON_CODE);
1543: XNP_WSGL.HiddenField('P_NRC_CODE', P_NRC_CODE);
1544: XNP_WSGL.HiddenField('Z_START', to_char(I_START));

Line 1541: XNP_WSGL.HiddenField('P_REC_CODE', P_REC_CODE);

1537: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1538: XNP_WSGL.HiddenField('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1539: XNP_WSGL.HiddenField('P_CUSTOMER_ID', P_CUSTOMER_ID);
1540: XNP_WSGL.HiddenField('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1541: XNP_WSGL.HiddenField('P_REC_CODE', P_REC_CODE);
1542: XNP_WSGL.HiddenField('P_DON_CODE', P_DON_CODE);
1543: XNP_WSGL.HiddenField('P_NRC_CODE', P_NRC_CODE);
1544: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
1545: htp.p ('');

Line 1550: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_FIRST_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,

1546: htp.p ('document.write ('''')');
1547: htp.p ('//-->');
1548: htp.p ('');
1549:
1550: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_FIRST_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1551: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1552: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1553: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1554: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,

Line 1552: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,

1548: htp.p ('');
1549:
1550: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_FIRST_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1551: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1552: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1553: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1554: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1555: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1556: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,

Line 1554: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,

1550: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_FIRST_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1551: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1552: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1553: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1554: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1555: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1556: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1557: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1558:

Line 1556: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,

1552: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1553: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1554: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1555: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1556: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1557: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1558:
1559: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1560: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');

Line 1559: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,

1555: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1556: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1557: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1558:
1559: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1560: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1561: XNP_WSGL.HiddenField('Z_CHK',
1562: to_char(XNP_WSGL.Checksum('')));
1563: htp.formClose;

Line 1561: XNP_WSGL.HiddenField('Z_CHK',

1557: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1558:
1559: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1560: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1561: XNP_WSGL.HiddenField('Z_CHK',
1562: to_char(XNP_WSGL.Checksum('')));
1563: htp.formClose;
1564:
1565: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.querylist', ctarget=>'_top', cattributes => 'NAME="frmOne"');

Line 1562: to_char(XNP_WSGL.Checksum('')));

1558:
1559: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1560: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1561: XNP_WSGL.HiddenField('Z_CHK',
1562: to_char(XNP_WSGL.Checksum('')));
1563: htp.formClose;
1564:
1565: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.querylist', ctarget=>'_top', cattributes => 'NAME="frmOne"');
1566: htp.p ('');
1574:
1575: if XNP_WSGL.IsSupported ('NOSCRIPT')
1576: then
1577:
1578: htp.p ('

Line 1583: XNP_WSGL.HiddenField('Z_CHK',

1579: htp.formSubmit('Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION));
1580: htp.p ('');
1581:
1582: end if;
1583: XNP_WSGL.HiddenField('Z_CHK',
1584: to_char(XNP_WSGL.Checksum('')));
1585: htp.formClose;
1586:
1587: XNP_WSGL.ClosePageBody;

Line 1584: to_char(XNP_WSGL.Checksum('')));

1580: htp.p ('');
1581:
1582: end if;
1583: XNP_WSGL.HiddenField('Z_CHK',
1584: to_char(XNP_WSGL.Checksum('')));
1585: htp.formClose;
1586:
1587: XNP_WSGL.ClosePageBody;
1588:

Line 1587: XNP_WSGL.ClosePageBody;

1583: XNP_WSGL.HiddenField('Z_CHK',
1584: to_char(XNP_WSGL.Checksum('')));
1585: htp.formClose;
1586:
1587: XNP_WSGL.ClosePageBody;
1588:
1589: exception
1590: when others then
1591: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

Line 1591: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

1587: XNP_WSGL.ClosePageBody;
1588:
1589: exception
1590: when others then
1591: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1592: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryList');
1593: XNP_WSGL.ClosePageBody;
1594: end;
1595:

Line 1593: XNP_WSGL.ClosePageBody;

1589: exception
1590: when others then
1591: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1592: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryList');
1593: XNP_WSGL.ClosePageBody;
1594: end;
1595:
1596: --------------------------------------------------------------------------------
1597: -- Name: xnp_sv_orders$soa_sv.QueryFirst

Line 1625: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryfirst');

1621: I_ROWS_FETCHED integer := 0;
1622:
1623: begin
1624:
1625: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryfirst');
1626: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1627: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1628: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1629: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);

Line 1626: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);

1622:
1623: begin
1624:
1625: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryfirst');
1626: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1627: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1628: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1629: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1630: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);

Line 1627: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);

1623: begin
1624:
1625: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryfirst');
1626: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1627: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1628: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1629: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1630: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1631: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);

Line 1628: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);

1624:
1625: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryfirst');
1626: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1627: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1628: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1629: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1630: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1631: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1632: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);

Line 1629: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);

1625: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryfirst');
1626: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1627: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1628: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1629: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1630: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1631: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1632: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1633: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);

Line 1630: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);

1626: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1627: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1628: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1629: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1630: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1631: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1632: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1633: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1634: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);

Line 1631: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);

1627: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1628: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1629: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1630: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1631: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1632: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1633: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1634: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1635: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);

Line 1632: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);

1628: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1629: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1630: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1631: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1632: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1633: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1634: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1635: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1636: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

Line 1633: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);

1629: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);
1630: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1631: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1632: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1633: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1634: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1635: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1636: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1637: if not Z_DIRECT_CALL then

Line 1634: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);

1630: XNP_WSGL.AddURLParam('P_CUSTOMER_ID', P_CUSTOMER_ID);
1631: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1632: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1633: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1634: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1635: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1636: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1637: if not Z_DIRECT_CALL then
1638: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

Line 1635: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);

1631: XNP_WSGL.AddURLParam('P_CUSTOMER_NAME', P_CUSTOMER_NAME);
1632: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1633: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1634: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1635: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1636: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1637: if not Z_DIRECT_CALL then
1638: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1639: return;

Line 1636: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

1632: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1633: XNP_WSGL.AddURLParam('P_DON_CODE', P_DON_CODE);
1634: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1635: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1636: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1637: if not Z_DIRECT_CALL then
1638: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1639: return;
1640: end if;

Line 1638: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

1634: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1635: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1636: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1637: if not Z_DIRECT_CALL then
1638: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1639: return;
1640: end if;
1641: end if;
1642:

Line 1644: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);

1640: end if;
1641: end if;
1642:
1643: if Z_ACTION = 'BLANK' then
1644: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1645: return;
1646: end if;
1647:
1648:

Line 1672: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

1668: P_CUSTOMER_NAME,
1669: P_REC_CODE,
1670: P_DON_CODE,
1671: P_NRC_CODE) then
1672: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1673: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
1674: return;
1675: end if;
1676:

Line 1689: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);

1685:
1686: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1687:
1688: if I_ROWS_FETCHED = 0 then
1689: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1690: else
1691: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);
1692: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);
1693: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);

Line 1702: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

1698: dbms_sql.close_cursor(I_CURSOR);
1699:
1700: exception
1701: when others then
1702: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1703: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryFirst');
1704: XNP_WSGL.ClosePageBody;
1705: end;
1706:

Line 1704: XNP_WSGL.ClosePageBody;

1700: exception
1701: when others then
1702: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1703: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryFirst');
1704: XNP_WSGL.ClosePageBody;
1705: end;
1706:
1707: --------------------------------------------------------------------------------
1708: -- Name: xnp_sv_orders$soa_sv.PreQuery

Line 1734: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

1730: begin
1731: return L_RET_VAL;
1732: exception
1733: when others then
1734: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1735: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.PreQuery');
1736: return FALSE;
1737: end;
1738:

Line 1757: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

1753: begin
1754: return L_RET_VAL;
1755: exception
1756: when others then
1757: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1758: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.PostQuery');
1759: return FALSE;
1760: end;
1761:

Line 1777: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

1773: htp.p('var FormType = "Query";');
1774: htp.p(XNP_WSGJSL.CloseScript);
1775: exception
1776: when others then
1777: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1778: QF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.CreateQueryJavaScript');
1779: end;
1780:
1781: --------------------------------------------------------------------------------

Line 1796: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',

1792: htp.p('var FormType = "List";');
1793: htp.p(XNP_WSGJSL.CloseScript);
1794: exception
1795: when others then
1796: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1797: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.CreateListJavaScript');
1798: end;
1799: end;