eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_NETWORK_API_PUB dependencies on CZ_API_PUB

Line 131: PROCEDURE default_pb_parameters(p_appl_param_rec IN OUT NOCOPY CZ_API_PUB.appl_param_rec_type,

127: -------------------------------------------------------------------------
128: -------calling applications default publication parameters to G_MISS_DATE, G_MISS_CHAR etc
129: -------In such cases default the parameter to NULL.
130: ----default pb applicability parameters to NULL if no values are passed in
131: PROCEDURE default_pb_parameters(p_appl_param_rec IN OUT NOCOPY CZ_API_PUB.appl_param_rec_type,
132: x_return_status IN OUT NOCOPY VARCHAR2)
133: IS
134: APPLID_NOT_FOUND EXCEPTION;
135:

Line 192: PROCEDURE delete_configuration(p_config_model_tbl IN cz_api_pub.config_model_tbl_type)

188: END set_error_message;
189:
190: ---------------------------------------------------------------------------
191: ----procedure that deletes the saved configurations
192: PROCEDURE delete_configuration(p_config_model_tbl IN cz_api_pub.config_model_tbl_type)
193: IS
194: PRAGMA AUTONOMOUS_TRANSACTION;
195: l_err_buf VARCHAR2(2000);
196: l_msg_data VARCHAR2(2000);

Line 485: p_appl_params IN CZ_API_PUB.appl_param_rec_type,

481: p_organization_id IN NUMBER,
482: p_config_hdr_id IN NUMBER,
483: p_config_rev_nbr IN NUMBER,
484: p_dummy_header_id IN NUMBER,
485: p_appl_params IN CZ_API_PUB.appl_param_rec_type,
486: p_tree_copy_mode IN VARCHAR2,
487: p_valid_context IN VARCHAR2,
488: x_xml_hdr OUT NOCOPY VARCHAR2 )
489: IS

Line 499: l_save_config_behavior VARCHAR2(30):= CZ_API_PUB.G_NEW_REVISION_COPY_MODE;

495:
496: l_rec_index BINARY_INTEGER;
497:
498: l_database_id VARCHAR2(100);
499: l_save_config_behavior VARCHAR2(30):= CZ_API_PUB.G_NEW_REVISION_COPY_MODE;
500: l_ui_type VARCHAR2(30):= null;
501: l_msg_behavior VARCHAR2(30):= 'brief';
502: l_context_org_id VARCHAR2(80);
503: l_inventory_item_id VARCHAR2(80);

Line 561: IF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN

557:
558: -- config_effective_date should have LONG DATE FORMAT --
559: param_value(9) := to_char(p_appl_params.config_effective_date,'MM-DD-YYYY-HH24-MI-SS');
560:
561: IF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
562: l_save_config_behavior := 'new_config';
563: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
564: l_save_config_behavior := 'new_revision';
565: END IF;

Line 563: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN

559: param_value(9) := to_char(p_appl_params.config_effective_date,'MM-DD-YYYY-HH24-MI-SS');
560:
561: IF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
562: l_save_config_behavior := 'new_config';
563: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
564: l_save_config_behavior := 'new_revision';
565: END IF;
566:
567: param_value(10) := l_save_config_behavior;

Line 706: p_config_tbl IN CZ_API_PUB.config_tbl_type,

702:
703: --------------------------------------------------------------------------
704: ----procedure that logs trace for network API
705: PROCEDURE trace_gen_config_trees (p_api_version IN NUMBER,
706: p_config_tbl IN CZ_API_PUB.config_tbl_type,
707: p_tree_copy_mode IN VARCHAR2,
708: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
709: p_validation_context IN VARCHAR2,
710: p_config_model_tbl IN OUT NOCOPY CZ_API_PUB.config_model_tbl_type,

Line 708: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,

704: ----procedure that logs trace for network API
705: PROCEDURE trace_gen_config_trees (p_api_version IN NUMBER,
706: p_config_tbl IN CZ_API_PUB.config_tbl_type,
707: p_tree_copy_mode IN VARCHAR2,
708: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
709: p_validation_context IN VARCHAR2,
710: p_config_model_tbl IN OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
711: p_return_status IN OUT NOCOPY VARCHAR2)
712: IS

Line 710: p_config_model_tbl IN OUT NOCOPY CZ_API_PUB.config_model_tbl_type,

706: p_config_tbl IN CZ_API_PUB.config_tbl_type,
707: p_tree_copy_mode IN VARCHAR2,
708: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
709: p_validation_context IN VARCHAR2,
710: p_config_model_tbl IN OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
711: p_return_status IN OUT NOCOPY VARCHAR2)
712: IS
713: PRAGMA AUTONOMOUS_TRANSACTION;
714: TYPE trace_tbl IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;

Line 806: p_instance_tbl IN CZ_API_PUB.config_tbl_type,

802: p_inventory_item_id IN NUMBER,
803: p_organization_id IN NUMBER,
804: p_config_hdr_id IN NUMBER,
805: p_config_rev_nbr IN NUMBER,
806: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
807: p_tree_copy_mode IN VARCHAR2,
808: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
809: p_validation_context IN VARCHAR2,
810: x_config_model_rec IN CZ_API_PUB.config_model_rec_type,

Line 808: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,

804: p_config_hdr_id IN NUMBER,
805: p_config_rev_nbr IN NUMBER,
806: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
807: p_tree_copy_mode IN VARCHAR2,
808: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
809: p_validation_context IN VARCHAR2,
810: x_config_model_rec IN CZ_API_PUB.config_model_rec_type,
811: x_return_status IN VARCHAR2,
812: x_msg_count IN NUMBER,

Line 810: x_config_model_rec IN CZ_API_PUB.config_model_rec_type,

806: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
807: p_tree_copy_mode IN VARCHAR2,
808: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
809: p_validation_context IN VARCHAR2,
810: x_config_model_rec IN CZ_API_PUB.config_model_rec_type,
811: x_return_status IN VARCHAR2,
812: x_msg_count IN NUMBER,
813: x_msg_data IN VARCHAR2)
814: IS

Line 910: --- CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN

906: --- p_tree_copy_mode IN VARCHAR2 Required
907: --- p_appl_param_rec IN appl_param_rec_type Required
908: --- p_validation_context IN VARCHAR2 Required
909: --- p_validation_type IN VARCHAR2 valid values are :
910: --- CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN
911: ---OUT : x_return_status OUT NOCOPY VARCHAR2
912: --- x_msg_count OUT NOCOPY NUMBER
913: --- x_msg_data OUT NOCOPY VARCHAR2
914: ---Version: Current version :1.0

Line 918: p_config_tbl IN CZ_API_PUB.config_tbl_type,

914: ---Version: Current version :1.0
915: ---End of comments
916:
917: PROCEDURE generate_config_trees(p_api_version IN NUMBER,
918: p_config_tbl IN CZ_API_PUB.config_tbl_type,
919: p_tree_copy_mode IN VARCHAR2,
920: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
921: p_validation_context IN VARCHAR2,
922: p_validation_type IN VARCHAR2,

Line 920: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,

916:
917: PROCEDURE generate_config_trees(p_api_version IN NUMBER,
918: p_config_tbl IN CZ_API_PUB.config_tbl_type,
919: p_tree_copy_mode IN VARCHAR2,
920: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
921: p_validation_context IN VARCHAR2,
922: p_validation_type IN VARCHAR2,
923: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
924: x_return_status OUT NOCOPY VARCHAR2,

Line 923: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,

919: p_tree_copy_mode IN VARCHAR2,
920: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
921: p_validation_context IN VARCHAR2,
922: p_validation_type IN VARCHAR2,
923: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
924: x_return_status OUT NOCOPY VARCHAR2,
925: x_msg_count OUT NOCOPY NUMBER,
926: x_msg_data OUT NOCOPY VARCHAR2
927: )

Line 972: l_orig_item_tbl cz_api_pub.number_tbl_type;

968: validation_status NUMBER;
969: v_parse_status VARCHAR2(1);
970: l_validation_context VARCHAR2(1);
971: l_url VARCHAR2(255);
972: l_orig_item_tbl cz_api_pub.number_tbl_type;
973: l_new_item_tbl cz_api_pub.number_tbl_type;
974: l_config_err_msg VARCHAR2(2000);
975: l_dummy_config_hdr_id NUMBER;
976:

Line 973: l_new_item_tbl cz_api_pub.number_tbl_type;

969: v_parse_status VARCHAR2(1);
970: l_validation_context VARCHAR2(1);
971: l_url VARCHAR2(255);
972: l_orig_item_tbl cz_api_pub.number_tbl_type;
973: l_new_item_tbl cz_api_pub.number_tbl_type;
974: l_config_err_msg VARCHAR2(2000);
975: l_dummy_config_hdr_id NUMBER;
976:
977: NO_INPUT_RECORDS EXCEPTION;

Line 996: IF p_validation_type NOT IN(CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN) THEN

992: NO_VALIDATION_CONTEXT EXCEPTION;
993:
994: BEGIN
995:
996: IF p_validation_type NOT IN(CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN) THEN
997: RAISE INVALID_VALIDATION_TYPE;
998: END IF;
999:
1000: l_orig_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();

Line 1000: l_orig_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();

996: IF p_validation_type NOT IN(CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN) THEN
997: RAISE INVALID_VALIDATION_TYPE;
998: END IF;
999:
1000: l_orig_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();
1001: l_new_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();
1002:
1003: ----initialize return status to success
1004: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1001: l_new_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();

997: RAISE INVALID_VALIDATION_TYPE;
998: END IF;
999:
1000: l_orig_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();
1001: l_new_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();
1002:
1003: ----initialize return status to success
1004: x_return_status := FND_API.G_RET_STS_SUCCESS;
1005: fnd_msg_pub.initialize;

Line 1020: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN

1016:
1017: ---verify that the input parameters are not null
1018: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN
1019: RAISE INPUT_TREE_MODE_NULL;
1020: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
1021: new_config_flag := '0';
1022: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1023: new_config_flag := '1';
1024: ELSE

Line 1022: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN

1018: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN
1019: RAISE INPUT_TREE_MODE_NULL;
1020: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
1021: new_config_flag := '0';
1022: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1023: new_config_flag := '1';
1024: ELSE
1025: RAISE INVALID_TREE_MODE_ERR;
1026: END IF;

Line 1031: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN

1027:
1028: ----verify validation context
1029: IF (p_validation_context IS NULL) THEN
1030: l_validation_context := NULL;
1031: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1032: l_validation_context := CZ_API_PUB.G_INSTALLED;
1033: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1034: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1035: ELSE

Line 1032: l_validation_context := CZ_API_PUB.G_INSTALLED;

1028: ----verify validation context
1029: IF (p_validation_context IS NULL) THEN
1030: l_validation_context := NULL;
1031: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1032: l_validation_context := CZ_API_PUB.G_INSTALLED;
1033: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1034: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1035: ELSE
1036: RAISE INVALID_CONTEXT;

Line 1033: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN

1029: IF (p_validation_context IS NULL) THEN
1030: l_validation_context := NULL;
1031: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1032: l_validation_context := CZ_API_PUB.G_INSTALLED;
1033: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1034: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1035: ELSE
1036: RAISE INVALID_CONTEXT;
1037: END IF;

Line 1034: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;

1030: l_validation_context := NULL;
1031: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1032: l_validation_context := CZ_API_PUB.G_INSTALLED;
1033: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1034: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1035: ELSE
1036: RAISE INVALID_CONTEXT;
1037: END IF;
1038:

Line 1202: IF p_validation_type<>CZ_API_PUB.VALIDATE_RETURN AND

1198: ------get top inv item and org id
1199: get_root_bom_config_item(v_output_cfg_hdr_id,v_output_cfg_rev_nbr,l_inventory_item_id,l_organization_id,l_config_item_id);
1200:
1201: -----if no inv item id or org id is retrieved raise exception
1202: IF p_validation_type<>CZ_API_PUB.VALIDATE_RETURN AND
1203: ( l_inventory_item_id = -1 OR l_organization_id = -1 ) THEN
1204: RAISE INVALID_OUT_INV_ORG_ID;
1205: END IF;
1206:

Line 1288: IF x_config_model_tbl.COUNT>0 AND p_validation_type<>CZ_API_PUB.VALIDATE_RETURN THEN

1284: WHEN INVALID_OUT_INV_ORG_ID THEN
1285: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',v_output_cfg_hdr_id,'REV',v_output_cfg_rev_nbr);
1286: set_fnd_message('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',v_output_cfg_hdr_id,'REV',v_output_cfg_rev_nbr);
1287: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1288: IF x_config_model_tbl.COUNT>0 AND p_validation_type<>CZ_API_PUB.VALIDATE_RETURN THEN
1289: delete_configuration(x_config_model_tbl);
1290: x_config_model_tbl.DELETE;
1291: END IF;
1292: COMMIT;

Line 1366: p_config_tbl IN CZ_API_PUB.config_tbl_type,

1362: ---Version: Current version :1.0
1363: ---End of comments
1364:
1365: PROCEDURE generate_config_trees(p_api_version IN NUMBER,
1366: p_config_tbl IN CZ_API_PUB.config_tbl_type,
1367: p_tree_copy_mode IN VARCHAR2,
1368: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1369: p_validation_context IN VARCHAR2,
1370: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,

Line 1368: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,

1364:
1365: PROCEDURE generate_config_trees(p_api_version IN NUMBER,
1366: p_config_tbl IN CZ_API_PUB.config_tbl_type,
1367: p_tree_copy_mode IN VARCHAR2,
1368: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1369: p_validation_context IN VARCHAR2,
1370: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
1371: x_return_status OUT NOCOPY VARCHAR2,
1372: x_msg_count OUT NOCOPY NUMBER,

Line 1370: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,

1366: p_config_tbl IN CZ_API_PUB.config_tbl_type,
1367: p_tree_copy_mode IN VARCHAR2,
1368: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1369: p_validation_context IN VARCHAR2,
1370: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
1371: x_return_status OUT NOCOPY VARCHAR2,
1372: x_msg_count OUT NOCOPY NUMBER,
1373: x_msg_data OUT NOCOPY VARCHAR2
1374: )

Line 1383: p_validation_type => CZ_API_PUB.INTERACTIVE,

1379: p_config_tbl => p_config_tbl,
1380: p_tree_copy_mode => p_tree_copy_mode,
1381: p_appl_param_rec => p_appl_param_rec,
1382: p_validation_context => p_validation_context,
1383: p_validation_type => CZ_API_PUB.INTERACTIVE,
1384: x_config_model_tbl => x_config_model_tbl,
1385: x_return_status => x_return_status,
1386: x_msg_count => x_msg_count,
1387: x_msg_data => x_msg_data

Line 1399: p_instance_tbl IN CZ_API_PUB.config_tbl_type,

1395: p_inventory_item_id IN NUMBER,
1396: p_organization_id IN NUMBER,
1397: p_config_hdr_id IN NUMBER,
1398: p_config_rev_nbr IN NUMBER,
1399: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
1400: p_tree_copy_mode IN VARCHAR2,
1401: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1402: p_validation_context IN VARCHAR2,
1403: x_config_model_rec OUT NOCOPY CZ_API_PUB.config_model_rec_type,

Line 1401: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,

1397: p_config_hdr_id IN NUMBER,
1398: p_config_rev_nbr IN NUMBER,
1399: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
1400: p_tree_copy_mode IN VARCHAR2,
1401: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1402: p_validation_context IN VARCHAR2,
1403: x_config_model_rec OUT NOCOPY CZ_API_PUB.config_model_rec_type,
1404: x_return_status OUT NOCOPY VARCHAR2,
1405: x_msg_count OUT NOCOPY NUMBER,

Line 1403: x_config_model_rec OUT NOCOPY CZ_API_PUB.config_model_rec_type,

1399: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
1400: p_tree_copy_mode IN VARCHAR2,
1401: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1402: p_validation_context IN VARCHAR2,
1403: x_config_model_rec OUT NOCOPY CZ_API_PUB.config_model_rec_type,
1404: x_return_status OUT NOCOPY VARCHAR2,
1405: x_msg_count OUT NOCOPY NUMBER,
1406: x_msg_data OUT NOCOPY VARCHAR2)
1407: IS

Line 1423: l_config_model_tbl CZ_API_PUB.config_model_tbl_type;

1419:
1420: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1421: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1422:
1423: l_config_model_tbl CZ_API_PUB.config_model_tbl_type;
1424: l_con_config_tbl container_config_tbl_type;
1425:
1426: l_model_instantiation_type VARCHAR2(1);
1427: l_component_instance_type VARCHAR2(1);

Line 1492: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN

1488:
1489: ---verify that the input parameters are not null
1490: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN
1491: RAISE INPUT_TREE_MODE_NULL;
1492: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
1493: new_config_flag := '0';
1494: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1495: new_config_flag := '1';
1496: ELSE

Line 1494: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN

1490: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN
1491: RAISE INPUT_TREE_MODE_NULL;
1492: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
1493: new_config_flag := '0';
1494: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1495: new_config_flag := '1';
1496: ELSE
1497: RAISE INVALID_TREE_MODE_ERR;
1498: END IF;

Line 1503: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN

1499:
1500: ----verify validation context
1501: IF (p_validation_context IS NULL) THEN
1502: l_validation_context := NULL;
1503: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1504: l_validation_context := CZ_API_PUB.G_INSTALLED;
1505: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1506: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1507: ELSE

Line 1504: l_validation_context := CZ_API_PUB.G_INSTALLED;

1500: ----verify validation context
1501: IF (p_validation_context IS NULL) THEN
1502: l_validation_context := NULL;
1503: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1504: l_validation_context := CZ_API_PUB.G_INSTALLED;
1505: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1506: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1507: ELSE
1508: RAISE INVALID_CONTEXT;

Line 1505: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN

1501: IF (p_validation_context IS NULL) THEN
1502: l_validation_context := NULL;
1503: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1504: l_validation_context := CZ_API_PUB.G_INSTALLED;
1505: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1506: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1507: ELSE
1508: RAISE INVALID_CONTEXT;
1509: END IF;

Line 1506: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;

1502: l_validation_context := NULL;
1503: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1504: l_validation_context := CZ_API_PUB.G_INSTALLED;
1505: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1506: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1507: ELSE
1508: RAISE INVALID_CONTEXT;
1509: END IF;
1510:

Line 1581: cz_cf_api.validate(config_input_list,l_xml_hdr,config_messages,validation_status,l_url,CZ_API_PUB.INTERACTIVE);

1577:
1578: config_input_list.DELETE;
1579: l_url := FND_PROFILE.VALUE('CZ_UIMGR_URL');
1580: config_messages.DELETE;
1581: cz_cf_api.validate(config_input_list,l_xml_hdr,config_messages,validation_status,l_url,CZ_API_PUB.INTERACTIVE);
1582:
1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: delete_dummy_config ( l_dummy_config_hdr_id );

Line 1778: ,p_inventory_item_id_tbl IN OUT NOCOPY CZ_API_PUB.number_tbl_type

1774: -- Function: Retrieves all trackable and instantiable child models for a
1775: -- given network container model.
1776:
1777: procedure get_contained_models_pvt(p_model_id IN NUMBER
1778: ,p_inventory_item_id_tbl IN OUT NOCOPY CZ_API_PUB.number_tbl_type
1779: )
1780: IS
1781: l_model_id NUMBER := p_model_id;
1782: l_reference_id NUMBER;

Line 1842: ,p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type

1838:
1839: procedure get_contained_models(p_api_version IN NUMBER
1840: ,p_inventory_item_id IN NUMBER
1841: ,p_organization_id IN NUMBER
1842: ,p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type
1843: ,x_model_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1844: ,x_return_status OUT NOCOPY VARCHAR2
1845: ,x_msg_count OUT NOCOPY NUMBER
1846: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1843: ,x_model_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type

1839: procedure get_contained_models(p_api_version IN NUMBER
1840: ,p_inventory_item_id IN NUMBER
1841: ,p_organization_id IN NUMBER
1842: ,p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type
1843: ,x_model_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1844: ,x_return_status OUT NOCOPY VARCHAR2
1845: ,x_msg_count OUT NOCOPY NUMBER
1846: ,x_msg_data OUT NOCOPY VARCHAR2
1847: )

Line 1857: l_inventory_item_id_tbl CZ_API_PUB.number_tbl_type := cz_api_pub.NUMBER_TBL_TYPE();

1853: l_config_model_lookup_date DATE := p_appl_param_rec.config_model_lookup_date;
1854: l_config_effective_date DATE := p_appl_param_rec.config_effective_date;
1855:
1856: l_model_id NUMBER;
1857: l_inventory_item_id_tbl CZ_API_PUB.number_tbl_type := cz_api_pub.NUMBER_TBL_TYPE();
1858: l_msg_data VARCHAR2(2000);
1859: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
1860:
1861: BEGIN

Line 1859: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;

1855:
1856: l_model_id NUMBER;
1857: l_inventory_item_id_tbl CZ_API_PUB.number_tbl_type := cz_api_pub.NUMBER_TBL_TYPE();
1858: l_msg_data VARCHAR2(2000);
1859: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
1860:
1861: BEGIN
1862: x_return_status := FND_API.G_RET_STS_SUCCESS;
1863: fnd_msg_pub.initialize;

Line 1864: x_model_tbl := cz_api_pub.NUMBER_TBL_TYPE();

1860:
1861: BEGIN
1862: x_return_status := FND_API.G_RET_STS_SUCCESS;
1863: fnd_msg_pub.initialize;
1864: x_model_tbl := cz_api_pub.NUMBER_TBL_TYPE();
1865: -- standard call to check for call compatibility
1866: IF (NOT FND_API.compatible_api_call(l_api_version
1867: ,p_api_version
1868: ,l_api_name

Line 1959: ,p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type

1955:
1956: procedure is_container(p_api_version IN NUMBER
1957: ,p_inventory_item_id IN NUMBER
1958: ,p_organization_id IN NUMBER
1959: ,p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type
1960: ,x_return_value OUT NOCOPY VARCHAR2
1961: ,x_return_status OUT NOCOPY VARCHAR2
1962: ,x_msg_count OUT NOCOPY NUMBER
1963: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2216: x_child_config_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type)

2212: -----that has been passed in (for a config hdr and config rev)
2213: PROCEDURE get_child_items(p_config_hdr_id IN NUMBER,
2214: p_config_rev_nbr IN NUMBER,
2215: p_config_item_id IN NUMBER,
2216: x_child_config_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type)
2217:
2218: IS
2219:
2220: BEGIN

Line 2259: v_child_config_tbl CZ_API_PUB.number_tbl_type;

2255: l_api_version CONSTANT NUMBER := 1.0;
2256: l_api_name VARCHAR2(30) := 'ext_deactivate_item';
2257: l_ext_activated_flag VARCHAR2(1);
2258: l_root_inst_changed BOOLEAN;
2259: v_child_config_tbl CZ_API_PUB.number_tbl_type;
2260: l_run_id NUMBER;
2261: l_config_item_id NUMBER;
2262: REMOVE_IB_ERR EXCEPTION;
2263:

Line 2364: p_validation_type IN VARCHAR2 DEFAULT CZ_API_PUB.VALIDATE_ORDER

2360: init_message IN VARCHAR2, -- additional XML
2361: config_messages IN OUT NOCOPY CZ_CF_API.CFG_OUTPUT_PIECES, -- table of output XML messages
2362: validation_status IN OUT NOCOPY NUMBER, -- status return
2363: URL IN VARCHAR2 DEFAULT FND_PROFILE.Value('CZ_UIMGR_URL'),
2364: p_validation_type IN VARCHAR2 DEFAULT CZ_API_PUB.VALIDATE_ORDER
2365: )
2366:
2367: IS
2368: