DBA Data[Home] [Help]

APPS.CZ_CONFIG_API_PUB dependencies on CZ_API_PUB

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

165: ,CONFIG_ENGINE_TYPE
166: )
167: SELECT
168: p_new_config_hdr_id -- new or old value
169: ,SUBSTR(DECODE(p_new_name, NULL, DECODE(NAME,NULL,NAME,DECODE(p_copy_mode,CZ_API_PUB.G_NEW_HEADER_COPY_MODE,
170: NEW_HDR_NAME_PREFIX || NAME, NEW_REV_NAME_PREFIX || NAME)), p_new_name), 1, 240)
171: ,p_new_config_rev_nbr -- new value
172: ,COMPONENT_ID
173: ,PERSISTENT_COMPONENT_ID

Line 253: IF (p_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE OR

249: -- 2. baseline_rev_nbr is null: copy all fields except config_hdr_id and config_rev_nbr (new hdr)
250: FOR i IN l_instance_hdr_tbl.FIRST .. l_instance_hdr_tbl.LAST LOOP
251: l_instance_hdr_id := l_instance_hdr_tbl(i).config_hdr_id;
252:
253: IF (p_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE OR
254: l_instance_hdr_tbl(i).component_instance_type = NETWORK_INSTANCE_ROOT AND
255: l_instance_hdr_tbl(i).baseline_rev_nbr IS NOT NULL) THEN
256: l_instance_hdr_tbl(i).config_rev_nbr := get_next_revision(l_instance_hdr_id);
257: ELSE

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

269:
270: x_instance_hdr_map(l_instance_hdr_id).instance_hdr_id := l_instance_hdr_tbl(i).config_hdr_id;
271: x_instance_hdr_map(l_instance_hdr_id).instance_rev_nbr := l_instance_hdr_tbl(i).config_rev_nbr;
272: IF l_instance_hdr_tbl(i).component_instance_type = NETWORK_INSTANCE_ROOT AND
273: p_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE AND l_instance_hdr_tbl(i).baseline_rev_nbr IS NULL THEN
274: -- transaction writing needed for this instance
275: x_instance_hdr_map(l_instance_hdr_id).txn_flag := '1';
276: END IF;
277: END LOOP;

Line 442: IF (p_network_config AND p_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN

438: ELSE
439: -- For network config, if copy mode is new_config and transaction needs to be written
440: -- for an instance, new instance config will be created and all config_item_ids of
441: -- the new instance items will be regenerated.
442: IF (p_network_config AND p_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
443: l_index := p_instance_hdr_map.FIRST;
444: WHILE (l_index IS NOT NULL) LOOP
445: IF p_instance_hdr_map(l_index).txn_flag = '1' THEN
446: FOR id_rec IN (SELECT config_item_id FROM cz_config_items

Line 995: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type

991: ,p_config_rev_nbr IN NUMBER
992: ,p_copy_mode IN VARCHAR2
993: ,x_config_hdr_id OUT NOCOPY NUMBER
994: ,x_config_rev_nbr OUT NOCOPY NUMBER
995: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
996: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
997: ,x_return_status OUT NOCOPY VARCHAR2
998: ,x_msg_count OUT NOCOPY NUMBER
999: ,x_msg_data OUT NOCOPY VARCHAR2

Line 996: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type

992: ,p_copy_mode IN VARCHAR2
993: ,x_config_hdr_id OUT NOCOPY NUMBER
994: ,x_config_rev_nbr OUT NOCOPY NUMBER
995: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
996: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
997: ,x_return_status OUT NOCOPY VARCHAR2
998: ,x_msg_count OUT NOCOPY NUMBER
999: ,x_msg_data OUT NOCOPY VARCHAR2
1000: ,p_handle_deleted_flag IN VARCHAR2 := NULL

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

1033: )) THEN
1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1035: END IF;
1036:
1037: IF ((p_copy_mode IS NULL) OR (p_copy_mode <> CZ_API_PUB.G_NEW_HEADER_COPY_MODE AND
1038: p_copy_mode <> CZ_API_PUB.G_NEW_REVISION_COPY_MODE)) THEN
1039: FND_MESSAGE.SET_NAME('CZ', 'CZ_NET_API_INVALID_TREE_MODE');
1040: FND_MESSAGE.SET_TOKEN('MODE', p_copy_mode);
1041: FND_MESSAGE.SET_TOKEN('PROC', l_api_name);

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

1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1035: END IF;
1036:
1037: IF ((p_copy_mode IS NULL) OR (p_copy_mode <> CZ_API_PUB.G_NEW_HEADER_COPY_MODE AND
1038: p_copy_mode <> CZ_API_PUB.G_NEW_REVISION_COPY_MODE)) THEN
1039: FND_MESSAGE.SET_NAME('CZ', 'CZ_NET_API_INVALID_TREE_MODE');
1040: FND_MESSAGE.SET_TOKEN('MODE', p_copy_mode);
1041: FND_MESSAGE.SET_TOKEN('PROC', l_api_name);
1042: FND_MSG_PUB.ADD;

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

1081: fnd_msg_pub.add;
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084:
1085: IF (p_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1086: l_new_config_hdr_id := p_config_hdr_id;
1087: l_new_config_rev_nbr := get_next_revision(p_config_hdr_id);
1088: ELSE
1089: l_new_config_hdr_id := get_next_hdr_id;

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

1164:
1165: x_config_hdr_id := l_new_config_hdr_id;
1166: x_config_rev_nbr := l_new_config_rev_nbr;
1167:
1168: x_orig_item_id_tbl := CZ_API_PUB.NUMBER_TBL_TYPE();
1169: x_new_item_id_tbl := CZ_API_PUB.NUMBER_TBL_TYPE();
1170: l_new_item_count := l_item_id_map.COUNT;
1171: IF (l_new_item_count > 0) THEN
1172: x_orig_item_id_tbl.EXTEND(l_new_item_count);

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

1165: x_config_hdr_id := l_new_config_hdr_id;
1166: x_config_rev_nbr := l_new_config_rev_nbr;
1167:
1168: x_orig_item_id_tbl := CZ_API_PUB.NUMBER_TBL_TYPE();
1169: x_new_item_id_tbl := CZ_API_PUB.NUMBER_TBL_TYPE();
1170: l_new_item_count := l_item_id_map.COUNT;
1171: IF (l_new_item_count > 0) THEN
1172: x_orig_item_id_tbl.EXTEND(l_new_item_count);
1173: x_new_item_id_tbl.EXTEND(l_new_item_count);

Line 1219: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type

1215: ,p_config_rev_nbr IN NUMBER
1216: ,p_copy_mode IN VARCHAR2
1217: ,x_config_hdr_id OUT NOCOPY NUMBER
1218: ,x_config_rev_nbr OUT NOCOPY NUMBER
1219: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1220: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1221: ,x_return_status OUT NOCOPY VARCHAR2
1222: ,x_msg_count OUT NOCOPY NUMBER
1223: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1220: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type

1216: ,p_copy_mode IN VARCHAR2
1217: ,x_config_hdr_id OUT NOCOPY NUMBER
1218: ,x_config_rev_nbr OUT NOCOPY NUMBER
1219: ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1220: ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1221: ,x_return_status OUT NOCOPY VARCHAR2
1222: ,x_msg_count OUT NOCOPY NUMBER
1223: ,x_msg_data OUT NOCOPY VARCHAR2
1224: ,p_handle_deleted_flag IN VARCHAR2 := NULL