APPS.FA_LEASE_PVT dependencies on PO_VENDORS

Line 8: P_VENDOR_ID IN PO_VENDORS.VENDOR_ID%TYPE,

4: -----------------------------------------------
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

Line 13: FROM PO_VENDORS

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
14: WHERE VENDOR_ID= P_VENDOR_ID;
15:
16: L_VENDOR_ID NUMBER:=NULL;
17:

Line 45: P_VENDOR_NAME IN PO_VENDORS.VENDOR_NAME%TYPE,

41: ---------------------------------------------------------
42: -- CHECK FOR LESSOR_NAME
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

Line 46: X_VENDOR_ID OUT NOCOPY PO_VENDORS.VENDOR_ID%TYPE,

42: -- CHECK FOR LESSOR_NAME
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

Line 51: FROM PO_VENDORS

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
52: WHERE VENDOR_NAME= P_VENDOR_NAME;
53:
54: L_VENDOR_ID NUMBER:=NULL;
55:

Line 579: FROM PO_VENDORS

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
580: WHERE VENDOR_NAME= P_VENDOR_NAME ;
581:
582: CURSOR C_VENDOR_ID IS
583: SELECT VENDOR_ID

Line 584: FROM PO_VENDORS

580: WHERE VENDOR_NAME= P_VENDOR_NAME ;
581:
582: CURSOR C_VENDOR_ID IS
583: SELECT VENDOR_ID
584: FROM PO_VENDORS
585: WHERE VENDOR_ID= P_VENDOR_ID ;
586:
587: L_VENDOR_ID NUMBER:=NULL;
588: