DBA Data[Home] [Help]

APPS.CZ_NETWORK_API_PUB dependencies on CZ_CONFIG_HDRS_S

Line 412: SELECT cz_config_hdrs_s.NEXTVAL INTO x_dummy_hdr_id FROM DUAL;

408: l_input_id_tbl t_local_number_tbl;
409:
410: BEGIN
411:
412: SELECT cz_config_hdrs_s.NEXTVAL INTO x_dummy_hdr_id FROM DUAL;
413:
414: FOR i IN 1..p_inst_hdr_id_tbl.COUNT LOOP
415:
416: IF(p_inst_hdr_id_tbl(i).inventory_item_id = p_inventory_id)THEN

Line 1135: UPDATE cz_config_hdrs SET effective_date = SYSDATE WHERE config_hdr_id = v_config_hdr_id

1131: reset_config_delta (v_config_hdr_id, v_config_rev_nbr);
1132: reset_config_flags (v_config_hdr_id, v_config_rev_nbr);
1133:
1134: -- set effective_date of new config to sysdate - bug#8417357
1135: UPDATE cz_config_hdrs SET effective_date = SYSDATE WHERE config_hdr_id = v_config_hdr_id
1136: AND config_rev_nbr = v_config_rev_nbr;
1137:
1138: -- set baseline rev for the new instance header
1139: UPDATE cz_config_hdrs SET baseline_rev_nbr = l_config_rev_nbr WHERE config_hdr_id = l_config_hdr_id

Line 1139: UPDATE cz_config_hdrs SET baseline_rev_nbr = l_config_rev_nbr WHERE config_hdr_id = l_config_hdr_id

1135: UPDATE cz_config_hdrs SET effective_date = SYSDATE WHERE config_hdr_id = v_config_hdr_id
1136: AND config_rev_nbr = v_config_rev_nbr;
1137:
1138: -- set baseline rev for the new instance header
1139: UPDATE cz_config_hdrs SET baseline_rev_nbr = l_config_rev_nbr WHERE config_hdr_id = l_config_hdr_id
1140: AND config_rev_nbr = (SELECT instance_rev_nbr FROM cz_config_items WHERE config_hdr_id =
1141: v_config_hdr_id AND config_rev_nbr = v_config_rev_nbr AND
1142: component_instance_type = 'I');
1143: