DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on OKL_TERMNT_INTF_PTY

Line 86: -- OKL_TERMNT_INTF_PTY record Spec

82: -- OKL_TERMNT_INTERFACE table Spec
83: TYPE tif_tbl_type IS TABLE OF tif_rec_type
84: INDEX BY BINARY_INTEGER;
85:
86: -- OKL_TERMNT_INTF_PTY record Spec
87: TYPE tip_rec_type IS RECORD(
88: row_id ROWID
89: ,contract_party_id OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID%TYPE
90: ,contract_party_role OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE%TYPE

Line 89: ,contract_party_id OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID%TYPE

85:
86: -- OKL_TERMNT_INTF_PTY record Spec
87: TYPE tip_rec_type IS RECORD(
88: row_id ROWID
89: ,contract_party_id OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID%TYPE
90: ,contract_party_role OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE%TYPE
91: ,contract_party_name OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME%TYPE
92: ,contract_party_number OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER%TYPE
93: ,party_object_code OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE%TYPE

Line 90: ,contract_party_role OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE%TYPE

86: -- OKL_TERMNT_INTF_PTY record Spec
87: TYPE tip_rec_type IS RECORD(
88: row_id ROWID
89: ,contract_party_id OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID%TYPE
90: ,contract_party_role OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE%TYPE
91: ,contract_party_name OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME%TYPE
92: ,contract_party_number OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER%TYPE
93: ,party_object_code OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE%TYPE
94: ,party_object_id1 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1%TYPE

Line 91: ,contract_party_name OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME%TYPE

87: TYPE tip_rec_type IS RECORD(
88: row_id ROWID
89: ,contract_party_id OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID%TYPE
90: ,contract_party_role OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE%TYPE
91: ,contract_party_name OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME%TYPE
92: ,contract_party_number OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER%TYPE
93: ,party_object_code OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE%TYPE
94: ,party_object_id1 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1%TYPE
95: ,party_object_id2 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2%TYPE

Line 92: ,contract_party_number OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER%TYPE

88: row_id ROWID
89: ,contract_party_id OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID%TYPE
90: ,contract_party_role OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE%TYPE
91: ,contract_party_name OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME%TYPE
92: ,contract_party_number OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER%TYPE
93: ,party_object_code OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE%TYPE
94: ,party_object_id1 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1%TYPE
95: ,party_object_id2 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2%TYPE
96: ,email_address OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS%TYPE

Line 93: ,party_object_code OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE%TYPE

89: ,contract_party_id OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID%TYPE
90: ,contract_party_role OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE%TYPE
91: ,contract_party_name OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME%TYPE
92: ,contract_party_number OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER%TYPE
93: ,party_object_code OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE%TYPE
94: ,party_object_id1 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1%TYPE
95: ,party_object_id2 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2%TYPE
96: ,email_address OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS%TYPE
97: ,allocation_percentage OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE%TYPE

Line 94: ,party_object_id1 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1%TYPE

90: ,contract_party_role OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE%TYPE
91: ,contract_party_name OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME%TYPE
92: ,contract_party_number OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER%TYPE
93: ,party_object_code OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE%TYPE
94: ,party_object_id1 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1%TYPE
95: ,party_object_id2 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2%TYPE
96: ,email_address OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS%TYPE
97: ,allocation_percentage OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE%TYPE
98: ,delay_days OKL_TERMNT_INTF_PTY.DELAY_DAYS%TYPE

Line 95: ,party_object_id2 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2%TYPE

91: ,contract_party_name OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME%TYPE
92: ,contract_party_number OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER%TYPE
93: ,party_object_code OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE%TYPE
94: ,party_object_id1 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1%TYPE
95: ,party_object_id2 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2%TYPE
96: ,email_address OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS%TYPE
97: ,allocation_percentage OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE%TYPE
98: ,delay_days OKL_TERMNT_INTF_PTY.DELAY_DAYS%TYPE
99: ,qpy_id OKL_TERMNT_INTF_PTY.QPY_ID%TYPE

Line 96: ,email_address OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS%TYPE

92: ,contract_party_number OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER%TYPE
93: ,party_object_code OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE%TYPE
94: ,party_object_id1 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1%TYPE
95: ,party_object_id2 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2%TYPE
96: ,email_address OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS%TYPE
97: ,allocation_percentage OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE%TYPE
98: ,delay_days OKL_TERMNT_INTF_PTY.DELAY_DAYS%TYPE
99: ,qpy_id OKL_TERMNT_INTF_PTY.QPY_ID%TYPE
100: ,transaction_number OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER%TYPE

Line 97: ,allocation_percentage OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE%TYPE

93: ,party_object_code OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE%TYPE
94: ,party_object_id1 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1%TYPE
95: ,party_object_id2 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2%TYPE
96: ,email_address OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS%TYPE
97: ,allocation_percentage OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE%TYPE
98: ,delay_days OKL_TERMNT_INTF_PTY.DELAY_DAYS%TYPE
99: ,qpy_id OKL_TERMNT_INTF_PTY.QPY_ID%TYPE
100: ,transaction_number OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER%TYPE
101: ,status OKL_TERMNT_INTF_PTY.STATUS%TYPE

Line 98: ,delay_days OKL_TERMNT_INTF_PTY.DELAY_DAYS%TYPE

94: ,party_object_id1 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1%TYPE
95: ,party_object_id2 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2%TYPE
96: ,email_address OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS%TYPE
97: ,allocation_percentage OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE%TYPE
98: ,delay_days OKL_TERMNT_INTF_PTY.DELAY_DAYS%TYPE
99: ,qpy_id OKL_TERMNT_INTF_PTY.QPY_ID%TYPE
100: ,transaction_number OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER%TYPE
101: ,status OKL_TERMNT_INTF_PTY.STATUS%TYPE
102: ,request_id OKL_TERMNT_INTF_PTY.REQUEST_ID%TYPE

Line 99: ,qpy_id OKL_TERMNT_INTF_PTY.QPY_ID%TYPE

95: ,party_object_id2 OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2%TYPE
96: ,email_address OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS%TYPE
97: ,allocation_percentage OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE%TYPE
98: ,delay_days OKL_TERMNT_INTF_PTY.DELAY_DAYS%TYPE
99: ,qpy_id OKL_TERMNT_INTF_PTY.QPY_ID%TYPE
100: ,transaction_number OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER%TYPE
101: ,status OKL_TERMNT_INTF_PTY.STATUS%TYPE
102: ,request_id OKL_TERMNT_INTF_PTY.REQUEST_ID%TYPE
103: ,program_application_id OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID%TYPE

Line 100: ,transaction_number OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER%TYPE

96: ,email_address OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS%TYPE
97: ,allocation_percentage OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE%TYPE
98: ,delay_days OKL_TERMNT_INTF_PTY.DELAY_DAYS%TYPE
99: ,qpy_id OKL_TERMNT_INTF_PTY.QPY_ID%TYPE
100: ,transaction_number OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER%TYPE
101: ,status OKL_TERMNT_INTF_PTY.STATUS%TYPE
102: ,request_id OKL_TERMNT_INTF_PTY.REQUEST_ID%TYPE
103: ,program_application_id OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID%TYPE
104: ,program_id OKL_TERMNT_INTF_PTY.PROGRAM_ID%TYPE

Line 101: ,status OKL_TERMNT_INTF_PTY.STATUS%TYPE

97: ,allocation_percentage OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE%TYPE
98: ,delay_days OKL_TERMNT_INTF_PTY.DELAY_DAYS%TYPE
99: ,qpy_id OKL_TERMNT_INTF_PTY.QPY_ID%TYPE
100: ,transaction_number OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER%TYPE
101: ,status OKL_TERMNT_INTF_PTY.STATUS%TYPE
102: ,request_id OKL_TERMNT_INTF_PTY.REQUEST_ID%TYPE
103: ,program_application_id OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID%TYPE
104: ,program_id OKL_TERMNT_INTF_PTY.PROGRAM_ID%TYPE
105: ,program_update_date OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE%TYPE

Line 102: ,request_id OKL_TERMNT_INTF_PTY.REQUEST_ID%TYPE

98: ,delay_days OKL_TERMNT_INTF_PTY.DELAY_DAYS%TYPE
99: ,qpy_id OKL_TERMNT_INTF_PTY.QPY_ID%TYPE
100: ,transaction_number OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER%TYPE
101: ,status OKL_TERMNT_INTF_PTY.STATUS%TYPE
102: ,request_id OKL_TERMNT_INTF_PTY.REQUEST_ID%TYPE
103: ,program_application_id OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID%TYPE
104: ,program_id OKL_TERMNT_INTF_PTY.PROGRAM_ID%TYPE
105: ,program_update_date OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE%TYPE
106: ,attribute_category OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY%TYPE

Line 103: ,program_application_id OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID%TYPE

99: ,qpy_id OKL_TERMNT_INTF_PTY.QPY_ID%TYPE
100: ,transaction_number OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER%TYPE
101: ,status OKL_TERMNT_INTF_PTY.STATUS%TYPE
102: ,request_id OKL_TERMNT_INTF_PTY.REQUEST_ID%TYPE
103: ,program_application_id OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID%TYPE
104: ,program_id OKL_TERMNT_INTF_PTY.PROGRAM_ID%TYPE
105: ,program_update_date OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE%TYPE
106: ,attribute_category OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY%TYPE
107: ,attribute1 OKL_TERMNT_INTF_PTY.ATTRIBUTE1%TYPE

Line 104: ,program_id OKL_TERMNT_INTF_PTY.PROGRAM_ID%TYPE

100: ,transaction_number OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER%TYPE
101: ,status OKL_TERMNT_INTF_PTY.STATUS%TYPE
102: ,request_id OKL_TERMNT_INTF_PTY.REQUEST_ID%TYPE
103: ,program_application_id OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID%TYPE
104: ,program_id OKL_TERMNT_INTF_PTY.PROGRAM_ID%TYPE
105: ,program_update_date OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE%TYPE
106: ,attribute_category OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY%TYPE
107: ,attribute1 OKL_TERMNT_INTF_PTY.ATTRIBUTE1%TYPE
108: ,attribute2 OKL_TERMNT_INTF_PTY.ATTRIBUTE2%TYPE

Line 105: ,program_update_date OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE%TYPE

101: ,status OKL_TERMNT_INTF_PTY.STATUS%TYPE
102: ,request_id OKL_TERMNT_INTF_PTY.REQUEST_ID%TYPE
103: ,program_application_id OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID%TYPE
104: ,program_id OKL_TERMNT_INTF_PTY.PROGRAM_ID%TYPE
105: ,program_update_date OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE%TYPE
106: ,attribute_category OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY%TYPE
107: ,attribute1 OKL_TERMNT_INTF_PTY.ATTRIBUTE1%TYPE
108: ,attribute2 OKL_TERMNT_INTF_PTY.ATTRIBUTE2%TYPE
109: ,attribute3 OKL_TERMNT_INTF_PTY.ATTRIBUTE3%TYPE

Line 106: ,attribute_category OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY%TYPE

102: ,request_id OKL_TERMNT_INTF_PTY.REQUEST_ID%TYPE
103: ,program_application_id OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID%TYPE
104: ,program_id OKL_TERMNT_INTF_PTY.PROGRAM_ID%TYPE
105: ,program_update_date OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE%TYPE
106: ,attribute_category OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY%TYPE
107: ,attribute1 OKL_TERMNT_INTF_PTY.ATTRIBUTE1%TYPE
108: ,attribute2 OKL_TERMNT_INTF_PTY.ATTRIBUTE2%TYPE
109: ,attribute3 OKL_TERMNT_INTF_PTY.ATTRIBUTE3%TYPE
110: ,attribute4 OKL_TERMNT_INTF_PTY.ATTRIBUTE4%TYPE

Line 107: ,attribute1 OKL_TERMNT_INTF_PTY.ATTRIBUTE1%TYPE

103: ,program_application_id OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID%TYPE
104: ,program_id OKL_TERMNT_INTF_PTY.PROGRAM_ID%TYPE
105: ,program_update_date OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE%TYPE
106: ,attribute_category OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY%TYPE
107: ,attribute1 OKL_TERMNT_INTF_PTY.ATTRIBUTE1%TYPE
108: ,attribute2 OKL_TERMNT_INTF_PTY.ATTRIBUTE2%TYPE
109: ,attribute3 OKL_TERMNT_INTF_PTY.ATTRIBUTE3%TYPE
110: ,attribute4 OKL_TERMNT_INTF_PTY.ATTRIBUTE4%TYPE
111: ,attribute5 OKL_TERMNT_INTF_PTY.ATTRIBUTE5%TYPE

Line 108: ,attribute2 OKL_TERMNT_INTF_PTY.ATTRIBUTE2%TYPE

104: ,program_id OKL_TERMNT_INTF_PTY.PROGRAM_ID%TYPE
105: ,program_update_date OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE%TYPE
106: ,attribute_category OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY%TYPE
107: ,attribute1 OKL_TERMNT_INTF_PTY.ATTRIBUTE1%TYPE
108: ,attribute2 OKL_TERMNT_INTF_PTY.ATTRIBUTE2%TYPE
109: ,attribute3 OKL_TERMNT_INTF_PTY.ATTRIBUTE3%TYPE
110: ,attribute4 OKL_TERMNT_INTF_PTY.ATTRIBUTE4%TYPE
111: ,attribute5 OKL_TERMNT_INTF_PTY.ATTRIBUTE5%TYPE
112: ,attribute6 OKL_TERMNT_INTF_PTY.ATTRIBUTE6%TYPE

Line 109: ,attribute3 OKL_TERMNT_INTF_PTY.ATTRIBUTE3%TYPE

105: ,program_update_date OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE%TYPE
106: ,attribute_category OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY%TYPE
107: ,attribute1 OKL_TERMNT_INTF_PTY.ATTRIBUTE1%TYPE
108: ,attribute2 OKL_TERMNT_INTF_PTY.ATTRIBUTE2%TYPE
109: ,attribute3 OKL_TERMNT_INTF_PTY.ATTRIBUTE3%TYPE
110: ,attribute4 OKL_TERMNT_INTF_PTY.ATTRIBUTE4%TYPE
111: ,attribute5 OKL_TERMNT_INTF_PTY.ATTRIBUTE5%TYPE
112: ,attribute6 OKL_TERMNT_INTF_PTY.ATTRIBUTE6%TYPE
113: ,attribute7 OKL_TERMNT_INTF_PTY.ATTRIBUTE7%TYPE

Line 110: ,attribute4 OKL_TERMNT_INTF_PTY.ATTRIBUTE4%TYPE

106: ,attribute_category OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY%TYPE
107: ,attribute1 OKL_TERMNT_INTF_PTY.ATTRIBUTE1%TYPE
108: ,attribute2 OKL_TERMNT_INTF_PTY.ATTRIBUTE2%TYPE
109: ,attribute3 OKL_TERMNT_INTF_PTY.ATTRIBUTE3%TYPE
110: ,attribute4 OKL_TERMNT_INTF_PTY.ATTRIBUTE4%TYPE
111: ,attribute5 OKL_TERMNT_INTF_PTY.ATTRIBUTE5%TYPE
112: ,attribute6 OKL_TERMNT_INTF_PTY.ATTRIBUTE6%TYPE
113: ,attribute7 OKL_TERMNT_INTF_PTY.ATTRIBUTE7%TYPE
114: ,attribute8 OKL_TERMNT_INTF_PTY.ATTRIBUTE8%TYPE

Line 111: ,attribute5 OKL_TERMNT_INTF_PTY.ATTRIBUTE5%TYPE

107: ,attribute1 OKL_TERMNT_INTF_PTY.ATTRIBUTE1%TYPE
108: ,attribute2 OKL_TERMNT_INTF_PTY.ATTRIBUTE2%TYPE
109: ,attribute3 OKL_TERMNT_INTF_PTY.ATTRIBUTE3%TYPE
110: ,attribute4 OKL_TERMNT_INTF_PTY.ATTRIBUTE4%TYPE
111: ,attribute5 OKL_TERMNT_INTF_PTY.ATTRIBUTE5%TYPE
112: ,attribute6 OKL_TERMNT_INTF_PTY.ATTRIBUTE6%TYPE
113: ,attribute7 OKL_TERMNT_INTF_PTY.ATTRIBUTE7%TYPE
114: ,attribute8 OKL_TERMNT_INTF_PTY.ATTRIBUTE8%TYPE
115: ,attribute9 OKL_TERMNT_INTF_PTY.ATTRIBUTE9%TYPE

Line 112: ,attribute6 OKL_TERMNT_INTF_PTY.ATTRIBUTE6%TYPE

108: ,attribute2 OKL_TERMNT_INTF_PTY.ATTRIBUTE2%TYPE
109: ,attribute3 OKL_TERMNT_INTF_PTY.ATTRIBUTE3%TYPE
110: ,attribute4 OKL_TERMNT_INTF_PTY.ATTRIBUTE4%TYPE
111: ,attribute5 OKL_TERMNT_INTF_PTY.ATTRIBUTE5%TYPE
112: ,attribute6 OKL_TERMNT_INTF_PTY.ATTRIBUTE6%TYPE
113: ,attribute7 OKL_TERMNT_INTF_PTY.ATTRIBUTE7%TYPE
114: ,attribute8 OKL_TERMNT_INTF_PTY.ATTRIBUTE8%TYPE
115: ,attribute9 OKL_TERMNT_INTF_PTY.ATTRIBUTE9%TYPE
116: ,attribute10 OKL_TERMNT_INTF_PTY.ATTRIBUTE10%TYPE

Line 113: ,attribute7 OKL_TERMNT_INTF_PTY.ATTRIBUTE7%TYPE

109: ,attribute3 OKL_TERMNT_INTF_PTY.ATTRIBUTE3%TYPE
110: ,attribute4 OKL_TERMNT_INTF_PTY.ATTRIBUTE4%TYPE
111: ,attribute5 OKL_TERMNT_INTF_PTY.ATTRIBUTE5%TYPE
112: ,attribute6 OKL_TERMNT_INTF_PTY.ATTRIBUTE6%TYPE
113: ,attribute7 OKL_TERMNT_INTF_PTY.ATTRIBUTE7%TYPE
114: ,attribute8 OKL_TERMNT_INTF_PTY.ATTRIBUTE8%TYPE
115: ,attribute9 OKL_TERMNT_INTF_PTY.ATTRIBUTE9%TYPE
116: ,attribute10 OKL_TERMNT_INTF_PTY.ATTRIBUTE10%TYPE
117: ,attribute11 OKL_TERMNT_INTF_PTY.ATTRIBUTE11%TYPE

Line 114: ,attribute8 OKL_TERMNT_INTF_PTY.ATTRIBUTE8%TYPE

110: ,attribute4 OKL_TERMNT_INTF_PTY.ATTRIBUTE4%TYPE
111: ,attribute5 OKL_TERMNT_INTF_PTY.ATTRIBUTE5%TYPE
112: ,attribute6 OKL_TERMNT_INTF_PTY.ATTRIBUTE6%TYPE
113: ,attribute7 OKL_TERMNT_INTF_PTY.ATTRIBUTE7%TYPE
114: ,attribute8 OKL_TERMNT_INTF_PTY.ATTRIBUTE8%TYPE
115: ,attribute9 OKL_TERMNT_INTF_PTY.ATTRIBUTE9%TYPE
116: ,attribute10 OKL_TERMNT_INTF_PTY.ATTRIBUTE10%TYPE
117: ,attribute11 OKL_TERMNT_INTF_PTY.ATTRIBUTE11%TYPE
118: ,attribute12 OKL_TERMNT_INTF_PTY.ATTRIBUTE12%TYPE

Line 115: ,attribute9 OKL_TERMNT_INTF_PTY.ATTRIBUTE9%TYPE

111: ,attribute5 OKL_TERMNT_INTF_PTY.ATTRIBUTE5%TYPE
112: ,attribute6 OKL_TERMNT_INTF_PTY.ATTRIBUTE6%TYPE
113: ,attribute7 OKL_TERMNT_INTF_PTY.ATTRIBUTE7%TYPE
114: ,attribute8 OKL_TERMNT_INTF_PTY.ATTRIBUTE8%TYPE
115: ,attribute9 OKL_TERMNT_INTF_PTY.ATTRIBUTE9%TYPE
116: ,attribute10 OKL_TERMNT_INTF_PTY.ATTRIBUTE10%TYPE
117: ,attribute11 OKL_TERMNT_INTF_PTY.ATTRIBUTE11%TYPE
118: ,attribute12 OKL_TERMNT_INTF_PTY.ATTRIBUTE12%TYPE
119: ,attribute13 OKL_TERMNT_INTF_PTY.ATTRIBUTE13%TYPE

Line 116: ,attribute10 OKL_TERMNT_INTF_PTY.ATTRIBUTE10%TYPE

112: ,attribute6 OKL_TERMNT_INTF_PTY.ATTRIBUTE6%TYPE
113: ,attribute7 OKL_TERMNT_INTF_PTY.ATTRIBUTE7%TYPE
114: ,attribute8 OKL_TERMNT_INTF_PTY.ATTRIBUTE8%TYPE
115: ,attribute9 OKL_TERMNT_INTF_PTY.ATTRIBUTE9%TYPE
116: ,attribute10 OKL_TERMNT_INTF_PTY.ATTRIBUTE10%TYPE
117: ,attribute11 OKL_TERMNT_INTF_PTY.ATTRIBUTE11%TYPE
118: ,attribute12 OKL_TERMNT_INTF_PTY.ATTRIBUTE12%TYPE
119: ,attribute13 OKL_TERMNT_INTF_PTY.ATTRIBUTE13%TYPE
120: ,attribute14 OKL_TERMNT_INTF_PTY.ATTRIBUTE14%TYPE

Line 117: ,attribute11 OKL_TERMNT_INTF_PTY.ATTRIBUTE11%TYPE

113: ,attribute7 OKL_TERMNT_INTF_PTY.ATTRIBUTE7%TYPE
114: ,attribute8 OKL_TERMNT_INTF_PTY.ATTRIBUTE8%TYPE
115: ,attribute9 OKL_TERMNT_INTF_PTY.ATTRIBUTE9%TYPE
116: ,attribute10 OKL_TERMNT_INTF_PTY.ATTRIBUTE10%TYPE
117: ,attribute11 OKL_TERMNT_INTF_PTY.ATTRIBUTE11%TYPE
118: ,attribute12 OKL_TERMNT_INTF_PTY.ATTRIBUTE12%TYPE
119: ,attribute13 OKL_TERMNT_INTF_PTY.ATTRIBUTE13%TYPE
120: ,attribute14 OKL_TERMNT_INTF_PTY.ATTRIBUTE14%TYPE
121: ,attribute15 OKL_TERMNT_INTF_PTY.ATTRIBUTE15%TYPE

Line 118: ,attribute12 OKL_TERMNT_INTF_PTY.ATTRIBUTE12%TYPE

114: ,attribute8 OKL_TERMNT_INTF_PTY.ATTRIBUTE8%TYPE
115: ,attribute9 OKL_TERMNT_INTF_PTY.ATTRIBUTE9%TYPE
116: ,attribute10 OKL_TERMNT_INTF_PTY.ATTRIBUTE10%TYPE
117: ,attribute11 OKL_TERMNT_INTF_PTY.ATTRIBUTE11%TYPE
118: ,attribute12 OKL_TERMNT_INTF_PTY.ATTRIBUTE12%TYPE
119: ,attribute13 OKL_TERMNT_INTF_PTY.ATTRIBUTE13%TYPE
120: ,attribute14 OKL_TERMNT_INTF_PTY.ATTRIBUTE14%TYPE
121: ,attribute15 OKL_TERMNT_INTF_PTY.ATTRIBUTE15%TYPE
122: ,created_by OKL_TERMNT_INTF_PTY.CREATED_BY%TYPE

Line 119: ,attribute13 OKL_TERMNT_INTF_PTY.ATTRIBUTE13%TYPE

115: ,attribute9 OKL_TERMNT_INTF_PTY.ATTRIBUTE9%TYPE
116: ,attribute10 OKL_TERMNT_INTF_PTY.ATTRIBUTE10%TYPE
117: ,attribute11 OKL_TERMNT_INTF_PTY.ATTRIBUTE11%TYPE
118: ,attribute12 OKL_TERMNT_INTF_PTY.ATTRIBUTE12%TYPE
119: ,attribute13 OKL_TERMNT_INTF_PTY.ATTRIBUTE13%TYPE
120: ,attribute14 OKL_TERMNT_INTF_PTY.ATTRIBUTE14%TYPE
121: ,attribute15 OKL_TERMNT_INTF_PTY.ATTRIBUTE15%TYPE
122: ,created_by OKL_TERMNT_INTF_PTY.CREATED_BY%TYPE
123: ,creation_date OKL_TERMNT_INTF_PTY.CREATION_DATE%TYPE

Line 120: ,attribute14 OKL_TERMNT_INTF_PTY.ATTRIBUTE14%TYPE

116: ,attribute10 OKL_TERMNT_INTF_PTY.ATTRIBUTE10%TYPE
117: ,attribute11 OKL_TERMNT_INTF_PTY.ATTRIBUTE11%TYPE
118: ,attribute12 OKL_TERMNT_INTF_PTY.ATTRIBUTE12%TYPE
119: ,attribute13 OKL_TERMNT_INTF_PTY.ATTRIBUTE13%TYPE
120: ,attribute14 OKL_TERMNT_INTF_PTY.ATTRIBUTE14%TYPE
121: ,attribute15 OKL_TERMNT_INTF_PTY.ATTRIBUTE15%TYPE
122: ,created_by OKL_TERMNT_INTF_PTY.CREATED_BY%TYPE
123: ,creation_date OKL_TERMNT_INTF_PTY.CREATION_DATE%TYPE
124: ,last_updated_by OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY%TYPE

Line 121: ,attribute15 OKL_TERMNT_INTF_PTY.ATTRIBUTE15%TYPE

117: ,attribute11 OKL_TERMNT_INTF_PTY.ATTRIBUTE11%TYPE
118: ,attribute12 OKL_TERMNT_INTF_PTY.ATTRIBUTE12%TYPE
119: ,attribute13 OKL_TERMNT_INTF_PTY.ATTRIBUTE13%TYPE
120: ,attribute14 OKL_TERMNT_INTF_PTY.ATTRIBUTE14%TYPE
121: ,attribute15 OKL_TERMNT_INTF_PTY.ATTRIBUTE15%TYPE
122: ,created_by OKL_TERMNT_INTF_PTY.CREATED_BY%TYPE
123: ,creation_date OKL_TERMNT_INTF_PTY.CREATION_DATE%TYPE
124: ,last_updated_by OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY%TYPE
125: ,last_update_date OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE%TYPE

Line 122: ,created_by OKL_TERMNT_INTF_PTY.CREATED_BY%TYPE

118: ,attribute12 OKL_TERMNT_INTF_PTY.ATTRIBUTE12%TYPE
119: ,attribute13 OKL_TERMNT_INTF_PTY.ATTRIBUTE13%TYPE
120: ,attribute14 OKL_TERMNT_INTF_PTY.ATTRIBUTE14%TYPE
121: ,attribute15 OKL_TERMNT_INTF_PTY.ATTRIBUTE15%TYPE
122: ,created_by OKL_TERMNT_INTF_PTY.CREATED_BY%TYPE
123: ,creation_date OKL_TERMNT_INTF_PTY.CREATION_DATE%TYPE
124: ,last_updated_by OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY%TYPE
125: ,last_update_date OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE%TYPE
126: ,last_update_login OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN%TYPE

Line 123: ,creation_date OKL_TERMNT_INTF_PTY.CREATION_DATE%TYPE

119: ,attribute13 OKL_TERMNT_INTF_PTY.ATTRIBUTE13%TYPE
120: ,attribute14 OKL_TERMNT_INTF_PTY.ATTRIBUTE14%TYPE
121: ,attribute15 OKL_TERMNT_INTF_PTY.ATTRIBUTE15%TYPE
122: ,created_by OKL_TERMNT_INTF_PTY.CREATED_BY%TYPE
123: ,creation_date OKL_TERMNT_INTF_PTY.CREATION_DATE%TYPE
124: ,last_updated_by OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY%TYPE
125: ,last_update_date OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE%TYPE
126: ,last_update_login OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN%TYPE
127: ,quote_role_code OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE%TYPE);

Line 124: ,last_updated_by OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY%TYPE

120: ,attribute14 OKL_TERMNT_INTF_PTY.ATTRIBUTE14%TYPE
121: ,attribute15 OKL_TERMNT_INTF_PTY.ATTRIBUTE15%TYPE
122: ,created_by OKL_TERMNT_INTF_PTY.CREATED_BY%TYPE
123: ,creation_date OKL_TERMNT_INTF_PTY.CREATION_DATE%TYPE
124: ,last_updated_by OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY%TYPE
125: ,last_update_date OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE%TYPE
126: ,last_update_login OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN%TYPE
127: ,quote_role_code OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE%TYPE);
128:

Line 125: ,last_update_date OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE%TYPE

121: ,attribute15 OKL_TERMNT_INTF_PTY.ATTRIBUTE15%TYPE
122: ,created_by OKL_TERMNT_INTF_PTY.CREATED_BY%TYPE
123: ,creation_date OKL_TERMNT_INTF_PTY.CREATION_DATE%TYPE
124: ,last_updated_by OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY%TYPE
125: ,last_update_date OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE%TYPE
126: ,last_update_login OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN%TYPE
127: ,quote_role_code OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE%TYPE);
128:
129: g_miss_tip_rec tip_rec_type;

Line 126: ,last_update_login OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN%TYPE

122: ,created_by OKL_TERMNT_INTF_PTY.CREATED_BY%TYPE
123: ,creation_date OKL_TERMNT_INTF_PTY.CREATION_DATE%TYPE
124: ,last_updated_by OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY%TYPE
125: ,last_update_date OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE%TYPE
126: ,last_update_login OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN%TYPE
127: ,quote_role_code OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE%TYPE);
128:
129: g_miss_tip_rec tip_rec_type;
130: -- OKL_TERMNT_INTF_PTY table Spec

Line 127: ,quote_role_code OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE%TYPE);

123: ,creation_date OKL_TERMNT_INTF_PTY.CREATION_DATE%TYPE
124: ,last_updated_by OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY%TYPE
125: ,last_update_date OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE%TYPE
126: ,last_update_login OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN%TYPE
127: ,quote_role_code OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE%TYPE);
128:
129: g_miss_tip_rec tip_rec_type;
130: -- OKL_TERMNT_INTF_PTY table Spec
131: TYPE tip_tbl_type IS TABLE OF tip_rec_type

Line 130: -- OKL_TERMNT_INTF_PTY table Spec

126: ,last_update_login OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN%TYPE
127: ,quote_role_code OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE%TYPE);
128:
129: g_miss_tip_rec tip_rec_type;
130: -- OKL_TERMNT_INTF_PTY table Spec
131: TYPE tip_tbl_type IS TABLE OF tip_rec_type
132: INDEX BY BINARY_INTEGER;
133:
134: ---------------------------------------------------------------------------