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_SEEDED_FUNCTIONS_PVT dependencies on OKL_API

Line 7: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;

3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
8: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
9: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
10: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;

Line 8: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;

4: ---------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
8: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
9: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
10: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;

Line 9: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;

5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
8: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
9: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
10: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;

Line 10: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;

6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
8: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
9: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
10: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;

Line 11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;

7: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
8: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
9: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
10: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;

Line 12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;

8: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
9: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
10: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;

Line 13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;

9: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
10: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
17: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';

Line 14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;

10: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
17: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
18: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';

Line 15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;

11: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
17: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
18: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
19: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';

Line 16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;

12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
17: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
18: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
19: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
20: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';

Line 29: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;

25: ---------------------------------------------------------------------------
26: -- GLOBAL VARIABLES
27: ---------------------------------------------------------------------------
28: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FORMULAFUNCTION_PVT';
29: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
30:
31:
32: ---------------------------------------------------------------------------
33: -- GLOBAL EXCEPTION

Line 65: p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE DEFAULT Okl_Api.G_MISS_NUM) RETURN NUMBER;

61: p_line_id IN NUMBER) RETURN NUMBER;
62:
63: FUNCTION line_oec(
64: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
65: p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE DEFAULT Okl_Api.G_MISS_NUM) RETURN NUMBER;
66:
67: FUNCTION contract_tradein(
68: p_chr_id IN NUMBER,
69: p_line_id IN NUMBER) RETURN NUMBER;

Line 147: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

143: --End Bug# 3036581 : avsingh new formula CONTRACT_AMORTIZED_EXPENSES
144: -----------------------------------------------------------------------
145: FUNCTION contract_amount_prefunded(
146: p_contract_id IN NUMBER
147: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
148: ) RETURN NUMBER;
149: PRAGMA RESTRICT_REFERENCES (contract_amount_prefunded, TRUST);
150:
151: FUNCTION contract_total_funded(

Line 153: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

149: PRAGMA RESTRICT_REFERENCES (contract_amount_prefunded, TRUST);
150:
151: FUNCTION contract_total_funded(
152: p_contract_id IN NUMBER
153: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
154: ) RETURN NUMBER;
155: PRAGMA RESTRICT_REFERENCES (contract_total_funded, TRUST);
156:
157: FUNCTION contract_total_debits(

Line 159: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

155: PRAGMA RESTRICT_REFERENCES (contract_total_funded, TRUST);
156:
157: FUNCTION contract_total_debits(
158: p_contract_id IN NUMBER
159: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
160: ) RETURN NUMBER;
161: PRAGMA RESTRICT_REFERENCES (contract_total_debits, TRUST);
162:
163: FUNCTION contract_total_adjustments(

Line 165: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

161: PRAGMA RESTRICT_REFERENCES (contract_total_debits, TRUST);
162:
163: FUNCTION contract_total_adjustments(
164: p_contract_id IN NUMBER
165: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
166: ) RETURN NUMBER;
167: PRAGMA RESTRICT_REFERENCES (contract_total_adjustments, TRUST);
168:
169: ------------------------------------------------------------------

Line 172: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

168:
169: ------------------------------------------------------------------
170: FUNCTION creditline_total_limit(
171: p_contract_id IN NUMBER
172: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
173: ) RETURN NUMBER;
174: PRAGMA RESTRICT_REFERENCES (creditline_total_limit, TRUST);
175:
176: FUNCTION creditline_total_remaining(

Line 178: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

174: PRAGMA RESTRICT_REFERENCES (creditline_total_limit, TRUST);
175:
176: FUNCTION creditline_total_remaining(
177: p_contract_id IN NUMBER
178: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
179: ) RETURN NUMBER;
180: PRAGMA RESTRICT_REFERENCES (creditline_total_remaining, TRUST);
181:
182: FUNCTION creditline_total_new_limit(

Line 184: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

180: PRAGMA RESTRICT_REFERENCES (creditline_total_remaining, TRUST);
181:
182: FUNCTION creditline_total_new_limit(
183: p_contract_id IN NUMBER
184: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
185: ) RETURN NUMBER;
186: PRAGMA RESTRICT_REFERENCES (creditline_total_new_limit, TRUST);
187:
188: FUNCTION creditline_total_addition(

Line 190: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

186: PRAGMA RESTRICT_REFERENCES (creditline_total_new_limit, TRUST);
187:
188: FUNCTION creditline_total_addition(
189: p_contract_id IN NUMBER
190: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
191: ) RETURN NUMBER;
192: PRAGMA RESTRICT_REFERENCES (creditline_total_addition, TRUST);
193:
194: FUNCTION creditline_total_reduction(

Line 196: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

192: PRAGMA RESTRICT_REFERENCES (creditline_total_addition, TRUST);
193:
194: FUNCTION creditline_total_reduction(
195: p_contract_id IN NUMBER
196: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
197: ) RETURN NUMBER;
198: PRAGMA RESTRICT_REFERENCES (creditline_total_reduction, TRUST);
199:
200: -- Commented out - no owner identified.

Line 392: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

388:
389:
390: FUNCTION INS_REFUNDABLE_MONTHS(
391: p_contract_id IN NUMBER
392: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
393: ) RETURN NUMBER;
394: PRAGMA RESTRICT_REFERENCES (INS_REFUNDABLE_MONTHS, TRUST);
395:
396: -----------------------------------------------------------------------

Line 464: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

460: -- 06/04/03 cklee start
461:
462: FUNCTION investor_rent_accural_amout(
463: p_contract_id IN okc_k_headers_b.id%TYPE
464: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
465: ) RETURN NUMBER;
466: PRAGMA RESTRICT_REFERENCES (investor_rent_accural_amout, TRUST);
467:
468: FUNCTION investor_user_amount_stake(

Line 470: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

466: PRAGMA RESTRICT_REFERENCES (investor_rent_accural_amout, TRUST);
467:
468: FUNCTION investor_user_amount_stake(
469: p_contract_id IN okc_k_headers_b.id%TYPE
470: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
471: ) RETURN NUMBER;
472: PRAGMA RESTRICT_REFERENCES (investor_user_amount_stake, TRUST);
473:
474: FUNCTION investor_stream_amount(

Line 476: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

472: PRAGMA RESTRICT_REFERENCES (investor_user_amount_stake, TRUST);
473:
474: FUNCTION investor_stream_amount(
475: p_contract_id IN okc_k_headers_b.id%TYPE
476: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
477: ) RETURN NUMBER;
478: PRAGMA RESTRICT_REFERENCES (investor_stream_amount, TRUST);
479:
480: FUNCTION INVESTORS_PV_AMOUNT(p_chr_id IN NUMBER -- Investor Agreement ID

Line 499: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

495: --for cure calculation
496:
497: FUNCTION contract_delinquent_amt (
498: p_contract_id IN okc_k_headers_b.id%TYPE
499: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
500: ) RETURN NUMBER;
501:
502:
503: FUNCTION cumulative_vendor_invoice_amt (

Line 505: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

501:
502:
503: FUNCTION cumulative_vendor_invoice_amt (
504: p_contract_id IN okc_k_headers_b.id%TYPE
505: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
506: ) RETURN NUMBER;
507:
508:
509: FUNCTION contract_short_fund_amt (

Line 511: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

507:
508:
509: FUNCTION contract_short_fund_amt (
510: p_contract_id IN okc_k_headers_b.id%TYPE
511: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
512: ) RETURN NUMBER;
513:
514:
515: -- 09/05/03 jsanju end

Line 526: p_contract_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

522: --end rkuttiya
523:
524: -- Bug# 3316994 :12-Jan-2004 cklee
525: FUNCTION SUBSIDY_AMOUNT(
526: p_contract_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
527: ,p_contract_line_id IN NUMBER
528: ) RETURN NUMBER;
529:
530: FUNCTION REFUND_SUBSIDY(

Line 531: p_contract_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

527: ,p_contract_line_id IN NUMBER
528: ) RETURN NUMBER;
529:
530: FUNCTION REFUND_SUBSIDY(
531: p_contract_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
532: ,p_contract_line_id IN NUMBER
533: ) RETURN NUMBER;
534: -- Bug# 3316994 :12-Jan-2004 cklee
535:

Line 559: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

555:
556: -- for bug#3819937 cklee
557: FUNCTION credit_check(
558: p_contract_id IN NUMBER -- credit line contract id
559: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
560: ) RETURN NUMBER;
561: -- for bug#3819937 cklee
562:
563: --Bug# 3872534: start

Line 595: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

591:
592: --cklee
593: FUNCTION rollover_fee
594: (p_contract_id IN NUMBER,
595: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
596: RETURN NUMBER;
597: FUNCTION tot_net_transfers
598: (p_contract_id IN NUMBER,
599: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

Line 599: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

595: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
596: RETURN NUMBER;
597: FUNCTION tot_net_transfers
598: (p_contract_id IN NUMBER,
599: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
600: RETURN NUMBER;
601: --cklee
602:
603: -- rmunjulu 3816891

Line 660: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

656:
657: -- STRAT: cklee - bug#4655437 10/06/2005
658: FUNCTION tot_credit_funding_pmt(
659: p_contract_id IN NUMBER -- credit line contract id
660: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
661: ) RETURN NUMBER;
662:
663: FUNCTION tot_credit_principal_pmt(
664: p_contract_id IN NUMBER -- credit line contract id

Line 665: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM

661: ) RETURN NUMBER;
662:
663: FUNCTION tot_credit_principal_pmt(
664: p_contract_id IN NUMBER -- credit line contract id
665: ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
666: ) RETURN NUMBER;
667: -- END: cklee - bug#4655437 10/06/2005
668:
669: -- sjalasut, Rebook Change Control Enhancement START

Line 673: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;

669: -- sjalasut, Rebook Change Control Enhancement START
670:
671: -- function that returns the sum of unbilled RENT for all active assets on the rebook copy of the contract
672: FUNCTION cont_rbk_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
673: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;
674:
675: -- function that returns the sum of pre-tax income that was not accrued for all active assets on the rebook copy of the contract
676: FUNCTION cont_rbk_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
677: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;

Line 677: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;

673: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;
674:
675: -- function that returns the sum of pre-tax income that was not accrued for all active assets on the rebook copy of the contract
676: FUNCTION cont_rbk_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
677: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;
678:
679: -- returns sum of rent not billed for all terminated assets
680: FUNCTION cont_tmt_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
681: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;

Line 681: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;

677: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;
678:
679: -- returns sum of rent not billed for all terminated assets
680: FUNCTION cont_tmt_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
681: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;
682:
683: -- returns sum of pre tax income not accrued for all terminated assets
684: FUNCTION cont_tmt_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
685: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;

Line 685: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;

681: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;
682:
683: -- returns sum of pre tax income not accrued for all terminated assets
684: FUNCTION cont_tmt_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
685: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;
686:
687: -- sjalasut, Rebook Change Control Enhancement END
688: --varangan bug #5036582 start
689: FUNCTION contract_unpaid_invoices(

Line 709: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

705: --End - varangan- bug#5009351
706:
707: -- Added by rravikir -- Bug 5055835
708: FUNCTION check_contract_fin_amount(p_contract_id IN NUMBER,
709: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
710: RETURN VARCHAR2;
711:
712: FUNCTION check_fund_amount(p_contract_id IN NUMBER,
713: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

Line 713: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

709: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
710: RETURN VARCHAR2;
711:
712: FUNCTION check_fund_amount(p_contract_id IN NUMBER,
713: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
714: RETURN VARCHAR2;
715:
716: FUNCTION check_party_custacct_match(p_contract_id IN NUMBER,
717: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

Line 717: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

713: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
714: RETURN VARCHAR2;
715:
716: FUNCTION check_party_custacct_match(p_contract_id IN NUMBER,
717: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
718: RETURN VARCHAR2;
719:
720: FUNCTION check_vendor_prog_match(p_contract_id IN NUMBER,
721: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

Line 721: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

717: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
718: RETURN VARCHAR2;
719:
720: FUNCTION check_vendor_prog_match(p_contract_id IN NUMBER,
721: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
722: RETURN VARCHAR2;
723:
724: FUNCTION check_booking_date(p_contract_id IN NUMBER,
725: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

Line 725: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

721: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
722: RETURN VARCHAR2;
723:
724: FUNCTION check_booking_date(p_contract_id IN NUMBER,
725: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
726: RETURN VARCHAR2;
727:
728: FUNCTION check_funding_date(p_contract_id IN NUMBER,
729: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

Line 729: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)

725: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
726: RETURN VARCHAR2;
727:
728: FUNCTION check_funding_date(p_contract_id IN NUMBER,
729: p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
730: RETURN VARCHAR2;
731: -- End
732:
733: --03-Jan-07 sechawla 6651621

Line 748: OKL_API.G_MISS_NUM)

744: --Bug # 6740000 ssdeshpa End;
745: -- Added by mansrini for ER Bug#6011738
746: FUNCTION front_end_financed_amount(p_contract_id IN NUMBER,
747: p_contract_line_id IN NUMBER DEFAULT
748: OKL_API.G_MISS_NUM)
749: RETURN NUMBER;
750: -- End by mansrini
751:
752: -- added Durga Janaswamy for Contract Line Extract