APPS.FTE_TENDER_WF dependencies on FTE_TENDER_ATTR_REC

Line 865: l_tender_attr_rec FTE_TENDER_ATTR_REC;

861:
862:
863: l_action_out_rec FTE_ACTION_OUT_REC;
864: trip_action_param FTE_TRIP_ACTION_PARAM_REC;
865: l_tender_attr_rec FTE_TENDER_ATTR_REC;
866: l_tender_status VARCHAR2(30);
867: l_tender_process VARCHAR2(100);
868:
869: l_file_name VARCHAR2(300);

Line 916: l_tender_attr_rec := FTE_TENDER_ATTR_REC(

912: END IF;
913:
914: WSH_DEBUG_SV.log(l_module_name,' l_tender_process ',l_tender_process);
915:
916: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
917: p_tender_id, -- TripId
918: null, -- Trip Name
919: p_tender_id, --tender id
920: p_tender_status, -- status

Line 1068: l_tender_attr_rec FTE_TENDER_ATTR_REC;

1064:
1065:
1066: l_action_out_rec FTE_ACTION_OUT_REC;
1067: trip_action_param FTE_TRIP_ACTION_PARAM_REC;
1068: l_tender_attr_rec FTE_TENDER_ATTR_REC;
1069: l_responseSource VARCHAR2(30);
1070:
1071: l_api_name VARCHAR2(30) := 'RAISE_TENDER_ACCEPT';
1072: l_api_version CONSTANT NUMBER := 1.0;

Line 1114: l_tender_attr_rec := FTE_TENDER_ATTR_REC(

1110: --l_carrier_reference_number := wf_engine.GetItemAttrText(itemtype,itemkey,'Z_CARRIER_REFERENCE_NUMBER');
1111: l_vehicle_number := wf_engine.GetItemAttrText(itemtype,itemkey,'VEHICLE_NUMBER');
1112: l_operator := wf_engine.GetItemAttrText(itemtype,itemkey,'VEHICLE_OPERATOR');
1113:
1114: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
1115: l_trip_id, -- TripId
1116: null, -- Trip Name
1117: l_tender_id, --tender id
1118: FTE_TENDER_PVT.S_ACCEPTED, -- status

Line 1252: l_tender_attr_rec FTE_TENDER_ATTR_REC;

1248: l_api_name VARCHAR2(30) := 'RAISE_TENDER_REJECT';
1249:
1250: l_action_out_rec FTE_ACTION_OUT_REC;
1251: trip_action_param FTE_TRIP_ACTION_PARAM_REC;
1252: l_tender_attr_rec FTE_TENDER_ATTR_REC;
1253:
1254: l_responseSource VARCHAR2(30);
1255:
1256: BEGIN

Line 1276: l_tender_attr_rec := FTE_TENDER_ATTR_REC(

1272: -- TBD
1273: l_trip_id := l_tender_id;
1274: l_carrier_response := wf_engine.GetItemAttrText(itemtype,itemkey,'CARRIER_RESPONSE');
1275:
1276: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
1277: l_trip_id, -- TripId
1278: null, -- Trip Name
1279: l_tender_id, --tender id
1280: FTE_TENDER_PVT.S_REJECTED, -- status

Line 1990: l_tender_attr_rec FTE_TENDER_ATTR_REC;

1986: l_msg_token VARCHAR2(1000);
1987:
1988: l_action_out_rec FTE_ACTION_OUT_REC;
1989: trip_action_param FTE_TRIP_ACTION_PARAM_REC;
1990: l_tender_attr_rec FTE_TENDER_ATTR_REC;
1991:
1992: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1993: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
1994:

Line 2052: l_tender_attr_rec := FTE_TENDER_ATTR_REC(

2048: END IF;
2049:
2050:
2051:
2052: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
2053: l_trip_id, -- TripId
2054: null, -- Trip Name
2055: l_tender_id, --tender id
2056: FTE_TENDER_PVT.S_NORESPONSE, -- status

Line 2175: l_tender_attr_rec FTE_TENDER_ATTR_REC;

2171:
2172:
2173: l_action_out_rec FTE_ACTION_OUT_REC;
2174: trip_action_param FTE_TRIP_ACTION_PARAM_REC;
2175: l_tender_attr_rec FTE_TENDER_ATTR_REC;
2176:
2177: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2178: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2179:

Line 2220: l_tender_attr_rec := FTE_TENDER_ATTR_REC(

2216: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2217: l_trip_id := l_tender_id;
2218:
2219:
2220: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
2221: l_trip_id, -- TripId
2222: null, -- Trip Name
2223: l_tender_id, --tender id
2224: FTE_TENDER_PVT.S_AUTO_ACCEPTED, -- status