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) RETURN BOOLEAN AS

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) RETURN BOOLEAN AS
10:
11: CURSOR C_VENDOR_ID IS
12: SELECT VENDOR_ID
13: FROM PO_VENDORS

Line 47: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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) RETURN BOOLEAN AS
48:
49: CURSOR C_VENDOR_NAME IS
50: SELECT VENDOR_ID
51: FROM PO_VENDORS

Line 85: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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) RETURN BOOLEAN AS
86:
87: CURSOR C_PAYMENT_SCHEDULE_ID IS
88: SELECT PAYMENT_SCHEDULE_ID
89: FROM FA_LEASE_SCHEDULES

Line 123: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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

Line 161: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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

Line 199: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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

Line 240: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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

Line 310: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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

Line 375: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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

Line 415: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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

Line 445: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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

Line 488: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) 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 default null) RETURN BOOLEAN AS
489:
490: CURSOR C_CURRENCY_CODE IS
491: SELECT CURRENCY_CODE
492: FROM FA_LEASE_SCHEDULES

Line 533: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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

Line 575: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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

Line 632: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

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

Line 675: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

671: -- VALIDATE LEASE
672: ------------------------------
673: FUNCTION VALIDATE_LEASE_ID
674: (P_LEASE_ID IN NUMBER,
675: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
676:
677: L_LEASE_ID NUMBER:=NULL;
678:
679: BEGIN

Line 704: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

700: -- CHECK LEASE UPDATE
701: -----------------------------------
702: FUNCTION CHECK_LEASE_UPDATE
703: (P_LEASE_ID IN NUMBER,
704: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
705: RETURN VARCHAR2 AS
706:
707: L_COUNT NUMBER:=0;
708:

Line 741: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

737: (P_LEASE_ID IN NUMBER
738: ,P_LESSOR_ID IN NUMBER
739: ,P_LESSOR_SITE_ID IN NUMBER
740: ,P_LESSOR_SITE_ORG_ID IN NUMBER,
741: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
742:
743: L_LEASE_NUMBER VARCHAR2(15):=NULL;
744: L_LESSOR_ID NUMBER:=NULL;
745: L_LESSOR_SITE_ID NUMBER:=NULL;

Line 787: PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,

783: --------------------------------------
784: -- VALIDATE CREATE LEASE PARAMETERS
785: --------------------------------------
786: FUNCTION VALIDATION_CREATE_LEASE (
787: PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,
788: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
789:
790: VALUE_ERROR_EXCEPTION EXCEPTION;
791: L_LESSOR_ID NUMBER:=NULL;

Line 788: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

784: -- VALIDATE CREATE LEASE PARAMETERS
785: --------------------------------------
786: FUNCTION VALIDATION_CREATE_LEASE (
787: PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,
788: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
789:
790: VALUE_ERROR_EXCEPTION EXCEPTION;
791: L_LESSOR_ID NUMBER:=NULL;
792: L_PAYMENT_SCHEDULE_ID NUMBER:=NULL;

Line 1112: PX_LEASE_DETAILS_REC_NEW IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,

1108: -----------------------------------------
1109: -- VALIDATE UPDATE LEASE API PARAMETERS
1110: -----------------------------------------
1111: FUNCTION VALIDATION_UPDATE_LEASE (
1112: PX_LEASE_DETAILS_REC_NEW IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,
1113: X_OK_TO_UPDATE_FLAG OUT NOCOPY VARCHAR2,
1114: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
1115:
1116: VALUE_ERROR_EXCEPTION EXCEPTION;

Line 1114: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

1110: -----------------------------------------
1111: FUNCTION VALIDATION_UPDATE_LEASE (
1112: PX_LEASE_DETAILS_REC_NEW IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,
1113: X_OK_TO_UPDATE_FLAG OUT NOCOPY VARCHAR2,
1114: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
1115:
1116: VALUE_ERROR_EXCEPTION EXCEPTION;
1117: L_LEASE_ID NUMBER:=NULL;
1118: L_LESSOR_ID NUMBER:=NULL;

Line 1264: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1260: X_ATTRIBUTE13 IN VARCHAR2,
1261: X_ATTRIBUTE14 IN VARCHAR2,
1262: X_ATTRIBUTE15 IN VARCHAR2,
1263: X_ATTRIBUTE_CATEGORY_CODE IN VARCHAR2,
1264: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1265: IS
1266: BEGIN
1267: IF X_ROWID IS NOT NULL THEN
1268: UPDATE FA_LEASES