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

APPS.XNP_SV_NETWORK$SMS_FE_MAP dependencies on XNP_SV_NETWORK$

Line 1: package body xnp_sv_network$sms_fe_map as

1: package body xnp_sv_network$sms_fe_map as
2: /* $Header: XNPSVN3B.pls 120.0 2005/05/30 11:51:59 appldev noship $ */
3:
4:
5: function BuildSQL(

Line 65: -- Name: xnp_sv_network$sms_fe_map.InitialiseDomain

61:
62: D_FEATURE_TYPE XNP_WSGL.typDVRecord;
63: D_PROVISION_STATUS XNP_WSGL.typDVRecord;
64: --------------------------------------------------------------------------------
65: -- Name: xnp_sv_network$sms_fe_map.InitialiseDomain
66: --
67: -- Description: Initialises the Domain Record for the given Column Usage
68: --
69: -- Parameters: P_ALIAS The alias of the column usage

Line 102: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.InitialseDomain');

98:
99: exception
100: when others then
101: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
102: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.InitialseDomain');
103: end;
104:
105: --------------------------------------------------------------------------------
106: -- Name: xnp_sv_network$sms_fe_map.Startup

Line 106: -- Name: xnp_sv_network$sms_fe_map.Startup

102: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.InitialseDomain');
103: end;
104:
105: --------------------------------------------------------------------------------
106: -- Name: xnp_sv_network$sms_fe_map.Startup
107: --
108: -- Description: Entry point for the 'SMS_FE_MAP' module
109: -- component (Provisioning Status).
110: --

Line 120: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.startup');

116: Z_DIRECT_CALL in boolean,
117: Z_CHK in varchar2) is
118: begin
119:
120: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.startup');
121: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
122: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
123:
124: if not Z_DIRECT_CALL then

Line 141: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.Startup');

137:
138: exception
139: when others then
140: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
141: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.Startup');
142: end;
143:
144: --------------------------------------------------------------------------------
145: -- Name: xnp_sv_network$sms_fe_map.QueryHits

Line 145: -- Name: xnp_sv_network$sms_fe_map.QueryHits

141: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.Startup');
142: end;
143:
144: --------------------------------------------------------------------------------
145: -- Name: xnp_sv_network$sms_fe_map.QueryHits
146: --
147: -- Description: Returns the number or rows which matches the given search
148: -- criteria (if any).
149: --

Line 194: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.QueryHits');

190:
191: exception
192: when others then
193: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
194: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.QueryHits');
195: return -1;
196: end;--------------------------------------------------------------------------------
197: -- Name: xnp_sv_network$sms_fe_map.BuildSQL
198: --

Line 197: -- Name: xnp_sv_network$sms_fe_map.BuildSQL

193: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
194: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.QueryHits');
195: return -1;
196: end;--------------------------------------------------------------------------------
197: -- Name: xnp_sv_network$sms_fe_map.BuildSQL
198: --
199: -- Description: Builds the SQL for the 'SMS_FE_MAP' module component (Provisioning Status).
200: -- This incorporates all query criteria and Foreign key columns.
201: --

Line 242: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.BuildSQL');

238:
239: exception
240: when others then
241: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
242: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.BuildSQL');
243: return false;
244: end;
245:
246:

Line 248: -- Name: xnp_sv_network$sms_fe_map.QueryList

244: end;
245:
246:
247: --------------------------------------------------------------------------------
248: -- Name: xnp_sv_network$sms_fe_map.QueryList
249: --
250: -- Description: This procedure builds the Record list for the 'SMS_FE_MAP'
251: -- module component (Provisioning Status).
252: --

Line 285: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.querylist');

281: L_CHECKSUM varchar2(10);
282:
283: begin
284:
285: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.querylist');
286: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
287: XNP_WSGL.AddURLParam('Z_START', Z_START);
288: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
289: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

Line 299: xnp_sv_network$.TemplateHeader(TRUE,0);

295: end if;
296:
297: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Provisioning Status');
298: CreateListJavaScript;
299: xnp_sv_network$.TemplateHeader(TRUE,0);
300: XNP_WSGL.ClosePageHead;
301:
302: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
303:

Line 451: htp.formOpen(curl => 'xnp_sv_network$sms_fe_map.querylist', cattributes => 'NAME="frmZero"');

447: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
448: dbms_sql.close_cursor(I_CURSOR);
449: end if;
450:
451: htp.formOpen(curl => 'xnp_sv_network$sms_fe_map.querylist', cattributes => 'NAME="frmZero"');
452: XNP_WSGL.HiddenField('P_SV_SMS_ID', P_SV_SMS_ID);
453: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
454: htp.p ('