APPS.HZ_ORG_CONTACTS_PKG dependencies on FND_API

Line 109: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACTS_S.NEXTVAL, NULL, HZ_ORG_CONTACTS_S.NEXTVAL, X_ORG_CONTACT_ID ),

105: APPLICATION_ID,
106: STATUS
107: )
108: VALUES (
109: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACTS_S.NEXTVAL, NULL, HZ_ORG_CONTACTS_S.NEXTVAL, X_ORG_CONTACT_ID ),
110: DECODE( X_PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
111: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
112: DECODE( X_CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
113: DECODE( X_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),

Line 110: DECODE( X_PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),

106: STATUS
107: )
108: VALUES (
109: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACTS_S.NEXTVAL, NULL, HZ_ORG_CONTACTS_S.NEXTVAL, X_ORG_CONTACT_ID ),
110: DECODE( X_PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
111: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
112: DECODE( X_CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
113: DECODE( X_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
114: DECODE( X_DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),

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

107: )
108: VALUES (
109: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACTS_S.NEXTVAL, NULL, HZ_ORG_CONTACTS_S.NEXTVAL, X_ORG_CONTACT_ID ),
110: DECODE( X_PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
111: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
112: DECODE( X_CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
113: DECODE( X_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
114: DECODE( X_DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
115: DECODE( X_JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),

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

108: VALUES (
109: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACTS_S.NEXTVAL, NULL, HZ_ORG_CONTACTS_S.NEXTVAL, X_ORG_CONTACT_ID ),
110: DECODE( X_PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
111: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
112: DECODE( X_CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
113: DECODE( X_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
114: DECODE( X_DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
115: DECODE( X_JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
116: DECODE( X_DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_DECISION_MAKER_FLAG ),

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

109: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACTS_S.NEXTVAL, NULL, HZ_ORG_CONTACTS_S.NEXTVAL, X_ORG_CONTACT_ID ),
110: DECODE( X_PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
111: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
112: DECODE( X_CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
113: DECODE( X_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
114: DECODE( X_DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
115: DECODE( X_JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
116: DECODE( X_DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_DECISION_MAKER_FLAG ),
117: DECODE( X_JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),

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

110: DECODE( X_PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
111: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
112: DECODE( X_CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
113: DECODE( X_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
114: DECODE( X_DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
115: DECODE( X_JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
116: DECODE( X_DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_DECISION_MAKER_FLAG ),
117: DECODE( X_JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
118: DECODE( X_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_REFERENCE_USE_FLAG ),

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

111: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
112: DECODE( X_CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
113: DECODE( X_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
114: DECODE( X_DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
115: DECODE( X_JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
116: DECODE( X_DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_DECISION_MAKER_FLAG ),
117: DECODE( X_JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
118: DECODE( X_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_REFERENCE_USE_FLAG ),
119: DECODE( X_RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),

Line 116: DECODE( X_DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_DECISION_MAKER_FLAG ),

112: DECODE( X_CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
113: DECODE( X_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
114: DECODE( X_DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
115: DECODE( X_JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
116: DECODE( X_DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_DECISION_MAKER_FLAG ),
117: DECODE( X_JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
118: DECODE( X_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_REFERENCE_USE_FLAG ),
119: DECODE( X_RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
120: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

113: DECODE( X_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
114: DECODE( X_DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
115: DECODE( X_JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
116: DECODE( X_DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_DECISION_MAKER_FLAG ),
117: DECODE( X_JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
118: DECODE( X_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_REFERENCE_USE_FLAG ),
119: DECODE( X_RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
120: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 118: DECODE( X_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_REFERENCE_USE_FLAG ),

114: DECODE( X_DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
115: DECODE( X_JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
116: DECODE( X_DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_DECISION_MAKER_FLAG ),
117: DECODE( X_JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
118: DECODE( X_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_REFERENCE_USE_FLAG ),
119: DECODE( X_RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
120: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
122: HZ_UTILITY_V2PUB.CREATION_DATE,

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

115: DECODE( X_JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
116: DECODE( X_DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_DECISION_MAKER_FLAG ),
117: DECODE( X_JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
118: DECODE( X_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_REFERENCE_USE_FLAG ),
119: DECODE( X_RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
120: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
122: HZ_UTILITY_V2PUB.CREATION_DATE,
123: HZ_UTILITY_V2PUB.CREATED_BY,

Line 129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

125: HZ_UTILITY_V2PUB.REQUEST_ID,
126: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
127: HZ_UTILITY_V2PUB.PROGRAM_ID,
128: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
130: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
131: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
132: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
133: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

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

126: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
127: HZ_UTILITY_V2PUB.PROGRAM_ID,
128: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
130: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
131: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
132: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
133: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
134: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

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

127: HZ_UTILITY_V2PUB.PROGRAM_ID,
128: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
130: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
131: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
132: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
133: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
134: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
135: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

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

128: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
130: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
131: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
132: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
133: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
134: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
135: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
136: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

Line 133: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
130: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
131: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
132: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
133: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
134: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
135: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
136: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
137: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

Line 134: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

130: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
131: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
132: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
133: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
134: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
135: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
136: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
137: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
138: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

Line 135: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

131: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
132: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
133: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
134: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
135: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
136: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
137: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
138: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
139: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

Line 136: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

132: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
133: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
134: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
135: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
136: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
137: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
138: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
139: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
140: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

Line 137: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

133: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
134: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
135: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
136: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
137: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
138: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
139: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
140: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
141: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

Line 138: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

134: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
135: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
136: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
137: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
138: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
139: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
140: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
141: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
142: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

Line 139: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

135: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
136: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
137: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
138: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
139: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
140: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
141: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
142: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
143: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

Line 140: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

136: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
137: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
138: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
139: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
140: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
141: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
142: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
143: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
144: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

Line 141: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

137: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
138: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
139: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
140: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
141: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
142: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
143: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
144: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
145: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

Line 142: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

138: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
139: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
140: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
141: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
142: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
143: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
144: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
145: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
146: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),

Line 143: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

139: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
140: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
141: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
142: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
143: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
144: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
145: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
146: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
147: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),

Line 144: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

140: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
141: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
142: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
143: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
144: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
145: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
146: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
147: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
148: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),

Line 145: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

141: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
142: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
143: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
144: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
145: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
146: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
147: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
148: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
149: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

Line 146: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),

142: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
143: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
144: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
145: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
146: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
147: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
148: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
149: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
150: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),

Line 147: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),

143: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
144: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
145: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
146: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
147: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
148: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
149: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
150: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
151: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),

Line 148: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),

144: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
145: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
146: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
147: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
148: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
149: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
150: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
151: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
152: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),

Line 149: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

145: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
146: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
147: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
148: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
149: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
150: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
151: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
152: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
153: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),

Line 150: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),

146: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
147: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
148: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
149: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
150: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
151: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
152: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
153: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
154: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),

Line 151: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),

147: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
148: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
149: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
150: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
151: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
152: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
153: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
154: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
155: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),

Line 152: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),

148: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
149: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
150: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
151: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
152: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
153: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
154: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
155: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
156: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 153: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),

149: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
150: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
151: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
152: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
153: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
154: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
155: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
156: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
157: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 154: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),

150: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
151: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
152: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
153: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
154: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
155: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
156: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
157: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
158: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

Line 155: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),

151: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
152: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
153: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
154: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
155: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
156: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
157: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
158: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
159: DECODE( X_STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS )

Line 156: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

152: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
153: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
154: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
155: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
156: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
157: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
158: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
159: DECODE( X_STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS )
160: ) RETURNING

Line 157: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

153: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
154: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
155: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
156: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
157: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
158: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
159: DECODE( X_STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS )
160: ) RETURNING
161: ORG_CONTACT_ID

Line 158: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

154: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
155: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
156: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
157: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
158: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
159: DECODE( X_STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS )
160: ) RETURNING
161: ORG_CONTACT_ID
162: INTO

Line 159: DECODE( X_STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS )

155: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
156: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
157: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
158: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
159: DECODE( X_STATUS, FND_API.G_MISS_CHAR, NULL, X_STATUS )
160: ) RETURNING
161: ORG_CONTACT_ID
162: INTO
163: X_ORG_CONTACT_ID;

Line 250: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),

246:
247: BEGIN
248:
249: UPDATE HZ_ORG_CONTACTS SET
250: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
251: PARTY_RELATIONSHIP_ID = DECODE( X_PARTY_RELATIONSHIP_ID, NULL, PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
252: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
253: CONTACT_NUMBER = DECODE( X_CONTACT_NUMBER, NULL, CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
254: DEPARTMENT_CODE = DECODE( X_DEPARTMENT_CODE, NULL, DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),

Line 251: PARTY_RELATIONSHIP_ID = DECODE( X_PARTY_RELATIONSHIP_ID, NULL, PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),

247: BEGIN
248:
249: UPDATE HZ_ORG_CONTACTS SET
250: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
251: PARTY_RELATIONSHIP_ID = DECODE( X_PARTY_RELATIONSHIP_ID, NULL, PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
252: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
253: CONTACT_NUMBER = DECODE( X_CONTACT_NUMBER, NULL, CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
254: DEPARTMENT_CODE = DECODE( X_DEPARTMENT_CODE, NULL, DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
255: DEPARTMENT = DECODE( X_DEPARTMENT, NULL, DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),

Line 252: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),

248:
249: UPDATE HZ_ORG_CONTACTS SET
250: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
251: PARTY_RELATIONSHIP_ID = DECODE( X_PARTY_RELATIONSHIP_ID, NULL, PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
252: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
253: CONTACT_NUMBER = DECODE( X_CONTACT_NUMBER, NULL, CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
254: DEPARTMENT_CODE = DECODE( X_DEPARTMENT_CODE, NULL, DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
255: DEPARTMENT = DECODE( X_DEPARTMENT, NULL, DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
256: JOB_TITLE = DECODE( X_JOB_TITLE, NULL, JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),

Line 253: CONTACT_NUMBER = DECODE( X_CONTACT_NUMBER, NULL, CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),

249: UPDATE HZ_ORG_CONTACTS SET
250: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
251: PARTY_RELATIONSHIP_ID = DECODE( X_PARTY_RELATIONSHIP_ID, NULL, PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
252: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
253: CONTACT_NUMBER = DECODE( X_CONTACT_NUMBER, NULL, CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
254: DEPARTMENT_CODE = DECODE( X_DEPARTMENT_CODE, NULL, DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
255: DEPARTMENT = DECODE( X_DEPARTMENT, NULL, DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
256: JOB_TITLE = DECODE( X_JOB_TITLE, NULL, JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
257: DECISION_MAKER_FLAG = DECODE( X_DECISION_MAKER_FLAG, NULL, DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', X_DECISION_MAKER_FLAG ),

Line 254: DEPARTMENT_CODE = DECODE( X_DEPARTMENT_CODE, NULL, DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),

250: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
251: PARTY_RELATIONSHIP_ID = DECODE( X_PARTY_RELATIONSHIP_ID, NULL, PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
252: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
253: CONTACT_NUMBER = DECODE( X_CONTACT_NUMBER, NULL, CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
254: DEPARTMENT_CODE = DECODE( X_DEPARTMENT_CODE, NULL, DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
255: DEPARTMENT = DECODE( X_DEPARTMENT, NULL, DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
256: JOB_TITLE = DECODE( X_JOB_TITLE, NULL, JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
257: DECISION_MAKER_FLAG = DECODE( X_DECISION_MAKER_FLAG, NULL, DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', X_DECISION_MAKER_FLAG ),
258: JOB_TITLE_CODE = DECODE( X_JOB_TITLE_CODE, NULL, JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),

Line 255: DEPARTMENT = DECODE( X_DEPARTMENT, NULL, DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),

251: PARTY_RELATIONSHIP_ID = DECODE( X_PARTY_RELATIONSHIP_ID, NULL, PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_RELATIONSHIP_ID ),
252: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
253: CONTACT_NUMBER = DECODE( X_CONTACT_NUMBER, NULL, CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
254: DEPARTMENT_CODE = DECODE( X_DEPARTMENT_CODE, NULL, DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
255: DEPARTMENT = DECODE( X_DEPARTMENT, NULL, DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
256: JOB_TITLE = DECODE( X_JOB_TITLE, NULL, JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
257: DECISION_MAKER_FLAG = DECODE( X_DECISION_MAKER_FLAG, NULL, DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', X_DECISION_MAKER_FLAG ),
258: JOB_TITLE_CODE = DECODE( X_JOB_TITLE_CODE, NULL, JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
259: REFERENCE_USE_FLAG = DECODE( X_REFERENCE_USE_FLAG, NULL, REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_USE_FLAG ),

Line 256: JOB_TITLE = DECODE( X_JOB_TITLE, NULL, JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),

252: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
253: CONTACT_NUMBER = DECODE( X_CONTACT_NUMBER, NULL, CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
254: DEPARTMENT_CODE = DECODE( X_DEPARTMENT_CODE, NULL, DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
255: DEPARTMENT = DECODE( X_DEPARTMENT, NULL, DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
256: JOB_TITLE = DECODE( X_JOB_TITLE, NULL, JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
257: DECISION_MAKER_FLAG = DECODE( X_DECISION_MAKER_FLAG, NULL, DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', X_DECISION_MAKER_FLAG ),
258: JOB_TITLE_CODE = DECODE( X_JOB_TITLE_CODE, NULL, JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
259: REFERENCE_USE_FLAG = DECODE( X_REFERENCE_USE_FLAG, NULL, REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_USE_FLAG ),
260: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),

Line 257: DECISION_MAKER_FLAG = DECODE( X_DECISION_MAKER_FLAG, NULL, DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', X_DECISION_MAKER_FLAG ),

253: CONTACT_NUMBER = DECODE( X_CONTACT_NUMBER, NULL, CONTACT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_CONTACT_NUMBER ),
254: DEPARTMENT_CODE = DECODE( X_DEPARTMENT_CODE, NULL, DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
255: DEPARTMENT = DECODE( X_DEPARTMENT, NULL, DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
256: JOB_TITLE = DECODE( X_JOB_TITLE, NULL, JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
257: DECISION_MAKER_FLAG = DECODE( X_DECISION_MAKER_FLAG, NULL, DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', X_DECISION_MAKER_FLAG ),
258: JOB_TITLE_CODE = DECODE( X_JOB_TITLE_CODE, NULL, JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
259: REFERENCE_USE_FLAG = DECODE( X_REFERENCE_USE_FLAG, NULL, REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_USE_FLAG ),
260: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
261: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 258: JOB_TITLE_CODE = DECODE( X_JOB_TITLE_CODE, NULL, JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),

254: DEPARTMENT_CODE = DECODE( X_DEPARTMENT_CODE, NULL, DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT_CODE ),
255: DEPARTMENT = DECODE( X_DEPARTMENT, NULL, DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
256: JOB_TITLE = DECODE( X_JOB_TITLE, NULL, JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
257: DECISION_MAKER_FLAG = DECODE( X_DECISION_MAKER_FLAG, NULL, DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', X_DECISION_MAKER_FLAG ),
258: JOB_TITLE_CODE = DECODE( X_JOB_TITLE_CODE, NULL, JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
259: REFERENCE_USE_FLAG = DECODE( X_REFERENCE_USE_FLAG, NULL, REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_USE_FLAG ),
260: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
261: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
262: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 259: REFERENCE_USE_FLAG = DECODE( X_REFERENCE_USE_FLAG, NULL, REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_USE_FLAG ),

255: DEPARTMENT = DECODE( X_DEPARTMENT, NULL, DEPARTMENT, FND_API.G_MISS_CHAR, NULL, X_DEPARTMENT ),
256: JOB_TITLE = DECODE( X_JOB_TITLE, NULL, JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
257: DECISION_MAKER_FLAG = DECODE( X_DECISION_MAKER_FLAG, NULL, DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', X_DECISION_MAKER_FLAG ),
258: JOB_TITLE_CODE = DECODE( X_JOB_TITLE_CODE, NULL, JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
259: REFERENCE_USE_FLAG = DECODE( X_REFERENCE_USE_FLAG, NULL, REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_USE_FLAG ),
260: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
261: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
262: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
263: CREATION_DATE = CREATION_DATE,

Line 260: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),

256: JOB_TITLE = DECODE( X_JOB_TITLE, NULL, JOB_TITLE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE ),
257: DECISION_MAKER_FLAG = DECODE( X_DECISION_MAKER_FLAG, NULL, DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', X_DECISION_MAKER_FLAG ),
258: JOB_TITLE_CODE = DECODE( X_JOB_TITLE_CODE, NULL, JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
259: REFERENCE_USE_FLAG = DECODE( X_REFERENCE_USE_FLAG, NULL, REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_USE_FLAG ),
260: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
261: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
262: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
263: CREATION_DATE = CREATION_DATE,
264: CREATED_BY = CREATED_BY,

Line 270: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),

266: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
267: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
271: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
272: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
273: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
274: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

Line 271: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

267: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
271: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
272: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
273: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
274: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
275: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

Line 272: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
271: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
272: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
273: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
274: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
275: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
276: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

Line 273: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
271: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
272: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
273: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
274: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
275: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
276: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
277: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

Line 274: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

270: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
271: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
272: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
273: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
274: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
275: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
276: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
277: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
278: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

Line 275: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

271: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
272: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
273: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
274: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
275: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
276: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
277: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
278: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
279: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

Line 276: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

272: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
273: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
274: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
275: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
276: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
277: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
278: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
279: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
280: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

Line 277: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

273: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
274: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
275: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
276: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
277: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
278: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
279: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
280: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
281: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

Line 278: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

274: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
275: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
276: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
277: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
278: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
279: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
280: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
281: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
282: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

Line 279: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

275: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
276: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
277: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
278: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
279: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
280: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
281: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
282: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
283: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

Line 280: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

276: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
277: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
278: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
279: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
280: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
281: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
282: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
283: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
284: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

Line 281: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

277: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
278: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
279: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
280: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
281: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
282: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
283: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
284: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
285: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

Line 282: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

278: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
279: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
280: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
281: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
282: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
283: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
284: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
285: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
286: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

Line 283: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

279: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
280: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
281: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
282: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
283: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
284: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
285: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
286: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
287: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),

Line 284: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

280: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
281: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
282: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
283: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
284: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
285: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
286: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
287: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
288: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),

Line 285: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

281: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
282: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
283: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
284: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
285: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
286: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
287: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
288: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
289: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),

Line 286: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

282: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
283: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
284: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
285: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
286: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
287: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
288: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
289: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
290: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

Line 287: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),

283: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
284: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
285: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
286: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
287: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
288: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
289: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
290: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
291: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),

Line 288: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),

284: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
285: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
286: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
287: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
288: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
289: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
290: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
291: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
292: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),

Line 289: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),

285: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
286: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
287: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
288: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
289: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
290: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
291: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
292: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
293: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),

Line 290: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

286: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
287: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
288: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
289: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
290: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
291: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
292: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
293: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
294: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),

Line 291: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),

287: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
288: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
289: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
290: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
291: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
292: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
293: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
294: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
295: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),

Line 292: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),

288: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
289: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
290: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
291: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
292: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
293: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
294: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
295: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
296: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),

Line 293: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),

289: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
290: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
291: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
292: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
293: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
294: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
295: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
296: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 294: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),

290: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
291: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
292: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
293: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
294: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
295: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
296: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 295: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),

291: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
292: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
293: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
294: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
295: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
296: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

Line 296: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),

292: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
293: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
294: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
295: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
296: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL, X_STATUS )

Line 297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

293: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
294: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
295: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
296: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL, X_STATUS )
301: WHERE ROWID = X_RowId;

Line 298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

294: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
295: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
296: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL, X_STATUS )
301: WHERE ROWID = X_RowId;
302:

Line 299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

295: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
296: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL, X_STATUS )
301: WHERE ROWID = X_RowId;
302:
303: IF ( SQL%NOTFOUND ) THEN

Line 300: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL, X_STATUS )

296: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR,NULL, X_STATUS )
301: WHERE ROWID = X_RowId;
302:
303: IF ( SQL%NOTFOUND ) THEN
304: RAISE NO_DATA_FOUND;

Line 588: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),

584:
585: BEGIN
586:
587: SELECT
588: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),
589: NVL( PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM ),
590: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
591: NVL( CONTACT_NUMBER, FND_API.G_MISS_CHAR ),
592: NVL( DEPARTMENT_CODE, FND_API.G_MISS_CHAR ),

Line 589: NVL( PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM ),

585: BEGIN
586:
587: SELECT
588: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),
589: NVL( PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM ),
590: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
591: NVL( CONTACT_NUMBER, FND_API.G_MISS_CHAR ),
592: NVL( DEPARTMENT_CODE, FND_API.G_MISS_CHAR ),
593: NVL( DEPARTMENT, FND_API.G_MISS_CHAR ),

Line 590: NVL( COMMENTS, FND_API.G_MISS_CHAR ),

586:
587: SELECT
588: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),
589: NVL( PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM ),
590: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
591: NVL( CONTACT_NUMBER, FND_API.G_MISS_CHAR ),
592: NVL( DEPARTMENT_CODE, FND_API.G_MISS_CHAR ),
593: NVL( DEPARTMENT, FND_API.G_MISS_CHAR ),
594: NVL( TITLE, FND_API.G_MISS_CHAR ),

Line 591: NVL( CONTACT_NUMBER, FND_API.G_MISS_CHAR ),

587: SELECT
588: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),
589: NVL( PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM ),
590: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
591: NVL( CONTACT_NUMBER, FND_API.G_MISS_CHAR ),
592: NVL( DEPARTMENT_CODE, FND_API.G_MISS_CHAR ),
593: NVL( DEPARTMENT, FND_API.G_MISS_CHAR ),
594: NVL( TITLE, FND_API.G_MISS_CHAR ),
595: NVL( JOB_TITLE, FND_API.G_MISS_CHAR ),

Line 592: NVL( DEPARTMENT_CODE, FND_API.G_MISS_CHAR ),

588: NVL( ORG_CONTACT_ID, FND_API.G_MISS_NUM ),
589: NVL( PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM ),
590: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
591: NVL( CONTACT_NUMBER, FND_API.G_MISS_CHAR ),
592: NVL( DEPARTMENT_CODE, FND_API.G_MISS_CHAR ),
593: NVL( DEPARTMENT, FND_API.G_MISS_CHAR ),
594: NVL( TITLE, FND_API.G_MISS_CHAR ),
595: NVL( JOB_TITLE, FND_API.G_MISS_CHAR ),
596: NVL( DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR ),

Line 593: NVL( DEPARTMENT, FND_API.G_MISS_CHAR ),

589: NVL( PARTY_RELATIONSHIP_ID, FND_API.G_MISS_NUM ),
590: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
591: NVL( CONTACT_NUMBER, FND_API.G_MISS_CHAR ),
592: NVL( DEPARTMENT_CODE, FND_API.G_MISS_CHAR ),
593: NVL( DEPARTMENT, FND_API.G_MISS_CHAR ),
594: NVL( TITLE, FND_API.G_MISS_CHAR ),
595: NVL( JOB_TITLE, FND_API.G_MISS_CHAR ),
596: NVL( DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR ),
597: NVL( JOB_TITLE_CODE, FND_API.G_MISS_CHAR ),

Line 594: NVL( TITLE, FND_API.G_MISS_CHAR ),

590: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
591: NVL( CONTACT_NUMBER, FND_API.G_MISS_CHAR ),
592: NVL( DEPARTMENT_CODE, FND_API.G_MISS_CHAR ),
593: NVL( DEPARTMENT, FND_API.G_MISS_CHAR ),
594: NVL( TITLE, FND_API.G_MISS_CHAR ),
595: NVL( JOB_TITLE, FND_API.G_MISS_CHAR ),
596: NVL( DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR ),
597: NVL( JOB_TITLE_CODE, FND_API.G_MISS_CHAR ),
598: NVL( REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR ),

Line 595: NVL( JOB_TITLE, FND_API.G_MISS_CHAR ),

591: NVL( CONTACT_NUMBER, FND_API.G_MISS_CHAR ),
592: NVL( DEPARTMENT_CODE, FND_API.G_MISS_CHAR ),
593: NVL( DEPARTMENT, FND_API.G_MISS_CHAR ),
594: NVL( TITLE, FND_API.G_MISS_CHAR ),
595: NVL( JOB_TITLE, FND_API.G_MISS_CHAR ),
596: NVL( DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR ),
597: NVL( JOB_TITLE_CODE, FND_API.G_MISS_CHAR ),
598: NVL( REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR ),
599: NVL( RANK, FND_API.G_MISS_CHAR ),

Line 596: NVL( DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR ),

592: NVL( DEPARTMENT_CODE, FND_API.G_MISS_CHAR ),
593: NVL( DEPARTMENT, FND_API.G_MISS_CHAR ),
594: NVL( TITLE, FND_API.G_MISS_CHAR ),
595: NVL( JOB_TITLE, FND_API.G_MISS_CHAR ),
596: NVL( DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR ),
597: NVL( JOB_TITLE_CODE, FND_API.G_MISS_CHAR ),
598: NVL( REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR ),
599: NVL( RANK, FND_API.G_MISS_CHAR ),
600: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),

Line 597: NVL( JOB_TITLE_CODE, FND_API.G_MISS_CHAR ),

593: NVL( DEPARTMENT, FND_API.G_MISS_CHAR ),
594: NVL( TITLE, FND_API.G_MISS_CHAR ),
595: NVL( JOB_TITLE, FND_API.G_MISS_CHAR ),
596: NVL( DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR ),
597: NVL( JOB_TITLE_CODE, FND_API.G_MISS_CHAR ),
598: NVL( REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR ),
599: NVL( RANK, FND_API.G_MISS_CHAR ),
600: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),

Line 598: NVL( REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR ),

594: NVL( TITLE, FND_API.G_MISS_CHAR ),
595: NVL( JOB_TITLE, FND_API.G_MISS_CHAR ),
596: NVL( DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR ),
597: NVL( JOB_TITLE_CODE, FND_API.G_MISS_CHAR ),
598: NVL( REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR ),
599: NVL( RANK, FND_API.G_MISS_CHAR ),
600: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),

Line 599: NVL( RANK, FND_API.G_MISS_CHAR ),

595: NVL( JOB_TITLE, FND_API.G_MISS_CHAR ),
596: NVL( DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR ),
597: NVL( JOB_TITLE_CODE, FND_API.G_MISS_CHAR ),
598: NVL( REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR ),
599: NVL( RANK, FND_API.G_MISS_CHAR ),
600: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),

Line 600: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),

596: NVL( DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR ),
597: NVL( JOB_TITLE_CODE, FND_API.G_MISS_CHAR ),
598: NVL( REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR ),
599: NVL( RANK, FND_API.G_MISS_CHAR ),
600: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),

Line 601: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),

597: NVL( JOB_TITLE_CODE, FND_API.G_MISS_CHAR ),
598: NVL( REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR ),
599: NVL( RANK, FND_API.G_MISS_CHAR ),
600: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),

Line 602: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),

598: NVL( REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR ),
599: NVL( RANK, FND_API.G_MISS_CHAR ),
600: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),

Line 603: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),

599: NVL( RANK, FND_API.G_MISS_CHAR ),
600: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),

Line 604: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),

600: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),

Line 605: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),

601: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),

Line 606: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),

602: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),

Line 607: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),

603: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),

Line 608: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),

604: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),

Line 609: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),

605: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),

Line 610: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),

606: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),

Line 611: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),

607: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),

Line 612: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),

608: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
616: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),

Line 613: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),

609: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
616: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
617: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),

Line 614: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),

610: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
616: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
617: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
618: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),

Line 615: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),

611: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
616: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
617: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
618: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
619: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),

Line 616: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),

612: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
616: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
617: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
618: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
619: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
620: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),

Line 617: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),

613: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
616: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
617: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
618: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
619: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
620: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
621: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),

Line 618: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),

614: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
616: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
617: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
618: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
619: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
620: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
621: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
622: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),

Line 619: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),

615: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
616: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
617: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
618: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
619: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
620: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
621: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
622: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),

Line 620: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),

616: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
617: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
618: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
619: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
620: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
621: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
622: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),

Line 621: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),

617: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
618: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
619: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
620: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
621: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
622: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),

Line 622: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),

618: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
619: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
620: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
621: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
622: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
626: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),

Line 623: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),

619: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
620: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
621: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
622: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
626: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
627: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

Line 624: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),

620: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
621: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
622: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
626: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
627: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
628: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

Line 625: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),

621: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
622: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
626: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
627: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
628: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
629: INTO

Line 626: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),

622: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
626: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
627: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
628: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
629: INTO
630: X_ORG_CONTACT_ID,

Line 627: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

623: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
626: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
627: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
628: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
629: INTO
630: X_ORG_CONTACT_ID,
631: X_PARTY_RELATIONSHIP_ID,

Line 628: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

624: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
626: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
627: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
628: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
629: INTO
630: X_ORG_CONTACT_ID,
631: X_PARTY_RELATIONSHIP_ID,
632: X_COMMENTS,

Line 680: RAISE FND_API.G_EXC_ERROR;

676: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
677: FND_MESSAGE.SET_TOKEN( 'RECORD', 'org_contact_rec');
678: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_ORG_CONTACT_ID ) );
679: FND_MSG_PUB.ADD;
680: RAISE FND_API.G_EXC_ERROR;
681:
682: END Select_Row;
683:
684: PROCEDURE Delete_Row (