APPS.AMV_CATEGORY_PVT dependencies on AMV_C_CATEGORIES_PKG

Line 723: AMV_C_CATEGORIES_PKG.INSERT_ROW(

719: CLOSE CategoryId_Seq;
720: --
721: -- Create a new channel category
722: BEGIN
723: AMV_C_CATEGORIES_PKG.INSERT_ROW(
724: X_ROWID => l_row_id,
725: X_CHANNEL_CATEGORY_ID => l_category_id ,
726: X_APPLICATION_ID => p_application_id,
727: X_OBJECT_VERSION_NUMBER => l_object_version_number,

Line 1101: AMV_C_CATEGORIES_PKG.DELETE_ROW(l_category_hr(i).id);

1097: WHERE subscribing_to_id = l_category_hr(i).id
1098: AND subscribing_to_type = AMV_UTILITY_PVT.G_CATEGORY;
1099:
1100: -- Remove channel category
1101: AMV_C_CATEGORIES_PKG.DELETE_ROW(l_category_hr(i).id);
1102: END LOOP;
1103: END IF;
1104: --
1105:

Line 1367: AMV_C_CATEGORIES_PKG.UPDATE_B_ROW(

1363: l_order := l_category_array.count - i + 1;
1364: END IF;
1365:
1366: BEGIN
1367: AMV_C_CATEGORIES_PKG.UPDATE_B_ROW(
1368: X_CHANNEL_CATEGORY_ID => l_category_id,
1369: X_APPLICATION_ID => l_application_id,
1370: X_OBJECT_VERSION_NUMBER => l_object_version_number,
1371: X_CHANNEL_CATEGORY_ORDER => l_order,

Line 1578: AMV_C_CATEGORIES_PKG.UPDATE_B_ROW(

1574: l_channel_count;
1575: CLOSE Get_CatRec_csr;
1576: -- Change the category order
1577: BEGIN
1578: AMV_C_CATEGORIES_PKG.UPDATE_B_ROW(
1579: X_CHANNEL_CATEGORY_ID => l_category_id,
1580: X_APPLICATION_ID => l_application_id,
1581: X_OBJECT_VERSION_NUMBER => l_object_version_number,
1582: X_CHANNEL_CATEGORY_ORDER => p_category_new_order(i),

Line 1975: AMV_C_CATEGORIES_PKG.UPDATE_ROW(

1971:
1972: -- update if the version is greater equal to one in db
1973: IF p_object_version_number = l_object_version_number THEN
1974: BEGIN
1975: AMV_C_CATEGORIES_PKG.UPDATE_ROW(
1976: X_CHANNEL_CATEGORY_ID => l_category_id,
1977: X_APPLICATION_ID => l_application_id,
1978: X_OBJECT_VERSION_NUMBER => p_object_version_number + 1,
1979: X_CHANNEL_CATEGORY_ORDER => l_category_order,

Line 4226: AMV_C_CATEGORIES_PKG.UPDATE_B_ROW(

4222: RAISE FND_API.G_EXC_ERROR;
4223: END IF;
4224:
4225: BEGIN
4226: AMV_C_CATEGORIES_PKG.UPDATE_B_ROW(
4227: X_CHANNEL_CATEGORY_ID => p_category_id,
4228: X_APPLICATION_ID => l_application_id,
4229: X_OBJECT_VERSION_NUMBER => p_object_version_number + 1,
4230: X_CHANNEL_CATEGORY_ORDER => l_order,

Line 4447: AMV_C_CATEGORIES_PKG.UPDATE_B_ROW(

4443: --
4444: IF p_object_version_number = l_object_version_number THEN
4445: l_parent_category_id := null;
4446: BEGIN
4447: AMV_C_CATEGORIES_PKG.UPDATE_B_ROW(
4448: X_CHANNEL_CATEGORY_ID => p_category_id,
4449: X_APPLICATION_ID => l_application_id,
4450: X_OBJECT_VERSION_NUMBER => p_object_version_number + 1,
4451: X_CHANNEL_CATEGORY_ORDER => l_order,