APPS.HZ_CLASSIFICATION_V2PUB dependencies on HZ_CLASS_CATEGORY_USES

Line 1252: HZ_CLASS_CATEGORY_USES_PKG.Insert_Row (

1248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: END IF;
1251:
1252: HZ_CLASS_CATEGORY_USES_PKG.Insert_Row (
1253: X_CLASS_CATEGORY => p_class_category_use_rec.class_category,
1254: X_OWNER_TABLE => p_class_category_use_rec.owner_table,
1255: X_COLUMN_NAME => p_class_category_use_rec.column_name,
1256: X_ADDITIONAL_WHERE_CLAUSE => p_class_category_use_rec.additional_where_clause,

Line 1308: FROM HZ_CLASS_CATEGORY_USES

1304: SELECT OBJECT_VERSION_NUMBER,
1305: ROWID
1306: INTO l_object_version_number,
1307: l_rowid
1308: FROM HZ_CLASS_CATEGORY_USES
1309: WHERE CLASS_CATEGORY = p_class_category_use_rec.class_category
1310: AND OWNER_TABLE = p_class_category_use_rec.owner_table
1311: FOR UPDATE OF CLASS_CATEGORY, OWNER_TABLE, COLUMN_NAME, ADDITIONAL_WHERE_CLAUSE NOWAIT;
1312:

Line 1317: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORY_USES');

1313: IF NOT ((p_object_version_number is null and l_object_version_number is null)
1314: OR (p_object_version_number = l_object_version_number))
1315: THEN
1316: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1317: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORY_USES');
1318: FND_MSG_PUB.ADD;
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321:

Line 1326: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORY_USES');

1322: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1323:
1324: EXCEPTION WHEN NO_DATA_FOUND THEN
1325: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1326: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORY_USES');
1327: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_category_use_rec.class_category');
1328: FND_MSG_PUB.ADD;
1329: RAISE FND_API.G_EXC_ERROR;
1330: END;

Line 1343: HZ_CLASS_CATEGORY_USES_PKG.Update_Row (

1339: RAISE FND_API.G_EXC_ERROR;
1340: END IF;
1341:
1342: -- call to table-handler.
1343: HZ_CLASS_CATEGORY_USES_PKG.Update_Row (
1344: X_CLASS_CATEGORY => p_class_category_use_rec.class_category,
1345: X_OWNER_TABLE => p_class_category_use_rec.owner_table,
1346: X_COLUMN_NAME => p_class_category_use_rec.column_name,
1347: X_ADDITIONAL_WHERE_CLAUSE => p_class_category_use_rec.additional_where_clause,

Line 2702: FROM hz_class_category_uses

2698: additional_where_clause
2699: INTO x_class_category_use_rec.class_category,
2700: x_class_category_use_rec.owner_table,
2701: x_class_category_use_rec.additional_where_clause
2702: FROM hz_class_category_uses
2703: WHERE class_category = p_class_category_use_rec.class_category
2704: AND owner_table = p_class_category_use_rec.owner_table;
2705: END get_curr_class_category_use;
2706:

Line 2873: * HZ_CLASS_CATEGORY_USES_PKG.Select_Row

2869: * DESCRIPTION
2870: * Gets class category use record.
2871: *
2872: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2873: * HZ_CLASS_CATEGORY_USES_PKG.Select_Row
2874: *
2875: * ARGUMENTS
2876: * IN:
2877: * p_init_msg_list Initialize message stack if it is set to

Line 2939: HZ_CLASS_CATEGORY_USES_PKG.Select_Row (

2935:
2936: x_class_category_use_rec.class_category := p_class_category;
2937: x_class_category_use_rec.owner_table := p_owner_table;
2938:
2939: HZ_CLASS_CATEGORY_USES_PKG.Select_Row (
2940: X_CLASS_CATEGORY => x_class_category_use_rec.class_category,
2941: X_OWNER_TABLE => x_class_category_use_rec.owner_table,
2942: X_COLUMN_NAME => x_class_category_use_rec.column_name,
2943: X_ADDITIONAL_WHERE_CLAUSE => x_class_category_use_rec.additional_where_clause,

Line 3296: --Bug 2824942: Modified the cursor to verify additional_where_clause from hz_class_category uses

3292: p_key_5 VARCHAR2 := FND_API.G_MISS_CHAR
3293: )
3294: RETURN VARCHAR2
3295: IS
3296: --Bug 2824942: Modified the cursor to verify additional_where_clause from hz_class_category uses
3297: CURSOR get_category_uses_info is
3298: SELECT h.owner_table,
3299: upper(trim(h.additional_where_clause)),
3300: f.pk1_column_name,

Line 3305: FROM hz_class_category_uses h,

3301: f.pk2_column_name,
3302: f.pk3_column_name,
3303: f.pk4_column_name,
3304: f.pk5_column_name
3305: FROM hz_class_category_uses h,
3306: fnd_objects f
3307: WHERE upper(f.database_object_name) = upper(h.owner_table)
3308: AND class_category = p_class_category
3309: AND owner_table = p_owner_table;

Line 3476: FROM hz_class_category_uses

3472: RETURN VARCHAR2
3473: IS
3474: CURSOR get_query_info is
3475: SELECT upper(trim(additional_where_clause)), column_name
3476: FROM hz_class_category_uses
3477: WHERE class_category = p_class_category
3478: AND owner_table = p_owner_table;
3479:
3480: bool VARCHAR2(1) := 'F';