APPS.ICX_CATG dependencies on AK_QUERY_PKG

Line 40: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

36:
37: l_where_clause := icx_call.decrypt2(p_where);
38: l_region_code := 'ICX_CATG_DETLS_LOAD_R';
39:
40: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
41: P_PARENT_REGION_CODE => l_region_code,
42: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
43: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
44: P_WHERE_CLAUSE => l_where_clause,

Line 48: l_total_rows := ak_query_pkg.g_results_table.count;

44: P_WHERE_CLAUSE => l_where_clause,
45: P_RETURN_PARENTS => 'T',
46: P_RETURN_CHILDREN => 'F');
47:
48: l_total_rows := ak_query_pkg.g_results_table.count;
49:
50: IF l_total_rows = 0 THEN
51: -- Print the no data found message.
52: -- Do not spwan the spread sheet

Line 60: htp.title(ak_query_pkg.g_regions_table(0).name);

56: icx_util.copyright;
57: js.scriptOpen;
58: icx_admin_sig.help_win_script(v_help_url, v_language_code);
59: js.scriptClose;
60: htp.title(ak_query_pkg.g_regions_table(0).name);
61: htp.headClose;
62:
63: icx_admin_sig.toolbar(language_code => v_language_code,
64: disp_find => 'icx_store_catg_templates.find_categories');

Line 67: ak_query_pkg.g_regions_table(0).name);

63: icx_admin_sig.toolbar(language_code => v_language_code,
64: disp_find => 'icx_store_catg_templates.find_categories');
65: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
66: fnd_message.set_token('NAME_OF_REGION_TOKEN',
67: ak_query_pkg.g_regions_table(0).name);
68: htp.br;
69: htp.tableOpen('BORDER=0');
70: htp.tableRowOpen;
71: htp.tableData(cvalue => ''||fnd_message.get||'

Line 90: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP

86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');
87: htp.p(FND_MESSAGE.GET);
88: htp.p;
89:
90: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
91: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
92: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' )
93: OR (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN
94:

Line 91: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'

87: htp.p(FND_MESSAGE.GET);
88: htp.p;
89:
90: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
91: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
92: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' )
93: OR (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN
94:
95: l_line := l_line || ak_query_pkg.g_items_table(i).attribute_label_long || l_field_sep;

Line 92: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' )

88: htp.p;
89:
90: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
91: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
92: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' )
93: OR (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN
94:
95: l_line := l_line || ak_query_pkg.g_items_table(i).attribute_label_long || l_field_sep;
96:

Line 93: OR (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN

89:
90: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
91: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
92: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' )
93: OR (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN
94:
95: l_line := l_line || ak_query_pkg.g_items_table(i).attribute_label_long || l_field_sep;
96:
97: END IF; -- IF ak_query_pkg....

Line 95: l_line := l_line || ak_query_pkg.g_items_table(i).attribute_label_long || l_field_sep;

91: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
92: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' )
93: OR (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN
94:
95: l_line := l_line || ak_query_pkg.g_items_table(i).attribute_label_long || l_field_sep;
96:
97: END IF; -- IF ak_query_pkg....
98:
99: END LOOP;

Line 97: END IF; -- IF ak_query_pkg....

93: OR (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN
94:
95: l_line := l_line || ak_query_pkg.g_items_table(i).attribute_label_long || l_field_sep;
96:
97: END IF; -- IF ak_query_pkg....
98:
99: END LOOP;
100:
101: -- Print the line string

Line 105: FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP

101: -- Print the line string
102: htp.p(l_line);
103:
104: -- FOR r IN p_start_row -1..v_end_row - 1 LOOP
105: FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
106: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
107:
108: l_line := NULL;
109: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP

Line 106: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);

102: htp.p(l_line);
103:
104: -- FOR r IN p_start_row -1..v_end_row - 1 LOOP
105: FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
106: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
107:
108: l_line := NULL;
109: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
110: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'

Line 109: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP

105: FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
106: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
107:
108: l_line := NULL;
109: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
110: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
111: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
112: OR ( ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN
113:

Line 110: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'

106: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
107:
108: l_line := NULL;
109: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
110: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
111: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
112: OR ( ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN
113:
114: l_line := l_line || y_table(ak_query_pkg.g_items_table(i).value_id)

Line 111: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')

107:
108: l_line := NULL;
109: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
110: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
111: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
112: OR ( ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN
113:
114: l_line := l_line || y_table(ak_query_pkg.g_items_table(i).value_id)
115: || l_field_sep;

Line 112: OR ( ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN

108: l_line := NULL;
109: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
110: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
111: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
112: OR ( ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN
113:
114: l_line := l_line || y_table(ak_query_pkg.g_items_table(i).value_id)
115: || l_field_sep;
116: END IF; -- IF ... secured_column = 'F'...

Line 114: l_line := l_line || y_table(ak_query_pkg.g_items_table(i).value_id)

110: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
111: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
112: OR ( ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID') THEN
113:
114: l_line := l_line || y_table(ak_query_pkg.g_items_table(i).value_id)
115: || l_field_sep;
116: END IF; -- IF ... secured_column = 'F'...
117:
118: END LOOP; -- FOR i ...