DBA Data[Home] [Help]

APPS.FTE_MLS_TEST_NT dependencies on FTE_SS_ATTR_REC

Line 11: -- If FTE_SS_ATTR_REC.DELIVERY_ID and

7: -- PROCEDURE : ASSIGN_SERVICE_TENDER FTE wrapper
8: --
9: -- COMMENT : Procedure assigns service, creates/updates ranked list,
10: -- tenders, and deletes rates. TripId should exist in the db.
11: -- If FTE_SS_ATTR_REC.DELIVERY_ID and
12: -- FTE_SS_ATTR_REC.DELIVERY_LEG_ID are null, then it means the
13: -- caller is TWB. Otherwise, the caller is DWB or ManItinerary
14: -- CALLER : FTE UI: TripWB, DeliveryWB, ManageItinerary
15: --========================================================================

Line 12: -- FTE_SS_ATTR_REC.DELIVERY_LEG_ID are null, then it means the

8: --
9: -- COMMENT : Procedure assigns service, creates/updates ranked list,
10: -- tenders, and deletes rates. TripId should exist in the db.
11: -- If FTE_SS_ATTR_REC.DELIVERY_ID and
12: -- FTE_SS_ATTR_REC.DELIVERY_LEG_ID are null, then it means the
13: -- caller is TWB. Otherwise, the caller is DWB or ManItinerary
14: -- CALLER : FTE UI: TripWB, DeliveryWB, ManageItinerary
15: --========================================================================
16: --

Line 22: p_SS_ATTR_REC IN FTE_SS_ATTR_REC,

18: (
19: p_API_VERSION_NUMBER IN NUMBER,
20: p_INIT_MSG_LIST IN VARCHAR2,
21: p_COMMIT IN VARCHAR2,
22: p_SS_ATTR_REC IN FTE_SS_ATTR_REC,
23: p_SS_RATE_SORT_TAB IN OUT NOCOPY FTE_SS_RATE_SORT_TAB_TYPE,
24: p_TENDER_ATTR_REC IN FTE_TENDER_ATTR_REC,
25: p_REQUEST_ID IN NUMBER,
26: p_SERVICE_ACTION IN VARCHAR2,

Line 200: -- current service from FTE_SS_ATTR_REC and rank id.

196: END IF;
197:
198: -- Step 4: Update Trip
199: -- If delivery_id is null, this call is coming from TripWB. Update Trip with
200: -- current service from FTE_SS_ATTR_REC and rank id.
201: -- Else this call is coming from DWB or MI. Update Trip with Rank Id only.
202:
203: IF (l_delivery_id IS NULL ) THEN -- Coming from TWB
204:

Line 379: p_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,

375: p_API_VERSION_NUMBER IN NUMBER,
376: p_INIT_MSG_LIST IN VARCHAR2,
377: p_COMMIT IN VARCHAR2,
378: p_CALLER IN VARCHAR2,
379: p_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,
380: x_LIST_CREATE_TYPE OUT NOCOPY VARCHAR2,
381: x_SS_RATE_SORT_TAB OUT NOCOPY FTE_SS_RATE_SORT_TAB_TYPE,
382: x_PRICING_REQUEST_ID OUT NOCOPY NUMBER,
383: x_RETURN_STATUS OUT NOCOPY VARCHAR2,