[Home] [Help]
11: -- CHECK FOR LESSOR_ID
12: --------------------------------
13: FUNCTION CHECK_LESSOR_ID (
14: P_VENDOR_ID IN PO_VENDORS.VENDOR_ID%TYPE
15: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
16: ) RETURN BOOLEAN;
17:
18: --------------------------------
19: -- CHECK FOR LESSOR_NAME
20: --------------------------------
21: FUNCTION CHECK_LESSOR_NAME (
22: P_VENDOR_NAME IN PO_VENDORS.VENDOR_NAME%TYPE,
23: X_VENDOR_ID OUT NOCOPY PO_VENDORS.VENDOR_ID%TYPE
24: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
25: ) RETURN BOOLEAN;
26: ----------------------------------
27: -- CHECK FOR PAYMENT SCHEDULE ID
28: ----------------------------------
27: -- CHECK FOR PAYMENT SCHEDULE ID
28: ----------------------------------
29: FUNCTION CHECK_PAYMENT_SCHEDULE_ID (
30: P_PAYMENT_SCHEDULE_ID IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE
31: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
32: ) RETURN BOOLEAN;
33:
34: ------------------------------------
35: -- CHECK FOR PAYMENT SCHEDULE NAME
36: ------------------------------------
37: FUNCTION CHECK_PAYMENT_SCHEDULE_NAME (
38: P_PAYMENT_SCHEDULE_NAME IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_NAME%TYPE,
39: X_PAYMENT_SCHEDULE_ID OUT NOCOPY FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE
40: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
41: ) RETURN BOOLEAN;
42:
43: --------------------------------
44: -- CHECK FOR PAYMENT TERMS ID
44: -- CHECK FOR PAYMENT TERMS ID
45: --------------------------------
46: FUNCTION CHECK_TERMS_ID (
47: P_TERMS_ID IN AP_TERMS.TERM_ID%TYPE
48: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
49: ) RETURN BOOLEAN;
50:
51: --------------------------------
52: -- CHECK FOR PAYMENT TERMS
53: --------------------------------
54: FUNCTION CHECK_PAYMENT_TERMS (
55: P_PAYMENT_TERMS IN AP_TERMS.NAME%TYPE,
56: X_TERMS_ID OUT NOCOPY AP_TERMS.TERM_ID%TYPE
57: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
58: ) RETURN BOOLEAN;
59:
60: --------------------------------
61: -- CHECK FOR LESSOR SITE ID
64: P_VENDOR_SITE_ID IN PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
65: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
66: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
67: X_LESSOR_SITE_ORG_ID OUT NOCOPY NUMBER
68: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
69: ) RETURN BOOLEAN;
70:
71: --------------------------------
72: -- CHECK FOR LESSOR SITE CODE
76: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
77: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
78: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
79: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE
80: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
81: ) RETURN BOOLEAN;
82:
83: ------------------------------------
84: -- CHECK FOR CODE COMBINATION ID
85: ------------------------------------
86: FUNCTION CHECK_DIST_CODE_COMBINATION_ID(
87: P_DIST_CODE_COMBINATION_ID IN GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE,
88: P_COA_ID IN GL_CODE_COMBINATIONS.CHART_OF_ACCOUNTS_ID%TYPE
89: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
90: ) RETURN BOOLEAN;
91:
92: --------------------------------------------------------------------------------
93: -- CHECK FOR CODE COMBINATION, IF DYNAMIC INSERT IS ON IF NOT FOUND INSERT ONE
95: FUNCTION CHECK_CODE_COMBINATION (
96: P_CON_CODE_COMBINATION IN VARCHAR2,
97: P_COA_ID IN GL_CODE_COMBINATIONS.CHART_OF_ACCOUNTS_ID%TYPE,
98: X_CODE_COMBINATION_ID OUT NOCOPY GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE
99: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
100: ) RETURN BOOLEAN;
101:
102: -------------------------------------------------
103: -- CHECK FOR LEASE NUMBER AND LESSOR COMBINATION
104: -------------------------------------------------
105: FUNCTION CHECK_LEASE_LESSOR_COMBINATION (
106: P_LESSOR_ID IN NUMBER,
107: P_LEASE_NUMBER IN VARCHAR2
108: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
109:
110: --------------------------------
111: -- CHECK FOR CURRENCY CODE
112: --------------------------------
112: --------------------------------
113: FUNCTION CHECK_CURRENCY_CODE (
114: P_CURRENCY_CODE IN VARCHAR2,
115: P_PAYMENT_SCHEDULE_ID IN NUMBER
116: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
117:
118: --------------------------------
119: -- CHECK FOR LEASE TYPE
120: --------------------------------
119: -- CHECK FOR LEASE TYPE
120: --------------------------------
121: FUNCTION CHECK_LEASE_TYPE(
122: P_LEASE_TYPE IN VARCHAR2
123: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
124:
125: ------------------------------------
126: --VALIDATE LESSOTR THAT IT EXISTS
127: ------------------------------------
128: FUNCTION VALIDATE_LESSOR
129: (P_VENDOR_ID IN NUMBER,
130: P_VENDOR_NAME IN VARCHAR2,
131: X_VENDOR_ID OUT NOCOPY NUMBER
132: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
133:
134: --------------------------------
135: -- GET LEASE_ID
136: --------------------------------
137: FUNCTION GET_LEASE_ID
138: (P_LESSOR_ID IN NUMBER,
139: P_LEASE_NUMBER IN VARCHAR2,
140: X_LEASE_ID OUT NOCOPY NUMBER
141: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
142:
143: --------------------------------
144: -- VALIDATE LEASE_ID
145: --------------------------------
144: -- VALIDATE LEASE_ID
145: --------------------------------
146: FUNCTION VALIDATE_LEASE_ID
147: (P_LEASE_ID IN NUMBER
148: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
149:
150: -------------------------------------------------------------------------------
151: -- CHECK IF LEASE INFORMATION CAN BE UPDATED AND NOT ASSOCIATED WITH ANY ASSET
152: -------------------------------------------------------------------------------
150: -------------------------------------------------------------------------------
151: -- CHECK IF LEASE INFORMATION CAN BE UPDATED AND NOT ASSOCIATED WITH ANY ASSET
152: -------------------------------------------------------------------------------
153: FUNCTION CHECK_LEASE_UPDATE
154: (P_LEASE_ID IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
155: RETURN VARCHAR2;
156:
157: --------------------------------------------------
158: -- CHECK IF LEASE, LESSOR COMBINATION
161: (P_LEASE_ID IN NUMBER,
162: P_LESSOR_ID IN NUMBER,
163: P_LESSOR_SITE_ID IN NUMBER,
164: P_LESSOR_SITE_ORG_ID IN NUMBER
165: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
166:
167: -------------------------------------------
168: -- VALIDATE CREATE LEASE PARAMETERS
169: -------------------------------------------
167: -------------------------------------------
168: -- VALIDATE CREATE LEASE PARAMETERS
169: -------------------------------------------
170: FUNCTION VALIDATION_CREATE_LEASE (
171: PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE
172: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
173:
174: --------------------------------------------
175: -- VALIDATE UPDATE LEASE PARAMETERS
168: -- VALIDATE CREATE LEASE PARAMETERS
169: -------------------------------------------
170: FUNCTION VALIDATION_CREATE_LEASE (
171: PX_LEASE_DETAILS_REC IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE
172: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
173:
174: --------------------------------------------
175: -- VALIDATE UPDATE LEASE PARAMETERS
176: ---------------------------------------------
174: --------------------------------------------
175: -- VALIDATE UPDATE LEASE PARAMETERS
176: ---------------------------------------------
177: FUNCTION VALIDATION_UPDATE_LEASE (
178: PX_LEASE_DETAILS_REC_NEW IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,
179: X_OK_TO_UPDATE_FLAG OUT NOCOPY VARCHAR2
180: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
181:
182: --------------------------------------------
176: ---------------------------------------------
177: FUNCTION VALIDATION_UPDATE_LEASE (
178: PX_LEASE_DETAILS_REC_NEW IN OUT NOCOPY FA_API_TYPES.LEASE_DETAILS_REC_TYPE,
179: X_OK_TO_UPDATE_FLAG OUT NOCOPY VARCHAR2
180: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
181:
182: --------------------------------------------
183: -- UPDATE LEASE DATA
184: ---------------------------------------------
205: X_ATTRIBUTE12 IN VARCHAR2,
206: X_ATTRIBUTE13 IN VARCHAR2,
207: X_ATTRIBUTE14 IN VARCHAR2,
208: X_ATTRIBUTE15 IN VARCHAR2,
209: X_ATTRIBUTE_CATEGORY_CODE IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
210:
211: END FA_LEASE_PVT;