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.WSH_OTM_RIQ_XML dependencies on WSH_OTM_RIQ_LINE_TAB

Line 1928: x_source_line_tab IN OUT NOCOPY WSH_OTM_RIQ_LINE_TAB,

1924: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
1925: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
1926: p_source_type IN VARCHAR2,
1927: p_action IN VARCHAR2,
1928: x_source_line_tab IN OUT NOCOPY WSH_OTM_RIQ_LINE_TAB,
1929: x_return_status OUT NOCOPY VARCHAR2) IS
1930:
1931:
1932: CURSOR c_item_dimensions(c_inv_item_id IN NUMBER,c_org_id IN NUMBER) IS

Line 2608: p_source_line_tab IN WSH_OTM_RIQ_LINE_TAB,

2604:
2605:
2606:
2607: PROCEDURE Create_RIQ_XML(
2608: p_source_line_tab IN WSH_OTM_RIQ_LINE_TAB,
2609: p_source_header_rec IN WSH_OTM_RIQ_HEADER_REC,
2610: p_source_type IN VARCHAR2,
2611: p_action IN VARCHAR2,
2612: x_xml_input IN OUT NOCOPY XMLTYPE,

Line 2620: CURSOR c_Choose_SM_XML(c_header_rec IN WSH_OTM_RIQ_HEADER_REC,c_line_tab IN WSH_OTM_RIQ_LINE_TAB)

2616: l_debug_on BOOLEAN;
2617: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_RIQ_XML';
2618:
2619:
2620: CURSOR c_Choose_SM_XML(c_header_rec IN WSH_OTM_RIQ_HEADER_REC,c_line_tab IN WSH_OTM_RIQ_LINE_TAB)
2621: IS
2622: SELECT XMLELEMENT("Transmission",
2623: XMLFOREST(
2624: XMLFOREST(

Line 2808: FROM TABLE(CAST(c_line_tab AS WSH_OTM_RIQ_LINE_TAB )) e;

2804: )
2805: ) AS "TransmissionBody"
2806: )
2807: )
2808: FROM TABLE(CAST(c_line_tab AS WSH_OTM_RIQ_LINE_TAB )) e;
2809:
2810:
2811:
2812:

Line 2813: CURSOR c_Get_Freight_Rates_XML(c_header_rec IN WSH_OTM_RIQ_HEADER_REC,c_line_tab IN WSH_OTM_RIQ_LINE_TAB)

2809:
2810:
2811:
2812:
2813: CURSOR c_Get_Freight_Rates_XML(c_header_rec IN WSH_OTM_RIQ_HEADER_REC,c_line_tab IN WSH_OTM_RIQ_LINE_TAB)
2814: IS
2815:
2816: SELECT
2817: XMLELEMENT("Transmission",

Line 3031: FROM TABLE(CAST(c_line_tab AS WSH_OTM_RIQ_LINE_TAB )) e;

3027: )
3028: ) AS "TransmissionBody"
3029: )
3030: )
3031: FROM TABLE(CAST(c_line_tab AS WSH_OTM_RIQ_LINE_TAB )) e;
3032:
3033:
3034:
3035: CURSOR c_Get_SM_XML(c_header_rec IN WSH_OTM_RIQ_HEADER_REC,c_line_tab IN WSH_OTM_RIQ_LINE_TAB)

Line 3035: CURSOR c_Get_SM_XML(c_header_rec IN WSH_OTM_RIQ_HEADER_REC,c_line_tab IN WSH_OTM_RIQ_LINE_TAB)

3031: FROM TABLE(CAST(c_line_tab AS WSH_OTM_RIQ_LINE_TAB )) e;
3032:
3033:
3034:
3035: CURSOR c_Get_SM_XML(c_header_rec IN WSH_OTM_RIQ_HEADER_REC,c_line_tab IN WSH_OTM_RIQ_LINE_TAB)
3036: IS
3037: SELECT
3038: XMLELEMENT("Transmission",
3039: XMLFOREST(

Line 3153: FROM TABLE(CAST(c_line_tab AS WSH_OTM_RIQ_LINE_TAB )) e;

3149: )
3150: ) AS "TransmissionBody"
3151: )
3152: )
3153: FROM TABLE(CAST(c_line_tab AS WSH_OTM_RIQ_LINE_TAB )) e;
3154:
3155:
3156:
3157: BEGIN

Line 5968: l_source_line_tab_xml WSH_OTM_RIQ_LINE_TAB;

5964: IS
5965: j NUMBER; -- Bug 6810844
5966: i NUMBER;
5967: l_source_header_tab_xml WSH_OTM_RIQ_HEADER_TAB;
5968: l_source_line_tab_xml WSH_OTM_RIQ_LINE_TAB;
5969: l_xmlCLOB CLOB;
5970: l_xml_input XMLTYPE;
5971: l_xml_output XMLTYPE;
5972: l_total_header_count NUMBER;

Line 6002: l_source_line_tab_xml:= NEW WSH_OTM_RIQ_LINE_TAB();

5998: --
5999: x_return_status := FND_API.G_RET_STS_SUCCESS;
6000:
6001:
6002: l_source_line_tab_xml:= NEW WSH_OTM_RIQ_LINE_TAB();
6003: --Get a new line table for each header
6004: l_source_line_tab_xml.DELETE;
6005:
6006: Format_Line_Input_For_Xml(