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
10: ) RETURN BOOLEAN AS
11:
12: CURSOR C_VENDOR_ID IS

Line 14: FROM PO_VENDORS

10: ) RETURN BOOLEAN AS
11:
12: CURSOR C_VENDOR_ID IS
13: SELECT VENDOR_ID
14: FROM PO_VENDORS
15: WHERE VENDOR_ID= P_VENDOR_ID;
16:
17: L_VENDOR_ID NUMBER:=NULL;
18:

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

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
48: ) RETURN BOOLEAN AS
49:
50: CURSOR C_VENDOR_NAME IS

Line 52: FROM PO_VENDORS

48: ) RETURN BOOLEAN AS
49:
50: CURSOR C_VENDOR_NAME IS
51: SELECT VENDOR_ID
52: FROM PO_VENDORS
53: WHERE VENDOR_NAME= P_VENDOR_NAME;
54:
55: L_VENDOR_ID NUMBER:=NULL;
56:

Line 577: FROM PO_VENDORS

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

Line 582: FROM PO_VENDORS

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