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.

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 70: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

66: ------------------------------------------------------------------------------
67:
68: PROCEDURE get_fund_summary(
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_contract_id IN NUMBER,

Line 80: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

76: );
77:
78: PROCEDURE create_funding_header(
79: p_api_version IN NUMBER
80: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
81: ,x_return_status OUT NOCOPY VARCHAR2
82: ,x_msg_count OUT NOCOPY NUMBER
83: ,x_msg_data OUT NOCOPY VARCHAR2
84: ,p_tapv_rec IN tapv_rec_type

Line 90: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

86: );
87:
88: PROCEDURE update_funding_header(
89: p_api_version IN NUMBER
90: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
91: ,x_return_status OUT NOCOPY VARCHAR2
92: ,x_msg_count OUT NOCOPY NUMBER
93: ,x_msg_data OUT NOCOPY VARCHAR2
94: ,p_tapv_rec IN tapv_rec_type

Line 100: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

96: );
97:
98: PROCEDURE create_funding_lines(
99: p_api_version IN NUMBER
100: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
101: ,x_return_status OUT NOCOPY VARCHAR2
102: ,x_msg_count OUT NOCOPY NUMBER
103: ,x_msg_data OUT NOCOPY VARCHAR2
104: ,p_tplv_tbl IN tplv_tbl_type

Line 110: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

106: );
107:
108: PROCEDURE create_funding_lines(
109: p_api_version IN NUMBER
110: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
111: ,x_return_status OUT NOCOPY VARCHAR2
112: ,x_msg_count OUT NOCOPY NUMBER
113: ,x_msg_data OUT NOCOPY VARCHAR2
114: ,p_hdr_id IN NUMBER

Line 122: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

118: );
119:
120: PROCEDURE update_funding_lines(
121: p_api_version IN NUMBER
122: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
123: ,x_return_status OUT NOCOPY VARCHAR2
124: ,x_msg_count OUT NOCOPY NUMBER
125: ,x_msg_data OUT NOCOPY VARCHAR2
126: ,p_tplv_tbl IN tplv_tbl_type

Line 132: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

128: );
129:
130: PROCEDURE create_funding_assets(
131: p_api_version IN NUMBER
132: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
133: ,x_return_status OUT NOCOPY VARCHAR2
134: ,x_msg_count OUT NOCOPY NUMBER
135: ,x_msg_data OUT NOCOPY VARCHAR2
136: ,p_fund_id IN NUMBER

Line 141: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

137: );
138:
139: PROCEDURE SYNC_HEADER_AMOUNT(
140: p_api_version IN NUMBER
141: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
142: ,x_return_status OUT NOCOPY VARCHAR2
143: ,x_msg_count OUT NOCOPY NUMBER
144: ,x_msg_data OUT NOCOPY VARCHAR2
145: ,p_tplv_tbl IN tplv_tbl_type

Line 150: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

146: );
147:
148: PROCEDURE reverse_funding_requests(
149: p_api_version IN NUMBER
150: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
151: ,x_return_status OUT NOCOPY VARCHAR2
152: ,x_msg_count OUT NOCOPY NUMBER
153: ,x_msg_data OUT NOCOPY VARCHAR2
154: ,p_contract_id IN NUMBER

Line 161: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

157: -- Total contract funded adjustments
158: FUNCTION get_chr_funded_adjs(
159: p_contract_id IN NUMBER -- contract hdr
160: -- 12-09-2003 cklee
161: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
162: ) RETURN NUMBER;
163: --PRAGMA RESTRICT_REFERENCES (get_chr_funded_adjs, TRUST);
164: ------------------
165:

Line 194: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

190:
191: -- Total contract has been funded oec amount
192: FUNCTION get_chr_oec_hasbeen_funded_amt(
193: p_contract_id IN NUMBER -- contract hdr
194: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
195: ) RETURN NUMBER;
196: --PRAGMA RESTRICT_REFERENCES (get_chr_oec_hasbeen_funded_amt, TRUST);
197:
198: ------------------

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

235: ------------------
236: -- get line oec for contract funded
237: FUNCTION get_contract_line_amt(
238: p_khr_id IN NUMBER -- contract hdr
239: ,p_kle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM -- contract line
240: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
241: ) RETURN NUMBER;
242: --PRAGMA RESTRICT_REFERENCES (get_contract_line_amt, TRUST);
243:

Line 240: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

236: -- get line oec for contract funded
237: FUNCTION get_contract_line_amt(
238: p_khr_id IN NUMBER -- contract hdr
239: ,p_kle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM -- contract line
240: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
241: ) RETURN NUMBER;
242: --PRAGMA RESTRICT_REFERENCES (get_contract_line_amt, TRUST);
243:
244: FUNCTION get_contract_line_funded_amt(

Line 247: ,p_ref_type_code IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR

243:
244: FUNCTION get_contract_line_funded_amt(
245: p_khr_id IN NUMBER
246: ,p_kle_id IN NUMBER
247: ,p_ref_type_code IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR
248: ) RETURN NUMBER;
249: --PRAGMA RESTRICT_REFERENCES (get_contract_line_funded_amt, TRUST);
250:
251: FUNCTION get_contract_line_funded_amt(

Line 260: ,p_org_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

256:
257: FUNCTION is_funding_unique(
258: p_vendor_id IN NUMBER
259: ,p_fund_number IN VARCHAR2
260: ,p_org_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
261: ) RETURN VARCHAR2;
262:
263: FUNCTION is_contract_line_unique(
264: p_kle_id IN NUMBER -- contract_line_id

Line 268: ,p_org_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

264: p_kle_id IN NUMBER -- contract_line_id
265: ,p_fund_id IN NUMBER
266: ,p_fund_line_id IN NUMBER
267: ,p_mode IN VARCHAR2 DEFAULT 'C'
268: ,p_org_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
269: ) RETURN VARCHAR2;
270:
271: FUNCTION is_kle_id_unique(
272: p_tplv_tbl IN tplv_tbl_type

Line 285: ,p_vendor_site_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

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

Line 291: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

287: --PRAGMA RESTRICT_REFERENCES (get_amount_prefunded, TRUST);
288:
289: FUNCTION get_total_funded(
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_funded, TRUST);
294:
295: FUNCTION get_total_retention(

Line 297: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

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

Line 304: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

300:
301: -- added for bug 2604862
302: FUNCTION get_amount_borrowerPay(
303: p_contract_id IN NUMBER
304: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
305: ) RETURN NUMBER;
306: --PRAGMA RESTRICT_REFERENCES (get_amount_borrowerPay, TRUST);
307:
308: FUNCTION get_creditRem_by_chrid(

Line 315: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

311: --PRAGMA RESTRICT_REFERENCES (get_creditRem_by_chrid, TRUST);
312: -- added for bug 2604862
313:
314: PROCEDURE CREATE_ACCOUNTING_DIST(p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
319: p_status IN OKL_TRX_AP_INVOICES_B.trx_status_code%TYPE,

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

340: --PRAGMA RESTRICT_REFERENCES (get_partial_subsidy_amount, TRUST);
341:
342: FUNCTION get_amount_subsidy(
343: p_contract_id IN NUMBER
344: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM -- fixed asset ID
345: ) RETURN NUMBER;
346: --PRAGMA RESTRICT_REFERENCES (get_amount_subsidy, TRUST);
347:
348: PROCEDURE create_fund_asset_subsidies

Line 350: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

346: --PRAGMA RESTRICT_REFERENCES (get_amount_subsidy, TRUST);
347:
348: PROCEDURE create_fund_asset_subsidies
349: (p_api_version IN NUMBER,
350: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_status IN OKL_TRX_AP_INVOICES_B.trx_status_code%TYPE,

Line 360: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

356: -- added for 11.5.10 subsidy
357:
358: PROCEDURE refresh_fund_chklst(
359: p_api_version IN NUMBER
360: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
361: ,x_return_status OUT NOCOPY VARCHAR2
362: ,x_msg_count OUT NOCOPY NUMBER
363: ,x_msg_data OUT NOCOPY VARCHAR2
364: ,p_chr_id IN okc_k_headers_b.id%type

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

367: );
368:
369: FUNCTION get_amount_manu_disb(
370: p_contract_id IN NUMBER
371: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM -- fixed asset ID
372: ) RETURN NUMBER;
373: --PRAGMA RESTRICT_REFERENCES (get_amount_manu_disb, TRUST);
374:
375: -- strat: T and A 11/04/2004

Line 401: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

397: -- End of comments
398: ----------------------------------------------------------------------------------
399: PROCEDURE contract_fee_canbe_funded(
400: p_api_version IN NUMBER
401: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
402: ,x_return_status OUT NOCOPY VARCHAR2
403: ,x_msg_count OUT NOCOPY NUMBER
404: ,x_msg_data OUT NOCOPY VARCHAR2
405: ,x_value OUT NOCOPY NUMBER

Line 433: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

429: -- End of comments
430: ----------------------------------------------------------------------------------
431: PROCEDURE is_contract_fully_funded(
432: p_api_version IN NUMBER
433: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
434: ,x_return_status OUT NOCOPY VARCHAR2
435: ,x_msg_count OUT NOCOPY NUMBER
436: ,x_msg_data OUT NOCOPY VARCHAR2
437: ,x_value OUT NOCOPY BOOLEAN

Line 460: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

456: -- End of comments
457: ----------------------------------------------------------------------------------
458: PROCEDURE get_checklist_source(
459: p_api_version IN NUMBER
460: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
461: ,x_return_status OUT NOCOPY VARCHAR2
462: ,x_msg_count OUT NOCOPY NUMBER
463: ,x_msg_data OUT NOCOPY VARCHAR2
464: ,p_chr_id IN okc_k_headers_b.id%type

Line 491: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

487: -- End of comments
488: ----------------------------------------------------------------------------------
489: PROCEDURE update_checklist_function(
490: p_api_version IN NUMBER
491: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
492: ,x_return_status OUT NOCOPY VARCHAR2
493: ,x_msg_count OUT NOCOPY NUMBER
494: ,x_msg_data OUT NOCOPY VARCHAR2
495: ,p_fund_req_id IN NUMBER