eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_CAT_SQE_PVT dependencies on ICX_TBL_NUMBER

Line 16: p_supplier_ids IN ICX_TBL_NUMBER,

12: PROCEDURE create_sqes_for_zone
13: (
14: p_content_zone_id IN NUMBER,
15: p_supplier_attr_action_flag IN VARCHAR2,
16: p_supplier_ids IN ICX_TBL_NUMBER,
17: p_supplier_site_ids IN ICX_TBL_NUMBER,
18: p_items_without_supplier_flag IN VARCHAR2,
19: p_category_attr_action_flag IN VARCHAR2,
20: p_category_ids IN ICX_TBL_NUMBER,

Line 17: p_supplier_site_ids IN ICX_TBL_NUMBER,

13: (
14: p_content_zone_id IN NUMBER,
15: p_supplier_attr_action_flag IN VARCHAR2,
16: p_supplier_ids IN ICX_TBL_NUMBER,
17: p_supplier_site_ids IN ICX_TBL_NUMBER,
18: p_items_without_supplier_flag IN VARCHAR2,
19: p_category_attr_action_flag IN VARCHAR2,
20: p_category_ids IN ICX_TBL_NUMBER,
21: p_items_without_shop_catg_flag IN VARCHAR2,

Line 20: p_category_ids IN ICX_TBL_NUMBER,

16: p_supplier_ids IN ICX_TBL_NUMBER,
17: p_supplier_site_ids IN ICX_TBL_NUMBER,
18: p_items_without_supplier_flag IN VARCHAR2,
19: p_category_attr_action_flag IN VARCHAR2,
20: p_category_ids IN ICX_TBL_NUMBER,
21: p_items_without_shop_catg_flag IN VARCHAR2,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_sqe_sequence IN OUT NOCOPY NUMBER
24: )

Line 213: p_supplier_ids IN ICX_TBL_NUMBER,

209: -- one for purchasable only items and one for both
210: PROCEDURE construct_exprs_for_zone
211: (
212: p_supplier_attr_action_flag IN VARCHAR2,
213: p_supplier_ids IN ICX_TBL_NUMBER,
214: p_supplier_site_ids IN ICX_TBL_NUMBER,
215: p_items_without_supplier_flag IN VARCHAR2,
216: p_category_attr_action_flag IN VARCHAR2,
217: p_category_ids IN ICX_TBL_NUMBER,

Line 214: p_supplier_site_ids IN ICX_TBL_NUMBER,

210: PROCEDURE construct_exprs_for_zone
211: (
212: p_supplier_attr_action_flag IN VARCHAR2,
213: p_supplier_ids IN ICX_TBL_NUMBER,
214: p_supplier_site_ids IN ICX_TBL_NUMBER,
215: p_items_without_supplier_flag IN VARCHAR2,
216: p_category_attr_action_flag IN VARCHAR2,
217: p_category_ids IN ICX_TBL_NUMBER,
218: p_items_without_shop_catg_flag IN VARCHAR2,

Line 217: p_category_ids IN ICX_TBL_NUMBER,

213: p_supplier_ids IN ICX_TBL_NUMBER,
214: p_supplier_site_ids IN ICX_TBL_NUMBER,
215: p_items_without_supplier_flag IN VARCHAR2,
216: p_category_attr_action_flag IN VARCHAR2,
217: p_category_ids IN ICX_TBL_NUMBER,
218: p_items_without_shop_catg_flag IN VARCHAR2,
219: x_int_intermedia_expression OUT NOCOPY VARCHAR2,
220: x_purch_intermedia_expression OUT NOCOPY VARCHAR2,
221: x_both_intermedia_expression OUT NOCOPY VARCHAR2

Line 380: p_supplier_ids IN ICX_TBL_NUMBER,

376: -- takes in the required parameters and returns the supplier and site expression
377: PROCEDURE construct_supp_and_site_expr
378: (
379: p_supplier_attr_action_flag IN VARCHAR2,
380: p_supplier_ids IN ICX_TBL_NUMBER,
381: p_supplier_site_ids IN ICX_TBL_NUMBER,
382: p_items_without_supplier_flag IN VARCHAR2,
383: x_supplier_and_site_expr OUT NOCOPY VARCHAR2
384: )

Line 381: p_supplier_site_ids IN ICX_TBL_NUMBER,

377: PROCEDURE construct_supp_and_site_expr
378: (
379: p_supplier_attr_action_flag IN VARCHAR2,
380: p_supplier_ids IN ICX_TBL_NUMBER,
381: p_supplier_site_ids IN ICX_TBL_NUMBER,
382: p_items_without_supplier_flag IN VARCHAR2,
383: x_supplier_and_site_expr OUT NOCOPY VARCHAR2
384: )
385: IS

Line 552: p_category_ids IN ICX_TBL_NUMBER,

548: -- takes in the required parameters and returns the category expression
549: PROCEDURE construct_category_expr
550: (
551: p_category_attr_action_flag IN VARCHAR2,
552: p_category_ids IN ICX_TBL_NUMBER,
553: p_items_without_shop_catg_flag IN VARCHAR2,
554: x_category_expr OUT NOCOPY VARCHAR2
555: )
556: IS

Line 561: l_category_ids ICX_TBL_NUMBER;

557: l_api_name CONSTANT VARCHAR2(30) := 'construct_category_expr';
558: l_log_string VARCHAR2(32000);
559: l_err_loc PLS_INTEGER;
560: l_exclude_expr VARCHAR2(100);
561: l_category_ids ICX_TBL_NUMBER;
562: l_category_id_list VARCHAR2(32000);
563: l_current_category_id_list VARCHAR2(32000);
564: BEGIN
565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 700: l_sqe_sequences ICX_TBL_NUMBER;

696: IS
697: l_api_name CONSTANT VARCHAR2(30) := 'purge_deleted_sqes';
698: l_log_string VARCHAR2(32000);
699: l_err_loc PLS_INTEGER;
700: l_sqe_sequences ICX_TBL_NUMBER;
701: BEGIN
702: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
703: l_log_string := 'Starting purge_deleted_sqes';
704: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

Line 779: l_content_zone_ids ICX_TBL_NUMBER;

775: IS
776: l_api_name CONSTANT VARCHAR2(30) := 'sync_sqes_hier_change_internal';
777: l_log_string VARCHAR2(32000);
778: l_err_loc PLS_INTEGER;
779: l_content_zone_ids ICX_TBL_NUMBER;
780: l_content_zone_names ICX_TBL_VARCHAR240;
781: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
782: l_supplier_ids ICX_TBL_NUMBER;
783: l_supplier_site_ids ICX_TBL_NUMBER;

Line 782: l_supplier_ids ICX_TBL_NUMBER;

778: l_err_loc PLS_INTEGER;
779: l_content_zone_ids ICX_TBL_NUMBER;
780: l_content_zone_names ICX_TBL_VARCHAR240;
781: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
782: l_supplier_ids ICX_TBL_NUMBER;
783: l_supplier_site_ids ICX_TBL_NUMBER;
784: l_items_without_supplier_flags ICX_TBL_FLAG;
785: l_category_attr_action_flags ICX_TBL_VARCHAR40;
786: l_category_ids ICX_TBL_NUMBER;

Line 783: l_supplier_site_ids ICX_TBL_NUMBER;

779: l_content_zone_ids ICX_TBL_NUMBER;
780: l_content_zone_names ICX_TBL_VARCHAR240;
781: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
782: l_supplier_ids ICX_TBL_NUMBER;
783: l_supplier_site_ids ICX_TBL_NUMBER;
784: l_items_without_supplier_flags ICX_TBL_FLAG;
785: l_category_attr_action_flags ICX_TBL_VARCHAR40;
786: l_category_ids ICX_TBL_NUMBER;
787: l_items_without_shop_cat_flags ICX_TBL_FLAG;

Line 786: l_category_ids ICX_TBL_NUMBER;

782: l_supplier_ids ICX_TBL_NUMBER;
783: l_supplier_site_ids ICX_TBL_NUMBER;
784: l_items_without_supplier_flags ICX_TBL_FLAG;
785: l_category_attr_action_flags ICX_TBL_VARCHAR40;
786: l_category_ids ICX_TBL_NUMBER;
787: l_items_without_shop_cat_flags ICX_TBL_FLAG;
788: l_sqe_sequences ICX_TBL_NUMBER;
789: l_return_status VARCHAR2(1);
790: l_current_sqe_sequence NUMBER;

Line 788: l_sqe_sequences ICX_TBL_NUMBER;

784: l_items_without_supplier_flags ICX_TBL_FLAG;
785: l_category_attr_action_flags ICX_TBL_VARCHAR40;
786: l_category_ids ICX_TBL_NUMBER;
787: l_items_without_shop_cat_flags ICX_TBL_FLAG;
788: l_sqe_sequences ICX_TBL_NUMBER;
789: l_return_status VARCHAR2(1);
790: l_current_sqe_sequence NUMBER;
791: l_first_errored_zone PLS_INTEGER;
792: BEGIN

Line 1069: l_content_zone_ids ICX_TBL_NUMBER;

1065: IS
1066: l_api_name CONSTANT VARCHAR2(30) := 'sync_sqes_for_all_zones';
1067: l_log_string VARCHAR2(32000);
1068: l_err_loc PLS_INTEGER;
1069: l_content_zone_ids ICX_TBL_NUMBER;
1070: l_content_zone_names ICX_TBL_VARCHAR240;
1071: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
1072: l_supplier_ids ICX_TBL_NUMBER;
1073: l_supplier_site_ids ICX_TBL_NUMBER;

Line 1072: l_supplier_ids ICX_TBL_NUMBER;

1068: l_err_loc PLS_INTEGER;
1069: l_content_zone_ids ICX_TBL_NUMBER;
1070: l_content_zone_names ICX_TBL_VARCHAR240;
1071: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
1072: l_supplier_ids ICX_TBL_NUMBER;
1073: l_supplier_site_ids ICX_TBL_NUMBER;
1074: l_items_without_supplier_flags ICX_TBL_FLAG;
1075: l_category_attr_action_flags ICX_TBL_VARCHAR40;
1076: l_category_ids ICX_TBL_NUMBER;

Line 1073: l_supplier_site_ids ICX_TBL_NUMBER;

1069: l_content_zone_ids ICX_TBL_NUMBER;
1070: l_content_zone_names ICX_TBL_VARCHAR240;
1071: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
1072: l_supplier_ids ICX_TBL_NUMBER;
1073: l_supplier_site_ids ICX_TBL_NUMBER;
1074: l_items_without_supplier_flags ICX_TBL_FLAG;
1075: l_category_attr_action_flags ICX_TBL_VARCHAR40;
1076: l_category_ids ICX_TBL_NUMBER;
1077: l_items_without_shop_cat_flags ICX_TBL_FLAG;

Line 1076: l_category_ids ICX_TBL_NUMBER;

1072: l_supplier_ids ICX_TBL_NUMBER;
1073: l_supplier_site_ids ICX_TBL_NUMBER;
1074: l_items_without_supplier_flags ICX_TBL_FLAG;
1075: l_category_attr_action_flags ICX_TBL_VARCHAR40;
1076: l_category_ids ICX_TBL_NUMBER;
1077: l_items_without_shop_cat_flags ICX_TBL_FLAG;
1078: l_sqe_sequences ICX_TBL_NUMBER;
1079: l_return_status VARCHAR2(1);
1080: l_current_sqe_sequence NUMBER;

Line 1078: l_sqe_sequences ICX_TBL_NUMBER;

1074: l_items_without_supplier_flags ICX_TBL_FLAG;
1075: l_category_attr_action_flags ICX_TBL_VARCHAR40;
1076: l_category_ids ICX_TBL_NUMBER;
1077: l_items_without_shop_cat_flags ICX_TBL_FLAG;
1078: l_sqe_sequences ICX_TBL_NUMBER;
1079: l_return_status VARCHAR2(1);
1080: l_current_sqe_sequence NUMBER;
1081: l_request_id NUMBER;
1082: l_errored_zone_name_list VARCHAR2(4000);