APPS.HZ_CLASSIFICATION_V2PUB dependencies on HZ_CLASS_CATEGORY_USES

Line 1278: HZ_CLASS_CATEGORY_USES_PKG.Insert_Row (

1274: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: END IF;
1277:
1278: HZ_CLASS_CATEGORY_USES_PKG.Insert_Row (
1279: X_CLASS_CATEGORY => p_class_category_use_rec.class_category,
1280: X_OWNER_TABLE => p_class_category_use_rec.owner_table,
1281: X_COLUMN_NAME => p_class_category_use_rec.column_name,
1282: X_ADDITIONAL_WHERE_CLAUSE => p_class_category_use_rec.additional_where_clause,

Line 1334: FROM HZ_CLASS_CATEGORY_USES

1330: SELECT OBJECT_VERSION_NUMBER,
1331: ROWID
1332: INTO l_object_version_number,
1333: l_rowid
1334: FROM HZ_CLASS_CATEGORY_USES
1335: WHERE CLASS_CATEGORY = p_class_category_use_rec.class_category
1336: AND OWNER_TABLE = p_class_category_use_rec.owner_table
1337: FOR UPDATE OF CLASS_CATEGORY, OWNER_TABLE, COLUMN_NAME, ADDITIONAL_WHERE_CLAUSE NOWAIT;
1338:

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

1339: IF NOT ((p_object_version_number is null and l_object_version_number is null)
1340: OR (p_object_version_number = l_object_version_number))
1341: THEN
1342: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1343: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORY_USES');
1344: FND_MSG_PUB.ADD;
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347:

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

1348: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1349:
1350: EXCEPTION WHEN NO_DATA_FOUND THEN
1351: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1352: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORY_USES');
1353: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_category_use_rec.class_category');
1354: FND_MSG_PUB.ADD;
1355: RAISE FND_API.G_EXC_ERROR;
1356: END;

Line 1369: HZ_CLASS_CATEGORY_USES_PKG.Update_Row (

1365: RAISE FND_API.G_EXC_ERROR;
1366: END IF;
1367:
1368: -- call to table-handler.
1369: HZ_CLASS_CATEGORY_USES_PKG.Update_Row (
1370: X_CLASS_CATEGORY => p_class_category_use_rec.class_category,
1371: X_OWNER_TABLE => p_class_category_use_rec.owner_table,
1372: X_COLUMN_NAME => p_class_category_use_rec.column_name,
1373: X_ADDITIONAL_WHERE_CLAUSE => p_class_category_use_rec.additional_where_clause,

Line 2728: FROM hz_class_category_uses

2724: additional_where_clause
2725: INTO x_class_category_use_rec.class_category,
2726: x_class_category_use_rec.owner_table,
2727: x_class_category_use_rec.additional_where_clause
2728: FROM hz_class_category_uses
2729: WHERE class_category = p_class_category_use_rec.class_category
2730: AND owner_table = p_class_category_use_rec.owner_table;
2731: END get_curr_class_category_use;
2732:

Line 2899: * HZ_CLASS_CATEGORY_USES_PKG.Select_Row

2895: * DESCRIPTION
2896: * Gets class category use record.
2897: *
2898: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2899: * HZ_CLASS_CATEGORY_USES_PKG.Select_Row
2900: *
2901: * ARGUMENTS
2902: * IN:
2903: * p_init_msg_list Initialize message stack if it is set to

Line 2965: HZ_CLASS_CATEGORY_USES_PKG.Select_Row (

2961:
2962: x_class_category_use_rec.class_category := p_class_category;
2963: x_class_category_use_rec.owner_table := p_owner_table;
2964:
2965: HZ_CLASS_CATEGORY_USES_PKG.Select_Row (
2966: X_CLASS_CATEGORY => x_class_category_use_rec.class_category,
2967: X_OWNER_TABLE => x_class_category_use_rec.owner_table,
2968: X_COLUMN_NAME => x_class_category_use_rec.column_name,
2969: X_ADDITIONAL_WHERE_CLAUSE => x_class_category_use_rec.additional_where_clause,

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

3318: p_key_5 VARCHAR2 := FND_API.G_MISS_CHAR
3319: )
3320: RETURN VARCHAR2
3321: IS
3322: --Bug 2824942: Modified the cursor to verify additional_where_clause from hz_class_category uses
3323: CURSOR get_category_uses_info is
3324: SELECT h.owner_table,
3325: upper(trim(h.additional_where_clause)),
3326: f.pk1_column_name,

Line 3331: FROM hz_class_category_uses h,

3327: f.pk2_column_name,
3328: f.pk3_column_name,
3329: f.pk4_column_name,
3330: f.pk5_column_name
3331: FROM hz_class_category_uses h,
3332: fnd_objects f
3333: WHERE upper(f.database_object_name) = upper(h.owner_table)
3334: AND class_category = p_class_category
3335: AND owner_table = p_owner_table;

Line 3502: FROM hz_class_category_uses

3498: RETURN VARCHAR2
3499: IS
3500: CURSOR get_query_info is
3501: SELECT upper(trim(additional_where_clause)), column_name
3502: FROM hz_class_category_uses
3503: WHERE class_category = p_class_category
3504: AND owner_table = p_owner_table;
3505:
3506: bool VARCHAR2(1) := 'F';