APPS.FTE_MLS_WRAPPER dependencies on FTE_TENDER_ATTR_REC

Line 1167: l_tender_attr_rec FTE_TENDER_ATTR_REC;

1163: l_msg_data VARCHAR2(32767);
1164:
1165: l_action_out_rec FTE_ACTION_OUT_REC;
1166: trip_action_param FTE_TRIP_ACTION_PARAM_REC;
1167: l_tender_attr_rec FTE_TENDER_ATTR_REC;
1168:
1169: l_db_lane_id NUMBER;
1170:
1171: BEGIN

Line 1426: l_tender_attr_rec := FTE_TENDER_ATTR_REC(

1422: null,null,null,null,null,null,
1423: null,null,null,null,null,null,
1424: null,null);
1425:
1426: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
1427: p_rec_TRIP_ID, -- TripId
1428: p_rec_NAME, -- Trip Name
1429: p_rec_TRIP_ID, --tender id
1430: l_db_tender_status, -- status

Line 2014: l_tender_attr_rec FTE_TENDER_ATTR_REC;

2010: l_tenderIds VARCHAR2(500);
2011:
2012: l_trip_action_rec FTE_TRIP_ACTION_PARAM_REC;
2013: l_action_out_rec FTE_ACTION_OUT_REC;
2014: l_tender_attr_rec FTE_TENDER_ATTR_REC;
2015:
2016:
2017: --OUTBOUND TripStops
2018: CURSOR c_tripStops (p_tripID NUMBER) IS

Line 2242: l_tender_attr_rec := FTE_TENDER_ATTR_REC(

2238: null,null,null,null,null,null,
2239: null,null);
2240:
2241:
2242: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
2243: p_trip_id_tab(i), -- TripId
2244: l_tripName, -- Trip Name
2245: p_trip_id_tab(i), --tender id
2246: l_tripTenderStatus, -- status

Line 2580: l_tender_attr_rec FTE_TENDER_ATTR_REC;

2576: x_LAST_UPDATE_LOGIN NUMBER;
2577:
2578: l_trip_action_rec FTE_TRIP_ACTION_PARAM_REC;
2579: l_action_out_rec FTE_ACTION_OUT_REC;
2580: l_tender_attr_rec FTE_TENDER_ATTR_REC;
2581:
2582:
2583: BEGIN
2584: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2619: l_tender_attr_rec := FTE_TENDER_ATTR_REC(

2615: null,null,null,null,null,null,
2616: null,null,null,null,null,null,
2617: null,null);
2618:
2619: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
2620: p_trip_id_tab(i), -- TripId
2621: null, -- Trip Name
2622: p_trip_id_tab(i), --tender id
2623: FTE_TENDER_PVT.S_SHIPPER_CANCELLED, -- status

Line 5855: p_trip_info_rec IN FTE_TENDER_ATTR_REC,

5851: x_return_status OUT NOCOPY VARCHAR2,
5852: x_msg_count OUT NOCOPY NUMBER,
5853: x_msg_data OUT NOCOPY VARCHAR2,
5854: x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC,
5855: p_trip_info_rec IN FTE_TENDER_ATTR_REC,
5856: p_action_prms IN FTE_TRIP_ACTION_PARAM_REC
5857: ) IS
5858:
5859:

Line 5871: l_trip_info_rec FTE_TENDER_ATTR_REC;

5867:
5868: l_mbol_number VARCHAR2(32767);
5869: l_tender_action VARCHAR2(30);
5870: l_item_key VARCHAR2(240);
5871: l_trip_info_rec FTE_TENDER_ATTR_REC;
5872:
5873: l_trip_id NUMBER;
5874: l_trip_name VARCHAR2(100);
5875: db_mode_of_transport VARCHAR2(30);

Line 5956: l_trip_info_rec := FTE_TENDER_ATTR_REC(

5952: SELECT SHIP_METHOD_CODE,MODE_OF_TRANSPORT
5953: INTO l_db_sm_code,db_mode_of_transport FROM WSH_TRIPS
5954: WHERE TRIP_ID = p_trip_info_rec.trip_id;
5955:
5956: l_trip_info_rec := FTE_TENDER_ATTR_REC(
5957: p_trip_info_rec.trip_id, -- TripId
5958: p_trip_info_rec.trip_name, -- Trip Name
5959: p_trip_info_rec.tender_id, --tender id
5960: FTE_TENDER_PVT.S_TENDERED, -- status

Line 6125: l_trip_info_rec := FTE_TENDER_ATTR_REC(

6121: select wf_item_key into l_item_key from wsh_trips
6122: where trip_id = p_trip_info_rec.trip_id;
6123:
6124: IF (l_tender_action = FTE_TENDER_PVT.S_REJECTED) THEN
6125: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6126: p_trip_info_rec.trip_id, -- TripId
6127: p_trip_info_rec.trip_name, -- Trip Name
6128: p_trip_info_rec.trip_id, --tender id
6129: FTE_TENDER_PVT.S_REJECTED, -- status

Line 6144: l_trip_info_rec := FTE_TENDER_ATTR_REC(

6140: null,null,null,null,
6141: null,null,
6142: p_trip_info_rec.response_source,null);
6143: ELSIF (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED) THEN
6144: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6145: p_trip_info_rec.trip_id, -- TripId
6146: p_trip_info_rec.trip_name, -- Trip Name
6147: p_trip_info_rec.trip_id, --tender id
6148: FTE_TENDER_PVT.S_ACCEPTED, -- status

Line 6309: l_trip_info_rec := FTE_TENDER_ATTR_REC(

6305:
6306: select wf_item_key into l_item_key from wsh_trips
6307: where trip_id = p_trip_info_rec.trip_id;
6308:
6309: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6310: p_trip_info_rec.trip_id, -- TripId
6311: p_trip_info_rec.trip_name, -- Trip Name
6312: p_trip_info_rec.trip_id, --tender id
6313: FTE_TENDER_PVT.S_SHIPPER_CANCELLED, -- status

Line 6355: l_trip_info_rec := FTE_TENDER_ATTR_REC(

6351:
6352: select wf_item_key into l_item_key from wsh_trips
6353: where trip_id = p_trip_info_rec.trip_id;
6354:
6355: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6356: p_trip_info_rec.trip_id, -- TripId
6357: p_trip_info_rec.trip_name, -- Trip Name
6358: p_trip_info_rec.trip_id, --tender id
6359: FTE_TENDER_PVT.S_SHIPPER_UPDATED, -- status