APPS.CZ_IB_TRANSACTIONS dependencies on CZ_CONFIG_ITEMS_V

Line 946: FOR i IN(SELECT DISTINCT config_hdr_id,config_rev_nbr FROM CZ_CONFIG_ITEMS_V

942: -- nontrackable items ( IB_TRACKABLE = '0' )
943: -- also will be collected here
944: --
945:
946: FOR i IN(SELECT DISTINCT config_hdr_id,config_rev_nbr FROM CZ_CONFIG_ITEMS_V
947: WHERE instance_hdr_id=p_config_hdr_id AND
948: instance_rev_nbr=p_config_rev_nbr)
949: LOOP
950: LOG_REPORT(m_RUN_ID,'config_hdr_id='||TO_CHAR(i.config_hdr_id)||' config_rev_nbr='||TO_CHAR(i.config_rev_nbr));

Line 1032: SELECT NVL(ib_trackable,NO_FLAG) INTO v_ib_trackable FROM CZ_CONFIG_ITEMS_V

1028: LOOP
1029: IF t_target_item_tbl(i) IS NOT NULL THEN
1030: v_ib_trackable:=NO_FLAG;
1031: BEGIN
1032: SELECT NVL(ib_trackable,NO_FLAG) INTO v_ib_trackable FROM CZ_CONFIG_ITEMS_V
1033: WHERE instance_hdr_id = t_target_hdr_tbl(i) AND
1034: instance_rev_nbr = t_target_rev_nbr_tbl(i) AND
1035: config_item_id = t_target_item_tbl(i);
1036: EXCEPTION

Line 1069: FROM CZ_CONFIG_ITEMS_V

1065: BEGIN
1066: v_root_config_item_id:=NULL;
1067: SELECT instance_hdr_id,instance_rev_nbr,parent_config_item_id
1068: INTO v_root_instance_hdr_id,v_root_instance_rev_nbr,v_root_config_item_id
1069: FROM CZ_CONFIG_ITEMS_V
1070: WHERE instance_hdr_id=p_config_hdr_id AND
1071: instance_rev_nbr=p_config_rev_nbr AND
1072: config_item_id=p_config_item_id;
1073: EXCEPTION

Line 1208: FROM CZ_CONFIG_ITEMS_V

1204:
1205: BEGIN
1206: SELECT target_hdr_id,target_rev_nbr,target_config_item_id
1207: INTO v_target_hdr_id,v_target_rev_nbr,v_target_config_item_id
1208: FROM CZ_CONFIG_ITEMS_V
1209: WHERE instance_hdr_id=t_instance_hdr_tbl(i) AND instance_rev_nbr=v_baseline_rev_nbr AND
1210: config_item_id=t_config_item_tbl(i);
1211:
1212: IF NOT(v_target_hdr_id=t_target_hdr_tbl(i) AND v_target_config_item_id=t_target_item_tbl(i)) THEN

Line 1575: FROM CZ_CONFIG_ITEMS_V

1571: IF v_status NOT IN ('00','000','0000')THEN
1572:
1573: SELECT config_item_id
1574: BULK COLLECT INTO t_config_item_tbl
1575: FROM CZ_CONFIG_ITEMS_V
1576: WHERE instance_hdr_id=p_config_instance_tbl(i).config_hdr_id AND
1577: instance_rev_nbr=p_config_instance_tbl(i).new_config_rev_nbr AND
1578: ib_trackable='1';
1579:

Line 1606: FROM CZ_CONFIG_ITEMS_V

1602: --
1603: -- collect all Connectors that we are passing
1604: --
1605: FOR k IN (SELECT target_hdr_id,target_rev_nbr,target_config_item_id,config_item_id
1606: FROM CZ_CONFIG_ITEMS_V
1607: WHERE instance_hdr_id=p_config_instance_tbl(i).config_hdr_id AND
1608: instance_rev_nbr=p_config_instance_tbl(i).new_config_rev_nbr AND
1609: target_config_item_id IS NOT NULL)
1610: LOOP

Line 1615: FROM CZ_CONFIG_ITEMS_V

1611: BEGIN
1612: IF v_baseline_rev_nbr IS NOT NULL THEN
1613: SELECT target_hdr_id,target_rev_nbr,target_config_item_id
1614: INTO v_target_hdr_id,v_target_rev_nbr,v_target_config_item_id
1615: FROM CZ_CONFIG_ITEMS_V
1616: WHERE instance_hdr_id=p_config_instance_tbl(i).config_hdr_id AND
1617: instance_rev_nbr=v_baseline_rev_nbr AND config_item_id=k.config_item_id;
1618:
1619:

Line 2278: 'FROM CZ_CONFIG_ITEMS_V ' ||

2274: 'SELECT ' ||
2275: ' config_item_id ' ||
2276: 'BULK COLLECT INTO ' ||
2277: ' CZ_IB_TRANSACTIONS.m_config_item_tbl ' ||
2278: 'FROM CZ_CONFIG_ITEMS_V ' ||
2279: 'WHERE instance_hdr_id=:1 AND instance_rev_nbr=:2 ' ||
2280: ' AND CZ_UTILS.conv_num(item_val) IS NOT NULL AND ib_trackable=''1''; ' ||
2281: 'END;'
2282: USING p_config_hdr_id,p_config_rev_nbr;