eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_LEASE_PVT dependencies on FA_API_TYPES

Line 9: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

5: -- CHECK FOR LESSOR_ID
6: -----------------------------------------------
7: FUNCTION CHECK_LESSOR_ID (
8: P_VENDOR_ID IN PO_VENDORS.VENDOR_ID%TYPE
9: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
10: ) RETURN BOOLEAN AS
11:
12: CURSOR C_VENDOR_ID IS
13: SELECT VENDOR_ID

Line 47: p_log_level_rec IN fa_api_types.log_level_rec_type default null

43: ---------------------------------------------------------
44: FUNCTION CHECK_LESSOR_NAME (
45: P_VENDOR_NAME IN PO_VENDORS.VENDOR_NAME%TYPE,
46: X_VENDOR_ID OUT NOCOPY PO_VENDORS.VENDOR_ID%TYPE,
47: p_log_level_rec IN fa_api_types.log_level_rec_type default null
48: ) RETURN BOOLEAN AS
49:
50: CURSOR C_VENDOR_NAME IS
51: SELECT VENDOR_ID

Line 85: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

81: -- CHECK FOR PAYMENT SCHEDULE ID
82: ---------------------------------------
83: FUNCTION CHECK_PAYMENT_SCHEDULE_ID (
84: P_PAYMENT_SCHEDULE_ID IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE
85: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
86:
87: ) RETURN BOOLEAN AS
88:
89: CURSOR C_PAYMENT_SCHEDULE_ID IS

Line 124: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

120: ----------------------------------------
121: FUNCTION CHECK_PAYMENT_SCHEDULE_NAME (
122: P_PAYMENT_SCHEDULE_NAME IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_NAME%TYPE,
123: X_PAYMENT_SCHEDULE_ID OUT NOCOPY FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE
124: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
125: ) RETURN BOOLEAN AS
126:
127: CURSOR C_PAYMENT_SCHEDULE_NAME IS
128: SELECT PAYMENT_SCHEDULE_ID

Line 162: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

158: -- CHECK FOR CHECK TERMS
159: --------------------------------
160: FUNCTION CHECK_TERMS_ID (
161: P_TERMS_ID IN AP_TERMS.TERM_ID%TYPE
162: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
163: ) RETURN BOOLEAN AS
164:
165: CURSOR C_CHECK_TERMS_ID IS
166: SELECT TERM_ID FROM

Line 200: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

196: ---------------------------------------
197: FUNCTION CHECK_PAYMENT_TERMS(
198: P_PAYMENT_TERMS IN AP_TERMS.NAME%TYPE,
199: X_TERMS_ID OUT NOCOPY AP_TERMS.TERM_ID%TYPE
200: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
201: ) RETURN BOOLEAN AS
202:
203: CURSOR C_CHECK_PAYMENT_TERMS IS
204: SELECT TERM_ID FROM

Line 241: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

237: P_VENDOR_SITE_ID IN PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
238: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
239: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
240: X_LESSOR_SITE_ORG_ID OUT NOCOPY NUMBER
241: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
242: ) RETURN BOOLEAN AS
243:
244: CURSOR C_LESSOR_SITE_ID IS
245: SELECT

Line 311: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

307: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
308: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
309: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
310: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE
311: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
312: ) RETURN BOOLEAN AS
313:
314: CURSOR C_LESSOR_SITE_CODE IS
315: SELECT

Line 376: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

372:
373: FUNCTION CHECK_DIST_CODE_COMBINATION_ID(
374: P_DIST_CODE_COMBINATION_ID IN GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE,
375: P_COA_ID IN GL_CODE_COMBINATIONS.CHART_OF_ACCOUNTS_ID%TYPE
376: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
377: ) RETURN BOOLEAN AS
378:
379: CURSOR C_CODE_COMBINATION_ID IS
380: SELECT

Line 416: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

412: FUNCTION CHECK_CODE_COMBINATION
413: (P_CON_CODE_COMBINATION IN VARCHAR2,
414: P_COA_ID IN GL_CODE_COMBINATIONS.CHART_OF_ACCOUNTS_ID%TYPE,
415: X_CODE_COMBINATION_ID OUT NOCOPY GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE
416: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
417: ) RETURN BOOLEAN AS
418:
419: L_CODE_COMBINATION_ID NUMBER:=NULL;
420:

Line 446: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS

442: ---------------------------------------------------
443: FUNCTION CHECK_LEASE_LESSOR_COMBINATION (
444: P_LESSOR_ID IN NUMBER,
445: P_LEASE_NUMBER IN VARCHAR2
446: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
447:
448: CURSOR C_LEASE_LESSOR IS
449: SELECT LEASE_ID
450: FROM FA_LEASES

Line 488: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS

484: ----------------------------------------
485: FUNCTION CHECK_CURRENCY_CODE (
486: P_CURRENCY_CODE VARCHAR2,
487: P_PAYMENT_SCHEDULE_ID NUMBER
488: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
489:
490: CURSOR C_CURRENCY_CODE IS
491: SELECT CURRENCY_CODE
492: FROM FA_LEASE_SCHEDULES

Line 532: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS

528: -- CHECK FOR CHECK LEASE TYPE
529: -----------------------------------
530: FUNCTION CHECK_LEASE_TYPE(
531: P_LEASE_TYPE VARCHAR2
532: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
533:
534: CURSOR C_LEASE_TYPE IS
535: SELECT LOOKUP_CODE
536: FROM FA_LOOKUPS WHERE

Line 573: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS

569: FUNCTION VALIDATE_LESSOR
570: (P_VENDOR_ID IN NUMBER,
571: P_VENDOR_NAME IN VARCHAR2,
572: X_VENDOR_ID OUT NOCOPY NUMBER
573: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
574:
575: CURSOR C_VENDOR_NAME IS
576: SELECT VENDOR_ID
577: FROM PO_VENDORS

Line 629: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS

625: FUNCTION GET_LEASE_ID
626: (P_LESSOR_ID IN NUMBER,
627: P_LEASE_NUMBER IN VARCHAR2,
628: X_LEASE_ID OUT NOCOPY NUMBER
629: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
630:
631: CURSOR C_LEASE_LESSOR IS
632: SELECT LEASE_ID
633: FROM FA_LEASES

Line 671: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS

667: -- VALIDATE LEASE
668: ------------------------------
669: FUNCTION VALIDATE_LEASE_ID
670: (P_LEASE_ID IN NUMBER
671: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
672:
673: L_LEASE_ID NUMBER:=NULL;
674:
675: BEGIN

Line 698: (P_LEASE_ID IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

694: -----------------------------------
695: -- CHECK LEASE UPDATE
696: -----------------------------------
697: FUNCTION CHECK_LEASE_UPDATE
698: (P_LEASE_ID IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
699: RETURN VARCHAR2 AS
700:
701: L_COUNT NUMBER:=0;
702:

Line 734: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS

730: (P_LEASE_ID IN NUMBER
731: ,P_LESSOR_ID IN NUMBER
732: ,P_LESSOR_SITE_ID IN NUMBER
733: ,P_LESSOR_SITE_ORG_ID IN NUMBER
734: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
735:
736: L_LEASE_NUMBER VARCHAR2(15):=NULL;
737: L_LESSOR_ID NUMBER:=NULL;
738: L_LESSOR_SITE_ID NUMBER:=NULL;

Line 781: PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE

777: --------------------------------------
778: -- VALIDATE CREATE LEASE PARAMETERS
779: --------------------------------------
780: FUNCTION VALIDATION_CREATE_LEASE (
781: PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE
782: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
783:
784: VALUE_ERROR_EXCEPTION EXCEPTION;
785: L_LESSOR_ID NUMBER:=NULL;

Line 782: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS

778: -- VALIDATE CREATE LEASE PARAMETERS
779: --------------------------------------
780: FUNCTION VALIDATION_CREATE_LEASE (
781: PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE
782: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
783:
784: VALUE_ERROR_EXCEPTION EXCEPTION;
785: L_LESSOR_ID NUMBER:=NULL;
786: L_PAYMENT_SCHEDULE_ID NUMBER:=NULL;

Line 1105: PX_LEASE_DETAILS_REC_NEW IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,

1101: -----------------------------------------
1102: -- VALIDATE UPDATE LEASE API PARAMETERS
1103: -----------------------------------------
1104: FUNCTION VALIDATION_UPDATE_LEASE (
1105: PX_LEASE_DETAILS_REC_NEW IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,
1106: X_OK_TO_UPDATE_FLAG OUT NOCOPY VARCHAR2
1107: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
1108:
1109: VALUE_ERROR_EXCEPTION EXCEPTION;

Line 1107: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS

1103: -----------------------------------------
1104: FUNCTION VALIDATION_UPDATE_LEASE (
1105: PX_LEASE_DETAILS_REC_NEW IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,
1106: X_OK_TO_UPDATE_FLAG OUT NOCOPY VARCHAR2
1107: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
1108:
1109: VALUE_ERROR_EXCEPTION EXCEPTION;
1110: L_LEASE_ID NUMBER:=NULL;
1111: L_LESSOR_ID NUMBER:=NULL;

Line 1256: X_ATTRIBUTE_CATEGORY_CODE IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

1252: X_ATTRIBUTE12 IN VARCHAR2,
1253: X_ATTRIBUTE13 IN VARCHAR2,
1254: X_ATTRIBUTE14 IN VARCHAR2,
1255: X_ATTRIBUTE15 IN VARCHAR2,
1256: X_ATTRIBUTE_CATEGORY_CODE IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
1257: IS
1258: BEGIN
1259: IF X_ROWID IS NOT NULL THEN
1260: UPDATE FA_LEASES