APPS.OZF_CODE_CONVERSION_PKG dependencies on FND_API

Line 79: /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN

75:
76: BEGIN
77:
78: -- R12 Enhancements
79: /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
80: SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
81: INTO px_org_id
82: FROM DUAL;
83: END IF;

Line 123: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),

119: attribute13,
120: attribute14,
121: attribute15
122: ) VALUES (
123: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
124: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 124: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

120: attribute14,
121: attribute15
122: ) VALUES (
123: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
124: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
128: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

121: attribute15
122: ) VALUES (
123: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
124: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
128: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
129: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

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

122: ) VALUES (
123: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
124: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
128: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
129: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
130: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),

Line 127: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

123: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
124: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
128: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
129: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
130: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
131: DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),

Line 128: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

124: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
128: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
129: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
130: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
131: DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),
132: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),

Line 129: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
128: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
129: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
130: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
131: DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),
132: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
133: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),

Line 130: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),

126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
128: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
129: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
130: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
131: DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),
132: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
133: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
134: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),

Line 131: DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),

127: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
128: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
129: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
130: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
131: DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),
132: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
133: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
134: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
135: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),

Line 132: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),

128: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
129: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
130: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
131: DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),
132: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
133: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
134: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
135: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
136: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),

Line 133: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),

129: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
130: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
131: DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),
132: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
133: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
134: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
135: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
136: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
137: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

Line 134: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),

130: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
131: DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),
132: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
133: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
134: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
135: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
136: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
137: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
138: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

Line 135: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),

131: DECODE( p_party_id, FND_API.G_MISS_NUM, NULL, p_party_id),
132: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
133: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
134: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
135: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
136: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
137: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
138: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

Line 136: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),

132: DECODE( p_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
133: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
134: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
135: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
136: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
137: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
138: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

Line 137: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

133: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
134: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
135: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
136: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
137: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
138: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

Line 138: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

134: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
135: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
136: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
137: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
138: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

Line 139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

135: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
136: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
137: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
138: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

Line 140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

136: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
137: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
138: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

Line 141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

137: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
138: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

Line 142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

138: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

Line 143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

Line 144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

Line 145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

Line 146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

Line 147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

Line 148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

Line 149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

Line 150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));

Line 151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
155:

Line 152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
155:
156: END Insert_Row;

Line 153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
155:
156: END Insert_Row;
157:

Line 154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));

150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
155:
156: END Insert_Row;
157:
158:

Line 209: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),

205: IS
206: BEGIN
207: Update ozf_code_conversions_all
208: SET
209: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
210: object_version_number = nvl(p_object_version_number,0) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

207: Update ozf_code_conversions_all
208: SET
209: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
210: object_version_number = nvl(p_object_version_number,0) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
215: party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),

Line 212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

208: SET
209: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
210: object_version_number = nvl(p_object_version_number,0) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
215: party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),
216: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),

Line 213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

209: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
210: object_version_number = nvl(p_object_version_number,0) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
215: party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),
216: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
217: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),

Line 214: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),

210: object_version_number = nvl(p_object_version_number,0) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
215: party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),
216: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
217: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
218: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),

Line 215: party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),

211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
215: party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),
216: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
217: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
218: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
219: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),

Line 216: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),

212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
215: party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),
216: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
217: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
218: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
219: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
220: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),

Line 217: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),

213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
215: party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),
216: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
217: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
218: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
219: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
220: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
221: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

Line 218: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),

214: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
215: party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),
216: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
217: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
218: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
219: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
220: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
221: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
222: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

Line 219: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),

215: party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),
216: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
217: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
218: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
219: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
220: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
221: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
222: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
223: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),

Line 220: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),

216: cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
217: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
218: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
219: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
220: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
221: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
222: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
223: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
224: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

Line 221: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

217: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
218: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
219: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
220: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
221: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
222: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
223: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
224: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
225: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

Line 222: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

218: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
219: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
220: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
221: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
222: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
223: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
224: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
225: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
226: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

Line 223: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),

219: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
220: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
221: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
222: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
223: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
224: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
225: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
226: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
227: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

Line 224: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

220: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
221: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
222: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
223: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
224: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
225: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
226: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
227: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
228: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

Line 225: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

221: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
222: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
223: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
224: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
225: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
226: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
227: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
228: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
229: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

Line 226: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

222: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
223: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
224: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
225: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
226: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
227: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
228: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
229: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
230: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

Line 227: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

223: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
224: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
225: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
226: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
227: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
228: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
229: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
230: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
231: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

Line 228: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

224: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
225: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
226: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
227: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
228: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
229: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
230: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
231: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
232: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

Line 229: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

225: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
226: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
227: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
228: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
229: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
230: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
231: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
232: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
233: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

Line 230: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

226: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
227: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
228: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
229: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
230: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
231: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
232: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
233: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
234: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

Line 231: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

227: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
228: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
229: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
230: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
231: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
232: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
233: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
234: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
235: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

Line 232: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

228: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
229: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
230: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
231: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
232: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
233: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
234: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
235: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
236: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

Line 233: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

229: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
230: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
231: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
232: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
233: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
234: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
235: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
236: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
237: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

Line 234: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

230: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
231: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
232: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
233: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
234: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
235: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
236: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
237: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
238: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)

Line 235: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

231: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
232: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
233: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
234: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
235: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
236: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
237: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
238: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
239: WHERE code_conversion_id = p_code_conversion_id

Line 236: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

232: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
233: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
234: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
235: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
236: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
237: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
238: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
239: WHERE code_conversion_id = p_code_conversion_id
240: AND object_version_number = p_object_version_number;

Line 237: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

233: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
234: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
235: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
236: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
237: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
238: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
239: WHERE code_conversion_id = p_code_conversion_id
240: AND object_version_number = p_object_version_number;
241:

Line 238: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)

234: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
235: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
236: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
237: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
238: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
239: WHERE code_conversion_id = p_code_conversion_id
240: AND object_version_number = p_object_version_number;
241:
242:

Line 244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

240: AND object_version_number = p_object_version_number;
241:
242:
243: IF (SQL%NOTFOUND) THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:
247:
248: END Update_Row;

Line 274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

270: DELETE FROM ozf_code_conversions_all
271: WHERE code_conversion_id = p_code_conversion_id
272: AND object_version_number = p_object_version_number;
273: If (SQL%NOTFOUND) then
274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275: End If;
276: END Delete_Row ;
277:
278:

Line 332: /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN

328:
329: BEGIN
330:
331: -- R12 Enhancements
332: /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
333: SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
334: INTO px_org_id
335: FROM DUAL;
336: END IF;

Line 375: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),

371: attribute13,
372: attribute14,
373: attribute15
374: ) VALUES (
375: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
376: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
377: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
378: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
379: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 376: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

372: attribute14,
373: attribute15
374: ) VALUES (
375: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
376: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
377: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
378: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
379: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
380: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 377: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

373: attribute15
374: ) VALUES (
375: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
376: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
377: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
378: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
379: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
380: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
381: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 378: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

374: ) VALUES (
375: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
376: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
377: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
378: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
379: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
380: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
381: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
382: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),

Line 379: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

375: DECODE( px_code_conversion_id, FND_API.G_MISS_NUM, NULL, px_code_conversion_id),
376: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
377: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
378: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
379: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
380: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
381: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
382: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
383: DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL,p_supp_trade_profile_id ),

Line 380: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

376: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
377: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
378: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
379: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
380: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
381: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
382: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
383: DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL,p_supp_trade_profile_id ),
384: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),

Line 381: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

377: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
378: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
379: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
380: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
381: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
382: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
383: DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL,p_supp_trade_profile_id ),
384: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
385: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),

Line 382: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),

378: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
379: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
380: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
381: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
382: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
383: DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL,p_supp_trade_profile_id ),
384: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
385: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
386: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),

Line 383: DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL,p_supp_trade_profile_id ),

379: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
380: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
381: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
382: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
383: DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL,p_supp_trade_profile_id ),
384: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
385: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
386: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
387: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),

Line 384: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),

380: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
381: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
382: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
383: DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL,p_supp_trade_profile_id ),
384: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
385: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
386: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
387: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
388: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

Line 385: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),

381: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
382: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
383: DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL,p_supp_trade_profile_id ),
384: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
385: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
386: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
387: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
388: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
389: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

Line 386: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),

382: DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
383: DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL,p_supp_trade_profile_id ),
384: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
385: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
386: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
387: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
388: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
389: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
390: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

Line 387: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),

383: DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL,p_supp_trade_profile_id ),
384: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
385: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
386: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
387: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
388: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
389: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
390: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
391: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

Line 388: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

384: DECODE( p_code_conversion_type, FND_API.g_miss_char, NULL, p_code_conversion_type),
385: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
386: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
387: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
388: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
389: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
390: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
391: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
392: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

Line 389: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

385: DECODE( p_external_code, FND_API.g_miss_char, NULL, p_external_code),
386: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
387: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
388: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
389: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
390: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
391: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
392: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
393: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

Line 390: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

386: DECODE( p_internal_code, FND_API.g_miss_char, NULL, p_internal_code),
387: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
388: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
389: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
390: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
391: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
392: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
393: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
394: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

Line 391: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

387: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
388: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
389: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
390: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
391: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
392: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
393: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
394: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
395: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

Line 392: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

388: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
389: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
390: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
391: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
392: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
393: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
394: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
395: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
396: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

Line 393: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

389: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
390: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
391: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
392: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
393: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
394: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
395: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
396: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
397: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

Line 394: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

390: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
391: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
392: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
393: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
394: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
395: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
396: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
397: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
398: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

Line 395: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

391: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
392: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
393: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
394: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
395: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
396: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
397: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
398: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
399: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

Line 396: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

392: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
393: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
394: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
395: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
396: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
397: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
398: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
399: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
400: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

Line 397: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

393: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
394: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
395: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
396: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
397: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
398: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
399: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
400: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
401: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

Line 398: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

394: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
395: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
396: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
397: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
398: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
399: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
400: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
401: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
402: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

Line 399: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

395: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
396: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
397: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
398: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
399: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
400: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
401: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
402: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
403: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

Line 400: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

396: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
397: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
398: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
399: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
400: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
401: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
402: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
403: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
404: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

Line 401: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

397: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
398: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
399: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
400: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
401: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
402: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
403: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
404: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
405: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));

Line 402: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

398: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
399: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
400: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
401: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
402: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
403: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
404: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
405: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
406:

Line 403: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

399: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
400: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
401: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
402: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
403: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
404: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
405: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
406:
407: END Insert_Supp_Code_Conv_Row;

Line 404: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

400: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
401: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
402: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
403: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
404: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
405: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
406:
407: END Insert_Supp_Code_Conv_Row;
408:

Line 405: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));

401: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
402: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
403: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
404: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
405: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
406:
407: END Insert_Supp_Code_Conv_Row;
408:
409:

Line 459: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),

455: IS
456: BEGIN
457: Update ozf_supp_code_conversions_all
458: SET
459: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
460: object_version_number = nvl(p_object_version_number,0) + 1 ,
461: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
462: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
463: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 461: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

457: Update ozf_supp_code_conversions_all
458: SET
459: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
460: object_version_number = nvl(p_object_version_number,0) + 1 ,
461: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
462: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
463: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
464: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
465: supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),

Line 462: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

458: SET
459: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
460: object_version_number = nvl(p_object_version_number,0) + 1 ,
461: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
462: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
463: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
464: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
465: supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),
466: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),

Line 463: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

459: code_conversion_id = DECODE( p_code_conversion_id, null, code_conversion_id, FND_API.G_MISS_NUM, null, p_code_conversion_id),
460: object_version_number = nvl(p_object_version_number,0) + 1 ,
461: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
462: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
463: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
464: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
465: supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),
466: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
467: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),

Line 464: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),

460: object_version_number = nvl(p_object_version_number,0) + 1 ,
461: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
462: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
463: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
464: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
465: supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),
466: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
467: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
468: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),

Line 465: supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),

461: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
462: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
463: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
464: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
465: supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),
466: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
467: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
468: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
469: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),

Line 466: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),

462: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
463: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
464: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
465: supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),
466: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
467: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
468: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
469: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
470: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

Line 467: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),

463: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
464: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
465: supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),
466: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
467: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
468: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
469: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
470: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
471: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

Line 468: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),

464: org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
465: supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),
466: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
467: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
468: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
469: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
470: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
471: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
472: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),

Line 469: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),

465: supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),
466: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
467: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
468: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
469: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
470: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
471: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
472: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
473: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

Line 470: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

466: code_conversion_type = DECODE( p_code_conversion_type, null, code_conversion_type, FND_API.g_miss_char, null, p_code_conversion_type),
467: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
468: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
469: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
470: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
471: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
472: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
473: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
474: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

Line 471: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

467: external_code = DECODE( p_external_code, null, external_code, FND_API.g_miss_char, null, p_external_code),
468: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
469: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
470: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
471: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
472: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
473: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
474: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
475: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

Line 472: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),

468: internal_code = DECODE( p_internal_code, null, internal_code, FND_API.g_miss_char, null, p_internal_code),
469: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
470: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
471: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
472: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
473: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
474: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
475: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
476: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

Line 473: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

469: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
470: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
471: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
472: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
473: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
474: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
475: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
476: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
477: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

Line 474: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

470: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
471: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
472: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
473: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
474: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
475: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
476: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
477: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
478: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

Line 475: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

471: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
472: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
473: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
474: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
475: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
476: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
477: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
478: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
479: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

Line 476: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

472: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
473: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
474: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
475: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
476: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
477: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
478: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
479: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
480: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

Line 477: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

473: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
474: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
475: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
476: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
477: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
478: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
479: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
480: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
481: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

Line 478: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

474: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
475: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
476: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
477: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
478: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
479: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
480: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
481: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
482: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

Line 479: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

475: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
476: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
477: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
478: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
479: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
480: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
481: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
482: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
483: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

Line 480: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

476: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
477: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
478: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
479: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
480: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
481: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
482: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
483: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
484: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

Line 481: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

477: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
478: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
479: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
480: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
481: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
482: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
483: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
484: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
485: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

Line 482: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

478: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
479: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
480: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
481: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
482: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
483: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
484: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
485: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
486: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

Line 483: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

479: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
480: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
481: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
482: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
483: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
484: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
485: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
486: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
487: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)

Line 484: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

480: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
481: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
482: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
483: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
484: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
485: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
486: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
487: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
488: WHERE code_conversion_id = p_code_conversion_id

Line 485: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

481: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
482: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
483: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
484: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
485: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
486: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
487: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
488: WHERE code_conversion_id = p_code_conversion_id
489: AND object_version_number = p_object_version_number;

Line 486: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

482: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
483: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
484: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
485: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
486: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
487: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
488: WHERE code_conversion_id = p_code_conversion_id
489: AND object_version_number = p_object_version_number;
490:

Line 487: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)

483: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
484: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
485: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
486: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
487: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
488: WHERE code_conversion_id = p_code_conversion_id
489: AND object_version_number = p_object_version_number;
490:
491:

Line 493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

489: AND object_version_number = p_object_version_number;
490:
491:
492: IF (SQL%NOTFOUND) THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;
495:
496:
497: END Update_Supp_Code_Conv_Row;

Line 523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

519: DELETE FROM ozf_supp_code_conversions_all
520: WHERE code_conversion_id = p_code_conversion_id
521: AND object_version_number = p_object_version_number;
522: If (SQL%NOTFOUND) then
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: End If;
525: END Delete_Supp_Code_Conv_Row ;
526:
527: