APPS.FA_LEASE_PVT dependencies on FA_LEASES

Line 449: FROM FA_LEASES

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
450: WHERE LEASE_NUMBER = P_LEASE_NUMBER
451: AND LESSOR_ID = P_LESSOR_ID;
452:
453: L_LEASE_ID NUMBER:=NULL;

Line 636: FROM FA_LEASES

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
637: WHERE LEASE_NUMBER = P_LEASE_NUMBER
638: AND LESSOR_ID = P_LESSOR_ID;
639:
640: L_LEASE_ID NUMBER:=NULL;

Line 682: FROM FA_LEASES

678:
679: BEGIN
680:
681: SELECT LEASE_ID INTO L_LEASE_ID
682: FROM FA_LEASES
683: WHERE LEASE_ID = P_LEASE_ID;
684:
685: RETURN (TRUE);
686:

Line 760: FROM FA_LEASES A,

756: L_LEASE_NUMBER,
757: L_LESSOR_ID,
758: L_LESSOR_SITE_ID,
759: L_LESSOR_SITE_ORG_ID
760: FROM FA_LEASES A,
761: PO_VENDOR_SITES_ALL B
762: WHERE A.LEASE_ID = P_LEASE_ID
763: AND A.LESSOR_SITE_ID = B.VENDOR_SITE_ID;
764:

Line 1268: UPDATE FA_LEASES

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
1269: SET
1270: LESSOR_ID = NVL(X_LESSOR_ID,LESSOR_ID),
1271: DESCRIPTION = NVL(X_DESCRIPTION,DESCRIPTION),
1272: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE,NULL,LAST_UPDATE_DATE,X_LAST_UPDATE_DATE),

Line 1293: UPDATE FA_LEASES

1289: ATTRIBUTE_CATEGORY_CODE = DECODE(X_ATTRIBUTE_CATEGORY_CODE,NULL,ATTRIBUTE_CATEGORY_CODE,FND_API.G_MISS_CHAR,NULL,X_ATTRIBUTE_CATEGORY_CODE),
1290: LESSOR_SITE_ID = NVL(X_LESSOR_SITE_ID,LESSOR_SITE_ID)
1291: WHERE ROWID = X_ROWID;
1292: ELSE
1293: UPDATE FA_LEASES
1294: SET
1295: LESSOR_ID = NVL(X_LESSOR_ID,LESSOR_ID),
1296: DESCRIPTION = NVL(X_DESCRIPTION,DESCRIPTION),
1297: LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE,NULL,LAST_UPDATE_DATE,X_LAST_UPDATE_DATE),