27: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
28: G_EXCEPTION_ERROR EXCEPTION;
29: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
30:
31: G_ORP_CODE_BOOKING CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_BOOKING;
32: G_ORP_CODE_RESTRUCTURE_AM CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_AM;
33: G_ORP_CODE_RESTRUCTURE_CS CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_CS;
34: -- mvasudev , sno, changed "QUOT" to "QUOTE"
35: G_ORP_CODE_QUOTE CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_QUOTE;
28: G_EXCEPTION_ERROR EXCEPTION;
29: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
30:
31: G_ORP_CODE_BOOKING CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_BOOKING;
32: G_ORP_CODE_RESTRUCTURE_AM CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_AM;
33: G_ORP_CODE_RESTRUCTURE_CS CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_CS;
34: -- mvasudev , sno, changed "QUOT" to "QUOTE"
35: G_ORP_CODE_QUOTE CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_QUOTE;
36: G_ORP_CODE_VARIABLE_INTEREST CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_VARIABLE_INTEREST;
29: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
30:
31: G_ORP_CODE_BOOKING CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_BOOKING;
32: G_ORP_CODE_RESTRUCTURE_AM CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_AM;
33: G_ORP_CODE_RESTRUCTURE_CS CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_CS;
34: -- mvasudev , sno, changed "QUOT" to "QUOTE"
35: G_ORP_CODE_QUOTE CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_QUOTE;
36: G_ORP_CODE_VARIABLE_INTEREST CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_VARIABLE_INTEREST;
37: G_ORP_CODE_RENEWAL CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RENEWAL;
31: G_ORP_CODE_BOOKING CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_BOOKING;
32: G_ORP_CODE_RESTRUCTURE_AM CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_AM;
33: G_ORP_CODE_RESTRUCTURE_CS CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_CS;
34: -- mvasudev , sno, changed "QUOT" to "QUOTE"
35: G_ORP_CODE_QUOTE CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_QUOTE;
36: G_ORP_CODE_VARIABLE_INTEREST CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_VARIABLE_INTEREST;
37: G_ORP_CODE_RENEWAL CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RENEWAL;
38:
39: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
32: G_ORP_CODE_RESTRUCTURE_AM CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_AM;
33: G_ORP_CODE_RESTRUCTURE_CS CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_CS;
34: -- mvasudev , sno, changed "QUOT" to "QUOTE"
35: G_ORP_CODE_QUOTE CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_QUOTE;
36: G_ORP_CODE_VARIABLE_INTEREST CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_VARIABLE_INTEREST;
37: G_ORP_CODE_RENEWAL CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RENEWAL;
38:
39: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
40: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
33: G_ORP_CODE_RESTRUCTURE_CS CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_CS;
34: -- mvasudev , sno, changed "QUOT" to "QUOTE"
35: G_ORP_CODE_QUOTE CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_QUOTE;
36: G_ORP_CODE_VARIABLE_INTEREST CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_VARIABLE_INTEREST;
37: G_ORP_CODE_RENEWAL CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RENEWAL;
38:
39: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
40: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
41: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
35: G_ORP_CODE_QUOTE CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_QUOTE;
36: G_ORP_CODE_VARIABLE_INTEREST CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_VARIABLE_INTEREST;
37: G_ORP_CODE_RENEWAL CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RENEWAL;
38:
39: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
40: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
41: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
42: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
43: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
36: G_ORP_CODE_VARIABLE_INTEREST CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_VARIABLE_INTEREST;
37: G_ORP_CODE_RENEWAL CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RENEWAL;
38:
39: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
40: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
41: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
42: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
43: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
44: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
37: G_ORP_CODE_RENEWAL CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RENEWAL;
38:
39: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
40: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
41: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
42: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
43: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
44: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
45: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
38:
39: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
40: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
41: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
42: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
43: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
44: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
45: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
46: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
39: G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
40: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
41: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
42: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
43: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
44: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
45: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
46: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
47:
40: G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
41: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
42: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
43: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
44: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
45: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
46: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
47:
48: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
41: G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
42: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
43: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
44: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
45: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
46: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
47:
48: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
49: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
42: G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
43: G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
44: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
45: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
46: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
47:
48: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
49: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
50: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
44: G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
45: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
46: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
47:
48: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
49: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
50: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
51: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
52: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
45: G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
46: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
47:
48: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
49: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
50: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
51: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
52: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
53: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
46: G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
47:
48: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
49: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
50: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
51: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
52: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
53: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
54: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
47:
48: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
49: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
50: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
51: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
52: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
53: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
54: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
55: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
48: G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
49: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
50: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
51: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
52: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
53: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
54: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
55: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
56: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
49: G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
50: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
51: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
52: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
53: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
54: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
55: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
56: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
57: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
50: G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
51: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
52: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
53: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
54: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
55: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
56: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
57: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
58: G_ADJUST CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADJUST;
51: G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
52: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
53: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
54: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
55: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
56: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
57: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
58: G_ADJUST CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADJUST;
59: G_ADJUST_LOAN CONSTANT VARCHAR2(30) := Okl_Create_Streams_Pvt.G_ADJUST_LOAN;
52: G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
53: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
54: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
55: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
56: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
57: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
58: G_ADJUST CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADJUST;
59: G_ADJUST_LOAN CONSTANT VARCHAR2(30) := Okl_Create_Streams_Pvt.G_ADJUST_LOAN;
60: G_ADJUSTMENT_METHOD CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_ADJUSTMENT_METHOD;
53: G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
54: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
55: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
56: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
57: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
58: G_ADJUST CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADJUST;
59: G_ADJUST_LOAN CONSTANT VARCHAR2(30) := Okl_Create_Streams_Pvt.G_ADJUST_LOAN;
60: G_ADJUSTMENT_METHOD CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_ADJUSTMENT_METHOD;
61:
54: G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
55: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
56: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
57: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
58: G_ADJUST CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADJUST;
59: G_ADJUST_LOAN CONSTANT VARCHAR2(30) := Okl_Create_Streams_Pvt.G_ADJUST_LOAN;
60: G_ADJUSTMENT_METHOD CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_ADJUSTMENT_METHOD;
61:
62:
55: G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
56: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
57: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
58: G_ADJUST CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADJUST;
59: G_ADJUST_LOAN CONSTANT VARCHAR2(30) := Okl_Create_Streams_Pvt.G_ADJUST_LOAN;
60: G_ADJUSTMENT_METHOD CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_ADJUSTMENT_METHOD;
61:
62:
63: SUBTYPE sifv_rec_type IS okl_stream_interfaces_pub.sifv_rec_type;
56: G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
57: G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
58: G_ADJUST CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADJUST;
59: G_ADJUST_LOAN CONSTANT VARCHAR2(30) := Okl_Create_Streams_Pvt.G_ADJUST_LOAN;
60: G_ADJUSTMENT_METHOD CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_ADJUSTMENT_METHOD;
61:
62:
63: SUBTYPE sifv_rec_type IS okl_stream_interfaces_pub.sifv_rec_type;
64: SUBTYPE csm_lease_rec_type IS Okl_Create_Streams_Pvt.csm_lease_rec_type;
60: G_ADJUSTMENT_METHOD CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_ADJUSTMENT_METHOD;
61:
62:
63: SUBTYPE sifv_rec_type IS okl_stream_interfaces_pub.sifv_rec_type;
64: SUBTYPE csm_lease_rec_type IS Okl_Create_Streams_Pvt.csm_lease_rec_type;
65: SUBTYPE csm_one_off_fee_tbl_type IS Okl_Create_Streams_Pvt.csm_one_off_fee_tbl_type;
66: SUBTYPE csm_periodic_expenses_tbl_type IS Okl_Create_Streams_Pvt.csm_periodic_expenses_tbl_type;
67: SUBTYPE csm_yields_tbl_type IS Okl_Create_Streams_Pvt.csm_yields_tbl_type;
68: SUBTYPE csm_stream_types_tbl_type IS Okl_Create_Streams_Pvt.csm_stream_types_tbl_type;
61:
62:
63: SUBTYPE sifv_rec_type IS okl_stream_interfaces_pub.sifv_rec_type;
64: SUBTYPE csm_lease_rec_type IS Okl_Create_Streams_Pvt.csm_lease_rec_type;
65: SUBTYPE csm_one_off_fee_tbl_type IS Okl_Create_Streams_Pvt.csm_one_off_fee_tbl_type;
66: SUBTYPE csm_periodic_expenses_tbl_type IS Okl_Create_Streams_Pvt.csm_periodic_expenses_tbl_type;
67: SUBTYPE csm_yields_tbl_type IS Okl_Create_Streams_Pvt.csm_yields_tbl_type;
68: SUBTYPE csm_stream_types_tbl_type IS Okl_Create_Streams_Pvt.csm_stream_types_tbl_type;
69: SUBTYPE csm_line_details_tbl_type IS Okl_Create_Streams_Pvt.csm_line_details_tbl_type;
62:
63: SUBTYPE sifv_rec_type IS okl_stream_interfaces_pub.sifv_rec_type;
64: SUBTYPE csm_lease_rec_type IS Okl_Create_Streams_Pvt.csm_lease_rec_type;
65: SUBTYPE csm_one_off_fee_tbl_type IS Okl_Create_Streams_Pvt.csm_one_off_fee_tbl_type;
66: SUBTYPE csm_periodic_expenses_tbl_type IS Okl_Create_Streams_Pvt.csm_periodic_expenses_tbl_type;
67: SUBTYPE csm_yields_tbl_type IS Okl_Create_Streams_Pvt.csm_yields_tbl_type;
68: SUBTYPE csm_stream_types_tbl_type IS Okl_Create_Streams_Pvt.csm_stream_types_tbl_type;
69: SUBTYPE csm_line_details_tbl_type IS Okl_Create_Streams_Pvt.csm_line_details_tbl_type;
70:
63: SUBTYPE sifv_rec_type IS okl_stream_interfaces_pub.sifv_rec_type;
64: SUBTYPE csm_lease_rec_type IS Okl_Create_Streams_Pvt.csm_lease_rec_type;
65: SUBTYPE csm_one_off_fee_tbl_type IS Okl_Create_Streams_Pvt.csm_one_off_fee_tbl_type;
66: SUBTYPE csm_periodic_expenses_tbl_type IS Okl_Create_Streams_Pvt.csm_periodic_expenses_tbl_type;
67: SUBTYPE csm_yields_tbl_type IS Okl_Create_Streams_Pvt.csm_yields_tbl_type;
68: SUBTYPE csm_stream_types_tbl_type IS Okl_Create_Streams_Pvt.csm_stream_types_tbl_type;
69: SUBTYPE csm_line_details_tbl_type IS Okl_Create_Streams_Pvt.csm_line_details_tbl_type;
70:
71: SUBTYPE csm_loan_rec_type IS Okl_Create_Streams_Pvt.csm_loan_rec_type;
64: SUBTYPE csm_lease_rec_type IS Okl_Create_Streams_Pvt.csm_lease_rec_type;
65: SUBTYPE csm_one_off_fee_tbl_type IS Okl_Create_Streams_Pvt.csm_one_off_fee_tbl_type;
66: SUBTYPE csm_periodic_expenses_tbl_type IS Okl_Create_Streams_Pvt.csm_periodic_expenses_tbl_type;
67: SUBTYPE csm_yields_tbl_type IS Okl_Create_Streams_Pvt.csm_yields_tbl_type;
68: SUBTYPE csm_stream_types_tbl_type IS Okl_Create_Streams_Pvt.csm_stream_types_tbl_type;
69: SUBTYPE csm_line_details_tbl_type IS Okl_Create_Streams_Pvt.csm_line_details_tbl_type;
70:
71: SUBTYPE csm_loan_rec_type IS Okl_Create_Streams_Pvt.csm_loan_rec_type;
72: SUBTYPE csm_loan_line_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_line_tbl_type;
65: SUBTYPE csm_one_off_fee_tbl_type IS Okl_Create_Streams_Pvt.csm_one_off_fee_tbl_type;
66: SUBTYPE csm_periodic_expenses_tbl_type IS Okl_Create_Streams_Pvt.csm_periodic_expenses_tbl_type;
67: SUBTYPE csm_yields_tbl_type IS Okl_Create_Streams_Pvt.csm_yields_tbl_type;
68: SUBTYPE csm_stream_types_tbl_type IS Okl_Create_Streams_Pvt.csm_stream_types_tbl_type;
69: SUBTYPE csm_line_details_tbl_type IS Okl_Create_Streams_Pvt.csm_line_details_tbl_type;
70:
71: SUBTYPE csm_loan_rec_type IS Okl_Create_Streams_Pvt.csm_loan_rec_type;
72: SUBTYPE csm_loan_line_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_line_tbl_type;
73: SUBTYPE csm_loan_level_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_level_tbl_type;
67: SUBTYPE csm_yields_tbl_type IS Okl_Create_Streams_Pvt.csm_yields_tbl_type;
68: SUBTYPE csm_stream_types_tbl_type IS Okl_Create_Streams_Pvt.csm_stream_types_tbl_type;
69: SUBTYPE csm_line_details_tbl_type IS Okl_Create_Streams_Pvt.csm_line_details_tbl_type;
70:
71: SUBTYPE csm_loan_rec_type IS Okl_Create_Streams_Pvt.csm_loan_rec_type;
72: SUBTYPE csm_loan_line_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_line_tbl_type;
73: SUBTYPE csm_loan_level_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_level_tbl_type;
74:
75: PROCEDURE Create_Streams_Lease_Book(
68: SUBTYPE csm_stream_types_tbl_type IS Okl_Create_Streams_Pvt.csm_stream_types_tbl_type;
69: SUBTYPE csm_line_details_tbl_type IS Okl_Create_Streams_Pvt.csm_line_details_tbl_type;
70:
71: SUBTYPE csm_loan_rec_type IS Okl_Create_Streams_Pvt.csm_loan_rec_type;
72: SUBTYPE csm_loan_line_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_line_tbl_type;
73: SUBTYPE csm_loan_level_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_level_tbl_type;
74:
75: PROCEDURE Create_Streams_Lease_Book(
76: p_api_version IN NUMBER
69: SUBTYPE csm_line_details_tbl_type IS Okl_Create_Streams_Pvt.csm_line_details_tbl_type;
70:
71: SUBTYPE csm_loan_rec_type IS Okl_Create_Streams_Pvt.csm_loan_rec_type;
72: SUBTYPE csm_loan_line_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_line_tbl_type;
73: SUBTYPE csm_loan_level_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_level_tbl_type;
74:
75: PROCEDURE Create_Streams_Lease_Book(
76: p_api_version IN NUMBER
77: ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE