APPS.AMW_COMPLIANCE_ENV_ASSOCS_PVT dependencies on AMW_COMPLIANCE_ENV_ASSOCS

Line 1: PACKAGE BODY AMW_COMPLIANCE_ENV_ASSOCS_PVT as

1: PACKAGE BODY AMW_COMPLIANCE_ENV_ASSOCS_PVT as
2: /* $Header: amwvenvb.pls 120.0 2005/05/31 23:30:18 appldev noship $ */
3:
4: -- ===============================================================
5: -- Function name

Line 27: from amw_compliance_env_assocs

23: n number;
24: BEGIN
25: select count(*)
26: into n
27: from amw_compliance_env_assocs
28: where pk1 = p_pk1
29: and object_type = p_object_type
30: and compliance_env_id = p_compliance_env_id;
31:

Line 63: from amw_compliance_env_assocs

59: no varchar2(80);
60: BEGIN
61: select count(*)
62: into n
63: from amw_compliance_env_assocs
64: where pk1 = p_pk1
65: and object_type = p_object_type
66: and compliance_env_id = p_compliance_env_id;
67:

Line 124: from amw_compliance_env_assocs

120:
121: -- find out is the parent of specified setup risk type is associated this env already
122: cursor is_associated_env_c (l_setup_risk_type_id IN NUMBER) is
123: SELECT count(*)
124: from amw_compliance_env_assocs
125: where pk1 = l_setup_risk_type_id
126: and object_type = 'SETUP_RISK_TYPE'
127: and compliance_env_id = p_compliance_env_id;
128:

Line 132: from amw_compliance_env_assocs

128:
129: -- 12.09.2004 tsho: find out is the direct children of specified setup risk type is associated this env already
130: cursor is_child_associated_env_c (l_setup_risk_type_id IN NUMBER) is
131: SELECT count(*)
132: from amw_compliance_env_assocs
133: where pk1 in (
134: select b.setup_risk_type_id
135: from amw_setup_risk_types_b b
136: where b.parent_setup_risk_type_id = l_setup_risk_type_id

Line 259: delete from amw_compliance_env_assocs

255:
256: -- initialize return status to success
257: x_return_status := fnd_api.g_ret_sts_success;
258:
259: delete from amw_compliance_env_assocs
260: where pk1 = p_pk1
261: and object_type = p_object_type
262: and compliance_env_id = p_compliance_env_id;
263:

Line 274: insert into amw_compliance_env_assocs (compliance_env_assoc_id,

270: l_object_version_number := 1;
271:
272: select amw_compliance_env_assoc_s.nextval into l_compliance_env_assoc_id from dual;
273:
274: insert into amw_compliance_env_assocs (compliance_env_assoc_id,
275: compliance_env_id,
276: object_type,
277: pk1,
278: pk2,

Line 322: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_COMPLIANCE_ENV_ASSOCS_PVT',

318: END IF;
319:
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321:
322: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_COMPLIANCE_ENV_ASSOCS_PVT',
323: p_procedure_name => 'PROCESS_COMPLIANCE_ENV_ASSOCS',
324: p_error_text => SUBSTRB(SQLERRM,1,240));
325:
326: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 341: -- as long as it appears in amw_compliance_env_assocs table,

337: -- selected(associated) Compliance Environment is used for assoication
338: -- if it's in used, return 'Y', else, return 'N'.
339: -- Notes
340: -- don't need to bother which p_object_type it's associated with.
341: -- as long as it appears in amw_compliance_env_assocs table,
342: -- the return value will be 'Y'.
343: -- ===============================================================
344: FUNCTION COMPLIANCE_ENVS_IN_USE (
345: p_compliance_env_id IN NUMBER

Line 352: from amw_compliance_env_assocs

348: n number;
349: BEGIN
350: select count(*)
351: into n
352: from amw_compliance_env_assocs
353: where compliance_env_id = p_compliance_env_id;
354:
355: if n > 0 then
356: return 'Y';

Line 364: END AMW_COMPLIANCE_ENV_ASSOCS_PVT;

360: END COMPLIANCE_ENVS_IN_USE;
361:
362:
363: -- ----------------------------------------------------------------------
364: END AMW_COMPLIANCE_ENV_ASSOCS_PVT;
365: