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.LNS_PARTICIPANTS_PKG dependencies on FND_API

Line 91: DECODE(x_participant_id, FND_API.G_MISS_NUM, LNS_PARTICIPANTS_S.NEXTVAL, NULL, LNS_PARTICIPANTS_S.NEXTVAL, x_participant_id)

87: ,REVIEW_TYPE
88: ,CREDIT_CLASSIFICATION
89: ,ACCESS_LEVEL
90: ) VALUES (
91: DECODE(x_participant_id, FND_API.G_MISS_NUM, LNS_PARTICIPANTS_S.NEXTVAL, NULL, LNS_PARTICIPANTS_S.NEXTVAL, x_participant_id)
92: ,DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, p_LOAN_ID)
93: ,DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_HZ_PARTY_ID)
94: ,DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, p_LOAN_PARTICIPANT_TYPE)
95: ,DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)

Line 92: ,DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, p_LOAN_ID)

88: ,CREDIT_CLASSIFICATION
89: ,ACCESS_LEVEL
90: ) VALUES (
91: DECODE(x_participant_id, FND_API.G_MISS_NUM, LNS_PARTICIPANTS_S.NEXTVAL, NULL, LNS_PARTICIPANTS_S.NEXTVAL, x_participant_id)
92: ,DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, p_LOAN_ID)
93: ,DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_HZ_PARTY_ID)
94: ,DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, p_LOAN_PARTICIPANT_TYPE)
95: ,DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
96: ,DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE)

Line 93: ,DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_HZ_PARTY_ID)

89: ,ACCESS_LEVEL
90: ) VALUES (
91: DECODE(x_participant_id, FND_API.G_MISS_NUM, LNS_PARTICIPANTS_S.NEXTVAL, NULL, LNS_PARTICIPANTS_S.NEXTVAL, x_participant_id)
92: ,DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, p_LOAN_ID)
93: ,DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_HZ_PARTY_ID)
94: ,DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, p_LOAN_PARTICIPANT_TYPE)
95: ,DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
96: ,DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE)
97: ,DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID)

Line 94: ,DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, p_LOAN_PARTICIPANT_TYPE)

90: ) VALUES (
91: DECODE(x_participant_id, FND_API.G_MISS_NUM, LNS_PARTICIPANTS_S.NEXTVAL, NULL, LNS_PARTICIPANTS_S.NEXTVAL, x_participant_id)
92: ,DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, p_LOAN_ID)
93: ,DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_HZ_PARTY_ID)
94: ,DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, p_LOAN_PARTICIPANT_TYPE)
95: ,DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
96: ,DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE)
97: ,DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID)
98: ,DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, p_BILL_TO_ACCT_SITE_ID)

Line 95: ,DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)

91: DECODE(x_participant_id, FND_API.G_MISS_NUM, LNS_PARTICIPANTS_S.NEXTVAL, NULL, LNS_PARTICIPANTS_S.NEXTVAL, x_participant_id)
92: ,DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, p_LOAN_ID)
93: ,DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_HZ_PARTY_ID)
94: ,DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, p_LOAN_PARTICIPANT_TYPE)
95: ,DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
96: ,DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE)
97: ,DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID)
98: ,DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, p_BILL_TO_ACCT_SITE_ID)
99: ,LNS_UTILITY_PUB.CREATED_BY

Line 96: ,DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE)

92: ,DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, p_LOAN_ID)
93: ,DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_HZ_PARTY_ID)
94: ,DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, p_LOAN_PARTICIPANT_TYPE)
95: ,DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
96: ,DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE)
97: ,DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID)
98: ,DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, p_BILL_TO_ACCT_SITE_ID)
99: ,LNS_UTILITY_PUB.CREATED_BY
100: ,LNS_UTILITY_PUB.CREATION_DATE

Line 97: ,DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID)

93: ,DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_HZ_PARTY_ID)
94: ,DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, p_LOAN_PARTICIPANT_TYPE)
95: ,DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
96: ,DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE)
97: ,DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID)
98: ,DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, p_BILL_TO_ACCT_SITE_ID)
99: ,LNS_UTILITY_PUB.CREATED_BY
100: ,LNS_UTILITY_PUB.CREATION_DATE
101: ,LNS_UTILITY_PUB.LAST_UPDATED_BY

Line 98: ,DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, p_BILL_TO_ACCT_SITE_ID)

94: ,DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, p_LOAN_PARTICIPANT_TYPE)
95: ,DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
96: ,DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE)
97: ,DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID)
98: ,DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, p_BILL_TO_ACCT_SITE_ID)
99: ,LNS_UTILITY_PUB.CREATED_BY
100: ,LNS_UTILITY_PUB.CREATION_DATE
101: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
102: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE

Line 104: ,DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, 1)

100: ,LNS_UTILITY_PUB.CREATION_DATE
101: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
102: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
103: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
104: ,DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, 1)
105: ,DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_CATEGORY)
106: ,DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
107: ,DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
108: ,DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)

Line 105: ,DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_CATEGORY)

101: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
102: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
103: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
104: ,DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, 1)
105: ,DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_CATEGORY)
106: ,DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
107: ,DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
108: ,DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
109: ,DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

Line 106: ,DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)

102: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
103: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
104: ,DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, 1)
105: ,DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_CATEGORY)
106: ,DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
107: ,DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
108: ,DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
109: ,DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
110: ,DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)

Line 107: ,DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)

103: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
104: ,DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, 1)
105: ,DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_CATEGORY)
106: ,DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
107: ,DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
108: ,DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
109: ,DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
110: ,DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
111: ,DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)

Line 108: ,DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)

104: ,DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, 1)
105: ,DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_CATEGORY)
106: ,DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
107: ,DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
108: ,DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
109: ,DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
110: ,DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
111: ,DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
112: ,DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)

Line 109: ,DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

105: ,DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_CATEGORY)
106: ,DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
107: ,DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
108: ,DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
109: ,DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
110: ,DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
111: ,DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
112: ,DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
113: ,DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)

Line 110: ,DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)

106: ,DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
107: ,DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
108: ,DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
109: ,DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
110: ,DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
111: ,DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
112: ,DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
113: ,DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
114: ,DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)

Line 111: ,DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)

107: ,DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
108: ,DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
109: ,DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
110: ,DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
111: ,DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
112: ,DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
113: ,DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
114: ,DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
115: ,DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)

Line 112: ,DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)

108: ,DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
109: ,DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
110: ,DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
111: ,DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
112: ,DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
113: ,DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
114: ,DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
115: ,DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
116: ,DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)

Line 113: ,DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)

109: ,DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
110: ,DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
111: ,DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
112: ,DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
113: ,DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
114: ,DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
115: ,DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
116: ,DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
117: ,DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)

Line 114: ,DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)

110: ,DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
111: ,DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
112: ,DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
113: ,DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
114: ,DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
115: ,DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
116: ,DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
117: ,DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
118: ,DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)

Line 115: ,DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)

111: ,DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
112: ,DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
113: ,DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
114: ,DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
115: ,DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
116: ,DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
117: ,DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
118: ,DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
119: ,DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)

Line 116: ,DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)

112: ,DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
113: ,DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
114: ,DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
115: ,DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
116: ,DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
117: ,DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
118: ,DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
119: ,DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
120: ,DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

Line 117: ,DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)

113: ,DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
114: ,DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
115: ,DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
116: ,DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
117: ,DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
118: ,DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
119: ,DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
120: ,DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
121: ,DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)

Line 118: ,DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)

114: ,DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
115: ,DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
116: ,DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
117: ,DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
118: ,DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
119: ,DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
120: ,DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
121: ,DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
122: ,DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)

Line 119: ,DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)

115: ,DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
116: ,DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
117: ,DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
118: ,DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
119: ,DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
120: ,DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
121: ,DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
122: ,DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
123: ,DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)

Line 120: ,DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

116: ,DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
117: ,DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
118: ,DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
119: ,DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
120: ,DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
121: ,DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
122: ,DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
123: ,DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
124: ,DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)

Line 121: ,DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)

117: ,DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
118: ,DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
119: ,DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
120: ,DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
121: ,DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
122: ,DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
123: ,DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
124: ,DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
125: ,DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)

Line 122: ,DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)

118: ,DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
119: ,DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
120: ,DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
121: ,DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
122: ,DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
123: ,DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
124: ,DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
125: ,DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
126: ,DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_REL_PARTY_ID)

Line 123: ,DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)

119: ,DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
120: ,DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
121: ,DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
122: ,DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
123: ,DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
124: ,DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
125: ,DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
126: ,DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_REL_PARTY_ID)
127: ,DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PERS_PARTY_ID)

Line 124: ,DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)

120: ,DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
121: ,DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
122: ,DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
123: ,DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
124: ,DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
125: ,DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
126: ,DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_REL_PARTY_ID)
127: ,DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PERS_PARTY_ID)
128: ,DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_REQUEST_ID)

Line 125: ,DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)

121: ,DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
122: ,DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
123: ,DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
124: ,DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
125: ,DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
126: ,DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_REL_PARTY_ID)
127: ,DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PERS_PARTY_ID)
128: ,DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_REQUEST_ID)
129: ,DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, p_CASE_FOLDER_ID)

Line 126: ,DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_REL_PARTY_ID)

122: ,DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
123: ,DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
124: ,DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
125: ,DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
126: ,DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_REL_PARTY_ID)
127: ,DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PERS_PARTY_ID)
128: ,DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_REQUEST_ID)
129: ,DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, p_CASE_FOLDER_ID)
130: ,DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, p_REVIEW_TYPE)

Line 127: ,DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PERS_PARTY_ID)

123: ,DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
124: ,DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
125: ,DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
126: ,DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_REL_PARTY_ID)
127: ,DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PERS_PARTY_ID)
128: ,DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_REQUEST_ID)
129: ,DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, p_CASE_FOLDER_ID)
130: ,DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, p_REVIEW_TYPE)
131: ,DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, p_CREDIT_CLASSIFICATION)

Line 128: ,DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_REQUEST_ID)

124: ,DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
125: ,DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
126: ,DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_REL_PARTY_ID)
127: ,DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PERS_PARTY_ID)
128: ,DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_REQUEST_ID)
129: ,DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, p_CASE_FOLDER_ID)
130: ,DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, p_REVIEW_TYPE)
131: ,DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, p_CREDIT_CLASSIFICATION)
132: ,DECODE(p_ACCESS_LEVEL, FND_API.G_MISS_CHAR, NULL, p_ACCESS_LEVEL)

Line 129: ,DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, p_CASE_FOLDER_ID)

125: ,DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
126: ,DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_REL_PARTY_ID)
127: ,DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PERS_PARTY_ID)
128: ,DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_REQUEST_ID)
129: ,DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, p_CASE_FOLDER_ID)
130: ,DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, p_REVIEW_TYPE)
131: ,DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, p_CREDIT_CLASSIFICATION)
132: ,DECODE(p_ACCESS_LEVEL, FND_API.G_MISS_CHAR, NULL, p_ACCESS_LEVEL)
133: ) RETURNING

Line 130: ,DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, p_REVIEW_TYPE)

126: ,DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_REL_PARTY_ID)
127: ,DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PERS_PARTY_ID)
128: ,DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_REQUEST_ID)
129: ,DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, p_CASE_FOLDER_ID)
130: ,DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, p_REVIEW_TYPE)
131: ,DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, p_CREDIT_CLASSIFICATION)
132: ,DECODE(p_ACCESS_LEVEL, FND_API.G_MISS_CHAR, NULL, p_ACCESS_LEVEL)
133: ) RETURNING
134: PARTICIPANT_ID

Line 131: ,DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, p_CREDIT_CLASSIFICATION)

127: ,DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PERS_PARTY_ID)
128: ,DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_REQUEST_ID)
129: ,DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, p_CASE_FOLDER_ID)
130: ,DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, p_REVIEW_TYPE)
131: ,DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, p_CREDIT_CLASSIFICATION)
132: ,DECODE(p_ACCESS_LEVEL, FND_API.G_MISS_CHAR, NULL, p_ACCESS_LEVEL)
133: ) RETURNING
134: PARTICIPANT_ID
135: INTO

Line 132: ,DECODE(p_ACCESS_LEVEL, FND_API.G_MISS_CHAR, NULL, p_ACCESS_LEVEL)

128: ,DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_REQUEST_ID)
129: ,DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, p_CASE_FOLDER_ID)
130: ,DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, p_REVIEW_TYPE)
131: ,DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, p_CREDIT_CLASSIFICATION)
132: ,DECODE(p_ACCESS_LEVEL, FND_API.G_MISS_CHAR, NULL, p_ACCESS_LEVEL)
133: ) RETURNING
134: PARTICIPANT_ID
135: INTO
136: x_participant_id;

Line 183: --PARTICIPANT_ID = DECODE(p_PARTICIPANT_ID, FND_API.G_MISS_NUM, p_PARTICIPANT_ID, NULL, PARTICIPANT_ID)

179: ) IS
180: BEGIN
181:
182: UPDATE LNS_PARTICIPANTS SET
183: --PARTICIPANT_ID = DECODE(p_PARTICIPANT_ID, FND_API.G_MISS_NUM, p_PARTICIPANT_ID, NULL, PARTICIPANT_ID)
184: LOAN_ID = DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, NULL, LOAN_ID, P_LOAN_ID)
185: ,HZ_PARTY_ID = DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, HZ_PARTY_ID, p_HZ_PARTY_ID)
186: ,LOAN_PARTICIPANT_TYPE = DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, LOAN_PARTICIPANT_TYPE, p_LOAN_PARTICIPANT_TYPE)
187: ,START_DATE_ACTIVE = DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, START_DATE_ACTIVE, p_START_DATE_ACTIVE)

Line 184: LOAN_ID = DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, NULL, LOAN_ID, P_LOAN_ID)

180: BEGIN
181:
182: UPDATE LNS_PARTICIPANTS SET
183: --PARTICIPANT_ID = DECODE(p_PARTICIPANT_ID, FND_API.G_MISS_NUM, p_PARTICIPANT_ID, NULL, PARTICIPANT_ID)
184: LOAN_ID = DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, NULL, LOAN_ID, P_LOAN_ID)
185: ,HZ_PARTY_ID = DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, HZ_PARTY_ID, p_HZ_PARTY_ID)
186: ,LOAN_PARTICIPANT_TYPE = DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, LOAN_PARTICIPANT_TYPE, p_LOAN_PARTICIPANT_TYPE)
187: ,START_DATE_ACTIVE = DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, START_DATE_ACTIVE, p_START_DATE_ACTIVE)
188: ,END_DATE_ACTIVE = DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, END_DATE_ACTIVE, p_END_DATE_ACTIVE)

Line 185: ,HZ_PARTY_ID = DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, HZ_PARTY_ID, p_HZ_PARTY_ID)

181:
182: UPDATE LNS_PARTICIPANTS SET
183: --PARTICIPANT_ID = DECODE(p_PARTICIPANT_ID, FND_API.G_MISS_NUM, p_PARTICIPANT_ID, NULL, PARTICIPANT_ID)
184: LOAN_ID = DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, NULL, LOAN_ID, P_LOAN_ID)
185: ,HZ_PARTY_ID = DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, HZ_PARTY_ID, p_HZ_PARTY_ID)
186: ,LOAN_PARTICIPANT_TYPE = DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, LOAN_PARTICIPANT_TYPE, p_LOAN_PARTICIPANT_TYPE)
187: ,START_DATE_ACTIVE = DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, START_DATE_ACTIVE, p_START_DATE_ACTIVE)
188: ,END_DATE_ACTIVE = DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, END_DATE_ACTIVE, p_END_DATE_ACTIVE)
189: ,CUST_ACCOUNT_ID = DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, NULL, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID)

Line 186: ,LOAN_PARTICIPANT_TYPE = DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, LOAN_PARTICIPANT_TYPE, p_LOAN_PARTICIPANT_TYPE)

182: UPDATE LNS_PARTICIPANTS SET
183: --PARTICIPANT_ID = DECODE(p_PARTICIPANT_ID, FND_API.G_MISS_NUM, p_PARTICIPANT_ID, NULL, PARTICIPANT_ID)
184: LOAN_ID = DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, NULL, LOAN_ID, P_LOAN_ID)
185: ,HZ_PARTY_ID = DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, HZ_PARTY_ID, p_HZ_PARTY_ID)
186: ,LOAN_PARTICIPANT_TYPE = DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, LOAN_PARTICIPANT_TYPE, p_LOAN_PARTICIPANT_TYPE)
187: ,START_DATE_ACTIVE = DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, START_DATE_ACTIVE, p_START_DATE_ACTIVE)
188: ,END_DATE_ACTIVE = DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, END_DATE_ACTIVE, p_END_DATE_ACTIVE)
189: ,CUST_ACCOUNT_ID = DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, NULL, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID)
190: ,BILL_TO_ACCT_SITE_ID = DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, NULL, BILL_TO_ACCT_SITE_ID, p_BILL_TO_ACCT_SITE_ID)

Line 187: ,START_DATE_ACTIVE = DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, START_DATE_ACTIVE, p_START_DATE_ACTIVE)

183: --PARTICIPANT_ID = DECODE(p_PARTICIPANT_ID, FND_API.G_MISS_NUM, p_PARTICIPANT_ID, NULL, PARTICIPANT_ID)
184: LOAN_ID = DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, NULL, LOAN_ID, P_LOAN_ID)
185: ,HZ_PARTY_ID = DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, HZ_PARTY_ID, p_HZ_PARTY_ID)
186: ,LOAN_PARTICIPANT_TYPE = DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, LOAN_PARTICIPANT_TYPE, p_LOAN_PARTICIPANT_TYPE)
187: ,START_DATE_ACTIVE = DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, START_DATE_ACTIVE, p_START_DATE_ACTIVE)
188: ,END_DATE_ACTIVE = DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, END_DATE_ACTIVE, p_END_DATE_ACTIVE)
189: ,CUST_ACCOUNT_ID = DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, NULL, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID)
190: ,BILL_TO_ACCT_SITE_ID = DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, NULL, BILL_TO_ACCT_SITE_ID, p_BILL_TO_ACCT_SITE_ID)
191: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

Line 188: ,END_DATE_ACTIVE = DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, END_DATE_ACTIVE, p_END_DATE_ACTIVE)

184: LOAN_ID = DECODE(p_LOAN_ID, FND_API.G_MISS_NUM, NULL, NULL, LOAN_ID, P_LOAN_ID)
185: ,HZ_PARTY_ID = DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, HZ_PARTY_ID, p_HZ_PARTY_ID)
186: ,LOAN_PARTICIPANT_TYPE = DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, LOAN_PARTICIPANT_TYPE, p_LOAN_PARTICIPANT_TYPE)
187: ,START_DATE_ACTIVE = DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, START_DATE_ACTIVE, p_START_DATE_ACTIVE)
188: ,END_DATE_ACTIVE = DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, END_DATE_ACTIVE, p_END_DATE_ACTIVE)
189: ,CUST_ACCOUNT_ID = DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, NULL, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID)
190: ,BILL_TO_ACCT_SITE_ID = DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, NULL, BILL_TO_ACCT_SITE_ID, p_BILL_TO_ACCT_SITE_ID)
191: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
192: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE

Line 189: ,CUST_ACCOUNT_ID = DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, NULL, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID)

185: ,HZ_PARTY_ID = DECODE(p_HZ_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, HZ_PARTY_ID, p_HZ_PARTY_ID)
186: ,LOAN_PARTICIPANT_TYPE = DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, LOAN_PARTICIPANT_TYPE, p_LOAN_PARTICIPANT_TYPE)
187: ,START_DATE_ACTIVE = DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, START_DATE_ACTIVE, p_START_DATE_ACTIVE)
188: ,END_DATE_ACTIVE = DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, END_DATE_ACTIVE, p_END_DATE_ACTIVE)
189: ,CUST_ACCOUNT_ID = DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, NULL, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID)
190: ,BILL_TO_ACCT_SITE_ID = DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, NULL, BILL_TO_ACCT_SITE_ID, p_BILL_TO_ACCT_SITE_ID)
191: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
192: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
193: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 190: ,BILL_TO_ACCT_SITE_ID = DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, NULL, BILL_TO_ACCT_SITE_ID, p_BILL_TO_ACCT_SITE_ID)

186: ,LOAN_PARTICIPANT_TYPE = DECODE(p_LOAN_PARTICIPANT_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, LOAN_PARTICIPANT_TYPE, p_LOAN_PARTICIPANT_TYPE)
187: ,START_DATE_ACTIVE = DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, START_DATE_ACTIVE, p_START_DATE_ACTIVE)
188: ,END_DATE_ACTIVE = DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, END_DATE_ACTIVE, p_END_DATE_ACTIVE)
189: ,CUST_ACCOUNT_ID = DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, NULL, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID)
190: ,BILL_TO_ACCT_SITE_ID = DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, NULL, BILL_TO_ACCT_SITE_ID, p_BILL_TO_ACCT_SITE_ID)
191: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
192: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
193: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
194: ,OBJECT_VERSION_NUMBER = DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

Line 194: ,OBJECT_VERSION_NUMBER = DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

190: ,BILL_TO_ACCT_SITE_ID = DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, NULL, BILL_TO_ACCT_SITE_ID, p_BILL_TO_ACCT_SITE_ID)
191: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
192: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
193: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
194: ,OBJECT_VERSION_NUMBER = DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
195: ,ATTRIBUTE_CATEGORY = DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
196: ,ATTRIBUTE1 = DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
197: ,ATTRIBUTE2 = DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
198: ,ATTRIBUTE3 = DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)

Line 195: ,ATTRIBUTE_CATEGORY = DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)

191: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
192: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
193: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
194: ,OBJECT_VERSION_NUMBER = DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
195: ,ATTRIBUTE_CATEGORY = DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
196: ,ATTRIBUTE1 = DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
197: ,ATTRIBUTE2 = DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
198: ,ATTRIBUTE3 = DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
199: ,ATTRIBUTE4 = DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)

Line 196: ,ATTRIBUTE1 = DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)

192: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
193: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
194: ,OBJECT_VERSION_NUMBER = DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
195: ,ATTRIBUTE_CATEGORY = DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
196: ,ATTRIBUTE1 = DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
197: ,ATTRIBUTE2 = DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
198: ,ATTRIBUTE3 = DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
199: ,ATTRIBUTE4 = DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
200: ,ATTRIBUTE5 = DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)

Line 197: ,ATTRIBUTE2 = DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)

193: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
194: ,OBJECT_VERSION_NUMBER = DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
195: ,ATTRIBUTE_CATEGORY = DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
196: ,ATTRIBUTE1 = DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
197: ,ATTRIBUTE2 = DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
198: ,ATTRIBUTE3 = DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
199: ,ATTRIBUTE4 = DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
200: ,ATTRIBUTE5 = DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
201: ,ATTRIBUTE6 = DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)

Line 198: ,ATTRIBUTE3 = DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)

194: ,OBJECT_VERSION_NUMBER = DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
195: ,ATTRIBUTE_CATEGORY = DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
196: ,ATTRIBUTE1 = DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
197: ,ATTRIBUTE2 = DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
198: ,ATTRIBUTE3 = DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
199: ,ATTRIBUTE4 = DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
200: ,ATTRIBUTE5 = DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
201: ,ATTRIBUTE6 = DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
202: ,ATTRIBUTE7 = DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)

Line 199: ,ATTRIBUTE4 = DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)

195: ,ATTRIBUTE_CATEGORY = DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
196: ,ATTRIBUTE1 = DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
197: ,ATTRIBUTE2 = DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
198: ,ATTRIBUTE3 = DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
199: ,ATTRIBUTE4 = DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
200: ,ATTRIBUTE5 = DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
201: ,ATTRIBUTE6 = DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
202: ,ATTRIBUTE7 = DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
203: ,ATTRIBUTE8 = DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)

Line 200: ,ATTRIBUTE5 = DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)

196: ,ATTRIBUTE1 = DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
197: ,ATTRIBUTE2 = DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
198: ,ATTRIBUTE3 = DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
199: ,ATTRIBUTE4 = DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
200: ,ATTRIBUTE5 = DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
201: ,ATTRIBUTE6 = DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
202: ,ATTRIBUTE7 = DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
203: ,ATTRIBUTE8 = DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
204: ,ATTRIBUTE9 = DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)

Line 201: ,ATTRIBUTE6 = DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)

197: ,ATTRIBUTE2 = DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
198: ,ATTRIBUTE3 = DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
199: ,ATTRIBUTE4 = DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
200: ,ATTRIBUTE5 = DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
201: ,ATTRIBUTE6 = DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
202: ,ATTRIBUTE7 = DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
203: ,ATTRIBUTE8 = DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
204: ,ATTRIBUTE9 = DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
205: ,ATTRIBUTE10 = DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)

Line 202: ,ATTRIBUTE7 = DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)

198: ,ATTRIBUTE3 = DECODE(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
199: ,ATTRIBUTE4 = DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
200: ,ATTRIBUTE5 = DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
201: ,ATTRIBUTE6 = DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
202: ,ATTRIBUTE7 = DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
203: ,ATTRIBUTE8 = DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
204: ,ATTRIBUTE9 = DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
205: ,ATTRIBUTE10 = DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
206: ,ATTRIBUTE11 = DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)

Line 203: ,ATTRIBUTE8 = DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)

199: ,ATTRIBUTE4 = DECODE(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
200: ,ATTRIBUTE5 = DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
201: ,ATTRIBUTE6 = DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
202: ,ATTRIBUTE7 = DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
203: ,ATTRIBUTE8 = DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
204: ,ATTRIBUTE9 = DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
205: ,ATTRIBUTE10 = DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
206: ,ATTRIBUTE11 = DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
207: ,ATTRIBUTE12 = DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)

Line 204: ,ATTRIBUTE9 = DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)

200: ,ATTRIBUTE5 = DECODE(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
201: ,ATTRIBUTE6 = DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
202: ,ATTRIBUTE7 = DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
203: ,ATTRIBUTE8 = DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
204: ,ATTRIBUTE9 = DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
205: ,ATTRIBUTE10 = DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
206: ,ATTRIBUTE11 = DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
207: ,ATTRIBUTE12 = DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
208: ,ATTRIBUTE13 = DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)

Line 205: ,ATTRIBUTE10 = DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)

201: ,ATTRIBUTE6 = DECODE(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
202: ,ATTRIBUTE7 = DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
203: ,ATTRIBUTE8 = DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
204: ,ATTRIBUTE9 = DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
205: ,ATTRIBUTE10 = DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
206: ,ATTRIBUTE11 = DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
207: ,ATTRIBUTE12 = DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
208: ,ATTRIBUTE13 = DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
209: ,ATTRIBUTE14 = DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)

Line 206: ,ATTRIBUTE11 = DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)

202: ,ATTRIBUTE7 = DECODE(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
203: ,ATTRIBUTE8 = DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
204: ,ATTRIBUTE9 = DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
205: ,ATTRIBUTE10 = DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
206: ,ATTRIBUTE11 = DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
207: ,ATTRIBUTE12 = DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
208: ,ATTRIBUTE13 = DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
209: ,ATTRIBUTE14 = DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
210: ,ATTRIBUTE15 = DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)

Line 207: ,ATTRIBUTE12 = DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)

203: ,ATTRIBUTE8 = DECODE(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
204: ,ATTRIBUTE9 = DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
205: ,ATTRIBUTE10 = DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
206: ,ATTRIBUTE11 = DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
207: ,ATTRIBUTE12 = DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
208: ,ATTRIBUTE13 = DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
209: ,ATTRIBUTE14 = DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
210: ,ATTRIBUTE15 = DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
211: ,ATTRIBUTE16 = DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE16, p_ATTRIBUTE16)

Line 208: ,ATTRIBUTE13 = DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)

204: ,ATTRIBUTE9 = DECODE(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
205: ,ATTRIBUTE10 = DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
206: ,ATTRIBUTE11 = DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
207: ,ATTRIBUTE12 = DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
208: ,ATTRIBUTE13 = DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
209: ,ATTRIBUTE14 = DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
210: ,ATTRIBUTE15 = DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
211: ,ATTRIBUTE16 = DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE16, p_ATTRIBUTE16)
212: ,ATTRIBUTE17 = DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE17, p_ATTRIBUTE17)

Line 209: ,ATTRIBUTE14 = DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)

205: ,ATTRIBUTE10 = DECODE(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
206: ,ATTRIBUTE11 = DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
207: ,ATTRIBUTE12 = DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
208: ,ATTRIBUTE13 = DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
209: ,ATTRIBUTE14 = DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
210: ,ATTRIBUTE15 = DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
211: ,ATTRIBUTE16 = DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE16, p_ATTRIBUTE16)
212: ,ATTRIBUTE17 = DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE17, p_ATTRIBUTE17)
213: ,ATTRIBUTE18 = DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE18, p_ATTRIBUTE18)

Line 210: ,ATTRIBUTE15 = DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)

206: ,ATTRIBUTE11 = DECODE(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
207: ,ATTRIBUTE12 = DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
208: ,ATTRIBUTE13 = DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
209: ,ATTRIBUTE14 = DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
210: ,ATTRIBUTE15 = DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
211: ,ATTRIBUTE16 = DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE16, p_ATTRIBUTE16)
212: ,ATTRIBUTE17 = DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE17, p_ATTRIBUTE17)
213: ,ATTRIBUTE18 = DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE18, p_ATTRIBUTE18)
214: ,ATTRIBUTE19 = DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE19, p_ATTRIBUTE19)

Line 211: ,ATTRIBUTE16 = DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE16, p_ATTRIBUTE16)

207: ,ATTRIBUTE12 = DECODE(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
208: ,ATTRIBUTE13 = DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
209: ,ATTRIBUTE14 = DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
210: ,ATTRIBUTE15 = DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
211: ,ATTRIBUTE16 = DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE16, p_ATTRIBUTE16)
212: ,ATTRIBUTE17 = DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE17, p_ATTRIBUTE17)
213: ,ATTRIBUTE18 = DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE18, p_ATTRIBUTE18)
214: ,ATTRIBUTE19 = DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE19, p_ATTRIBUTE19)
215: ,ATTRIBUTE20 = DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE20, p_ATTRIBUTE20)

Line 212: ,ATTRIBUTE17 = DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE17, p_ATTRIBUTE17)

208: ,ATTRIBUTE13 = DECODE(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
209: ,ATTRIBUTE14 = DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
210: ,ATTRIBUTE15 = DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
211: ,ATTRIBUTE16 = DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE16, p_ATTRIBUTE16)
212: ,ATTRIBUTE17 = DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE17, p_ATTRIBUTE17)
213: ,ATTRIBUTE18 = DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE18, p_ATTRIBUTE18)
214: ,ATTRIBUTE19 = DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE19, p_ATTRIBUTE19)
215: ,ATTRIBUTE20 = DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE20, p_ATTRIBUTE20)
216: ,CONTACT_REL_PARTY_ID = DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_REL_PARTY_ID, p_CONTACT_REL_PARTY_ID)

Line 213: ,ATTRIBUTE18 = DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE18, p_ATTRIBUTE18)

209: ,ATTRIBUTE14 = DECODE(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
210: ,ATTRIBUTE15 = DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
211: ,ATTRIBUTE16 = DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE16, p_ATTRIBUTE16)
212: ,ATTRIBUTE17 = DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE17, p_ATTRIBUTE17)
213: ,ATTRIBUTE18 = DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE18, p_ATTRIBUTE18)
214: ,ATTRIBUTE19 = DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE19, p_ATTRIBUTE19)
215: ,ATTRIBUTE20 = DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE20, p_ATTRIBUTE20)
216: ,CONTACT_REL_PARTY_ID = DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_REL_PARTY_ID, p_CONTACT_REL_PARTY_ID)
217: ,CONTACT_PERS_PARTY_ID = DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_PERS_PARTY_ID, p_CONTACT_PERS_PARTY_ID)

Line 214: ,ATTRIBUTE19 = DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE19, p_ATTRIBUTE19)

210: ,ATTRIBUTE15 = DECODE(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
211: ,ATTRIBUTE16 = DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE16, p_ATTRIBUTE16)
212: ,ATTRIBUTE17 = DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE17, p_ATTRIBUTE17)
213: ,ATTRIBUTE18 = DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE18, p_ATTRIBUTE18)
214: ,ATTRIBUTE19 = DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE19, p_ATTRIBUTE19)
215: ,ATTRIBUTE20 = DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE20, p_ATTRIBUTE20)
216: ,CONTACT_REL_PARTY_ID = DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_REL_PARTY_ID, p_CONTACT_REL_PARTY_ID)
217: ,CONTACT_PERS_PARTY_ID = DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_PERS_PARTY_ID, p_CONTACT_PERS_PARTY_ID)
218: ,CREDIT_REQUEST_ID = DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, NULL, CREDIT_REQUEST_ID, p_CREDIT_REQUEST_ID)

Line 215: ,ATTRIBUTE20 = DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE20, p_ATTRIBUTE20)

211: ,ATTRIBUTE16 = DECODE(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE16, p_ATTRIBUTE16)
212: ,ATTRIBUTE17 = DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE17, p_ATTRIBUTE17)
213: ,ATTRIBUTE18 = DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE18, p_ATTRIBUTE18)
214: ,ATTRIBUTE19 = DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE19, p_ATTRIBUTE19)
215: ,ATTRIBUTE20 = DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE20, p_ATTRIBUTE20)
216: ,CONTACT_REL_PARTY_ID = DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_REL_PARTY_ID, p_CONTACT_REL_PARTY_ID)
217: ,CONTACT_PERS_PARTY_ID = DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_PERS_PARTY_ID, p_CONTACT_PERS_PARTY_ID)
218: ,CREDIT_REQUEST_ID = DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, NULL, CREDIT_REQUEST_ID, p_CREDIT_REQUEST_ID)
219: ,CASE_FOLDER_ID = DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, NULL, CASE_FOLDER_ID, p_CASE_FOLDER_ID)

Line 216: ,CONTACT_REL_PARTY_ID = DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_REL_PARTY_ID, p_CONTACT_REL_PARTY_ID)

212: ,ATTRIBUTE17 = DECODE(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE17, p_ATTRIBUTE17)
213: ,ATTRIBUTE18 = DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE18, p_ATTRIBUTE18)
214: ,ATTRIBUTE19 = DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE19, p_ATTRIBUTE19)
215: ,ATTRIBUTE20 = DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE20, p_ATTRIBUTE20)
216: ,CONTACT_REL_PARTY_ID = DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_REL_PARTY_ID, p_CONTACT_REL_PARTY_ID)
217: ,CONTACT_PERS_PARTY_ID = DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_PERS_PARTY_ID, p_CONTACT_PERS_PARTY_ID)
218: ,CREDIT_REQUEST_ID = DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, NULL, CREDIT_REQUEST_ID, p_CREDIT_REQUEST_ID)
219: ,CASE_FOLDER_ID = DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, NULL, CASE_FOLDER_ID, p_CASE_FOLDER_ID)
220: ,REVIEW_TYPE = DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, REVIEW_TYPE, p_REVIEW_TYPE)

Line 217: ,CONTACT_PERS_PARTY_ID = DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_PERS_PARTY_ID, p_CONTACT_PERS_PARTY_ID)

213: ,ATTRIBUTE18 = DECODE(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE18, p_ATTRIBUTE18)
214: ,ATTRIBUTE19 = DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE19, p_ATTRIBUTE19)
215: ,ATTRIBUTE20 = DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE20, p_ATTRIBUTE20)
216: ,CONTACT_REL_PARTY_ID = DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_REL_PARTY_ID, p_CONTACT_REL_PARTY_ID)
217: ,CONTACT_PERS_PARTY_ID = DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_PERS_PARTY_ID, p_CONTACT_PERS_PARTY_ID)
218: ,CREDIT_REQUEST_ID = DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, NULL, CREDIT_REQUEST_ID, p_CREDIT_REQUEST_ID)
219: ,CASE_FOLDER_ID = DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, NULL, CASE_FOLDER_ID, p_CASE_FOLDER_ID)
220: ,REVIEW_TYPE = DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, REVIEW_TYPE, p_REVIEW_TYPE)
221: ,CREDIT_CLASSIFICATION = DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, NULL, CREDIT_CLASSIFICATION, p_CREDIT_CLASSIFICATION)

Line 218: ,CREDIT_REQUEST_ID = DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, NULL, CREDIT_REQUEST_ID, p_CREDIT_REQUEST_ID)

214: ,ATTRIBUTE19 = DECODE(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE19, p_ATTRIBUTE19)
215: ,ATTRIBUTE20 = DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE20, p_ATTRIBUTE20)
216: ,CONTACT_REL_PARTY_ID = DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_REL_PARTY_ID, p_CONTACT_REL_PARTY_ID)
217: ,CONTACT_PERS_PARTY_ID = DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_PERS_PARTY_ID, p_CONTACT_PERS_PARTY_ID)
218: ,CREDIT_REQUEST_ID = DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, NULL, CREDIT_REQUEST_ID, p_CREDIT_REQUEST_ID)
219: ,CASE_FOLDER_ID = DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, NULL, CASE_FOLDER_ID, p_CASE_FOLDER_ID)
220: ,REVIEW_TYPE = DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, REVIEW_TYPE, p_REVIEW_TYPE)
221: ,CREDIT_CLASSIFICATION = DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, NULL, CREDIT_CLASSIFICATION, p_CREDIT_CLASSIFICATION)
222: ,ACCESS_LEVEL = DECODE(p_ACCESS_LEVEL,FND_API.G_MISS_CHAR, NULL, NULL, ACCESS_LEVEL, p_ACCESS_LEVEL)

Line 219: ,CASE_FOLDER_ID = DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, NULL, CASE_FOLDER_ID, p_CASE_FOLDER_ID)

215: ,ATTRIBUTE20 = DECODE(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE20, p_ATTRIBUTE20)
216: ,CONTACT_REL_PARTY_ID = DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_REL_PARTY_ID, p_CONTACT_REL_PARTY_ID)
217: ,CONTACT_PERS_PARTY_ID = DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_PERS_PARTY_ID, p_CONTACT_PERS_PARTY_ID)
218: ,CREDIT_REQUEST_ID = DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, NULL, CREDIT_REQUEST_ID, p_CREDIT_REQUEST_ID)
219: ,CASE_FOLDER_ID = DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, NULL, CASE_FOLDER_ID, p_CASE_FOLDER_ID)
220: ,REVIEW_TYPE = DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, REVIEW_TYPE, p_REVIEW_TYPE)
221: ,CREDIT_CLASSIFICATION = DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, NULL, CREDIT_CLASSIFICATION, p_CREDIT_CLASSIFICATION)
222: ,ACCESS_LEVEL = DECODE(p_ACCESS_LEVEL,FND_API.G_MISS_CHAR, NULL, NULL, ACCESS_LEVEL, p_ACCESS_LEVEL)
223: WHERE PARTICIPANT_ID= p_PARTICIPANT_ID;

Line 220: ,REVIEW_TYPE = DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, REVIEW_TYPE, p_REVIEW_TYPE)

216: ,CONTACT_REL_PARTY_ID = DECODE(p_CONTACT_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_REL_PARTY_ID, p_CONTACT_REL_PARTY_ID)
217: ,CONTACT_PERS_PARTY_ID = DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_PERS_PARTY_ID, p_CONTACT_PERS_PARTY_ID)
218: ,CREDIT_REQUEST_ID = DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, NULL, CREDIT_REQUEST_ID, p_CREDIT_REQUEST_ID)
219: ,CASE_FOLDER_ID = DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, NULL, CASE_FOLDER_ID, p_CASE_FOLDER_ID)
220: ,REVIEW_TYPE = DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, REVIEW_TYPE, p_REVIEW_TYPE)
221: ,CREDIT_CLASSIFICATION = DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, NULL, CREDIT_CLASSIFICATION, p_CREDIT_CLASSIFICATION)
222: ,ACCESS_LEVEL = DECODE(p_ACCESS_LEVEL,FND_API.G_MISS_CHAR, NULL, NULL, ACCESS_LEVEL, p_ACCESS_LEVEL)
223: WHERE PARTICIPANT_ID= p_PARTICIPANT_ID;
224:

Line 221: ,CREDIT_CLASSIFICATION = DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, NULL, CREDIT_CLASSIFICATION, p_CREDIT_CLASSIFICATION)

217: ,CONTACT_PERS_PARTY_ID = DECODE(p_CONTACT_PERS_PARTY_ID, FND_API.G_MISS_NUM, NULL, NULL, CONTACT_PERS_PARTY_ID, p_CONTACT_PERS_PARTY_ID)
218: ,CREDIT_REQUEST_ID = DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, NULL, CREDIT_REQUEST_ID, p_CREDIT_REQUEST_ID)
219: ,CASE_FOLDER_ID = DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, NULL, CASE_FOLDER_ID, p_CASE_FOLDER_ID)
220: ,REVIEW_TYPE = DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, REVIEW_TYPE, p_REVIEW_TYPE)
221: ,CREDIT_CLASSIFICATION = DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, NULL, CREDIT_CLASSIFICATION, p_CREDIT_CLASSIFICATION)
222: ,ACCESS_LEVEL = DECODE(p_ACCESS_LEVEL,FND_API.G_MISS_CHAR, NULL, NULL, ACCESS_LEVEL, p_ACCESS_LEVEL)
223: WHERE PARTICIPANT_ID= p_PARTICIPANT_ID;
224:
225: if (sql%notfound) then

Line 222: ,ACCESS_LEVEL = DECODE(p_ACCESS_LEVEL,FND_API.G_MISS_CHAR, NULL, NULL, ACCESS_LEVEL, p_ACCESS_LEVEL)

218: ,CREDIT_REQUEST_ID = DECODE(p_CREDIT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, NULL, CREDIT_REQUEST_ID, p_CREDIT_REQUEST_ID)
219: ,CASE_FOLDER_ID = DECODE(p_CASE_FOLDER_ID, FND_API.G_MISS_NUM, NULL, NULL, CASE_FOLDER_ID, p_CASE_FOLDER_ID)
220: ,REVIEW_TYPE = DECODE(p_REVIEW_TYPE, FND_API.G_MISS_CHAR, NULL, NULL, REVIEW_TYPE, p_REVIEW_TYPE)
221: ,CREDIT_CLASSIFICATION = DECODE(p_CREDIT_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, NULL, CREDIT_CLASSIFICATION, p_CREDIT_CLASSIFICATION)
222: ,ACCESS_LEVEL = DECODE(p_ACCESS_LEVEL,FND_API.G_MISS_CHAR, NULL, NULL, ACCESS_LEVEL, p_ACCESS_LEVEL)
223: WHERE PARTICIPANT_ID= p_PARTICIPANT_ID;
224:
225: if (sql%notfound) then
226: raise no_data_found;