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