APPS.ICX_TAG dependencies on AK_QUERY_PKG

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

45:
46: v_order_by := 'TAG_NAME';
47: /*****Prints the tags ******/
48:
49: ak_query_pkg.exec_query( P_PARENT_REGION_APPL_ID => 601,
50: P_PARENT_REGION_CODE => 'ICX_TEMPL_TAG_HDR_R',
51: P_ORDER_BY_CLAUSE => v_order_by,
52: P_RESPONSIBILITY_ID => icx_sec.getID( icx_sec.PV_RESPONSIBILITY_ID ),
53: P_USER_ID => icx_sec.getID( icx_sec.PV_WEB_USER_ID ),

Line 56: if ak_query_pkg.g_results_table.COUNT > 0 then

52: P_RESPONSIBILITY_ID => icx_sec.getID( icx_sec.PV_RESPONSIBILITY_ID ),
53: P_USER_ID => icx_sec.getID( icx_sec.PV_WEB_USER_ID ),
54: P_RETURN_PARENTS => 'T');
55:
56: if ak_query_pkg.g_results_table.COUNT > 0 then
57:
58:
59: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
60:

Line 59: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop

55:
56: if ak_query_pkg.g_results_table.COUNT > 0 then
57:
58:
59: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
60:
61: icx_util.transfer_row_to_column(ak_query_pkg.g_results_table(i),v_line_table);
62:
63: for k in ak_query_pkg.g_items_table.first..ak_query_pkg.g_items_table.last loop

Line 61: icx_util.transfer_row_to_column(ak_query_pkg.g_results_table(i),v_line_table);

57:
58:
59: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
60:
61: icx_util.transfer_row_to_column(ak_query_pkg.g_results_table(i),v_line_table);
62:
63: for k in ak_query_pkg.g_items_table.first..ak_query_pkg.g_items_table.last loop
64:
65: if ak_query_pkg.g_items_table(k).secured_column = 'F' and

Line 63: for k in ak_query_pkg.g_items_table.first..ak_query_pkg.g_items_table.last loop

59: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
60:
61: icx_util.transfer_row_to_column(ak_query_pkg.g_results_table(i),v_line_table);
62:
63: for k in ak_query_pkg.g_items_table.first..ak_query_pkg.g_items_table.last loop
64:
65: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
66: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' and
67: ak_query_pkg.g_items_table(k).value_id is not NULL then

Line 65: if ak_query_pkg.g_items_table(k).secured_column = 'F' and

61: icx_util.transfer_row_to_column(ak_query_pkg.g_results_table(i),v_line_table);
62:
63: for k in ak_query_pkg.g_items_table.first..ak_query_pkg.g_items_table.last loop
64:
65: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
66: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' and
67: ak_query_pkg.g_items_table(k).value_id is not NULL then
68: v_tag_val := (v_line_table(ak_query_pkg.g_items_table(k).value_id));
69: htp.p(''||v_tag_val||'');

Line 66: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' and

62:
63: for k in ak_query_pkg.g_items_table.first..ak_query_pkg.g_items_table.last loop
64:
65: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
66: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' and
67: ak_query_pkg.g_items_table(k).value_id is not NULL then
68: v_tag_val := (v_line_table(ak_query_pkg.g_items_table(k).value_id));
69: htp.p(''||v_tag_val||'');
70: htp.p('
');

Line 67: ak_query_pkg.g_items_table(k).value_id is not NULL then

63: for k in ak_query_pkg.g_items_table.first..ak_query_pkg.g_items_table.last loop
64:
65: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
66: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' and
67: ak_query_pkg.g_items_table(k).value_id is not NULL then
68: v_tag_val := (v_line_table(ak_query_pkg.g_items_table(k).value_id));
69: htp.p(''||v_tag_val||'');
70: htp.p('
');
71:

Line 68: v_tag_val := (v_line_table(ak_query_pkg.g_items_table(k).value_id));

64:
65: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
66: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' and
67: ak_query_pkg.g_items_table(k).value_id is not NULL then
68: v_tag_val := (v_line_table(ak_query_pkg.g_items_table(k).value_id));
69: htp.p(''||v_tag_val||'');
70: htp.p('
');
71:
72: end if;