27: G_EXCEPTION_ERROR EXCEPTION;
28: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
29:
30: G_DEFAULT_DATE_FORMAT CONSTANT VARCHAR2(10) := 'YYYY-MM-DD';
31: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
32: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
33: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
34: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
35: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
28: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
29:
30: G_DEFAULT_DATE_FORMAT CONSTANT VARCHAR2(10) := 'YYYY-MM-DD';
31: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
32: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
33: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
34: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
35: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
36: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
29:
30: G_DEFAULT_DATE_FORMAT CONSTANT VARCHAR2(10) := 'YYYY-MM-DD';
31: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
32: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
33: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
34: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
35: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
36: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
37: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
30: G_DEFAULT_DATE_FORMAT CONSTANT VARCHAR2(10) := 'YYYY-MM-DD';
31: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
32: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
33: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
34: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
35: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
36: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
37: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
38: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
31: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
32: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
33: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
34: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
35: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
36: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
37: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
38: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
39:
32: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
33: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
34: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
35: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
36: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
37: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
38: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
39:
40: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
33: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
34: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
35: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
36: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
37: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
38: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
39:
40: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
41: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
34: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
35: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
36: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
37: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
38: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
39:
40: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
41: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
42: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
36: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
37: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
38: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
39:
40: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
41: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
42: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
43: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
44: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
37: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
38: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
39:
40: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
41: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
42: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
43: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
44: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
45: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
38: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
39:
40: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
41: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
42: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
43: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
44: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
45: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
46: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
39:
40: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
41: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
42: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
43: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
44: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
45: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
46: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
47: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
40: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
41: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
42: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
43: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
44: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
45: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
46: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
47: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
48: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
41: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
42: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
43: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
44: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
45: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
46: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
47: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
48: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
49: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
42: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
43: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
44: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
45: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
46: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
47: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
48: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
49: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
50: --Added by kthiruva on 12-Sep-2005 for Variable Rate Project
43: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
44: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
45: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
46: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
47: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
48: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
49: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
50: --Added by kthiruva on 12-Sep-2005 for Variable Rate Project
51: --Bug -Start of Changes
44: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
45: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
46: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
47: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
48: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
49: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
50: --Added by kthiruva on 12-Sep-2005 for Variable Rate Project
51: --Bug -Start of Changes
52: G_BALANCE_RATE CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_RATE;
45: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
46: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
47: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
48: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
49: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
50: --Added by kthiruva on 12-Sep-2005 for Variable Rate Project
51: --Bug -Start of Changes
52: G_BALANCE_RATE CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_RATE;
53: G_BALANCE_PAYMENT CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_PAYMENT;
48: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
49: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
50: --Added by kthiruva on 12-Sep-2005 for Variable Rate Project
51: --Bug -Start of Changes
52: G_BALANCE_RATE CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_RATE;
53: G_BALANCE_PAYMENT CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_PAYMENT;
54: G_BALANCE_TERM CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_TERM;
55: G_BALANCE_FUNDING CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_FUNDING;
56: --Bug - End of Changes
49: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
50: --Added by kthiruva on 12-Sep-2005 for Variable Rate Project
51: --Bug -Start of Changes
52: G_BALANCE_RATE CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_RATE;
53: G_BALANCE_PAYMENT CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_PAYMENT;
54: G_BALANCE_TERM CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_TERM;
55: G_BALANCE_FUNDING CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_FUNDING;
56: --Bug - End of Changes
57:
50: --Added by kthiruva on 12-Sep-2005 for Variable Rate Project
51: --Bug -Start of Changes
52: G_BALANCE_RATE CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_RATE;
53: G_BALANCE_PAYMENT CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_PAYMENT;
54: G_BALANCE_TERM CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_TERM;
55: G_BALANCE_FUNDING CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_FUNDING;
56: --Bug - End of Changes
57:
58:
51: --Bug -Start of Changes
52: G_BALANCE_RATE CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_RATE;
53: G_BALANCE_PAYMENT CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_PAYMENT;
54: G_BALANCE_TERM CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_TERM;
55: G_BALANCE_FUNDING CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_FUNDING;
56: --Bug - End of Changes
57:
58:
59: ---------------------------------------------------------------------------