[Home] [Help]
376:
377: l_prof_val VARCHAR2(10);
378:
379: BEGIN
380: l_prof_val := fnd_profile.value('CZ_OUTPUT_IB_UNCHD_CHILD_ITEMS');
381:
382: -- if unchanged items not output, only set ext_activated_flag to '1' on instance root
383: -- otherwise set to '1' on all items in trackable instances
384: UPDATE cz_config_items
576: param_value(1) := l_database_id;
577: param_value(2) := l_context_org_id;
578: param_value(3) := to_char(sysdate,'MM-DD-YYYY-HH24-MI-SS');
579: param_value(4) := p_appl_params.calling_application_id;
580: param_value(5) := fnd_profile.value('RESP_ID');
581: param_value(6) := l_inventory_item_id;
582: param_value(7) := l_config_header_id;
583: param_value(8) := l_config_rev_nbr;
584:
1285: p_tree_copy_mode,
1286: l_validation_context,
1287: l_xml_hdr);
1288:
1289: l_url := FND_PROFILE.VALUE('CZ_UIMGR_URL');
1290: config_messages.DELETE;
1291: cz_cf_api.validate(config_input_list,l_xml_hdr,config_messages,validation_status,l_url,p_validation_type);
1292:
1293: EXCEPTION
1713: l_validation_context,
1714: l_xml_hdr);
1715:
1716: config_input_list.DELETE;
1717: l_url := FND_PROFILE.VALUE('CZ_UIMGR_URL');
1718: config_messages.DELETE;
1719: cz_cf_api.validate(config_input_list,l_xml_hdr,config_messages,validation_status,l_url,CZ_API_PUB.INTERACTIVE);
1720:
1721: EXCEPTION
2497: PROCEDURE VALIDATE(config_input_list IN CZ_CF_API.CFG_INPUT_LIST, -- input selections
2498: init_message IN VARCHAR2, -- additional XML
2499: config_messages IN OUT NOCOPY CZ_CF_API.CFG_OUTPUT_PIECES, -- table of output XML messages
2500: validation_status IN OUT NOCOPY NUMBER, -- status return
2501: URL IN VARCHAR2 DEFAULT FND_PROFILE.Value('CZ_UIMGR_URL'),
2502: p_validation_type IN VARCHAR2 DEFAULT CZ_API_PUB.VALIDATE_ORDER
2503: )
2504:
2505: IS