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 EGO_PUB_WS_PARAMS

Line 864: from EGO_PUB_WS_PARAMS i,

860: IS
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:

Line 908: --EGO_PUB_WS_PARAMS using the session_id.

904:
905:
906:
907: --Function that returns the specified ODI input parameter from table
908: --EGO_PUB_WS_PARAMS using the session_id.
909: --INPUT:
910: --p_session_id: unique identifier of input XML stored in table EGO_PUB_WS_PARAMS
911: --p_search_str: x_path expression pointing to parameter to be recovered
912: -- (e.g. '/structureQueryParameters/PublishEntities/StructureRevision')

Line 910: --p_session_id: unique identifier of input XML stored in table EGO_PUB_WS_PARAMS

906:
907: --Function that returns the specified ODI input parameter from table
908: --EGO_PUB_WS_PARAMS using the session_id.
909: --INPUT:
910: --p_session_id: unique identifier of input XML stored in table EGO_PUB_WS_PARAMS
911: --p_search_str: x_path expression pointing to parameter to be recovered
912: -- (e.g. '/structureQueryParameters/PublishEntities/StructureRevision')
913: --OUTPUT:
914: --parameter value in VARCHAR or NULL if parameter specified does not exist

Line 925: from EGO_PUB_WS_PARAMS

921:
922:
923: select extractValue(xmlcontent, p_search_str)
924: into x_value
925: from EGO_PUB_WS_PARAMS
926: where session_id = p_session_id;
927:
928: --check for parameter value not available condition generated by
929: --some web services when parameter value is not specified.

Line 941: --EGO_PUB_WS_PARAMS using the session_id as a comma separated list.

937:
938:
939:
940: --Function that returns the specified ODI input parameters from table
941: --EGO_PUB_WS_PARAMS using the session_id as a comma separated list.
942: --INPUT:
943: --p_session_id: unique identifier of input XML stored in table EGO_PUB_WS_PARAMS
944: --p_search_str: x_path expression pointing to parameter to be recovered. The parameter
945: -- to be recovered (xml node) must be of type list

Line 943: --p_session_id: unique identifier of input XML stored in table EGO_PUB_WS_PARAMS

939:
940: --Function that returns the specified ODI input parameters from table
941: --EGO_PUB_WS_PARAMS using the session_id as a comma separated list.
942: --INPUT:
943: --p_session_id: unique identifier of input XML stored in table EGO_PUB_WS_PARAMS
944: --p_search_str: x_path expression pointing to parameter to be recovered. The parameter
945: -- to be recovered (xml node) must be of type list
946: -- (e.g. '/structureQueryParameters/ListOfLanguageInformation/LanguageCode')
947: /*

Line 966: from EGO_PUB_WS_PARAMS i,

962: IS
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:

Line 1041: from EGO_PUB_WS_PARAMS

1037:
1038: /*--retrieving batchId from input XML
1039: select to_number(extractValue(xmlcontent, '/structureQueryParameters/BatchStructureQueryParameters/BatchId'))
1040: into l_batch_id
1041: from EGO_PUB_WS_PARAMS
1042: where session_id = p_session_id;
1043:
1044: --retrieving user_id and responsibility
1045: select created_by, responsibility_id

Line 1356: from EGO_PUB_WS_PARAMS

1352:
1353: --retrieving batchId from input XML
1354: select to_number(extractValue(xmlcontent, '/structureQueryParameters/BatchStructureQueryParameters/BatchId'))
1355: into l_batch_id
1356: from EGO_PUB_WS_PARAMS
1357: where session_id = p_session_id;
1358:
1359: --retrieving batch_id
1360: --select Numeric_Value

Line 1757: from EGO_PUB_WS_PARAMS

1753: --START BATCH MODE CHECK
1754: --if batch_id is populated, we are in 'BATCH' mode
1755: select existsNode(xmlcontent, '/structureQueryParameters/BatchStructureQueryParameters/BatchId')
1756: into l_exists
1757: from EGO_PUB_WS_PARAMS
1758: where session_id = p_session_id;
1759:
1760: IF l_exists=1 THEN
1761:

Line 1764: from EGO_PUB_WS_PARAMS

1760: IF l_exists=1 THEN
1761:
1762: select extractValue(xmlcontent, '/structureQueryParameters/BatchStructureQueryParameters/BatchId')
1763: into l_tmp_val
1764: from EGO_PUB_WS_PARAMS
1765: where session_id = p_session_id;
1766:
1767: IF l_tmp_val <> '?' THEN
1768: RETURN 'BATCH';

Line 1778: from EGO_PUB_WS_PARAMS

1774: --START HMDM MODE CHECK
1775: --if organization Id or organization name were populated, we are in 'HMDM' mode
1776: select existsNode(xmlcontent, '/structureQueryParameters/OrganizationId')
1777: into l_exists
1778: from EGO_PUB_WS_PARAMS
1779: where session_id = p_session_id;
1780:
1781: select existsNode(xmlcontent, '/structureQueryParameters/OrganizationCode')
1782: into l_exists1

Line 1783: from EGO_PUB_WS_PARAMS

1779: where session_id = p_session_id;
1780:
1781: select existsNode(xmlcontent, '/structureQueryParameters/OrganizationCode')
1782: into l_exists1
1783: from EGO_PUB_WS_PARAMS
1784: where session_id = p_session_id;
1785:
1786:
1787: IF l_exists=1 OR l_exists1=1 THEN

Line 1791: from EGO_PUB_WS_PARAMS

1787: IF l_exists=1 OR l_exists1=1 THEN
1788:
1789: select extractValue(xmlcontent, '/structureQueryParameters/OrganizationId')
1790: into l_tmp_val
1791: from EGO_PUB_WS_PARAMS
1792: where session_id = p_session_id;
1793:
1794: IF l_tmp_val <> '?' THEN
1795: RETURN 'HMDM';

Line 1800: from EGO_PUB_WS_PARAMS

1796: END IF;
1797:
1798: select extractValue(xmlcontent, '/structureQueryParameters/OrganizationCode')
1799: into l_tmp_val
1800: from EGO_PUB_WS_PARAMS
1801: where session_id = p_session_id;
1802:
1803: IF l_tmp_val <> '?' THEN
1804: RETURN 'HMDM';

Line 1815: from EGO_PUB_WS_PARAMS

1811: --if node ListOfItemStructureQueryParams occurs more than once,
1812: --we are in 'LIST' MODE
1813: select count(*)
1814: into l_exists
1815: from EGO_PUB_WS_PARAMS
1816: where session_id = p_session_id
1817: and existsNode(xmlcontent, '/structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/OrganizationId')=1;
1818:
1819: select count(*)

Line 1821: from EGO_PUB_WS_PARAMS

1817: and existsNode(xmlcontent, '/structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/OrganizationId')=1;
1818:
1819: select count(*)
1820: into l_exists1
1821: from EGO_PUB_WS_PARAMS
1822: where session_id = p_session_id
1823: and existsNode(xmlcontent, '/structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/OrganizationCode')=1;
1824:
1825:

Line 1832: from EGO_PUB_WS_PARAMS

1828: IF l_exists>=1 OR l_exists1>=1 THEN
1829:
1830: /*select extractValue(xmlcontent, '/structureQueryParameters/ParametersForListOfItems/ListOfItemStructureQueryParams/OrganizationId')
1831: into l_tmp_val
1832: from EGO_PUB_WS_PARAMS
1833: where session_id = p_session_id;
1834:
1835: IF l_tmp_val <> '?' THEN
1836: RETURN 'LIST';

Line 1879: FROM EGO_PUB_WS_PARAMS i,

1875: --extracting language Codes
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: );

Line 1889: FROM EGO_PUB_WS_PARAMS i,

1885: --extracting language names
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: );

Line 2048: FROM EGO_PUB_WS_PARAMS i,

2044: --reading list of attribute group ids
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: );

Line 2058: FROM EGO_PUB_WS_PARAMS i,

2054: --reading list of attribute group names
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: );

Line 2443: --EGO_PUB_WS_PARAMS and can be recovered with the session_id

2439: --SECURITY_GROUP_NAME depending on input mode
2440:
2441: --if mode is LIST or H-MDM, get authentication information from
2442: --user calling the web service. This info is stored in table
2443: --EGO_PUB_WS_PARAMS and can be recovered with the session_id
2444: IF l_mode <> 'BATCH' THEN
2445:
2446: --retrieving and storing FND_USER_NAME
2447: select fnd_user_name

Line 2449: from EGO_PUB_WS_PARAMS

2445:
2446: --retrieving and storing FND_USER_NAME
2447: select fnd_user_name
2448: into l_fnd_user_name
2449: from EGO_PUB_WS_PARAMS
2450: where session_id = p_session_id;
2451:
2452: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2453: odi_session_id,

Line 2472: from EGO_PUB_WS_PARAMS

2468:
2469: --retrieving and storing RESPONSIBILITY_NAME
2470: select responsibility_name
2471: into l_responsibility_name
2472: from EGO_PUB_WS_PARAMS
2473: where session_id = p_session_id;
2474:
2475: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2476: odi_session_id,

Line 2496: from EGO_PUB_WS_PARAMS

2492:
2493: --retrieving and storing RESPONSIBILITY_APPL_NAME
2494: select responsibility_appl_name
2495: into l_responsibility_appl_name
2496: from EGO_PUB_WS_PARAMS
2497: where session_id = p_session_id;
2498:
2499: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2500: odi_session_id,

Line 2520: from EGO_PUB_WS_PARAMS

2516:
2517: --retrieving and storing SECURITY_GROUP_NAME
2518: select security_group_name
2519: into l_security_group_name
2520: from EGO_PUB_WS_PARAMS
2521: where session_id = p_session_id;
2522:
2523: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2524: odi_session_id,

Line 2549: from EGO_PUB_WS_PARAMS

2545:
2546: --retrieving batchId from input XML
2547: select to_number(extractValue(xmlcontent, '/structureQueryParameters/BatchStructureQueryParameters/BatchId'))
2548: into l_batch_id
2549: from EGO_PUB_WS_PARAMS
2550: where session_id = p_session_id;
2551:
2552: --retrieving user_id and responsibility
2553: select created_by, responsibility_id

Line 2666: from EGO_PUB_WS_PARAMS

2662:
2663: --retrieving batch_id
2664: select to_number(extractValue(xmlcontent, '/structureQueryParameters/BatchStructureQueryParameters/BatchId'))
2665: into l_batch_id
2666: from EGO_PUB_WS_PARAMS
2667: where session_id = p_session_id;
2668:
2669: --retrieving levels_to_explode
2670: select to_char(numeric_value)

Line 3108: from EGO_PUB_WS_PARAMS

3104:
3105: --retrieving batchId from input XML
3106: select to_number(extractValue(xmlcontent, '/structureQueryParameters/BatchStructureQueryParameters/BatchId'))
3107: into l_batch_id
3108: from EGO_PUB_WS_PARAMS
3109: where session_id = p_session_id;
3110:
3111: --retrieving structure name from publication framework params table
3112: select char_value

Line 3434: FROM EGO_PUB_WS_PARAMS i,

3430: /*extract list of inventory item ids */
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: );

Line 3444: FROM EGO_PUB_WS_PARAMS i,

3440: /*extract list of inventory item segment1 */
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: );

Line 3454: FROM EGO_PUB_WS_PARAMS i,

3450: /*extract list of inventory item segment2 */
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: );

Line 3464: FROM EGO_PUB_WS_PARAMS i,

3460: /*extract list of inventory item segment3 */
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: );

Line 3474: FROM EGO_PUB_WS_PARAMS i,

3470: /*extract list of inventory item segment4 */
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: );

Line 3484: FROM EGO_PUB_WS_PARAMS i,

3480: /*extract list of inventory item segment5 */
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: );

Line 3494: FROM EGO_PUB_WS_PARAMS i,

3490: /*extract list of inventory item segment6 */
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: );

Line 3504: FROM EGO_PUB_WS_PARAMS i,

3500: /*extract list of inventory item segment7 */
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: );

Line 3514: FROM EGO_PUB_WS_PARAMS i,

3510: /*extract list of inventory item segment8 */
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: );

Line 3524: FROM EGO_PUB_WS_PARAMS i,

3520: /*extract list of inventory item segment9 */
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: );

Line 3534: FROM EGO_PUB_WS_PARAMS i,

3530: /*extract list of inventory item segment10 */
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: );

Line 3544: FROM EGO_PUB_WS_PARAMS i,

3540: /*extract list of inventory item segment11 */
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: );

Line 3554: FROM EGO_PUB_WS_PARAMS i,

3550: /*extract list of inventory item segment12 */
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: );

Line 3564: FROM EGO_PUB_WS_PARAMS i,

3560: /*extract list of inventory item segment13 */
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: );

Line 3574: FROM EGO_PUB_WS_PARAMS i,

3570: /*extract list of inventory item segment14 */
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: );

Line 3584: FROM EGO_PUB_WS_PARAMS i,

3580: /*extract list of inventory item segment15 */
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: );

Line 3594: FROM EGO_PUB_WS_PARAMS i,

3590: /*extract list of inventory item segment16 */
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: );

Line 3604: FROM EGO_PUB_WS_PARAMS i,

3600: /*extract list of inventory item segment17 */
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: );

Line 3614: FROM EGO_PUB_WS_PARAMS i,

3610: /*extract list of inventory item segment18 */
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: );

Line 3624: FROM EGO_PUB_WS_PARAMS i,

3620: /*extract list of inventory item segment19 */
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: );

Line 3634: FROM EGO_PUB_WS_PARAMS i,

3630: /*extract list of inventory item segment20 */
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: );

Line 3645: FROM EGO_PUB_WS_PARAMS i,

3641: /*extract list of organization ids */
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: );

Line 3655: FROM EGO_PUB_WS_PARAMS i,

3651: /*extract list of organization codes */
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: );

Line 3666: FROM EGO_PUB_WS_PARAMS i,

3662: /*extract list of revision ids */
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: );

Line 3676: FROM EGO_PUB_WS_PARAMS i,

3672: /*extract list of revision codes */
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: );

Line 3690: FROM EGO_PUB_WS_PARAMS i,

3686: --different from the format provided by the user. perhaps specify format in to_char()?
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: );

Line 3701: FROM EGO_PUB_WS_PARAMS i,

3697: /*extract list of structure names */
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: );

Line 4667: from EGO_PUB_WS_PARAMS

4663:
4664: --retrieving and storing FND_USER_NAME
4665: select fnd_user_name
4666: into l_fnd_user_name
4667: from EGO_PUB_WS_PARAMS
4668: where session_id = p_session_id;
4669:
4670: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4671: odi_session_id,

Line 4690: from EGO_PUB_WS_PARAMS

4686:
4687: --retrieving and storing RESPONSIBILITY_NAME
4688: select responsibility_name
4689: into l_responsibility_name
4690: from EGO_PUB_WS_PARAMS
4691: where session_id = p_session_id;
4692:
4693: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4694: odi_session_id,

Line 4714: from EGO_PUB_WS_PARAMS

4710:
4711: --retrieving and storing RESPONSIBILITY_APPL_NAME
4712: select responsibility_appl_name
4713: into l_responsibility_appl_name
4714: from EGO_PUB_WS_PARAMS
4715: where session_id = p_session_id;
4716:
4717: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4718: odi_session_id,

Line 4738: from EGO_PUB_WS_PARAMS

4734:
4735: --retrieving and storing SECURITY_GROUP_NAME
4736: select security_group_name
4737: into l_security_group_name
4738: from EGO_PUB_WS_PARAMS
4739: where session_id = p_session_id;
4740:
4741: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4742: odi_session_id,

Line 5926: FROM EGO_PUB_WS_PARAMS

5922: BEGIN
5923: --if BatchId node exist and It has some value then we are in 'BATCH' mode
5924: SELECT existsNode(xmlcontent, p_search_str)
5925: INTO l_exists
5926: FROM EGO_PUB_WS_PARAMS
5927: WHERE session_id = p_session_id;
5928:
5929:
5930: IF l_exists=1 THEN

Line 5934: FROM EGO_PUB_WS_PARAMS

5930: IF l_exists=1 THEN
5931: /*If node exist for 'BatchId' then extractValue for BatchId'*/
5932: SELECT Nvl(extractValue(xmlcontent,p_search_str),-1)
5933: INTO l_batch_id
5934: FROM EGO_PUB_WS_PARAMS
5935: WHERE session_id = p_session_id;
5936:
5937: IF l_batch_id >-1 THEN
5938: x_mode:= 'BATCH';

Line 5982: FROM EGO_PUB_WS_PARAMS i,

5978: /*extract configurable parameter for language */
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: );

Line 6009: FROM EGO_PUB_WS_PARAMS i,

6005: BEGIN
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: );

Line 6034: FROM EGO_PUB_WS_PARAMS i,

6030: /*extract configurable parameter Attr Group and insert record into config table */
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: );

Line 6051: FROM EGO_PUB_WS_PARAMS i,

6047: /*extract configurable parameter ICCVersions and insert record into config table */
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: );

Line 6067: FROM EGO_PUB_WS_PARAMS i,

6063: /*extract configurable parameter TransAttrs and insert record into config table */
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: );

Line 6082: FROM EGO_PUB_WS_PARAMS i,

6078: /*extract configurable parameter ICCStructure and insert record into config table */
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: );

Line 6326: FROM EGO_PUB_WS_PARAMS i,

6322: /*Extract value into array if ICCId node exist in Input table*/
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: );

Line 6337: FROM EGO_PUB_WS_PARAMS i,

6333: /*Extract value into array if VersionSequence node exist in Input table*/
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: );

Line 6347: FROM EGO_PUB_WS_PARAMS i,

6343: /* Find out if parent ICC's need to publish for a ICC*/
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: );

Line 6357: FROM EGO_PUB_WS_PARAMS i,

6353: /* Find out if child ICC's need to publish for a ICC*/
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: );

Line 6635: FROM EGO_PUB_WS_PARAMS i,

6631: /*Extract value into array if ICCId node exist in Input table*/
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: );

Line 6646: FROM EGO_PUB_WS_PARAMS i,

6642: /*Extract value into array if VersionSequence node exist in Input table*/
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: );

Line 6901: FROM ego_pub_ws_params

6897: /*Cursor to get I/P value for user_name, resp_name and appl_name */
6898: CURSOR Cur_ws_input (cp_session_id NUMBER )
6899: IS
6900: SELECT fnd_user_name,responsibility_appl_name,responsibility_name
6901: FROM ego_pub_ws_params
6902: WHERE session_id=cp_session_id;
6903:
6904:
6905: