DBA Data[Home] [Help]

APPS.FA_LEASE_PUB dependencies on FA_API_TYPES

Line 9: g_log_level_rec fa_api_types.log_level_rec_type;

5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FA_LEASE_PUB';
6: G_API_NAME CONSTANT VARCHAR2(30) := 'LEASE API';
7: G_API_VERSION CONSTANT NUMBER := 1.0;
8:
9: g_log_level_rec fa_api_types.log_level_rec_type;
10:
11: --*********************** PUBLIC PROCEDURES *****************************--
12: ----------------------------------------
13: -- CREATE LEASE PUBLIC API

Line 24: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,

20: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
21: X_MSG_COUNT OUT NOCOPY NUMBER,
22: X_MSG_DATA OUT NOCOPY VARCHAR2,
23: P_CALLING_FN IN VARCHAR2,
24: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,
25: PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE) AS
26:
27: VALUE_ERROR_EXCEPTION EXCEPTION;
28: L_ROWID VARCHAR2(100):=NULL;

Line 25: PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE) AS

21: X_MSG_COUNT OUT NOCOPY NUMBER,
22: X_MSG_DATA OUT NOCOPY VARCHAR2,
23: P_CALLING_FN IN VARCHAR2,
24: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,
25: PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE) AS
26:
27: VALUE_ERROR_EXCEPTION EXCEPTION;
28: L_ROWID VARCHAR2(100):=NULL;
29: L_LEASE_ID NUMBER:=NULL;

Line 37: L_LEASE_DETAILS_REC FA_API_TYPES.LEASE_DETAILS_REC_TYPE;

33: L_FASB_LEASE_TYPE VARCHAR2(15):=NULL;
34: L_COST_CAPITALIZED NUMBER:=NULL;
35: L_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_LEASE';
36: L_API_VERSION CONSTANT NUMBER := 1.0;
37: L_LEASE_DETAILS_REC FA_API_TYPES.LEASE_DETAILS_REC_TYPE;
38:
39: CURSOR C_PRESENT_VALUE IS
40: SELECT PRESENT_VALUE
41: FROM FA_LEASE_SCHEDULES

Line 272: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,

268: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
269: X_MSG_COUNT OUT NOCOPY NUMBER,
270: X_MSG_DATA OUT NOCOPY VARCHAR2,
271: P_CALLING_FN IN VARCHAR2,
272: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,
273: P_LEASE_DETAILS_REC_NEW IN FA_API_TYPES.LEASE_DETAILS_REC_TYPE) AS
274:
275: VALUE_ERROR_EXCEPTION EXCEPTION;
276: L_UPDATE_FLAG VARCHAR2(1):= NULL;

Line 273: P_LEASE_DETAILS_REC_NEW IN FA_API_TYPES.LEASE_DETAILS_REC_TYPE) AS

269: X_MSG_COUNT OUT NOCOPY NUMBER,
270: X_MSG_DATA OUT NOCOPY VARCHAR2,
271: P_CALLING_FN IN VARCHAR2,
272: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,
273: P_LEASE_DETAILS_REC_NEW IN FA_API_TYPES.LEASE_DETAILS_REC_TYPE) AS
274:
275: VALUE_ERROR_EXCEPTION EXCEPTION;
276: L_UPDATE_FLAG VARCHAR2(1):= NULL;
277: L_OK_TO_UPDATE_LESSOR VARCHAR2(1):= NULL;

Line 281: L_LEASE_DETAILS_REC_NEW FA_API_TYPES.LEASE_DETAILS_REC_TYPE;

277: L_OK_TO_UPDATE_LESSOR VARCHAR2(1):= NULL;
278: L_ATLEAST_ONE_UPDATE NUMBER := 0;
279: L_API_NAME CONSTANT VARCHAR2(30) := 'UPDATE_LEASE';
280: L_API_VERSION CONSTANT NUMBER := 1.0;
281: L_LEASE_DETAILS_REC_NEW FA_API_TYPES.LEASE_DETAILS_REC_TYPE;
282:
283: BEGIN
284:
285: SAVEPOINT UPDATE_LEASE;