DBA Data[Home] [Help]

APPS.AMV_C_CATEGORIES_PKG dependencies on AMV_C_CATEGORIES_PKG

Line 1: package body AMV_C_CATEGORIES_PKG as

1: package body AMV_C_CATEGORIES_PKG as
2: /* $Header: amvtcatb.pls 120.2 2006/02/03 16:12:29 mkettle ship $ */
3: procedure LOAD_ROW (
4: X_CHANNEL_CATEGORY_ID in VARCHAR2,
5: X_OBJECT_VERSION_NUMBER in VARCHAR2,

Line 56: AMV_C_CATEGORIES_PKG.UPDATE_ROW (

52: END IF;
53:
54: IF l_upd = 'TRUE' THEN
55:
56: AMV_C_CATEGORIES_PKG.UPDATE_ROW (
57: X_CHANNEL_CATEGORY_ID => l_channel_category_id,
58: X_APPLICATION_ID => l_application_id,
59: X_OBJECT_VERSION_NUMBER => l_object_version_number,
60: X_CHANNEL_CATEGORY_ORDER => l_channel_category_order,

Line 73: AMV_C_CATEGORIES_PKG.INSERT_ROW (

69: END IF;
70:
71: exception
72: when NO_DATA_FOUND then
73: AMV_C_CATEGORIES_PKG.INSERT_ROW (
74: X_ROWID => l_row_id,
75: X_CHANNEL_CATEGORY_ID => l_channel_category_id,
76: X_APPLICATION_ID => l_application_id,
77: X_OBJECT_VERSION_NUMBER => l_object_version_number,

Line 449: end AMV_C_CATEGORIES_PKG;

445: where T.CHANNEL_CATEGORY_ID = B.CHANNEL_CATEGORY_ID
446: and T.LANGUAGE = L.LANGUAGE_CODE);
447: end ADD_LANGUAGE;
448:
449: end AMV_C_CATEGORIES_PKG;