APPS.EGO_PUB_WS_AG dependencies on EGO_PUB_WS_PARAMS

Line 162: FROM EGO_PUB_WS_PARAMS

158:
159: --get web service name
160: SELECT WEB_SERVICE_NAME
161: INTO l_web_service_name
162: FROM EGO_PUB_WS_PARAMS
163: WHERE SESSION_ID = p_session_id;
164:
165: --insert into EGO.tr_temp VALUES('create param l_web_service_name :', l_web_service_name);
166:

Line 536: FROM EGO_PUB_WS_PARAMS i,

532: /*extract list of attribute group ids */
533: SELECT Decode(existsNode(ag_id, '/AGId'), 1, Nvl(extractValue(ag_id, '/AGId'), -1), 0 , -1)
534: BULK COLLECT INTO l_ag_id_tab
535: FROM( SELECT Value(agid) ag_id
536: FROM EGO_PUB_WS_PARAMS i,
537: TABLE(XMLSequence(
538: extract(i.xmlcontent, 'AGQueryParam/AGIdentifiersList/AGIdentifier/AGId') )) agid
539: WHERE session_id=p_session_id
540: );

Line 546: FROM EGO_PUB_WS_PARAMS i,

542: /*extract list of attibute group name*/
543: SELECT extractValue(ag_name, '/AGName')
544: BULK COLLECT INTO l_ag_name_tab
545: FROM( SELECT Value(agname) ag_name
546: FROM EGO_PUB_WS_PARAMS i,
547: TABLE(XMLSequence(
548: extract(i.xmlcontent, 'AGQueryParam/AGIdentifiersList/AGIdentifier/AGName') )) agname
549: WHERE session_id=p_session_id
550: );

Line 784: FROM EGO_PUB_WS_PARAMS

780: BEGIN
781:
782: SELECT WEB_SERVICE_NAME
783: INTO l_web_service_name
784: FROM EGO_PUB_WS_PARAMS
785: WHERE SESSION_ID = p_session_id;
786:
787: --Initialize FND security
788: EGO_PUB_WS_UTIL.Init_Security(p_session_id, l_web_service_name);