APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_EFFECTIVITY_SETS

Line 1842: FROM CZ_EFFECTIVITY_SETS

1838: l_effective_until := CZ_UTILS.EPOCH_BEGIN_;
1839: ELSE
1840: SELECT effective_from,effective_until
1841: INTO l_effective_from,l_effective_until
1842: FROM CZ_EFFECTIVITY_SETS
1843: WHERE effectivity_set_id = i.EFFECTIVITY_SET_ID;
1844:
1845: IF l_effective_from = CZ_UTILS.EPOCH_END_ AND
1846: l_effective_until = CZ_UTILS.EPOCH_BEGIN_ THEN

Line 5043: x_new_effectivity_set_id := allocateId('CZ_EFFECTIVITY_SETS_S');

5039: l_name cz_rp_entries.name%TYPE;
5040: BEGIN
5041: FND_MSG_PUB.initialize;
5042: x_return_status := FND_API.G_RET_STS_SUCCESS;
5043: x_new_effectivity_set_id := allocateId('CZ_EFFECTIVITY_SETS_S');
5044: l_name := copy_name(p_effectivity_set_id,'EFF');
5045: INSERT INTO CZ_RP_ENTRIES
5046: (
5047: OBJECT_TYPE

Line 5073: INSERT INTO CZ_EFFECTIVITY_SETS

5069: IF SQL%ROWCOUNT = 0 THEN
5070: RAISE INVALID_EFF_SET_ID_EXCP;
5071: END IF;
5072:
5073: INSERT INTO CZ_EFFECTIVITY_SETS
5074: (
5075: EFFECTIVITY_SET_ID
5076: ,NAME
5077: ,DESCRIPTION

Line 5107: FROM CZ_EFFECTIVITY_SETS

5103: ,USER_NUM02
5104: ,USER_NUM03
5105: ,USER_NUM04
5106: ,DELETED_FLAG
5107: FROM CZ_EFFECTIVITY_SETS
5108: WHERE effectivity_set_id = p_effectivity_set_id;
5109:
5110: IF SQL%ROWCOUNT = 0 THEN
5111: RAISE INVALID_EFF_SET_ID_EXCP;

Line 6475: UPDATE cz_effectivity_sets

6471: x_msg_data := '';
6472:
6473: is_eff_set_deleteable(p_eff_set_id,l_return_status,l_msg_count,l_msg_data);
6474: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6475: UPDATE cz_effectivity_sets
6476: SET deleted_flag = '1',
6477: name = append_name(p_eff_set_id, 'EFF', name)
6478: WHERE effectivity_set_id = p_eff_set_id;
6479:

Line 8411: UPDATE cz_effectivity_sets

8407: UPDATE cz_archives
8408: SET deleted_flag = '1'
8409: WHERE archive_id = l_object_id_tbl(i);
8410: ELSIF (l_object_typ_tbl(i) = 'EFF') THEN
8411: UPDATE cz_effectivity_sets
8412: SET deleted_flag = '1'
8413: WHERE effectivity_set_id = l_object_id_tbl(i);
8414: ELSIF (l_object_typ_tbl(i) = 'PRP') THEN
8415: UPDATE cz_properties

Line 11600: FROM cz_effectivity_sets

11596: v_eff_until := h_eff_until(v_eff_set_id);
11597: ELSE
11598:
11599: SELECT effective_from, effective_until INTO v_eff_from, v_eff_until
11600: FROM cz_effectivity_sets
11601: WHERE deleted_flag = '0'
11602: AND effectivity_set_id = v_eff_set_id;
11603:
11604: h_eff_from(v_eff_set_id) := v_eff_from;

Line 11701: FROM cz_effectivity_sets

11697: v_eff_until := h_eff_until(v_eff_set_id);
11698: ELSE
11699:
11700: SELECT effective_from, effective_until INTO v_eff_from, v_eff_until
11701: FROM cz_effectivity_sets
11702: WHERE deleted_flag = '0'
11703: AND effectivity_set_id = v_eff_set_id;
11704:
11705: h_eff_from(v_eff_set_id) := v_eff_from;

Line 11751: FROM cz_effectivity_sets

11747: v_eff_until := h_eff_until(v_eff_set_id);
11748: ELSE
11749:
11750: SELECT effective_from, effective_until INTO v_eff_from, v_eff_until
11751: FROM cz_effectivity_sets
11752: WHERE deleted_flag = '0'
11753: AND effectivity_set_id = v_eff_set_id;
11754:
11755: h_eff_from(v_eff_set_id) := v_eff_from;