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.EGO_ODI_PUB dependencies on XMLSEQUENCE

Line 865: table(XMLSequence(

861: select extractValue(val, xml_node_name) value
862: from
863: (select value(tags) val
864: from EGO_PUB_WS_PARAMS i,
865: table(XMLSequence(
866: extract(i.xmlcontent, xml_node_path))) tags
867: where session_id = p_session_id);
868:
869:

Line 967: table(XMLSequence(

963: select extractValue(val, xml_node_name) value
964: from
965: (select value(tags) val
966: from EGO_PUB_WS_PARAMS i,
967: table(XMLSequence(
968: extract(i.xmlcontent, xml_node_path))) tags
969: where session_id = p_session_id);
970:
971: BEGIN

Line 1880: TABLE(XMLSequence(

1876: SELECT extractValue(lang_code, '/LanguageCode')
1877: BULK COLLECT INTO l_lang_code_tab
1878: FROM (SELECT Value(langcode) lang_code
1879: FROM EGO_PUB_WS_PARAMS i,
1880: TABLE(XMLSequence(
1881: extract(i.xmlcontent, l_langcode_xpath) )) langcode
1882: WHERE session_id=p_session_id
1883: );
1884:

Line 1890: TABLE(XMLSequence(

1886: SELECT extractValue(lang_code, '/LanguageName')
1887: BULK COLLECT INTO l_lang_name_tab
1888: FROM (SELECT Value(langcode) lang_code
1889: FROM EGO_PUB_WS_PARAMS i,
1890: TABLE(XMLSequence(
1891: extract(i.xmlcontent, l_langname_xpath) )) langcode
1892: WHERE session_id=p_session_id
1893: );
1894:

Line 2049: TABLE(XMLSequence(

2045: SELECT extractValue(uda_ag, p_ag_id_node_tag)
2046: BULK COLLECT INTO l_uda_attr_id_tab
2047: FROM (SELECT Value(udaag) uda_ag
2048: FROM EGO_PUB_WS_PARAMS i,
2049: TABLE(XMLSequence(
2050: extract(i.xmlcontent, l_uda_id_xpath) )) udaag
2051: WHERE session_id=p_session_id
2052: );
2053:

Line 2059: TABLE(XMLSequence(

2055: SELECT extractValue(uda_ag, p_ag_name_node_tag)
2056: BULK COLLECT INTO l_uda_attr_name_tab
2057: FROM (SELECT Value(udaag) uda_ag
2058: FROM EGO_PUB_WS_PARAMS i,
2059: TABLE(XMLSequence(
2060: extract(i.xmlcontent, l_uda_name_xpath) )) udaag
2061: WHERE session_id=p_session_id
2062: );
2063:

Line 3435: TABLE(XMLSequence(

3431: SELECT extractValue(lang_code, '/InventoryItemId')
3432: BULK COLLECT INTO l_item_id_tab
3433: FROM (SELECT Value(langcode) lang_code
3434: FROM EGO_PUB_WS_PARAMS i,
3435: TABLE(XMLSequence(
3436: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemId') )) langcode
3437: WHERE session_id=p_session_id
3438: );
3439:

Line 3445: TABLE(XMLSequence(

3441: SELECT extractValue(lang_code, '/Segment1')
3442: BULK COLLECT INTO l_item_segment1_tab
3443: FROM (SELECT Value(langcode) lang_code
3444: FROM EGO_PUB_WS_PARAMS i,
3445: TABLE(XMLSequence(
3446: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment1') )) langcode
3447: WHERE session_id=p_session_id
3448: );
3449:

Line 3455: TABLE(XMLSequence(

3451: SELECT extractValue(lang_code, '/Segment2')
3452: BULK COLLECT INTO l_item_segment2_tab
3453: FROM (SELECT Value(langcode) lang_code
3454: FROM EGO_PUB_WS_PARAMS i,
3455: TABLE(XMLSequence(
3456: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment2') )) langcode
3457: WHERE session_id=p_session_id
3458: );
3459:

Line 3465: TABLE(XMLSequence(

3461: SELECT extractValue(lang_code, '/Segment3')
3462: BULK COLLECT INTO l_item_segment3_tab
3463: FROM (SELECT Value(langcode) lang_code
3464: FROM EGO_PUB_WS_PARAMS i,
3465: TABLE(XMLSequence(
3466: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment3') )) langcode
3467: WHERE session_id=p_session_id
3468: );
3469:

Line 3475: TABLE(XMLSequence(

3471: SELECT extractValue(lang_code, '/Segment4')
3472: BULK COLLECT INTO l_item_segment4_tab
3473: FROM (SELECT Value(langcode) lang_code
3474: FROM EGO_PUB_WS_PARAMS i,
3475: TABLE(XMLSequence(
3476: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment4') )) langcode
3477: WHERE session_id=p_session_id
3478: );
3479:

Line 3485: TABLE(XMLSequence(

3481: SELECT extractValue(lang_code, '/Segment5')
3482: BULK COLLECT INTO l_item_segment5_tab
3483: FROM (SELECT Value(langcode) lang_code
3484: FROM EGO_PUB_WS_PARAMS i,
3485: TABLE(XMLSequence(
3486: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment5') )) langcode
3487: WHERE session_id=p_session_id
3488: );
3489:

Line 3495: TABLE(XMLSequence(

3491: SELECT extractValue(lang_code, '/Segment6')
3492: BULK COLLECT INTO l_item_segment6_tab
3493: FROM (SELECT Value(langcode) lang_code
3494: FROM EGO_PUB_WS_PARAMS i,
3495: TABLE(XMLSequence(
3496: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment6') )) langcode
3497: WHERE session_id=p_session_id
3498: );
3499:

Line 3505: TABLE(XMLSequence(

3501: SELECT extractValue(lang_code, '/Segment7')
3502: BULK COLLECT INTO l_item_segment7_tab
3503: FROM (SELECT Value(langcode) lang_code
3504: FROM EGO_PUB_WS_PARAMS i,
3505: TABLE(XMLSequence(
3506: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment7') )) langcode
3507: WHERE session_id=p_session_id
3508: );
3509:

Line 3515: TABLE(XMLSequence(

3511: SELECT extractValue(lang_code, '/Segment8')
3512: BULK COLLECT INTO l_item_segment8_tab
3513: FROM (SELECT Value(langcode) lang_code
3514: FROM EGO_PUB_WS_PARAMS i,
3515: TABLE(XMLSequence(
3516: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment8') )) langcode
3517: WHERE session_id=p_session_id
3518: );
3519:

Line 3525: TABLE(XMLSequence(

3521: SELECT extractValue(lang_code, '/Segment9')
3522: BULK COLLECT INTO l_item_segment9_tab
3523: FROM (SELECT Value(langcode) lang_code
3524: FROM EGO_PUB_WS_PARAMS i,
3525: TABLE(XMLSequence(
3526: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment9') )) langcode
3527: WHERE session_id=p_session_id
3528: );
3529:

Line 3535: TABLE(XMLSequence(

3531: SELECT extractValue(lang_code, '/Segment10')
3532: BULK COLLECT INTO l_item_segment10_tab
3533: FROM (SELECT Value(langcode) lang_code
3534: FROM EGO_PUB_WS_PARAMS i,
3535: TABLE(XMLSequence(
3536: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment10') )) langcode
3537: WHERE session_id=p_session_id
3538: );
3539:

Line 3545: TABLE(XMLSequence(

3541: SELECT extractValue(lang_code, '/Segment11')
3542: BULK COLLECT INTO l_item_segment11_tab
3543: FROM (SELECT Value(langcode) lang_code
3544: FROM EGO_PUB_WS_PARAMS i,
3545: TABLE(XMLSequence(
3546: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment11') )) langcode
3547: WHERE session_id=p_session_id
3548: );
3549:

Line 3555: TABLE(XMLSequence(

3551: SELECT extractValue(lang_code, '/Segment12')
3552: BULK COLLECT INTO l_item_segment12_tab
3553: FROM (SELECT Value(langcode) lang_code
3554: FROM EGO_PUB_WS_PARAMS i,
3555: TABLE(XMLSequence(
3556: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment12') )) langcode
3557: WHERE session_id=p_session_id
3558: );
3559:

Line 3565: TABLE(XMLSequence(

3561: SELECT extractValue(lang_code, '/Segment13')
3562: BULK COLLECT INTO l_item_segment13_tab
3563: FROM (SELECT Value(langcode) lang_code
3564: FROM EGO_PUB_WS_PARAMS i,
3565: TABLE(XMLSequence(
3566: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment13') )) langcode
3567: WHERE session_id=p_session_id
3568: );
3569:

Line 3575: TABLE(XMLSequence(

3571: SELECT extractValue(lang_code, '/Segment14')
3572: BULK COLLECT INTO l_item_segment14_tab
3573: FROM (SELECT Value(langcode) lang_code
3574: FROM EGO_PUB_WS_PARAMS i,
3575: TABLE(XMLSequence(
3576: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment14') )) langcode
3577: WHERE session_id=p_session_id
3578: );
3579:

Line 3585: TABLE(XMLSequence(

3581: SELECT extractValue(lang_code, '/Segment15')
3582: BULK COLLECT INTO l_item_segment15_tab
3583: FROM (SELECT Value(langcode) lang_code
3584: FROM EGO_PUB_WS_PARAMS i,
3585: TABLE(XMLSequence(
3586: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment15') )) langcode
3587: WHERE session_id=p_session_id
3588: );
3589:

Line 3595: TABLE(XMLSequence(

3591: SELECT extractValue(lang_code, '/Segment16')
3592: BULK COLLECT INTO l_item_segment16_tab
3593: FROM (SELECT Value(langcode) lang_code
3594: FROM EGO_PUB_WS_PARAMS i,
3595: TABLE(XMLSequence(
3596: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment16') )) langcode
3597: WHERE session_id=p_session_id
3598: );
3599:

Line 3605: TABLE(XMLSequence(

3601: SELECT extractValue(lang_code, '/Segment17')
3602: BULK COLLECT INTO l_item_segment17_tab
3603: FROM (SELECT Value(langcode) lang_code
3604: FROM EGO_PUB_WS_PARAMS i,
3605: TABLE(XMLSequence(
3606: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment17') )) langcode
3607: WHERE session_id=p_session_id
3608: );
3609:

Line 3615: TABLE(XMLSequence(

3611: SELECT extractValue(lang_code, '/Segment18')
3612: BULK COLLECT INTO l_item_segment18_tab
3613: FROM (SELECT Value(langcode) lang_code
3614: FROM EGO_PUB_WS_PARAMS i,
3615: TABLE(XMLSequence(
3616: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment18') )) langcode
3617: WHERE session_id=p_session_id
3618: );
3619:

Line 3625: TABLE(XMLSequence(

3621: SELECT extractValue(lang_code, '/Segment19')
3622: BULK COLLECT INTO l_item_segment19_tab
3623: FROM (SELECT Value(langcode) lang_code
3624: FROM EGO_PUB_WS_PARAMS i,
3625: TABLE(XMLSequence(
3626: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment19') )) langcode
3627: WHERE session_id=p_session_id
3628: );
3629:

Line 3635: TABLE(XMLSequence(

3631: SELECT extractValue(lang_code, '/Segment20')
3632: BULK COLLECT INTO l_item_segment20_tab
3633: FROM (SELECT Value(langcode) lang_code
3634: FROM EGO_PUB_WS_PARAMS i,
3635: TABLE(XMLSequence(
3636: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/InventoryItemName/Segment20') )) langcode
3637: WHERE session_id=p_session_id
3638: );
3639:

Line 3646: TABLE(XMLSequence(

3642: SELECT extractValue(lang_code, '/OrganizationId')
3643: BULK COLLECT INTO l_org_id_tab
3644: FROM (SELECT Value(langcode) lang_code
3645: FROM EGO_PUB_WS_PARAMS i,
3646: TABLE(XMLSequence(
3647: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/OrganizationId') )) langcode
3648: WHERE session_id=p_session_id
3649: );
3650:

Line 3656: TABLE(XMLSequence(

3652: SELECT extractValue(lang_code, '/OrganizationCode')
3653: BULK COLLECT INTO l_org_name_tab
3654: FROM (SELECT Value(langcode) lang_code
3655: FROM EGO_PUB_WS_PARAMS i,
3656: TABLE(XMLSequence(
3657: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/OrganizationCode') )) langcode
3658: WHERE session_id=p_session_id
3659: );
3660:

Line 3667: TABLE(XMLSequence(

3663: SELECT extractValue(lang_code, '/RevisionId')
3664: BULK COLLECT INTO l_rev_id_tab
3665: FROM (SELECT Value(langcode) lang_code
3666: FROM EGO_PUB_WS_PARAMS i,
3667: TABLE(XMLSequence(
3668: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/RevisionId') )) langcode
3669: WHERE session_id=p_session_id
3670: );
3671:

Line 3677: TABLE(XMLSequence(

3673: SELECT extractValue(lang_code, '/Revision')
3674: BULK COLLECT INTO l_rev_name_tab
3675: FROM (SELECT Value(langcode) lang_code
3676: FROM EGO_PUB_WS_PARAMS i,
3677: TABLE(XMLSequence(
3678: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/Revision') )) langcode
3679: WHERE session_id=p_session_id
3680: );
3681:

Line 3691: TABLE(XMLSequence(

3687: SELECT extractValue(lang_code, '/RevisionDate')
3688: BULK COLLECT INTO l_explosion_date_tab
3689: FROM (SELECT Value(langcode) lang_code
3690: FROM EGO_PUB_WS_PARAMS i,
3691: TABLE(XMLSequence(
3692: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/RevisionDate') )) langcode
3693: WHERE session_id=p_session_id
3694: );
3695:

Line 3702: TABLE(XMLSequence(

3698: SELECT extractValue(lang_code, '/StructureName')
3699: BULK COLLECT INTO l_structure_name_tab
3700: FROM (SELECT Value(langcode) lang_code
3701: FROM EGO_PUB_WS_PARAMS i,
3702: TABLE(XMLSequence(
3703: extract(i.xmlcontent, 'structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/StructureName') )) langcode
3704: WHERE session_id=p_session_id
3705: );
3706:

Line 5983: TABLE(XMLSequence(

5979: SELECT extractValue(lang_code, '/LanguageCode')
5980: BULK COLLECT INTO l_lang_code_tab
5981: FROM (SELECT Value(langcode) lang_code
5982: FROM EGO_PUB_WS_PARAMS i,
5983: TABLE(XMLSequence(
5984: extract(i.xmlcontent, l_langcode_xpath) )) langcode
5985: WHERE session_id=p_session_id
5986: );
5987:

Line 6010: TABLE(XMLSequence(

6006: SELECT Upper(Nvl(extractValue(ret_pay, '/ReturnPayload'),'TRUE'))
6007: INTO l_retpayload
6008: FROM (SELECT Value(retpay) ret_pay
6009: FROM EGO_PUB_WS_PARAMS i,
6010: TABLE(XMLSequence(
6011: extract(i.xmlcontent, l_retpay_xpath) )) retpay
6012: WHERE session_id=p_session_id
6013: );
6014:

Line 6035: TABLE(XMLSequence(

6031: SELECT Nvl(extractValue(uda_ag, '/UserDefAttrGrps'),'TRUE')
6032: INTO l_UserDefAttrGrps
6033: FROM (SELECT Value(udaag) uda_ag
6034: FROM EGO_PUB_WS_PARAMS i,
6035: TABLE(XMLSequence(
6036: extract(i.xmlcontent, '/ICCQueryParam/ICCPubEntityObject/UserDefAttrGrps') )) udaag
6037: WHERE session_id=p_session_id
6038: );
6039:

Line 6052: TABLE(XMLSequence(

6048: SELECT Nvl(extractValue(uda_ag, '/ICCVersions'),'TRUE')
6049: INTO l_iccvers_config
6050: FROM (SELECT Value(udaag) uda_ag
6051: FROM EGO_PUB_WS_PARAMS i,
6052: TABLE(XMLSequence(
6053: extract(i.xmlcontent, '/ICCQueryParam/ICCPubEntityObject/ICCVersions') )) udaag
6054: WHERE session_id=p_session_id
6055: );
6056:

Line 6068: TABLE(XMLSequence(

6064: SELECT Nvl(extractValue(uda_ag, '/TransAttrs'),'TRUE')
6065: INTO l_transattrs_config
6066: FROM (SELECT Value(udaag) uda_ag
6067: FROM EGO_PUB_WS_PARAMS i,
6068: TABLE(XMLSequence(
6069: extract(i.xmlcontent, '/ICCQueryParam/ICCPubEntityObject/TransAttrs') )) udaag
6070: WHERE session_id=p_session_id
6071: );
6072:

Line 6083: TABLE(XMLSequence(

6079: SELECT Nvl(extractValue(uda_ag, '/ICCStructure'),'TRUE')
6080: INTO l_structure_config
6081: FROM (SELECT Value(udaag) uda_ag
6082: FROM EGO_PUB_WS_PARAMS i,
6083: TABLE(XMLSequence(
6084: extract(i.xmlcontent, '/ICCQueryParam/ICCPubEntityObject/ICCStructure') )) udaag
6085: WHERE session_id=p_session_id
6086: );
6087:

Line 6327: TABLE(XMLSequence(

6323: SELECT extractValue(ICC_Id, '/ICCId')
6324: BULK COLLECT INTO l_dup_icc_id_tab
6325: FROM (SELECT Value(iccid) ICC_Id
6326: FROM EGO_PUB_WS_PARAMS i,
6327: TABLE(XMLSequence(
6328: extract(i.xmlcontent, '/ICCQueryParam/ICCIdentifiersList/ICCIdentifier/ICCId') )) iccid
6329: WHERE session_id=p_session_id
6330: );
6331:

Line 6338: TABLE(XMLSequence(

6334: SELECT Nvl(extractValue(ICC_Ver, '/VersionSequence'),-1)
6335: BULK COLLECT INTO l_dup_icc_ver_tab
6336: FROM (SELECT Value(iccver) ICC_Ver
6337: FROM EGO_PUB_WS_PARAMS i,
6338: TABLE(XMLSequence(
6339: extract(i.xmlcontent, '/ICCQueryParam/ICCIdentifiersList/ICCIdentifier/VersionSequence') )) iccver
6340: WHERE session_id=p_session_id
6341: );
6342:

Line 6348: TABLE(XMLSequence(

6344: SELECT upper(Nvl(extractValue(ICC_Id, '/ParentICCs'),'FALSE'))
6345: INTO l_parent_hier
6346: FROM (SELECT Value(iccid) ICC_Id
6347: FROM EGO_PUB_WS_PARAMS i,
6348: TABLE(XMLSequence(
6349: extract(i.xmlcontent, '/ICCQueryParam/ICCPubEntityObject/ParentICCs') )) iccid
6350: WHERE session_id=p_session_id
6351: );
6352:

Line 6358: TABLE(XMLSequence(

6354: SELECT upper(Nvl(extractValue(ICC_Id, '/ChildICCs'),'FALSE'))
6355: INTO l_child_hier
6356: FROM (SELECT Value(iccid) ICC_Id
6357: FROM EGO_PUB_WS_PARAMS i,
6358: TABLE(XMLSequence(
6359: extract(i.xmlcontent, '/ICCQueryParam/ICCPubEntityObject/ChildICCs') )) iccid
6360: WHERE session_id=p_session_id
6361: );
6362:

Line 6636: TABLE(XMLSequence(

6632: SELECT extractValue(ValueSet_Id, '/ValueSetId')
6633: BULK COLLECT INTO l_dup_vs_id_tab
6634: FROM (SELECT Value(VSId) ValueSet_Id
6635: FROM EGO_PUB_WS_PARAMS i,
6636: TABLE(XMLSequence(
6637: extract(i.xmlcontent, '/ValuesetQueryParam/ValuesetIdentifiersList/ValuesetIdentifier/ValueSetId') )) VSId
6638: WHERE session_id=p_session_id
6639: );
6640:

Line 6647: TABLE(XMLSequence(

6643: SELECT Nvl(extractValue(ValueSet_Ver, '/VersionSeqId'),-1)
6644: BULK COLLECT INTO l_dup_vs_ver_tab
6645: FROM (SELECT Value(VSVer) ValueSet_Ver
6646: FROM EGO_PUB_WS_PARAMS i,
6647: TABLE(XMLSequence(
6648: extract(i.xmlcontent, '/ValuesetQueryParam/ValuesetIdentifiersList/ValuesetIdentifier/VersionSeqId') )) VSVer
6649: WHERE session_id=p_session_id
6650: );
6651: END IF; --IF l_batch_id >-1 THEN