APPS.XNP_SV_ORDERS$SOA_ORDERS dependencies on XNP_SV_ORDERS$SOA_ORDERS

Line 1: package body xnp_sv_orders$soa_orders as

1: package body xnp_sv_orders$soa_orders as
2: /* $Header: XNPSVO4B.pls 120.0 2005/05/30 11:46:22 appldev noship $ */
3:
4:
5: function BuildSQL(

Line 52: -- Name: xnp_sv_orders$soa_orders.Startup

48:
49: ZONE_SQL VARCHAR2(1000) := null;
50:
51: --------------------------------------------------------------------------------
52: -- Name: xnp_sv_orders$soa_orders.Startup
53: --
54: -- Description: Entry point for the 'SOA_ORDERS' module
55: -- component (Order Workitems).
56: --

Line 66: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.startup');

62: Z_DIRECT_CALL in boolean,
63: Z_CHK in varchar2) is
64: begin
65:
66: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.startup');
67: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
68: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
69:
70: if not Z_DIRECT_CALL then

Line 87: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.Startup');

83:
84: exception
85: when others then
86: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',
87: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.Startup');
88: end;
89:
90: --------------------------------------------------------------------------------
91: -- Name: xnp_sv_orders$soa_orders.QueryHits

Line 91: -- Name: xnp_sv_orders$soa_orders.QueryHits

87: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.Startup');
88: end;
89:
90: --------------------------------------------------------------------------------
91: -- Name: xnp_sv_orders$soa_orders.QueryHits
92: --
93: -- Description: Returns the number or rows which matches the given search
94: -- criteria (if any).
95: --

Line 140: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.QueryHits');

136:
137: exception
138: when others then
139: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',
140: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.QueryHits');
141: return -1;
142: end;--------------------------------------------------------------------------------
143: -- Name: xnp_sv_orders$soa_orders.BuildSQL
144: --

Line 143: -- Name: xnp_sv_orders$soa_orders.BuildSQL

139: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',
140: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.QueryHits');
141: return -1;
142: end;--------------------------------------------------------------------------------
143: -- Name: xnp_sv_orders$soa_orders.BuildSQL
144: --
145: -- Description: Builds the SQL for the 'SOA_ORDERS' module component (Order Workitems).
146: -- This incorporates all query criteria and Foreign key columns.
147: --

Line 182: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.BuildSQL');

178:
179: exception
180: when others then
181: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',
182: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.BuildSQL');
183: return false;
184: end;
185:
186:

Line 188: -- Name: xnp_sv_orders$soa_orders.QueryList

184: end;
185:
186:
187: --------------------------------------------------------------------------------
188: -- Name: xnp_sv_orders$soa_orders.QueryList
189: --
190: -- Description: This procedure builds the Record list for the 'SOA_ORDERS'
191: -- module component (Order Workitems).
192: --

Line 225: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.querylist');

221: L_CHECKSUM varchar2(10);
222:
223: begin
224:
225: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.querylist');
226: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
227: XNP_WSGL.AddURLParam('Z_START', Z_START);
228: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
229: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

Line 381: htp.formOpen(curl => 'xnp_sv_orders$soa_orders.querylist', cattributes => 'NAME="frmZero"');

377: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
378: dbms_sql.close_cursor(I_CURSOR);
379: end if;
380:
381: htp.formOpen(curl => 'xnp_sv_orders$soa_orders.querylist', cattributes => 'NAME="frmZero"');
382: XNP_WSGL.HiddenField('P_SV_SOA_ID', P_SV_SOA_ID);
383: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
384: htp.p ('