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.AMW_SCOPE_PVT dependencies on AMW_AUDIT_UNITS_V

Line 98: l_sub_code amw_audit_units_v.company_code%TYPE;

94: found_org_parent BOOLEAN;
95: is_root_node BOOLEAN;
96:
97: l_sub_exists VARCHAR2(1);
98: l_sub_code amw_audit_units_v.company_code%TYPE;
99: l_temp_sub_id NUMBER;
100: l_temp_sub_parent_id NUMBER;
101: l_sub_recursive_parent NUMBER;
102:

Line 104: l_lob_code amw_audit_units_v.lob_code%TYPE;

100: l_temp_sub_parent_id NUMBER;
101: l_sub_recursive_parent NUMBER;
102:
103: l_lob_exists VARCHAR2(1);
104: l_lob_code amw_audit_units_v.lob_code%TYPE;
105: l_lob_recursive_parent NUMBER;
106: l_temp_lob_id NUMBER;
107: l_temp_lob_parent_id NUMBER;
108: found_lob_parent BOOLEAN;

Line 126: FROM amw_audit_units_v auv,fnd_flex_values flv

122: l_msg_data VARCHAR2(32767);
123:
124: CURSOR find_parent_subsidiary(l_organization_id NUMBER) IS
125: SELECT flv.flex_value_id
126: FROM amw_audit_units_v auv,fnd_flex_values flv
127: WHERE auv.subsidiary_valueset = flv.flex_value_set_id
128: AND auv.company_code = flv.flex_value
129: AND organization_id = l_organization_id;
130:

Line 133: FROM amw_audit_units_v auv,fnd_flex_values flv

129: AND organization_id = l_organization_id;
130:
131: CURSOR find_parent_lob(l_organization_id NUMBER) IS
132: SELECT flv.flex_value_id
133: FROM amw_audit_units_v auv,fnd_flex_values flv
134: WHERE auv.lob_valueset = flv.flex_value_set_id
135: AND auv.lob_code = flv.flex_value
136: AND organization_id = l_organization_id;
137:

Line 140: FROM AMW_AUDIT_UNITS_V

136: AND organization_id = l_organization_id;
137:
138: CURSOR check_lob_exists (l_organization_id NUMBER) IS
139: SELECT 'Y'
140: FROM AMW_AUDIT_UNITS_V
141: --WHERE LOB_valueset = p_LOB_vs
142: WHERE LOB_valueset IS NOT NULL
143: AND organization_id = l_organization_id;
144:

Line 884: FROM amw_audit_units_v auv,fnd_flex_values flv

880: IS
881:
882: l_get_subsidiary_query VARCHAR2(32767) :=
883: 'SELECT DISTINCT flv.flex_value_id
884: FROM amw_audit_units_v auv,fnd_flex_values flv
885: WHERE auv.subsidiary_valueset = flv.flex_value_set_id
886: AND auv.company_code = flv.flex_value';
887:
888:

Line 949: FROM amw_audit_units_v auv,fnd_flex_values flv

945: lobs_cursor lobcurtype;
946:
947: l_get_lob_query VARCHAR2(32767) :=
948: 'SELECT DISTINCT flv.flex_value_id
949: FROM amw_audit_units_v auv,fnd_flex_values flv
950: WHERE auv.lob_valueset = flv.flex_value_set_id
951: AND auv.lob_code = flv.flex_value';
952:
953: l_extra_query VARCHAR2(32767);

Line 1018: FROM amw_audit_units_v audit_v

1014: audit_v.subsidiary_valueset,
1015: audit_v.lob_code,
1016: audit_v.lob_valueset,
1017: audit_v.organization_id
1018: FROM amw_audit_units_v audit_v
1019: WHERE organization_id = p_org_id;
1020:
1021: CURSOR c_sub_lob_exists (l_sub_vs amw_audit_units_v.subsidiary_valueset%TYPE,
1022: l_sub_code amw_audit_units_v.company_code%TYPE,

Line 1021: CURSOR c_sub_lob_exists (l_sub_vs amw_audit_units_v.subsidiary_valueset%TYPE,

1017: audit_v.organization_id
1018: FROM amw_audit_units_v audit_v
1019: WHERE organization_id = p_org_id;
1020:
1021: CURSOR c_sub_lob_exists (l_sub_vs amw_audit_units_v.subsidiary_valueset%TYPE,
1022: l_sub_code amw_audit_units_v.company_code%TYPE,
1023: l_lob_vs amw_audit_units_v.lob_valueset%TYPE,
1024: l_lob_code amw_audit_units_v.lob_code%TYPE)
1025: IS

Line 1022: l_sub_code amw_audit_units_v.company_code%TYPE,

1018: FROM amw_audit_units_v audit_v
1019: WHERE organization_id = p_org_id;
1020:
1021: CURSOR c_sub_lob_exists (l_sub_vs amw_audit_units_v.subsidiary_valueset%TYPE,
1022: l_sub_code amw_audit_units_v.company_code%TYPE,
1023: l_lob_vs amw_audit_units_v.lob_valueset%TYPE,
1024: l_lob_code amw_audit_units_v.lob_code%TYPE)
1025: IS
1026: SELECT 'Y'

Line 1023: l_lob_vs amw_audit_units_v.lob_valueset%TYPE,

1019: WHERE organization_id = p_org_id;
1020:
1021: CURSOR c_sub_lob_exists (l_sub_vs amw_audit_units_v.subsidiary_valueset%TYPE,
1022: l_sub_code amw_audit_units_v.company_code%TYPE,
1023: l_lob_vs amw_audit_units_v.lob_valueset%TYPE,
1024: l_lob_code amw_audit_units_v.lob_code%TYPE)
1025: IS
1026: SELECT 'Y'
1027: FROM amw_audit_units_v

Line 1024: l_lob_code amw_audit_units_v.lob_code%TYPE)

1020:
1021: CURSOR c_sub_lob_exists (l_sub_vs amw_audit_units_v.subsidiary_valueset%TYPE,
1022: l_sub_code amw_audit_units_v.company_code%TYPE,
1023: l_lob_vs amw_audit_units_v.lob_valueset%TYPE,
1024: l_lob_code amw_audit_units_v.lob_code%TYPE)
1025: IS
1026: SELECT 'Y'
1027: FROM amw_audit_units_v
1028: WHERE subsidiary_valueset = l_sub_vs

Line 1027: FROM amw_audit_units_v

1023: l_lob_vs amw_audit_units_v.lob_valueset%TYPE,
1024: l_lob_code amw_audit_units_v.lob_code%TYPE)
1025: IS
1026: SELECT 'Y'
1027: FROM amw_audit_units_v
1028: WHERE subsidiary_valueset = l_sub_vs
1029: AND company_code = l_sub_code
1030: AND lob_valueset = l_lob_vs
1031: AND lob_code = l_lob_code;

Line 1047: FROM amw_curr_app_hierarchy_org_v org_v,amw_audit_units_v audit_v

1043: audit_v.company_code,
1044: audit_v.subsidiary_valueset,
1045: audit_v.lob_code,
1046: audit_v.lob_valueset
1047: FROM amw_curr_app_hierarchy_org_v org_v,amw_audit_units_v audit_v
1048: WHERE org_v.parent_process_id = -2
1049: AND audit_v.organization_id = org_v.child_organization_id
1050: AND audit_v.organization_id =';
1051:

Line 1058: l_company_code amw_audit_units_v.company_code%TYPE;

1054:
1055: l_process_id NUMBER;
1056: l_process_org_rev_id NUMBER;
1057: l_organization_id NUMBER;
1058: l_company_code amw_audit_units_v.company_code%TYPE;
1059: l_subsidiary_valueset amw_audit_units_v.subsidiary_valueset%TYPE;
1060: l_lob_code amw_audit_units_v.lob_code%TYPE;
1061: l_lob_valueset amw_audit_units_v.lob_valueset%TYPE;
1062:

Line 1059: l_subsidiary_valueset amw_audit_units_v.subsidiary_valueset%TYPE;

1055: l_process_id NUMBER;
1056: l_process_org_rev_id NUMBER;
1057: l_organization_id NUMBER;
1058: l_company_code amw_audit_units_v.company_code%TYPE;
1059: l_subsidiary_valueset amw_audit_units_v.subsidiary_valueset%TYPE;
1060: l_lob_code amw_audit_units_v.lob_code%TYPE;
1061: l_lob_valueset amw_audit_units_v.lob_valueset%TYPE;
1062:
1063: l_sub_lob_exists VARCHAR2(1);

Line 1060: l_lob_code amw_audit_units_v.lob_code%TYPE;

1056: l_process_org_rev_id NUMBER;
1057: l_organization_id NUMBER;
1058: l_company_code amw_audit_units_v.company_code%TYPE;
1059: l_subsidiary_valueset amw_audit_units_v.subsidiary_valueset%TYPE;
1060: l_lob_code amw_audit_units_v.lob_code%TYPE;
1061: l_lob_valueset amw_audit_units_v.lob_valueset%TYPE;
1062:
1063: l_sub_lob_exists VARCHAR2(1);
1064:

Line 1061: l_lob_valueset amw_audit_units_v.lob_valueset%TYPE;

1057: l_organization_id NUMBER;
1058: l_company_code amw_audit_units_v.company_code%TYPE;
1059: l_subsidiary_valueset amw_audit_units_v.subsidiary_valueset%TYPE;
1060: l_lob_code amw_audit_units_v.lob_code%TYPE;
1061: l_lob_valueset amw_audit_units_v.lob_valueset%TYPE;
1062:
1063: l_sub_lob_exists VARCHAR2(1);
1064:
1065: BEGIN

Line 3149: FROM amw_audit_units_v audit_v;

3145: IS
3146: CURSOR all_auditable_units
3147: IS
3148: SELECT audit_v.company_code,audit_v.lob_code,audit_v.organization_id
3149: FROM amw_audit_units_v audit_v;
3150:
3151: CURSOR get_all_processes(p_org_id NUMBER)
3152: IS
3153: SELECT DISTINCT org_v.child_process_id as process_id

Line 3154: FROM amw_curr_app_hierarchy_org_v org_v,amw_audit_units_v audit_v

3150:
3151: CURSOR get_all_processes(p_org_id NUMBER)
3152: IS
3153: SELECT DISTINCT org_v.child_process_id as process_id
3154: FROM amw_curr_app_hierarchy_org_v org_v,amw_audit_units_v audit_v
3155: WHERE org_v.parent_process_id = -2
3156: AND audit_v.organization_id = org_v.child_organization_id
3157: AND audit_v.organization_id = p_org_id;
3158:

Line 3159: l_sub_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;

3155: WHERE org_v.parent_process_id = -2
3156: AND audit_v.organization_id = org_v.child_organization_id
3157: AND audit_v.organization_id = p_org_id;
3158:
3159: l_sub_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;
3160: l_lob_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;
3161: l_sub_tbl sub_tbl_type;
3162: l_lob_tbl lob_tbl_type;
3163: l_org_tbl org_tbl_type;

Line 3160: l_lob_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;

3156: AND audit_v.organization_id = org_v.child_organization_id
3157: AND audit_v.organization_id = p_org_id;
3158:
3159: l_sub_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;
3160: l_lob_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;
3161: l_sub_tbl sub_tbl_type;
3162: l_lob_tbl lob_tbl_type;
3163: l_org_tbl org_tbl_type;
3164: l_process_tbl process_tbl_type;

Line 3514: FROM amw_audit_units_v audit_v

3510: audit_v.subsidiary_valueset,
3511: audit_v.lob_code,
3512: audit_v.lob_valueset,
3513: audit_v.organization_id
3514: FROM amw_audit_units_v audit_v
3515: WHERE organization_id = p_org_id;
3516:
3517: BEGIN
3518:

Line 3924: FROM amw_audit_units_v au, amw_execution_scope es

3920: g_user_id,
3921: sysdate,
3922: g_login_id,
3923: 1
3924: FROM amw_audit_units_v au, amw_execution_scope es
3925: WHERE au.organization_id = es.organization_id
3926: AND es.entity_type = 'PROJECT'
3927: AND es.entity_id = p_audit_project_id
3928: AND es.level_id = 3