APPS.ICX_CAT_POPULATE_CATG_PVT dependencies on ICX_CAT_POPULATE_CATG_PVT

Line 1: PACKAGE BODY ICX_CAT_POPULATE_CATG_PVT AS

1: PACKAGE BODY ICX_CAT_POPULATE_CATG_PVT AS
2: /* $Header: ICXVPPCB.pls 120.3 2006/06/26 23:22:34 sbgeorge noship $*/
3:
4: -- Constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_CATG_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_CATG_PVT';

1: PACKAGE BODY ICX_CAT_POPULATE_CATG_PVT AS
2: /* $Header: ICXVPPCB.pls 120.3 2006/06/26 23:22:34 sbgeorge noship $*/
3:
4: -- Constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_CATG_PVT';
6: TYPE g_item_csr_type IS REF CURSOR;
7:
8: gTotalRowCount PLS_INTEGER:= 0;
9:

Line 898: IF (g_DML_TYPE = ICX_CAT_POPULATE_CATG_PVT.g_DML_INSERT_TYPE AND

894:
895: l_err_loc := 1300;
896: -- The pl/sql table used to create mappings. Need only one row for a language
897: -- the mapping rows will be populated only if this was a create category action
898: IF (g_DML_TYPE = ICX_CAT_POPULATE_CATG_PVT.g_DML_INSERT_TYPE AND
899: g_auto_create_shop_catg = 'Y' AND
900: l_category_name_is_valid)
901: THEN
902: l_err_loc := 1400;

Line 1234: -- ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE is used to decide whether to create the mapping or not

1230: populateValidCategorySetDelete(P_OLD_CATEGORY_ID);
1231:
1232: l_err_loc := 600;
1233: -- TODO: Check this comment
1234: -- ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE is used to decide whether to create the mapping or not
1235: -- So when a validate category set is updated with a new category it is really a
1236: -- valid category set insert.
1237: ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE := ICX_CAT_POPULATE_CATG_PVT.g_DML_INSERT_TYPE;
1238:

Line 1237: ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE := ICX_CAT_POPULATE_CATG_PVT.g_DML_INSERT_TYPE;

1233: -- TODO: Check this comment
1234: -- ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE is used to decide whether to create the mapping or not
1235: -- So when a validate category set is updated with a new category it is really a
1236: -- valid category set insert.
1237: ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE := ICX_CAT_POPULATE_CATG_PVT.g_DML_INSERT_TYPE;
1238:
1239: l_err_loc := 700;
1240: openValidCategorySetCursor(P_NEW_CATEGORY_ID);
1241:

Line 1310: END ICX_CAT_POPULATE_CATG_PVT;

1306: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1307: g_auto_create_shop_catg := 'N';
1308: END setAutoCreateShopCatg;
1309:
1310: END ICX_CAT_POPULATE_CATG_PVT;