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 384: p_supplier_ids IN ICX_TBL_NUMBER,

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

Line 385: p_supplier_site_ids IN ICX_TBL_NUMBER,

381: PROCEDURE construct_supp_and_site_expr
382: (
383: p_supplier_attr_action_flag IN VARCHAR2,
384: p_supplier_ids IN ICX_TBL_NUMBER,
385: p_supplier_site_ids IN ICX_TBL_NUMBER,
386: p_items_without_supplier_flag IN VARCHAR2,
387: x_supplier_and_site_expr OUT NOCOPY VARCHAR2
388: )
389: IS

Line 556: p_category_ids IN ICX_TBL_NUMBER,

552: -- takes in the required parameters and returns the category expression
553: PROCEDURE construct_category_expr
554: (
555: p_category_attr_action_flag IN VARCHAR2,
556: p_category_ids IN ICX_TBL_NUMBER,
557: p_items_without_shop_catg_flag IN VARCHAR2,
558: x_category_expr OUT NOCOPY VARCHAR2
559: )
560: IS

Line 565: l_category_ids ICX_TBL_NUMBER;

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

Line 711: l_sqe_sequences ICX_TBL_NUMBER;

707: IS
708: l_api_name CONSTANT VARCHAR2(30) := 'purge_deleted_sqes';
709: l_log_string VARCHAR2(32000);
710: l_err_loc PLS_INTEGER;
711: l_sqe_sequences ICX_TBL_NUMBER;
712: BEGIN
713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: l_log_string := 'Starting purge_deleted_sqes';
715: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

Line 790: l_content_zone_ids ICX_TBL_NUMBER;

786: IS
787: l_api_name CONSTANT VARCHAR2(30) := 'sync_sqes_hier_change_internal';
788: l_log_string VARCHAR2(32000);
789: l_err_loc PLS_INTEGER;
790: l_content_zone_ids ICX_TBL_NUMBER;
791: l_content_zone_names ICX_TBL_VARCHAR240;
792: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
793: l_supplier_ids ICX_TBL_NUMBER;
794: l_supplier_site_ids ICX_TBL_NUMBER;

Line 793: l_supplier_ids ICX_TBL_NUMBER;

789: l_err_loc PLS_INTEGER;
790: l_content_zone_ids ICX_TBL_NUMBER;
791: l_content_zone_names ICX_TBL_VARCHAR240;
792: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
793: l_supplier_ids ICX_TBL_NUMBER;
794: l_supplier_site_ids ICX_TBL_NUMBER;
795: l_items_without_supplier_flags ICX_TBL_FLAG;
796: l_category_attr_action_flags ICX_TBL_VARCHAR40;
797: l_category_ids ICX_TBL_NUMBER;

Line 794: l_supplier_site_ids ICX_TBL_NUMBER;

790: l_content_zone_ids ICX_TBL_NUMBER;
791: l_content_zone_names ICX_TBL_VARCHAR240;
792: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
793: l_supplier_ids ICX_TBL_NUMBER;
794: l_supplier_site_ids ICX_TBL_NUMBER;
795: l_items_without_supplier_flags ICX_TBL_FLAG;
796: l_category_attr_action_flags ICX_TBL_VARCHAR40;
797: l_category_ids ICX_TBL_NUMBER;
798: l_items_without_shop_cat_flags ICX_TBL_FLAG;

Line 797: l_category_ids ICX_TBL_NUMBER;

793: l_supplier_ids ICX_TBL_NUMBER;
794: l_supplier_site_ids ICX_TBL_NUMBER;
795: l_items_without_supplier_flags ICX_TBL_FLAG;
796: l_category_attr_action_flags ICX_TBL_VARCHAR40;
797: l_category_ids ICX_TBL_NUMBER;
798: l_items_without_shop_cat_flags ICX_TBL_FLAG;
799: l_sqe_sequences ICX_TBL_NUMBER;
800: l_return_status VARCHAR2(1);
801: l_current_sqe_sequence NUMBER;

Line 799: l_sqe_sequences ICX_TBL_NUMBER;

795: l_items_without_supplier_flags ICX_TBL_FLAG;
796: l_category_attr_action_flags ICX_TBL_VARCHAR40;
797: l_category_ids ICX_TBL_NUMBER;
798: l_items_without_shop_cat_flags ICX_TBL_FLAG;
799: l_sqe_sequences ICX_TBL_NUMBER;
800: l_return_status VARCHAR2(1);
801: l_current_sqe_sequence NUMBER;
802: l_first_errored_zone PLS_INTEGER;
803: BEGIN

Line 1080: l_content_zone_ids ICX_TBL_NUMBER;

1076: IS
1077: l_api_name CONSTANT VARCHAR2(30) := 'sync_sqes_for_all_zones';
1078: l_log_string VARCHAR2(32000);
1079: l_err_loc PLS_INTEGER;
1080: l_content_zone_ids ICX_TBL_NUMBER;
1081: l_content_zone_names ICX_TBL_VARCHAR240;
1082: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
1083: l_supplier_ids ICX_TBL_NUMBER;
1084: l_supplier_site_ids ICX_TBL_NUMBER;

Line 1083: l_supplier_ids ICX_TBL_NUMBER;

1079: l_err_loc PLS_INTEGER;
1080: l_content_zone_ids ICX_TBL_NUMBER;
1081: l_content_zone_names ICX_TBL_VARCHAR240;
1082: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
1083: l_supplier_ids ICX_TBL_NUMBER;
1084: l_supplier_site_ids ICX_TBL_NUMBER;
1085: l_items_without_supplier_flags ICX_TBL_FLAG;
1086: l_category_attr_action_flags ICX_TBL_VARCHAR40;
1087: l_category_ids ICX_TBL_NUMBER;

Line 1084: l_supplier_site_ids ICX_TBL_NUMBER;

1080: l_content_zone_ids ICX_TBL_NUMBER;
1081: l_content_zone_names ICX_TBL_VARCHAR240;
1082: l_supplier_attr_action_flags ICX_TBL_VARCHAR40;
1083: l_supplier_ids ICX_TBL_NUMBER;
1084: l_supplier_site_ids ICX_TBL_NUMBER;
1085: l_items_without_supplier_flags ICX_TBL_FLAG;
1086: l_category_attr_action_flags ICX_TBL_VARCHAR40;
1087: l_category_ids ICX_TBL_NUMBER;
1088: l_items_without_shop_cat_flags ICX_TBL_FLAG;

Line 1087: l_category_ids ICX_TBL_NUMBER;

1083: l_supplier_ids ICX_TBL_NUMBER;
1084: l_supplier_site_ids ICX_TBL_NUMBER;
1085: l_items_without_supplier_flags ICX_TBL_FLAG;
1086: l_category_attr_action_flags ICX_TBL_VARCHAR40;
1087: l_category_ids ICX_TBL_NUMBER;
1088: l_items_without_shop_cat_flags ICX_TBL_FLAG;
1089: l_sqe_sequences ICX_TBL_NUMBER;
1090: l_return_status VARCHAR2(1);
1091: l_current_sqe_sequence NUMBER;

Line 1089: l_sqe_sequences ICX_TBL_NUMBER;

1085: l_items_without_supplier_flags ICX_TBL_FLAG;
1086: l_category_attr_action_flags ICX_TBL_VARCHAR40;
1087: l_category_ids ICX_TBL_NUMBER;
1088: l_items_without_shop_cat_flags ICX_TBL_FLAG;
1089: l_sqe_sequences ICX_TBL_NUMBER;
1090: l_return_status VARCHAR2(1);
1091: l_current_sqe_sequence NUMBER;
1092: l_request_id NUMBER;
1093: l_errored_zone_name_list VARCHAR2(4000);