APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_EFFECTIVITY_SETS

Line 1870: FROM CZ_EFFECTIVITY_SETS

1866: l_effective_until := CZ_UTILS.EPOCH_BEGIN_;
1867: ELSE
1868: SELECT effective_from,effective_until
1869: INTO l_effective_from,l_effective_until
1870: FROM CZ_EFFECTIVITY_SETS
1871: WHERE effectivity_set_id = i.EFFECTIVITY_SET_ID;
1872:
1873: IF l_effective_from = CZ_UTILS.EPOCH_END_ AND
1874: l_effective_until = CZ_UTILS.EPOCH_BEGIN_ THEN

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

5068: l_name cz_rp_entries.name%TYPE;
5069: BEGIN
5070: FND_MSG_PUB.initialize;
5071: x_return_status := FND_API.G_RET_STS_SUCCESS;
5072: x_new_effectivity_set_id := allocateId('CZ_EFFECTIVITY_SETS_S');
5073: l_name := copy_name(p_effectivity_set_id,'EFF');
5074: INSERT INTO CZ_RP_ENTRIES
5075: (
5076: OBJECT_TYPE

Line 5102: INSERT INTO CZ_EFFECTIVITY_SETS

5098: IF SQL%ROWCOUNT = 0 THEN
5099: RAISE INVALID_EFF_SET_ID_EXCP;
5100: END IF;
5101:
5102: INSERT INTO CZ_EFFECTIVITY_SETS
5103: (
5104: EFFECTIVITY_SET_ID
5105: ,NAME
5106: ,DESCRIPTION

Line 5136: FROM CZ_EFFECTIVITY_SETS

5132: ,USER_NUM02
5133: ,USER_NUM03
5134: ,USER_NUM04
5135: ,DELETED_FLAG
5136: FROM CZ_EFFECTIVITY_SETS
5137: WHERE effectivity_set_id = p_effectivity_set_id;
5138:
5139: IF SQL%ROWCOUNT = 0 THEN
5140: RAISE INVALID_EFF_SET_ID_EXCP;

Line 6504: UPDATE cz_effectivity_sets

6500: x_msg_data := '';
6501:
6502: is_eff_set_deleteable(p_eff_set_id,l_return_status,l_msg_count,l_msg_data);
6503: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6504: UPDATE cz_effectivity_sets
6505: SET deleted_flag = '1',
6506: name = append_name(p_eff_set_id, 'EFF', name)
6507: WHERE effectivity_set_id = p_eff_set_id;
6508:

Line 11674: FROM cz_effectivity_sets

11670: v_eff_until := h_eff_until(v_eff_set_id);
11671: ELSE
11672:
11673: SELECT effective_from, effective_until INTO v_eff_from, v_eff_until
11674: FROM cz_effectivity_sets
11675: WHERE deleted_flag = '0'
11676: AND effectivity_set_id = v_eff_set_id;
11677:
11678: h_eff_from(v_eff_set_id) := v_eff_from;

Line 11775: FROM cz_effectivity_sets

11771: v_eff_until := h_eff_until(v_eff_set_id);
11772: ELSE
11773:
11774: SELECT effective_from, effective_until INTO v_eff_from, v_eff_until
11775: FROM cz_effectivity_sets
11776: WHERE deleted_flag = '0'
11777: AND effectivity_set_id = v_eff_set_id;
11778:
11779: h_eff_from(v_eff_set_id) := v_eff_from;

Line 11825: FROM cz_effectivity_sets

11821: v_eff_until := h_eff_until(v_eff_set_id);
11822: ELSE
11823:
11824: SELECT effective_from, effective_until INTO v_eff_from, v_eff_until
11825: FROM cz_effectivity_sets
11826: WHERE deleted_flag = '0'
11827: AND effectivity_set_id = v_eff_set_id;
11828:
11829: h_eff_from(v_eff_set_id) := v_eff_from;