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 FTE_PROCESS_REQUESTS

Line 62: g_source_line_tab_temp FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB;

58: g_timezone_code VARCHAR2(50);
59: g_global_time_class VARCHAR2(30);
60: g_xml_namespace_map VARCHAR2(200);
61: /*Bug7329859*/
62: g_source_line_tab_temp FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB;
63: /*Bug7329859*/
64:
65: TYPE WSH_UOM_MAP_TAB IS TABLE OF VARCHAR2(30)
66: INDEX BY VARCHAR2(30);

Line 89: (x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,

85:
86: --ECO 5516007 ,FP(5573379) to R12
87: -- Forward Declaration
88: PROCEDURE DERIVE_RIQ_DATES
89: (x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
90: x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
91: x_return_status OUT NOCOPY VARCHAR2);
92:
93: --ECO 5516007, FP(5573379) to R12

Line 90: x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,

86: --ECO 5516007 ,FP(5573379) to R12
87: -- Forward Declaration
88: PROCEDURE DERIVE_RIQ_DATES
89: (x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
90: x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
91: x_return_status OUT NOCOPY VARCHAR2);
92:
93: --ECO 5516007, FP(5573379) to R12
94: --=========================================================================

Line 116: (x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,

112: -- have multiple headers.
113: --
114: --=========================================================================
115: PROCEDURE DERIVE_RIQ_DATES
116: (x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
117: x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
118: x_return_status OUT NOCOPY VARCHAR2) AS
119:
120: -- Cursor declaration Section

Line 117: x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,

113: --
114: --=========================================================================
115: PROCEDURE DERIVE_RIQ_DATES
116: (x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
117: x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
118: x_return_status OUT NOCOPY VARCHAR2) AS
119:
120: -- Cursor declaration Section
121:

Line 436: p_source_line_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,

432:
433:
434:
435: PROCEDURE print_source_line_tab (
436: p_source_line_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
437: x_return_status OUT NOCOPY VARCHAR2)
438: IS
439:
440: i NUMBER;

Line 562: p_source_header_tab IN FTE_PROCESS_REQUESTS.fte_source_header_tab,

558:
559: END print_source_line_tab;
560:
561: PROCEDURE print_source_header_tab (
562: p_source_header_tab IN FTE_PROCESS_REQUESTS.fte_source_header_tab,
563: x_return_status OUT NOCOPY VARCHAR2)
564: IS
565: i NUMBER;
566: l_return_status VARCHAR2(1);

Line 673: p_source_line_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,

669: END print_source_header_tab;
670:
671:
672: PROCEDURE print_rates_tab (
673: p_source_line_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
674: p_source_header_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
675: x_return_status OUT NOCOPY VARCHAR2)
676: IS
677: i NUMBER;

Line 674: p_source_header_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,

670:
671:
672: PROCEDURE print_rates_tab (
673: p_source_line_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
674: p_source_header_rates_tab IN FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
675: x_return_status OUT NOCOPY VARCHAR2)
676: IS
677: i NUMBER;
678: l_return_status VARCHAR2(1);

Line 1441: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,

1437: END Get_Carrier_Info;
1438:
1439:
1440: PROCEDURE Sort(
1441: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
1442: x_return_status OUT NOCOPY VARCHAR2)
1443: IS
1444:
1445: CURSOR c_sort(c_tab IN WSH_OTM_RIQ_SORT_TAB)

Line 1458: l_out_tab FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB;

1454:
1455: l_sort_tab WSH_OTM_RIQ_SORT_TAB;
1456: l_sort_rec WSH_OTM_RIQ_SORT_REC;
1457: l_index_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
1458: l_out_tab FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB;
1459:
1460: l_return_status VARCHAR2(1);
1461: l_debug_on BOOLEAN;
1462: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Sort';

Line 1924: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,

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,
1928: x_source_line_tab IN OUT NOCOPY WSH_OTM_RIQ_LINE_TAB,

Line 1925: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

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,
1928: x_source_line_tab IN OUT NOCOPY WSH_OTM_RIQ_LINE_TAB,
1929: x_return_status OUT NOCOPY VARCHAR2) IS

Line 2217: p_source_header_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_TAB,

2213: END Format_Line_Input_For_Xml;
2214:
2215:
2216: PROCEDURE Format_Header_Input_For_Xml(
2217: p_source_header_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_TAB,
2218: p_source_type IN VARCHAR2,
2219: p_action IN VARCHAR2,
2220: x_source_header_tab IN OUT NOCOPY WSH_OTM_RIQ_HEADER_TAB,
2221: x_return_status OUT NOCOPY VARCHAR2) IS

Line 4099: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,

4095: END Extract_Ship_Method;
4096:
4097:
4098: PROCEDURE Populate_Get_SM_Result(
4099: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4100: p_carrier_id IN NUMBER,
4101: p_mode IN VARCHAR2,
4102: p_service_level IN VARCHAR2,
4103: p_freight_terms_code IN VARCHAR2,

Line 4280: p_source_header_rates_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_REC,

4276: PROCEDURE Allocate_rates(
4277: p_summary_rate IN NUMBER,
4278: p_base_price IN NUMBER,
4279: p_charge IN NUMBER,
4280: p_source_header_rates_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_REC,
4281: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4282: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4283: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4284: x_return_status OUT NOCOPY VARCHAR2)

Line 4281: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,

4277: p_summary_rate IN NUMBER,
4278: p_base_price IN NUMBER,
4279: p_charge IN NUMBER,
4280: p_source_header_rates_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_REC,
4281: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4282: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4283: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4284: x_return_status OUT NOCOPY VARCHAR2)
4285: IS

Line 4282: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

4278: p_base_price IN NUMBER,
4279: p_charge IN NUMBER,
4280: p_source_header_rates_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_REC,
4281: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4282: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4283: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4284: x_return_status OUT NOCOPY VARCHAR2)
4285: IS
4286: i NUMBER;

Line 4283: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,

4279: p_charge IN NUMBER,
4280: p_source_header_rates_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_REC,
4281: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4282: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4283: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4284: x_return_status OUT NOCOPY VARCHAR2)
4285: IS
4286: i NUMBER;
4287: j NUMBER;

Line 4294: l_line_rate_rec FTE_PROCESS_REQUESTS.fte_source_line_rates_rec;

4290:
4291: l_fraction NUMBER;
4292: l_base_price NUMBER;
4293: l_charge NUMBER;
4294: l_line_rate_rec FTE_PROCESS_REQUESTS.fte_source_line_rates_rec;
4295:
4296: l_return_status VARCHAR2(1);
4297: l_debug_on BOOLEAN;
4298: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Allocate_rates';

Line 4539: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,

4535: p_base_rate IN NUMBER,
4536: p_charge_rate IN NUMBER,
4537: p_transit_time IN NUMBER,
4538: p_transit_time_UOM IN VARCHAR2,
4539: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4540: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4541: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4542: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
4543: x_return_status OUT NOCOPY VARCHAR2)

Line 4540: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

4536: p_charge_rate IN NUMBER,
4537: p_transit_time IN NUMBER,
4538: p_transit_time_UOM IN VARCHAR2,
4539: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4540: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4541: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4542: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
4543: x_return_status OUT NOCOPY VARCHAR2)
4544: IS

Line 4541: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,

4537: p_transit_time IN NUMBER,
4538: p_transit_time_UOM IN VARCHAR2,
4539: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4540: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4541: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4542: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
4543: x_return_status OUT NOCOPY VARCHAR2)
4544: IS
4545:

Line 4542: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,

4538: p_transit_time_UOM IN VARCHAR2,
4539: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4540: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4541: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4542: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
4543: x_return_status OUT NOCOPY VARCHAR2)
4544: IS
4545:
4546: i NUMBER;

Line 4552: l_source_header_rates_rec FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_REC;

4548: k NUMBER;
4549: l_generic_carrier VARCHAR2(1);
4550: l_carrier_freight_code VARCHAR2(30);
4551:
4552: l_source_header_rates_rec FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_REC;
4553:
4554: l_return_status VARCHAR2(1);
4555: l_debug_on BOOLEAN;
4556: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Populate_Get_FC_Result';

Line 4698: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,

4694: p_summary_rate IN NUMBER,
4695: p_base_rate IN NUMBER,
4696: p_charge_rate IN NUMBER,
4697: p_ship_method_code IN VARCHAR2,
4698: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4699: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4700: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4701: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
4702: x_return_status OUT NOCOPY VARCHAR2)

Line 4699: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

4695: p_base_rate IN NUMBER,
4696: p_charge_rate IN NUMBER,
4697: p_ship_method_code IN VARCHAR2,
4698: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4699: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4700: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4701: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
4702: x_return_status OUT NOCOPY VARCHAR2)
4703: IS

Line 4700: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,

4696: p_charge_rate IN NUMBER,
4697: p_ship_method_code IN VARCHAR2,
4698: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4699: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4700: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4701: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
4702: x_return_status OUT NOCOPY VARCHAR2)
4703: IS
4704: i NUMBER;

Line 4701: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,

4697: p_ship_method_code IN VARCHAR2,
4698: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4699: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
4700: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
4701: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
4702: x_return_status OUT NOCOPY VARCHAR2)
4703: IS
4704: i NUMBER;
4705: j NUMBER;

Line 4707: l_source_header_rates_rec FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_REC;

4703: IS
4704: i NUMBER;
4705: j NUMBER;
4706: k NUMBER;
4707: l_source_header_rates_rec FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_REC;
4708: l_generic_carrier VARCHAR2(1);
4709: l_carrier_freight_code VARCHAR2(30);
4710:
4711: l_return_status VARCHAR2(1);

Line 4873: x_source_header_rec IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,

4869: PROCEDURE Handle_Get_SM_Response(
4870: p_xml_output IN XMLTYPE,
4871: p_source_type IN VARCHAR2,
4872: p_action IN VARCHAR2,
4873: x_source_header_rec IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4874: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4875: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4876: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4877: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 5061: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,

5057: PROCEDURE Handle_Get_FC_Response(
5058: p_xml_output IN XMLTYPE,
5059: p_source_type IN VARCHAR2,
5060: p_action IN VARCHAR2,
5061: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5062: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5063: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5064: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5065: x_return_status OUT NOCOPY VARCHAR2)

Line 5062: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

5058: p_xml_output IN XMLTYPE,
5059: p_source_type IN VARCHAR2,
5060: p_action IN VARCHAR2,
5061: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5062: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5063: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5064: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5065: x_return_status OUT NOCOPY VARCHAR2)
5066: IS

Line 5063: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,

5059: p_source_type IN VARCHAR2,
5060: p_action IN VARCHAR2,
5061: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5062: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5063: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5064: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5065: x_return_status OUT NOCOPY VARCHAR2)
5066: IS
5067:

Line 5064: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,

5060: p_action IN VARCHAR2,
5061: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5062: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5063: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5064: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5065: x_return_status OUT NOCOPY VARCHAR2)
5066: IS
5067:
5068: l_summary_rate NUMBER;

Line 5245: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,

5241: PROCEDURE Handle_Choose_SM_Response(
5242: p_xml_output IN XMLTYPE,
5243: p_source_type IN VARCHAR2,
5244: p_action IN VARCHAR2,
5245: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5246: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5247: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5248: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5249: x_return_status OUT NOCOPY VARCHAR2)

Line 5246: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

5242: p_xml_output IN XMLTYPE,
5243: p_source_type IN VARCHAR2,
5244: p_action IN VARCHAR2,
5245: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5246: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5247: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5248: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5249: x_return_status OUT NOCOPY VARCHAR2)
5250: IS

Line 5247: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,

5243: p_source_type IN VARCHAR2,
5244: p_action IN VARCHAR2,
5245: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5246: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5247: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5248: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5249: x_return_status OUT NOCOPY VARCHAR2)
5250: IS
5251:

Line 5248: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,

5244: p_action IN VARCHAR2,
5245: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5246: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5247: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5248: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5249: x_return_status OUT NOCOPY VARCHAR2)
5250: IS
5251:
5252: l_SM_failure VARCHAR2(1);

Line 5573: x_source_header_rec IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,

5569: PROCEDURE Parse_RIQ_Output_XML(
5570: p_xml_output IN XMLTYPE,
5571: p_source_type IN VARCHAR2,
5572: p_action IN VARCHAR2,
5573: x_source_header_rec IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5574: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5575: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5576: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5577: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 5574: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

5570: p_xml_output IN XMLTYPE,
5571: p_source_type IN VARCHAR2,
5572: p_action IN VARCHAR2,
5573: x_source_header_rec IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5574: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5575: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5576: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5577: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5578: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 5575: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,

5571: p_source_type IN VARCHAR2,
5572: p_action IN VARCHAR2,
5573: x_source_header_rec IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5574: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5575: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5576: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5577: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5578: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5579: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 5576: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,

5572: p_action IN VARCHAR2,
5573: x_source_header_rec IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5574: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5575: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5576: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5577: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5578: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5579: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5580: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 5948: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

5944: END Clear_Globals;
5945:
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,

Line 5949: x_source_header_rec IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,

5945:
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,

Line 5953: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_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,
5955: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5956: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5957: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 5954: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,

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,
5955: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5956: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5957: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5958: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 6231: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

6227: END Process_One_Header;
6228:
6229:
6230: PROCEDURE CALL_OTM_FOR_OM(
6231: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
6232: x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_TAB,
6233: p_source_type IN VARCHAR2,
6234: p_action IN VARCHAR2,
6235: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,

Line 6232: x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_TAB,

6228:
6229:
6230: PROCEDURE CALL_OTM_FOR_OM(
6231: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
6232: x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_TAB,
6233: p_source_type IN VARCHAR2,
6234: p_action IN VARCHAR2,
6235: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
6236: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,

Line 6235: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,

6231: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
6232: x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_TAB,
6233: p_source_type IN VARCHAR2,
6234: p_action IN VARCHAR2,
6235: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
6236: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
6237: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6238: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6239: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 6236: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,

6232: x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_TAB,
6233: p_source_type IN VARCHAR2,
6234: p_action IN VARCHAR2,
6235: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
6236: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
6237: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6238: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6239: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6240: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,