DBA Data[Home] [Help]

APPS.CZ_CONFIG_API_PVT dependencies on CZ_API_PUB

Line 186: ,SUBSTR(DECODE(p_new_name, NULL, DECODE(NAME,NULL,NAME,DECODE(p_copy_mode,CZ_API_PUB.G_NEW_HEADER_COPY_MODE,

182: ,CONFIG_ENGINE_TYPE
183: )
184: SELECT
185: p_new_config_hdr_id -- new or old value
186: ,SUBSTR(DECODE(p_new_name, NULL, DECODE(NAME,NULL,NAME,DECODE(p_copy_mode,CZ_API_PUB.G_NEW_HEADER_COPY_MODE,
187: NEW_HDR_NAME_PREFIX || NAME, NEW_REV_NAME_PREFIX || NAME)), p_new_name), 1, 240)
188: ,p_new_config_rev_nbr -- new value
189: ,COMPONENT_ID
190: ,PERSISTENT_COMPONENT_ID

Line 272: IF (p_force_new_inst_rev IS NOT NULL OR p_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE OR

268: -- 2. baseline_rev_nbr is null: copy all fields except config_hdr_id and config_rev_nbr (new hdr)
269: FOR i IN l_instance_hdr_tbl.FIRST .. l_instance_hdr_tbl.LAST LOOP
270: l_instance_hdr_id := l_instance_hdr_tbl(i).config_hdr_id;
271:
272: IF (p_force_new_inst_rev IS NOT NULL OR p_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE OR
273: (l_instance_hdr_tbl(i).component_instance_type = NETWORK_INSTANCE_ROOT AND
274: l_instance_hdr_tbl(i).baseline_rev_nbr IS NOT NULL)) THEN ---Fix BUG13638115
275: l_instance_hdr_tbl(i).config_rev_nbr := get_next_revision(l_instance_hdr_id);
276: ELSE

Line 292: p_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE AND l_instance_hdr_tbl(i).baseline_rev_nbr IS NULL THEN

288:
289: x_instance_hdr_map(l_instance_hdr_id).instance_hdr_id := l_instance_hdr_tbl(i).config_hdr_id;
290: x_instance_hdr_map(l_instance_hdr_id).instance_rev_nbr := l_instance_hdr_tbl(i).config_rev_nbr;
291: IF l_instance_hdr_tbl(i).component_instance_type = NETWORK_INSTANCE_ROOT AND
292: p_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE AND l_instance_hdr_tbl(i).baseline_rev_nbr IS NULL THEN
293: -- transaction writing needed for this instance
294: x_instance_hdr_map(l_instance_hdr_id).txn_flag := '1';
295: END IF;
296: END LOOP;

Line 463: IF (p_network_config AND p_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE and p_force_new_inst_rev is null) THEN

459: ELSE
460: -- For network config, if copy mode is new_config and transaction needs to be written
461: -- for an instance, new instance config will be created and all config_item_ids of
462: -- the new instance items will be regenerated.
463: IF (p_network_config AND p_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE and p_force_new_inst_rev is null) THEN
464: l_index := p_instance_hdr_map.FIRST;
465: WHILE (l_index IS NOT NULL) LOOP
466: IF p_instance_hdr_map(l_index).txn_flag = '1' THEN
467: FOR id_rec IN (SELECT config_item_id FROM cz_config_items

Line 1105: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type

1101: ,p_config_rev_nbr IN NUMBER
1102: ,p_copy_mode IN VARCHAR2
1103: ,x_config_hdr_id OUT NOCOPY NUMBER
1104: ,x_config_rev_nbr OUT NOCOPY NUMBER
1105: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1106: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1107: ,x_return_status OUT NOCOPY VARCHAR2
1108: ,x_msg_count OUT NOCOPY NUMBER
1109: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1106: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type

1102: ,p_copy_mode IN VARCHAR2
1103: ,x_config_hdr_id OUT NOCOPY NUMBER
1104: ,x_config_rev_nbr OUT NOCOPY NUMBER
1105: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1106: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1107: ,x_return_status OUT NOCOPY VARCHAR2
1108: ,x_msg_count OUT NOCOPY NUMBER
1109: ,x_msg_data OUT NOCOPY VARCHAR2
1110: ,p_handle_deleted_flag IN VARCHAR2 := NULL

Line 1149: IF ((p_copy_mode IS NULL) OR (p_copy_mode <> CZ_API_PUB.G_NEW_HEADER_COPY_MODE AND

1145: )) THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: IF ((p_copy_mode IS NULL) OR (p_copy_mode <> CZ_API_PUB.G_NEW_HEADER_COPY_MODE AND
1150: p_copy_mode <> CZ_API_PUB.G_NEW_REVISION_COPY_MODE)) THEN
1151: FND_MESSAGE.SET_NAME('CZ', 'CZ_NET_API_INVALID_TREE_MODE');
1152: FND_MESSAGE.SET_TOKEN('MODE', p_copy_mode);
1153: FND_MESSAGE.SET_TOKEN('PROC', l_api_name);

Line 1150: p_copy_mode <> CZ_API_PUB.G_NEW_REVISION_COPY_MODE)) THEN

1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: IF ((p_copy_mode IS NULL) OR (p_copy_mode <> CZ_API_PUB.G_NEW_HEADER_COPY_MODE AND
1150: p_copy_mode <> CZ_API_PUB.G_NEW_REVISION_COPY_MODE)) THEN
1151: FND_MESSAGE.SET_NAME('CZ', 'CZ_NET_API_INVALID_TREE_MODE');
1152: FND_MESSAGE.SET_TOKEN('MODE', p_copy_mode);
1153: FND_MESSAGE.SET_TOKEN('PROC', l_api_name);
1154: FND_MSG_PUB.ADD;

Line 1197: IF (p_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN

1193: fnd_msg_pub.add;
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:
1197: IF (p_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1198: l_new_config_hdr_id := p_config_hdr_id;
1199: l_new_config_rev_nbr := get_next_revision(p_config_hdr_id);
1200: ELSE
1201: l_new_config_hdr_id := get_next_hdr_id;

Line 1290: x_orig_item_id_tbl := CZ_API_PUB.NUMBER_TBL_TYPE();

1286:
1287: x_config_hdr_id := l_new_config_hdr_id;
1288: x_config_rev_nbr := l_new_config_rev_nbr;
1289:
1290: x_orig_item_id_tbl := CZ_API_PUB.NUMBER_TBL_TYPE();
1291: x_new_item_id_tbl := CZ_API_PUB.NUMBER_TBL_TYPE();
1292: l_new_item_count := l_item_id_map.COUNT;
1293: IF (l_new_item_count > 0) THEN
1294: x_orig_item_id_tbl.EXTEND(l_new_item_count);

Line 1291: x_new_item_id_tbl := CZ_API_PUB.NUMBER_TBL_TYPE();

1287: x_config_hdr_id := l_new_config_hdr_id;
1288: x_config_rev_nbr := l_new_config_rev_nbr;
1289:
1290: x_orig_item_id_tbl := CZ_API_PUB.NUMBER_TBL_TYPE();
1291: x_new_item_id_tbl := CZ_API_PUB.NUMBER_TBL_TYPE();
1292: l_new_item_count := l_item_id_map.COUNT;
1293: IF (l_new_item_count > 0) THEN
1294: x_orig_item_id_tbl.EXTEND(l_new_item_count);
1295: x_new_item_id_tbl.EXTEND(l_new_item_count);

Line 1341: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type

1337: ,p_config_rev_nbr IN NUMBER
1338: ,p_copy_mode IN VARCHAR2
1339: ,x_config_hdr_id OUT NOCOPY NUMBER
1340: ,x_config_rev_nbr OUT NOCOPY NUMBER
1341: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1342: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1343: ,x_return_status OUT NOCOPY VARCHAR2
1344: ,x_msg_count OUT NOCOPY NUMBER
1345: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1342: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type

1338: ,p_copy_mode IN VARCHAR2
1339: ,x_config_hdr_id OUT NOCOPY NUMBER
1340: ,x_config_rev_nbr OUT NOCOPY NUMBER
1341: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1342: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1343: ,x_return_status OUT NOCOPY VARCHAR2
1344: ,x_msg_count OUT NOCOPY NUMBER
1345: ,x_msg_data OUT NOCOPY VARCHAR2
1346: ,p_handle_deleted_flag IN VARCHAR2 := NULL