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) IS
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) IS

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) IS
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 267: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,

263: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
264: X_MSG_COUNT OUT NOCOPY NUMBER,
265: X_MSG_DATA OUT NOCOPY VARCHAR2,
266: P_CALLING_FN IN VARCHAR2,
267: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,
268: P_LEASE_DETAILS_REC_NEW IN FA_API_TYPES.LEASE_DETAILS_REC_TYPE) IS
269:
270: VALUE_ERROR_EXCEPTION EXCEPTION;
271: L_UPDATE_FLAG VARCHAR2(1):= NULL;

Line 268: P_LEASE_DETAILS_REC_NEW IN FA_API_TYPES.LEASE_DETAILS_REC_TYPE) IS

264: X_MSG_COUNT OUT NOCOPY NUMBER,
265: X_MSG_DATA OUT NOCOPY VARCHAR2,
266: P_CALLING_FN IN VARCHAR2,
267: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,
268: P_LEASE_DETAILS_REC_NEW IN FA_API_TYPES.LEASE_DETAILS_REC_TYPE) IS
269:
270: VALUE_ERROR_EXCEPTION EXCEPTION;
271: L_UPDATE_FLAG VARCHAR2(1):= NULL;
272: L_OK_TO_UPDATE_LESSOR VARCHAR2(1):= NULL;

Line 276: L_LEASE_DETAILS_REC_NEW FA_API_TYPES.LEASE_DETAILS_REC_TYPE;

272: L_OK_TO_UPDATE_LESSOR VARCHAR2(1):= NULL;
273: L_ATLEAST_ONE_UPDATE NUMBER := 0;
274: L_API_NAME CONSTANT VARCHAR2(30) := 'UPDATE_LEASE';
275: L_API_VERSION CONSTANT NUMBER := 1.0;
276: L_LEASE_DETAILS_REC_NEW FA_API_TYPES.LEASE_DETAILS_REC_TYPE;
277:
278: BEGIN
279:
280: SAVEPOINT UPDATE_LEASE;