APPS.AMW_COMPONENTS_PKG dependencies on AMW_ASSESSMENT_COMPONENTS

Line 16: from amw_assessment_components

12: -- 11.25.2003: use object_id and object_type instead
13: /*
14: select count(*)
15: into n
16: from amw_assessment_components
17: where assessment_id = P_ASSESSMENT_ID
18: and component_code = P_COMPONENT_CODE;
19: */
20: select count(*)

Line 22: from amw_assessment_components

18: and component_code = P_COMPONENT_CODE;
19: */
20: select count(*)
21: into n
22: from amw_assessment_components
23: where object_id = P_OBJECT_ID
24: and object_type = P_OBJECT_TYPE
25: and component_code = P_COMPONENT_CODE;
26:

Line 50: from amw_assessment_components

46: -- 11.25.2003: use object_id and object_type instead
47: /*
48: select count(*)
49: into n
50: from amw_assessment_components
51: where assessment_id = P_ASSESSMENT_ID
52: and component_code = P_COMPONENT_CODE;
53: */
54: select count(*)

Line 56: from amw_assessment_components

52: and component_code = P_COMPONENT_CODE;
53: */
54: select count(*)
55: into n
56: from amw_assessment_components
57: where object_id = P_OBJECT_ID
58: and object_type = P_OBJECT_TYPE
59: and component_code = P_COMPONENT_CODE;
60:

Line 123: delete from amw_assessment_components

119: x_return_status := fnd_api.g_ret_sts_success;
120:
121: -- 11.25.2003: use object_id and object_type instead
122: /*
123: delete from amw_assessment_components
124: where assessment_id = p_assessment_id
125: and component_code = p_component_code;
126: */
127: delete from amw_assessment_components

Line 127: delete from amw_assessment_components

123: delete from amw_assessment_components
124: where assessment_id = p_assessment_id
125: and component_code = p_component_code;
126: */
127: delete from amw_assessment_components
128: where object_id = p_object_id
129: and object_type = p_object_type
130: and component_code = p_component_code;
131:

Line 142: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;

138: l_last_updated_by := FND_GLOBAL.USER_ID;
139: l_last_update_login := FND_GLOBAL.USER_ID;
140: l_object_version_number := 1;
141:
142: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;
143:
144: insert into amw_assessment_components (assessment_component_id,
145: -- assessment_id, -- 11.25.2003 tsho: obseleted, use object_id and object_type instead
146: object_type, -- 11.25.2003: combined with object_id will replace assessment_id

Line 144: insert into amw_assessment_components (assessment_component_id,

140: l_object_version_number := 1;
141:
142: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;
143:
144: insert into amw_assessment_components (assessment_component_id,
145: -- assessment_id, -- 11.25.2003 tsho: obseleted, use object_id and object_type instead
146: object_type, -- 11.25.2003: combined with object_id will replace assessment_id
147: object_id, -- 11.25.2003: combined with object_type will replace assessment_id
148: component_code,