APPS.AK_QUERY_PKG dependencies on AK_RESP_SECURITY_ATTR_VALUES

Line 899: FROM AK_RESP_SECURITY_ATTR_VALUES arsav

895: AND awusav.attribute_code = p_attribute_code
896: union
897: SELECT nvl(to_char(number_value),
898: nvl(varchar2_value,to_char(date_value))) sec_value
899: FROM AK_RESP_SECURITY_ATTR_VALUES arsav
900: WHERE arsav.responsibility_id = p_responsibility_id
901: AND arsav.attribute_application_id = p_attribute_appl_id
902: AND arsav.attribute_code = p_attribute_code;
903:

Line 1049: -- ak_web_user_sec_attr_values or on the AK_RESP_SECURITY_ATTR_VALUES table.

1045: end if; -- end if display_node_flag = 'Y'
1046:
1047: --
1048: -- Item has secured VALUES if it was found on the
1049: -- ak_web_user_sec_attr_values or on the AK_RESP_SECURITY_ATTR_VALUES table.
1050: -- If found, then the
1051: -- record(s) will contain value(s) to use in the where clause
1052: -- to limit row selection. If item was suppose to have secured
1053: -- values, but none where found then create a where clause

Line 1128: || 'FROM AK_RESP_SECURITY_ATTR_VALUES arsav '

1124: || 'AND awusav.attribute_code = :BIND'
1125: || to_char(select_count) || 'ATTR_CODE '
1126: || 'union '
1127: || 'SELECT nvl(number_value,nvl(varchar2_value,date_value)) '
1128: || 'FROM AK_RESP_SECURITY_ATTR_VALUES arsav '
1129: || 'WHERE arsav.responsibility_id = :BIND'
1130: || to_char(select_count) || 'RESPONSIBILITY_ID '
1131: || 'AND arsav.attribute_application_id = :BIND'
1132: || to_char(select_count) || 'ATTR_APPL_ID '

Line 2643: FROM AK_RESP_SECURITY_ATTR_VALUES arsav

2639: AND awusav.attribute_code = p_attribute_code
2640: union
2641: SELECT nvl(to_char(number_value),
2642: nvl(varchar2_value,to_char(date_value))) sec_value
2643: FROM AK_RESP_SECURITY_ATTR_VALUES arsav
2644: WHERE arsav.responsibility_id = p_responsibility_id
2645: AND arsav.attribute_application_id = p_attribute_appl_id
2646: AND arsav.attribute_code = p_attribute_code;
2647:

Line 2706: -- ak_web_user_sec_attr_values table or ak_resp_security_attr_values table

2702:
2703: print_debug ( 'Secured Value is -> ' || select_rec.rls_column);
2704: --
2705: -- Item has secured VALUES if it was found on the
2706: -- ak_web_user_sec_attr_values table or ak_resp_security_attr_values table
2707: -- If found, then the
2708: -- record(s) will contain value(s) to use in the where clause
2709: -- to limit row selection. If item was suppose to have secured
2710: -- values, but none where found then create a where clause

Line 2731: FROM ak_resp_security_attr_values arsav

2727: ( date_value is not null and number_value is not null));
2728:
2729: SELECT count(*)
2730: INTO select_count2
2731: FROM ak_resp_security_attr_values arsav
2732: WHERE arsav.responsibility_id = p_responsibility_id
2733: AND arsav.attribute_application_id = select_rec.attribute_application_id
2734: AND arsav.attribute_code = select_rec.attribute_code
2735: AND (( varchar2_value is not null and date_value is not null) or