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.

[Home] [Help]

APPS.OKL_FUNDING_PVT dependencies on OKL_API

Line 7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

3: ----------------------------------------------------------------------------
4: -- GLOBAL VARIABLES
5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FUNDING_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8: G_OKL_FUNDING_APPROVER CONSTANT VARCHAR2(200) := 'OKL_FUNDING_APPROVER';
9: G_TRANSACTION_TYPE CONSTANT VARCHAR2(200) := 'Funding'; -- okl_trx_types_tl.name
10: -- sjalasut, changed the constant value to point to OKL_TXL_AP_INV_LNS_B
11: -- changes made as part of OKLR12B disbursements project

Line 65: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

61: ------------------------------------------------------------------------------
62:
63: PROCEDURE get_fund_summary(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_contract_id IN NUMBER,

Line 75: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

71: );
72:
73: PROCEDURE create_funding_header(
74: p_api_version IN NUMBER
75: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
76: ,x_return_status OUT NOCOPY VARCHAR2
77: ,x_msg_count OUT NOCOPY NUMBER
78: ,x_msg_data OUT NOCOPY VARCHAR2
79: ,p_tapv_rec IN tapv_rec_type

Line 85: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

81: );
82:
83: PROCEDURE update_funding_header(
84: p_api_version IN NUMBER
85: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
86: ,x_return_status OUT NOCOPY VARCHAR2
87: ,x_msg_count OUT NOCOPY NUMBER
88: ,x_msg_data OUT NOCOPY VARCHAR2
89: ,p_tapv_rec IN tapv_rec_type

Line 95: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

91: );
92:
93: PROCEDURE create_funding_lines(
94: p_api_version IN NUMBER
95: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
96: ,x_return_status OUT NOCOPY VARCHAR2
97: ,x_msg_count OUT NOCOPY NUMBER
98: ,x_msg_data OUT NOCOPY VARCHAR2
99: ,p_tplv_tbl IN tplv_tbl_type

Line 105: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

101: );
102:
103: PROCEDURE create_funding_lines(
104: p_api_version IN NUMBER
105: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
106: ,x_return_status OUT NOCOPY VARCHAR2
107: ,x_msg_count OUT NOCOPY NUMBER
108: ,x_msg_data OUT NOCOPY VARCHAR2
109: ,p_hdr_id IN NUMBER

Line 117: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

113: );
114:
115: PROCEDURE update_funding_lines(
116: p_api_version IN NUMBER
117: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
118: ,x_return_status OUT NOCOPY VARCHAR2
119: ,x_msg_count OUT NOCOPY NUMBER
120: ,x_msg_data OUT NOCOPY VARCHAR2
121: ,p_tplv_tbl IN tplv_tbl_type

Line 127: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

123: );
124:
125: PROCEDURE create_funding_assets(
126: p_api_version IN NUMBER
127: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
128: ,x_return_status OUT NOCOPY VARCHAR2
129: ,x_msg_count OUT NOCOPY NUMBER
130: ,x_msg_data OUT NOCOPY VARCHAR2
131: ,p_fund_id IN NUMBER

Line 136: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

132: );
133:
134: PROCEDURE SYNC_HEADER_AMOUNT(
135: p_api_version IN NUMBER
136: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
137: ,x_return_status OUT NOCOPY VARCHAR2
138: ,x_msg_count OUT NOCOPY NUMBER
139: ,x_msg_data OUT NOCOPY VARCHAR2
140: ,p_tplv_tbl IN tplv_tbl_type

Line 145: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

141: );
142:
143: PROCEDURE reverse_funding_requests(
144: p_api_version IN NUMBER
145: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
146: ,x_return_status OUT NOCOPY VARCHAR2
147: ,x_msg_count OUT NOCOPY NUMBER
148: ,x_msg_data OUT NOCOPY VARCHAR2
149: ,p_contract_id IN NUMBER

Line 156: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

152: -- Total contract funded adjustments
153: FUNCTION get_chr_funded_adjs(
154: p_contract_id IN NUMBER -- contract hdr
155: -- 12-09-2003 cklee
156: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
157: ) RETURN NUMBER;
158: --PRAGMA RESTRICT_REFERENCES (get_chr_funded_adjs, TRUST);
159: ------------------
160:

Line 189: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

185:
186: -- Total contract has been funded oec amount
187: FUNCTION get_chr_oec_hasbeen_funded_amt(
188: p_contract_id IN NUMBER -- contract hdr
189: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
190: ) RETURN NUMBER;
191: --PRAGMA RESTRICT_REFERENCES (get_chr_oec_hasbeen_funded_amt, TRUST);
192:
193: ------------------

Line 234: ,p_kle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM -- contract line

230: ------------------
231: -- get line oec for contract funded
232: FUNCTION get_contract_line_amt(
233: p_khr_id IN NUMBER -- contract hdr
234: ,p_kle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM -- contract line
235: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
236: ) RETURN NUMBER;
237: --PRAGMA RESTRICT_REFERENCES (get_contract_line_amt, TRUST);
238:

Line 235: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

231: -- get line oec for contract funded
232: FUNCTION get_contract_line_amt(
233: p_khr_id IN NUMBER -- contract hdr
234: ,p_kle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM -- contract line
235: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
236: ) RETURN NUMBER;
237: --PRAGMA RESTRICT_REFERENCES (get_contract_line_amt, TRUST);
238:
239: FUNCTION get_contract_line_funded_amt(

Line 242: ,p_ref_type_code IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR

238:
239: FUNCTION get_contract_line_funded_amt(
240: p_khr_id IN NUMBER
241: ,p_kle_id IN NUMBER
242: ,p_ref_type_code IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR
243: ) RETURN NUMBER;
244: --PRAGMA RESTRICT_REFERENCES (get_contract_line_funded_amt, TRUST);
245:
246: FUNCTION get_contract_line_funded_amt(

Line 255: ,p_org_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

251:
252: FUNCTION is_funding_unique(
253: p_vendor_id IN NUMBER
254: ,p_fund_number IN VARCHAR2
255: ,p_org_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
256: ) RETURN VARCHAR2;
257:
258: FUNCTION is_contract_line_unique(
259: p_kle_id IN NUMBER -- contract_line_id

Line 263: ,p_org_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

259: p_kle_id IN NUMBER -- contract_line_id
260: ,p_fund_id IN NUMBER
261: ,p_fund_line_id IN NUMBER
262: ,p_mode IN VARCHAR2 DEFAULT 'C'
263: ,p_org_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
264: ) RETURN VARCHAR2;
265:
266: FUNCTION is_kle_id_unique(
267: p_tplv_tbl IN tplv_tbl_type

Line 279: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

275:
276: ------------------------------------------------------------------
277: FUNCTION get_amount_prefunded(
278: p_contract_id IN NUMBER
279: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
280: ) RETURN NUMBER;
281: --PRAGMA RESTRICT_REFERENCES (get_amount_prefunded, TRUST);
282:
283: FUNCTION get_total_funded(

Line 285: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

281: --PRAGMA RESTRICT_REFERENCES (get_amount_prefunded, TRUST);
282:
283: FUNCTION get_total_funded(
284: p_contract_id IN NUMBER
285: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
286: ) RETURN NUMBER;
287: --PRAGMA RESTRICT_REFERENCES (get_total_funded, TRUST);
288:
289: FUNCTION get_total_retention(

Line 291: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

287: --PRAGMA RESTRICT_REFERENCES (get_total_funded, TRUST);
288:
289: FUNCTION get_total_retention(
290: p_contract_id IN NUMBER
291: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
292: ) RETURN NUMBER;
293: --PRAGMA RESTRICT_REFERENCES (get_total_retention, TRUST);
294:
295: -- added for bug 2604862

Line 298: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

294:
295: -- added for bug 2604862
296: FUNCTION get_amount_borrowerPay(
297: p_contract_id IN NUMBER
298: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
299: ) RETURN NUMBER;
300: --PRAGMA RESTRICT_REFERENCES (get_amount_borrowerPay, TRUST);
301:
302: FUNCTION get_creditRem_by_chrid(

Line 309: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

305: --PRAGMA RESTRICT_REFERENCES (get_creditRem_by_chrid, TRUST);
306: -- added for bug 2604862
307:
308: PROCEDURE CREATE_ACCOUNTING_DIST(p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
310: x_return_status OUT NOCOPY VARCHAR2,
311: x_msg_count OUT NOCOPY NUMBER,
312: x_msg_data OUT NOCOPY VARCHAR2,
313: p_status IN OKL_TRX_AP_INVOICES_B.trx_status_code%TYPE,

Line 338: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM -- fixed asset ID

334: --PRAGMA RESTRICT_REFERENCES (get_partial_subsidy_amount, TRUST);
335:
336: FUNCTION get_amount_subsidy(
337: p_contract_id IN NUMBER
338: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM -- fixed asset ID
339: ) RETURN NUMBER;
340: --PRAGMA RESTRICT_REFERENCES (get_amount_subsidy, TRUST);
341:
342: PROCEDURE create_fund_asset_subsidies

Line 344: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

340: --PRAGMA RESTRICT_REFERENCES (get_amount_subsidy, TRUST);
341:
342: PROCEDURE create_fund_asset_subsidies
343: (p_api_version IN NUMBER,
344: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
345: x_return_status OUT NOCOPY VARCHAR2,
346: x_msg_count OUT NOCOPY NUMBER,
347: x_msg_data OUT NOCOPY VARCHAR2,
348: p_status IN OKL_TRX_AP_INVOICES_B.trx_status_code%TYPE,

Line 354: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

350: -- added for 11.5.10 subsidy
351:
352: PROCEDURE refresh_fund_chklst(
353: p_api_version IN NUMBER
354: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
355: ,x_return_status OUT NOCOPY VARCHAR2
356: ,x_msg_count OUT NOCOPY NUMBER
357: ,x_msg_data OUT NOCOPY VARCHAR2
358: ,p_chr_id IN okc_k_headers_b.id%type

Line 365: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM -- fixed asset ID

361: );
362:
363: FUNCTION get_amount_manu_disb(
364: p_contract_id IN NUMBER
365: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM -- fixed asset ID
366: ) RETURN NUMBER;
367: --PRAGMA RESTRICT_REFERENCES (get_amount_manu_disb, TRUST);
368:
369: -- strat: T and A 11/04/2004

Line 395: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

391: -- End of comments
392: ----------------------------------------------------------------------------------
393: PROCEDURE contract_fee_canbe_funded(
394: p_api_version IN NUMBER
395: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
396: ,x_return_status OUT NOCOPY VARCHAR2
397: ,x_msg_count OUT NOCOPY NUMBER
398: ,x_msg_data OUT NOCOPY VARCHAR2
399: ,x_value OUT NOCOPY NUMBER

Line 427: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

423: -- End of comments
424: ----------------------------------------------------------------------------------
425: PROCEDURE is_contract_fully_funded(
426: p_api_version IN NUMBER
427: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
428: ,x_return_status OUT NOCOPY VARCHAR2
429: ,x_msg_count OUT NOCOPY NUMBER
430: ,x_msg_data OUT NOCOPY VARCHAR2
431: ,x_value OUT NOCOPY BOOLEAN

Line 454: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

450: -- End of comments
451: ----------------------------------------------------------------------------------
452: PROCEDURE get_checklist_source(
453: p_api_version IN NUMBER
454: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
455: ,x_return_status OUT NOCOPY VARCHAR2
456: ,x_msg_count OUT NOCOPY NUMBER
457: ,x_msg_data OUT NOCOPY VARCHAR2
458: ,p_chr_id IN okc_k_headers_b.id%type

Line 485: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

481: -- End of comments
482: ----------------------------------------------------------------------------------
483: PROCEDURE update_checklist_function(
484: p_api_version IN NUMBER
485: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
486: ,x_return_status OUT NOCOPY VARCHAR2
487: ,x_msg_count OUT NOCOPY NUMBER
488: ,x_msg_data OUT NOCOPY VARCHAR2
489: ,p_fund_req_id IN NUMBER