DBA Data[Home] [Help]

APPS.WSH_OTM_RIQ_XML dependencies on WSH_OTM_RIQ_HEADER_REC

Line 1923: x_source_header_xml_rec IN OUT NOCOPY WSH_OTM_RIQ_HEADER_REC,

1919:
1920:
1921:
1922: PROCEDURE Format_Line_Input_For_Xml(
1923: x_source_header_xml_rec IN OUT NOCOPY WSH_OTM_RIQ_HEADER_REC,
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,

Line 2238: l_header_rec WSH_OTM_RIQ_HEADER_REC;

2234: l_carrier_id NUMBER;
2235: l_mode VARCHAR2(30);
2236: l_service_level VARCHAR2(30);
2237:
2238: l_header_rec WSH_OTM_RIQ_HEADER_REC;
2239: /*Bug7329859*/
2240: j NUMBER;
2241: l_customer_id NUMBER;
2242: /*Bug7329859*/

Line 2265: l_header_rec:=NEW WSH_OTM_RIQ_HEADER_REC();

2261: x_return_status := FND_API.G_RET_STS_SUCCESS;
2262:
2263: x_source_header_tab.DELETE;
2264: x_source_header_tab.EXTEND(p_source_header_tab.COUNT);
2265: l_header_rec:=NEW WSH_OTM_RIQ_HEADER_REC();
2266:
2267: --Initialize fields that will be common to all header records
2268:
2269: --ShipUnitCount hardcoded to 1

Line 2609: p_source_header_rec IN WSH_OTM_RIQ_HEADER_REC,

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,
2613: x_return_status OUT NOCOPY VARCHAR2) IS

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 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 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 5950: x_source_header_rec_xml IN OUT NOCOPY WSH_OTM_RIQ_HEADER_REC,

5946:
5947: PROCEDURE Process_One_Header(
5948: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5949: x_source_header_rec IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5950: x_source_header_rec_xml IN OUT NOCOPY WSH_OTM_RIQ_HEADER_REC,
5951: p_source_type IN VARCHAR2,
5952: p_action IN VARCHAR2,
5953: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5954: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,