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

9: PROCEDURE create_sqes_for_zone
10: (
11: p_content_zone_id IN NUMBER,
12: p_supplier_attr_action_flag IN VARCHAR2,
13: p_supplier_ids IN ICX_TBL_NUMBER,
14: p_supplier_site_ids IN ICX_TBL_NUMBER,
15: p_items_without_supplier_flag IN VARCHAR2,
16: p_category_attr_action_flag IN VARCHAR2,
17: p_category_ids IN ICX_TBL_NUMBER,

Line 14: p_supplier_site_ids IN ICX_TBL_NUMBER,

10: (
11: p_content_zone_id IN NUMBER,
12: p_supplier_attr_action_flag IN VARCHAR2,
13: p_supplier_ids IN ICX_TBL_NUMBER,
14: p_supplier_site_ids IN ICX_TBL_NUMBER,
15: p_items_without_supplier_flag IN VARCHAR2,
16: p_category_attr_action_flag IN VARCHAR2,
17: p_category_ids IN ICX_TBL_NUMBER,
18: p_items_without_shop_catg_flag IN VARCHAR2,

Line 17: p_category_ids IN ICX_TBL_NUMBER,

13: p_supplier_ids IN ICX_TBL_NUMBER,
14: p_supplier_site_ids IN ICX_TBL_NUMBER,
15: p_items_without_supplier_flag IN VARCHAR2,
16: p_category_attr_action_flag IN VARCHAR2,
17: p_category_ids IN ICX_TBL_NUMBER,
18: p_items_without_shop_catg_flag IN VARCHAR2,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_sqe_sequence IN OUT NOCOPY NUMBER
21: );

Line 40: p_supplier_ids IN ICX_TBL_NUMBER,

36: -- one for purchasable only items and one for both
37: PROCEDURE construct_exprs_for_zone
38: (
39: p_supplier_attr_action_flag IN VARCHAR2,
40: p_supplier_ids IN ICX_TBL_NUMBER,
41: p_supplier_site_ids IN ICX_TBL_NUMBER,
42: p_items_without_supplier_flag IN VARCHAR2,
43: p_category_attr_action_flag IN VARCHAR2,
44: p_category_ids IN ICX_TBL_NUMBER,

Line 41: p_supplier_site_ids IN ICX_TBL_NUMBER,

37: PROCEDURE construct_exprs_for_zone
38: (
39: p_supplier_attr_action_flag IN VARCHAR2,
40: p_supplier_ids IN ICX_TBL_NUMBER,
41: p_supplier_site_ids IN ICX_TBL_NUMBER,
42: p_items_without_supplier_flag IN VARCHAR2,
43: p_category_attr_action_flag IN VARCHAR2,
44: p_category_ids IN ICX_TBL_NUMBER,
45: p_items_without_shop_catg_flag IN VARCHAR2,

Line 44: p_category_ids IN ICX_TBL_NUMBER,

40: p_supplier_ids IN ICX_TBL_NUMBER,
41: p_supplier_site_ids IN ICX_TBL_NUMBER,
42: p_items_without_supplier_flag IN VARCHAR2,
43: p_category_attr_action_flag IN VARCHAR2,
44: p_category_ids IN ICX_TBL_NUMBER,
45: p_items_without_shop_catg_flag IN VARCHAR2,
46: x_int_intermedia_expression OUT NOCOPY VARCHAR2,
47: x_purch_intermedia_expression OUT NOCOPY VARCHAR2,
48: x_both_intermedia_expression OUT NOCOPY VARCHAR2

Line 56: p_supplier_ids IN ICX_TBL_NUMBER,

52: -- takes in the required parameters and returns the supplier and site expression
53: PROCEDURE construct_supp_and_site_expr
54: (
55: p_supplier_attr_action_flag IN VARCHAR2,
56: p_supplier_ids IN ICX_TBL_NUMBER,
57: p_supplier_site_ids IN ICX_TBL_NUMBER,
58: p_items_without_supplier_flag IN VARCHAR2,
59: x_supplier_and_site_expr OUT NOCOPY VARCHAR2
60: );

Line 57: p_supplier_site_ids IN ICX_TBL_NUMBER,

53: PROCEDURE construct_supp_and_site_expr
54: (
55: p_supplier_attr_action_flag IN VARCHAR2,
56: p_supplier_ids IN ICX_TBL_NUMBER,
57: p_supplier_site_ids IN ICX_TBL_NUMBER,
58: p_items_without_supplier_flag IN VARCHAR2,
59: x_supplier_and_site_expr OUT NOCOPY VARCHAR2
60: );
61:

Line 67: p_category_ids IN ICX_TBL_NUMBER,

63: -- takes in the required parameters and returns the category expression
64: PROCEDURE construct_category_expr
65: (
66: p_category_attr_action_flag IN VARCHAR2,
67: p_category_ids IN ICX_TBL_NUMBER,
68: p_items_without_shop_catg_flag IN VARCHAR2,
69: x_category_expr OUT NOCOPY VARCHAR2
70: );
71: