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.FTE_MLS_WRAPPER dependencies on FTE_ID_TAB_TYPE

Line 1700: (p_tenderIdTab IN FTE_ID_TAB_TYPE -- Table of Trip Names

1696: -- VERSION : current version 1.0
1697: -- initial version 1.0
1698: --========================================================================
1699: FUNCTION GET_TRIP_MSG_TOKEN
1700: (p_tenderIdTab IN FTE_ID_TAB_TYPE -- Table of Trip Names
1701: ) RETURN VARCHAR2 IS
1702: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1703: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.' || 'GET_TRIP_MSG_TOKEN';
1704:

Line 1965: p_trip_id_tab IN FTE_ID_TAB_TYPE,

1961: --========================================================================
1962: PROCEDURE TENDER_TRIPS
1963: ( p_api_version_number IN NUMBER,
1964: p_init_msg_list IN VARCHAR2,
1965: p_trip_id_tab IN FTE_ID_TAB_TYPE,
1966: p_caller IN VARCHAR2,
1967: x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC,
1968: x_return_status OUT NOCOPY VARCHAR2,
1969: x_msg_count OUT NOCOPY NUMBER,

Line 2005: l_error_id_tab FTE_ID_TAB_TYPE;

2001: l_wFItemKey VARCHAR2(240);
2002: l_error_tkn VARCHAR2(500);
2003:
2004: --Result and Failed IDs
2005: l_error_id_tab FTE_ID_TAB_TYPE;
2006: l_valid_ids_tab FTE_ID_TAB_TYPE;
2007: l_error_name_tab FTE_NAME_TAB_TYPE;
2008: l_valid_name_tab FTE_NAME_TAB_TYPE;
2009:

Line 2006: l_valid_ids_tab FTE_ID_TAB_TYPE;

2002: l_error_tkn VARCHAR2(500);
2003:
2004: --Result and Failed IDs
2005: l_error_id_tab FTE_ID_TAB_TYPE;
2006: l_valid_ids_tab FTE_ID_TAB_TYPE;
2007: l_error_name_tab FTE_NAME_TAB_TYPE;
2008: l_valid_name_tab FTE_NAME_TAB_TYPE;
2009:
2010: l_tenderIds VARCHAR2(500);

Line 2142: l_error_id_tab := FTE_ID_TAB_TYPE();

2138: WSH_DEBUG_SV.PUSH(l_module_name);
2139: WSH_DEBUG_SV.logmsg(l_module_name,'About to tender ' || p_trip_id_tab.COUNT || ' Trips');
2140: END IF;
2141:
2142: l_error_id_tab := FTE_ID_TAB_TYPE();
2143: l_valid_ids_tab := FTE_ID_TAB_TYPE();
2144: l_error_name_tab := FTE_NAME_TAB_TYPE();
2145: l_valid_name_tab := FTE_NAME_TAB_TYPE();
2146:

Line 2143: l_valid_ids_tab := FTE_ID_TAB_TYPE();

2139: WSH_DEBUG_SV.logmsg(l_module_name,'About to tender ' || p_trip_id_tab.COUNT || ' Trips');
2140: END IF;
2141:
2142: l_error_id_tab := FTE_ID_TAB_TYPE();
2143: l_valid_ids_tab := FTE_ID_TAB_TYPE();
2144: l_error_name_tab := FTE_NAME_TAB_TYPE();
2145: l_valid_name_tab := FTE_NAME_TAB_TYPE();
2146:
2147:

Line 2541: p_trip_id_tab IN FTE_ID_TAB_TYPE,

2537: --========================================================================
2538: PROCEDURE CANCEL_TENDER_TRIPS
2539: ( p_api_version_number IN NUMBER,
2540: p_init_msg_list IN VARCHAR2,
2541: p_trip_id_tab IN FTE_ID_TAB_TYPE,
2542: x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC,
2543: x_return_status OUT NOCOPY VARCHAR2,
2544: x_msg_count OUT NOCOPY NUMBER,
2545: x_msg_data OUT NOCOPY VARCHAR2

Line 2566: l_error_id_tab FTE_ID_TAB_TYPE;

2562: l_carrier_contact_id NUMBER := 0;
2563: l_wFItemKey VARCHAR2(240);
2564:
2565: --Result and Failed IDs
2566: l_error_id_tab FTE_ID_TAB_TYPE;
2567: l_valid_ids_tab FTE_ID_TAB_TYPE;
2568: l_error_name_tab FTE_NAME_TAB_TYPE;
2569:
2570: x_trip_id NUMBER := 0;

Line 2567: l_valid_ids_tab FTE_ID_TAB_TYPE;

2563: l_wFItemKey VARCHAR2(240);
2564:
2565: --Result and Failed IDs
2566: l_error_id_tab FTE_ID_TAB_TYPE;
2567: l_valid_ids_tab FTE_ID_TAB_TYPE;
2568: l_error_name_tab FTE_NAME_TAB_TYPE;
2569:
2570: x_trip_id NUMBER := 0;
2571: x_trip_name VARCHAR2(30);

Line 2594: l_error_id_tab := FTE_ID_TAB_TYPE();

2590: WSH_DEBUG_SV.PUSH(l_module_name);
2591: WSH_DEBUG_SV.logmsg(l_module_name,'About to cancel tender ' || p_trip_id_tab.COUNT || ' Trips');
2592: END IF;
2593:
2594: l_error_id_tab := FTE_ID_TAB_TYPE();
2595: l_valid_ids_tab := FTE_ID_TAB_TYPE();
2596: l_error_name_tab := FTE_NAME_TAB_TYPE();
2597:
2598: BEGIN

Line 2595: l_valid_ids_tab := FTE_ID_TAB_TYPE();

2591: WSH_DEBUG_SV.logmsg(l_module_name,'About to cancel tender ' || p_trip_id_tab.COUNT || ' Trips');
2592: END IF;
2593:
2594: l_error_id_tab := FTE_ID_TAB_TYPE();
2595: l_valid_ids_tab := FTE_ID_TAB_TYPE();
2596: l_error_name_tab := FTE_NAME_TAB_TYPE();
2597:
2598: BEGIN
2599: FOR i IN p_trip_id_tab.FIRST..p_trip_id_tab.LAST LOOP

Line 2872: p_trip_id_tab IN FTE_ID_TAB_TYPE,

2868:
2869: PROCEDURE Trip_Action
2870: ( p_api_version_number IN NUMBER,
2871: p_init_msg_list IN VARCHAR2,
2872: p_trip_id_tab IN FTE_ID_TAB_TYPE,
2873: p_action_prms IN FTE_TRIP_ACTION_PARAM_REC,
2874: x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC,
2875: x_return_status OUT NOCOPY VARCHAR2,
2876: x_msg_count OUT NOCOPY NUMBER,

Line 2889: l_result_id_tab FTE_ID_TAB_TYPE;

2885:
2886: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2887: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME ||
2888: '.' || 'TRIP_ACTION';
2889: l_result_id_tab FTE_ID_TAB_TYPE;
2890: l_valid_ids_tab FTE_ID_TAB_TYPE;
2891:
2892:
2893: BEGIN

Line 2890: l_valid_ids_tab FTE_ID_TAB_TYPE;

2886: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2887: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME ||
2888: '.' || 'TRIP_ACTION';
2889: l_result_id_tab FTE_ID_TAB_TYPE;
2890: l_valid_ids_tab FTE_ID_TAB_TYPE;
2891:
2892:
2893: BEGIN
2894:

Line 2997: l_result_id_tab := FTE_ID_TAB_TYPE();

2993: );
2994:
2995:
2996: -- Step 4: Copy out wsh out rec to fte out rec
2997: l_result_id_tab := FTE_ID_TAB_TYPE();
2998: l_valid_ids_tab := FTE_ID_TAB_TYPE();
2999: x_action_out_rec := FTE_ACTION_OUT_REC(
3000: l_result_id_tab,l_valid_ids_tab,null,null,null,null,null,null);
3001:

Line 2998: l_valid_ids_tab := FTE_ID_TAB_TYPE();

2994:
2995:
2996: -- Step 4: Copy out wsh out rec to fte out rec
2997: l_result_id_tab := FTE_ID_TAB_TYPE();
2998: l_valid_ids_tab := FTE_ID_TAB_TYPE();
2999: x_action_out_rec := FTE_ACTION_OUT_REC(
3000: l_result_id_tab,l_valid_ids_tab,null,null,null,null,null,null);
3001:
3002: -- Step 4.1 Copy wsh result id from l_wsh_out_rec to

Line 3112: p_stop_id_tab IN FTE_ID_TAB_TYPE,

3108:
3109: PROCEDURE STOP_ACTION
3110: ( p_api_version_number IN NUMBER,
3111: p_init_msg_list IN VARCHAR2,
3112: p_stop_id_tab IN FTE_ID_TAB_TYPE,
3113: p_action_prms IN FTE_STOP_ACTION_PARAM_REC,
3114: x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC,
3115: x_return_status OUT NOCOPY VARCHAR2,
3116: x_msg_count OUT NOCOPY NUMBER,

Line 3464: x_stop_out_tab OUT NOCOPY FTE_ID_TAB_TYPE,

3460: PROCEDURE PROCESS_STOPS(
3461: p_api_version_number IN NUMBER,
3462: p_init_msg_list IN VARCHAR2,
3463: p_commit IN VARCHAR2,
3464: x_stop_out_tab OUT NOCOPY FTE_ID_TAB_TYPE,
3465: x_stop_seq_tab OUT NOCOPY FTE_ID_TAB_TYPE,
3466: x_return_status OUT NOCOPY VARCHAR2,
3467: x_msg_count OUT NOCOPY NUMBER,
3468: x_msg_data OUT NOCOPY VARCHAR2)

Line 3465: x_stop_seq_tab OUT NOCOPY FTE_ID_TAB_TYPE,

3461: p_api_version_number IN NUMBER,
3462: p_init_msg_list IN VARCHAR2,
3463: p_commit IN VARCHAR2,
3464: x_stop_out_tab OUT NOCOPY FTE_ID_TAB_TYPE,
3465: x_stop_seq_tab OUT NOCOPY FTE_ID_TAB_TYPE,
3466: x_return_status OUT NOCOPY VARCHAR2,
3467: x_msg_count OUT NOCOPY NUMBER,
3468: x_msg_data OUT NOCOPY VARCHAR2)
3469: IS

Line 3527: x_stop_out_tab := FTE_ID_TAB_TYPE();

3523: G_STOPS_SEQ_TAB.count);
3524:
3525: END IF;
3526:
3527: x_stop_out_tab := FTE_ID_TAB_TYPE();
3528: x_stop_seq_tab := FTE_ID_TAB_TYPE();
3529:
3530:
3531: IF l_debug_on THEN

Line 3528: x_stop_seq_tab := FTE_ID_TAB_TYPE();

3524:
3525: END IF;
3526:
3527: x_stop_out_tab := FTE_ID_TAB_TYPE();
3528: x_stop_seq_tab := FTE_ID_TAB_TYPE();
3529:
3530:
3531: IF l_debug_on THEN
3532:

Line 4018: p_mls_id_tab IN FTE_ID_TAB_TYPE,

4014:
4015: PROCEDURE Delivery_Detail_Action
4016: ( p_api_version_number IN NUMBER,
4017: p_init_msg_list IN VARCHAR2,
4018: p_mls_id_tab IN FTE_ID_TAB_TYPE,
4019: p_action_params IN FTE_DDL_ACTION_PARAM_REC,
4020: x_return_status OUT NOCOPY VARCHAR2,
4021: x_msg_count OUT NOCOPY NUMBER,
4022: x_msg_data OUT NOCOPY VARCHAR2,

Line 4032: l_result_id_tab FTE_ID_TAB_TYPE;

4028: l_action_prms wsh_glbl_var_strct_grp.dd_action_parameters_rec_type;
4029: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
4030:
4031: -- Set action_out_rec
4032: l_result_id_tab FTE_ID_TAB_TYPE;
4033: l_valid_id_tab FTE_ID_TAB_TYPE;
4034: l_delivery_id_tab FTE_ID_TAB_TYPE;
4035: l_selection_issue_flag VARCHAR(1);
4036: l_split_quantity NUMBER;

Line 4033: l_valid_id_tab FTE_ID_TAB_TYPE;

4029: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
4030:
4031: -- Set action_out_rec
4032: l_result_id_tab FTE_ID_TAB_TYPE;
4033: l_valid_id_tab FTE_ID_TAB_TYPE;
4034: l_delivery_id_tab FTE_ID_TAB_TYPE;
4035: l_selection_issue_flag VARCHAR(1);
4036: l_split_quantity NUMBER;
4037: l_split_quantity2 NUMBER;

Line 4034: l_delivery_id_tab FTE_ID_TAB_TYPE;

4030:
4031: -- Set action_out_rec
4032: l_result_id_tab FTE_ID_TAB_TYPE;
4033: l_valid_id_tab FTE_ID_TAB_TYPE;
4034: l_delivery_id_tab FTE_ID_TAB_TYPE;
4035: l_selection_issue_flag VARCHAR(1);
4036: l_split_quantity NUMBER;
4037: l_split_quantity2 NUMBER;
4038: l_caller VARCHAR(100);

Line 4115: l_result_id_tab := FTE_ID_TAB_TYPE();

4111: p_action_prms =>l_action_prms, -- wsh_glbl_var_strct_grp.dd_action_parameters_rec_type
4112: x_action_out_rec =>l_detail_out_rec -- wsh_glbl_var_strct_grp.dd_action_out_rec_type
4113: );
4114:
4115: l_result_id_tab := FTE_ID_TAB_TYPE();
4116: l_valid_id_tab := FTE_ID_TAB_TYPE();
4117: l_delivery_id_tab := FTE_ID_TAB_TYPE();
4118: x_action_out_rec := FTE_ACTION_OUT_REC(
4119: l_result_id_tab,l_valid_id_tab,l_delivery_id_tab,null,null,null,null,null);

Line 4116: l_valid_id_tab := FTE_ID_TAB_TYPE();

4112: x_action_out_rec =>l_detail_out_rec -- wsh_glbl_var_strct_grp.dd_action_out_rec_type
4113: );
4114:
4115: l_result_id_tab := FTE_ID_TAB_TYPE();
4116: l_valid_id_tab := FTE_ID_TAB_TYPE();
4117: l_delivery_id_tab := FTE_ID_TAB_TYPE();
4118: x_action_out_rec := FTE_ACTION_OUT_REC(
4119: l_result_id_tab,l_valid_id_tab,l_delivery_id_tab,null,null,null,null,null);
4120:

Line 4117: l_delivery_id_tab := FTE_ID_TAB_TYPE();

4113: );
4114:
4115: l_result_id_tab := FTE_ID_TAB_TYPE();
4116: l_valid_id_tab := FTE_ID_TAB_TYPE();
4117: l_delivery_id_tab := FTE_ID_TAB_TYPE();
4118: x_action_out_rec := FTE_ACTION_OUT_REC(
4119: l_result_id_tab,l_valid_id_tab,l_delivery_id_tab,null,null,null,null,null);
4120:
4121: -- set valid ids tab

Line 4233: x_detail_id_tab OUT NOCOPY FTE_ID_TAB_TYPE

4229: p_action_code IN VARCHAR2,
4230: x_return_status OUT NOCOPY VARCHAR2,
4231: x_msg_count OUT NOCOPY NUMBER,
4232: x_msg_data OUT NOCOPY VARCHAR2,
4233: x_detail_id_tab OUT NOCOPY FTE_ID_TAB_TYPE
4234: ) IS
4235:
4236: l_detail_attr_tab_type wsh_glbl_var_strct_grp.delivery_details_Attr_tbl_Type;
4237: l_detail_attr_rec wsh_glbl_var_strct_grp.delivery_details_rec_type;

Line 4561: p_mls_id_tab IN FTE_ID_TAB_TYPE,

4557:
4558: PROCEDURE Delivery_Action
4559: ( p_api_version_number IN NUMBER,
4560: p_init_msg_list IN VARCHAR2,
4561: p_mls_id_tab IN FTE_ID_TAB_TYPE,
4562: p_action_params IN FTE_DLV_ACTION_PARAM_REC,
4563: x_return_status OUT NOCOPY VARCHAR2,
4564: x_msg_count OUT NOCOPY NUMBER,
4565: x_msg_data OUT NOCOPY VARCHAR2,

Line 4574: l_result_id_tab FTE_ID_TAB_TYPE;

4570: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
4571: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4572:
4573: -- Set delivery action_out_rec
4574: l_result_id_tab FTE_ID_TAB_TYPE;
4575: l_valid_id_tab FTE_ID_TAB_TYPE;
4576: l_selection_issue_flag VARCHAR(1);
4577: l_packing_slip_number VARCHAR2(50);
4578:

Line 4575: l_valid_id_tab FTE_ID_TAB_TYPE;

4571: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4572:
4573: -- Set delivery action_out_rec
4574: l_result_id_tab FTE_ID_TAB_TYPE;
4575: l_valid_id_tab FTE_ID_TAB_TYPE;
4576: l_selection_issue_flag VARCHAR(1);
4577: l_packing_slip_number VARCHAR2(50);
4578:
4579:

Line 4700: l_result_id_tab := FTE_ID_TAB_TYPE();

4696: p_msg_data =>l_msg_data);
4697:
4698:
4699:
4700: l_result_id_tab := FTE_ID_TAB_TYPE();
4701: l_valid_id_tab := FTE_ID_TAB_TYPE();
4702: x_action_out_rec := FTE_ACTION_OUT_REC(
4703: l_result_id_tab,l_valid_id_tab,null,null,null,null,null,null);
4704:

Line 4701: l_valid_id_tab := FTE_ID_TAB_TYPE();

4697:
4698:
4699:
4700: l_result_id_tab := FTE_ID_TAB_TYPE();
4701: l_valid_id_tab := FTE_ID_TAB_TYPE();
4702: x_action_out_rec := FTE_ACTION_OUT_REC(
4703: l_result_id_tab,l_valid_id_tab,null,null,null,null,null,null);
4704:
4705: -- set valid ids tab

Line 4831: p_mls_delivery_id_tab IN FTE_ID_TAB_TYPE,

4827:
4828: PROCEDURE Delivery_Action_On_Trip
4829: ( p_api_version_number IN NUMBER,
4830: p_init_msg_list IN VARCHAR2,
4831: p_mls_delivery_id_tab IN FTE_ID_TAB_TYPE,
4832: p_mls_trip_id_tab IN FTE_ID_TAB_TYPE,
4833: p_action_params IN FTE_DLV_ACTION_PARAM_REC,
4834: x_return_status OUT NOCOPY VARCHAR2,
4835: x_msg_count OUT NOCOPY NUMBER,

Line 4832: p_mls_trip_id_tab IN FTE_ID_TAB_TYPE,

4828: PROCEDURE Delivery_Action_On_Trip
4829: ( p_api_version_number IN NUMBER,
4830: p_init_msg_list IN VARCHAR2,
4831: p_mls_delivery_id_tab IN FTE_ID_TAB_TYPE,
4832: p_mls_trip_id_tab IN FTE_ID_TAB_TYPE,
4833: p_action_params IN FTE_DLV_ACTION_PARAM_REC,
4834: x_return_status OUT NOCOPY VARCHAR2,
4835: x_msg_count OUT NOCOPY NUMBER,
4836: x_msg_data OUT NOCOPY VARCHAR2,

Line 4845: x_result_id_tab FTE_ID_TAB_TYPE;

4841: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
4842: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4843:
4844: -- Set delivery action_out_rec
4845: x_result_id_tab FTE_ID_TAB_TYPE;
4846: x_valid_id_tab FTE_ID_TAB_TYPE;
4847: l_selection_issue_flag VARCHAR(1);
4848: l_packing_slip_number VARCHAR2(50);
4849: l_return_status VARCHAR2(100);

Line 4846: x_valid_id_tab FTE_ID_TAB_TYPE;

4842: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4843:
4844: -- Set delivery action_out_rec
4845: x_result_id_tab FTE_ID_TAB_TYPE;
4846: x_valid_id_tab FTE_ID_TAB_TYPE;
4847: l_selection_issue_flag VARCHAR(1);
4848: l_packing_slip_number VARCHAR2(50);
4849: l_return_status VARCHAR2(100);
4850: l_msg_count NUMBER;

Line 4887: x_result_id_tab := FTE_ID_TAB_TYPE();

4883: IF l_debug_on THEN
4884: wsh_debug_sv.push(l_module_name);
4885: END IF;
4886:
4887: x_result_id_tab := FTE_ID_TAB_TYPE();
4888: x_valid_id_tab := FTE_ID_TAB_TYPE();
4889:
4890: FOR i IN p_mls_delivery_id_tab.FIRST..p_mls_delivery_id_tab.LAST LOOP
4891: -- set action_prms

Line 4888: x_valid_id_tab := FTE_ID_TAB_TYPE();

4884: wsh_debug_sv.push(l_module_name);
4885: END IF;
4886:
4887: x_result_id_tab := FTE_ID_TAB_TYPE();
4888: x_valid_id_tab := FTE_ID_TAB_TYPE();
4889:
4890: FOR i IN p_mls_delivery_id_tab.FIRST..p_mls_delivery_id_tab.LAST LOOP
4891: -- set action_prms
4892: l_action_prms.phase := p_action_params.phase;

Line 5041: x_dlvy_id_tab OUT NOCOPY FTE_ID_TAB_TYPE

5037: p_action_code IN VARCHAR2,
5038: x_return_status OUT NOCOPY VARCHAR2,
5039: x_msg_count OUT NOCOPY NUMBER,
5040: x_msg_data OUT NOCOPY VARCHAR2,
5041: x_dlvy_id_tab OUT NOCOPY FTE_ID_TAB_TYPE
5042: ) IS
5043:
5044: l_dlvy_attr_tab_type WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
5045: l_dlvy_attr_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

Line 5358: x_result_id_tab FTE_ID_TAB_TYPE;

5354: l_exception_action_param_rec WSH_EXCEPTIONS_PUB.XC_ACTION_REC_TYPE;
5355: l_fte_dlvy_attr_rec FTE_XC_ACTION_PARAM_REC;
5356:
5357: -- Set delivery action_out_rec
5358: x_result_id_tab FTE_ID_TAB_TYPE;
5359: x_valid_id_tab FTE_ID_TAB_TYPE;
5360: l_return_status VARCHAR2(100);
5361: l_msg_count NUMBER;
5362: l_msg_data VARCHAR2(500);

Line 5359: x_valid_id_tab FTE_ID_TAB_TYPE;

5355: l_fte_dlvy_attr_rec FTE_XC_ACTION_PARAM_REC;
5356:
5357: -- Set delivery action_out_rec
5358: x_result_id_tab FTE_ID_TAB_TYPE;
5359: x_valid_id_tab FTE_ID_TAB_TYPE;
5360: l_return_status VARCHAR2(100);
5361: l_msg_count NUMBER;
5362: l_msg_data VARCHAR2(500);
5363: l_number_of_warnings NUMBER;

Line 5397: x_result_id_tab := FTE_ID_TAB_TYPE();

5393: wsh_debug_sv.push(l_module_name);
5394: END IF;
5395:
5396: -- Iteratively loop through each rec in the tab and call WSH API
5397: x_result_id_tab := FTE_ID_TAB_TYPE();
5398: x_valid_id_tab := FTE_ID_TAB_TYPE();
5399:
5400: FOR i IN p_xc_action_tab.FIRST..p_xc_action_tab.LAST LOOP
5401: l_fte_dlvy_attr_rec := p_xc_action_tab(i);

Line 5398: x_valid_id_tab := FTE_ID_TAB_TYPE();

5394: END IF;
5395:
5396: -- Iteratively loop through each rec in the tab and call WSH API
5397: x_result_id_tab := FTE_ID_TAB_TYPE();
5398: x_valid_id_tab := FTE_ID_TAB_TYPE();
5399:
5400: FOR i IN p_xc_action_tab.FIRST..p_xc_action_tab.LAST LOOP
5401: l_fte_dlvy_attr_rec := p_xc_action_tab(i);
5402:

Line 5596: p_id_tab IN FTE_ID_TAB_TYPE,

5592: PROCEDURE GROUP_DETAIL_SEARCH_DLVY
5593: ( p_api_version_number IN NUMBER,
5594: p_init_msg_list IN VARCHAR2,
5595: p_commit IN VARCHAR2,
5596: p_id_tab IN FTE_ID_TAB_TYPE,
5597: x_return_status OUT NOCOPY VARCHAR2,
5598: x_msg_count OUT NOCOPY NUMBER,
5599: x_msg_data OUT NOCOPY VARCHAR2
5600: )IS

Line 6491: l_trip_id_tab FTE_ID_TAB_TYPE;

6487: l_msg_data VARCHAR2(32767);
6488: l_number_of_warnings NUMBER;
6489: l_number_of_errors NUMBER;
6490:
6491: l_trip_id_tab FTE_ID_TAB_TYPE;
6492:
6493:
6494:
6495: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 6532: l_trip_id_tab := FTE_ID_TAB_TYPE();

6528:
6529:
6530: IF p_action_prms.action_code = FTE_TENDER_PVT.S_TENDERED THEN
6531: --{
6532: l_trip_id_tab := FTE_ID_TAB_TYPE();
6533: l_trip_id_tab.EXTEND;
6534: l_trip_id_tab(l_trip_id_tab.COUNT) := p_tripId;
6535:
6536: FTE_MLS_WRAPPER.TENDER_TRIPS