APPS.CZ_IB_TRANSACTIONS dependencies on CZ_CONFIG_HDRS

Line 1056: FROM cz_config_hdrs

1052:
1053: BEGIN
1054: v_baseline_rev_nbr:=NULL;
1055: SELECT baseline_rev_nbr INTO v_baseline_rev_nbr
1056: FROM cz_config_hdrs
1057: WHERE config_hdr_id=p_config_hdr_id AND
1058: config_rev_nbr=p_config_rev_nbr AND
1059: deleted_flag=NO_FLAG;
1060: EXCEPTION

Line 1598: FROM CZ_CONFIG_HDRS

1594: FOR i IN p_config_instance_tbl.FIRST..p_config_instance_tbl.LAST
1595: LOOP
1596:
1597: SELECT baseline_rev_nbr INTO v_baseline_rev_nbr
1598: FROM CZ_CONFIG_HDRS
1599: WHERE config_hdr_id=p_config_instance_tbl(i).config_hdr_id AND
1600: config_rev_nbr=p_config_instance_tbl(i).new_config_rev_nbr AND deleted_flag=NO_FLAG;
1601:
1602: --

Line 1686: SELECT baseline_rev_nbr INTO v_baseline_rev_nbr FROM CZ_CONFIG_HDRS

1682:
1683: v_baseline_rev_nbr:=t_rltns_tbl(t).obj_config_inst_rev_num;
1684:
1685: BEGIN
1686: SELECT baseline_rev_nbr INTO v_baseline_rev_nbr FROM CZ_CONFIG_HDRS
1687: WHERE config_hdr_id=t_rltns_tbl(t).obj_config_inst_hdr_id AND
1688: config_rev_nbr=t_rltns_tbl(t).obj_config_inst_rev_num AND
1689: deleted_flag=NO_FLAG;
1690: LOG_REPORT(m_RUN_ID,'baseline_rev_nbr = '||TO_CHAR(v_baseline_rev_nbr)||

Line 1974: * IF either the CZ_CONFIG_HDRS.config_status field IS SET TO INCOMPLETE OR

1970:
1971: /**
1972: * The method will UPDATE the status OF the IB instance
1973: * <=> CSI_T_TRANSACTION_LINES.CONFIG_VALID_STATUS / CSI_ITEM_INSTANCES.CONFIG_VALID_STATUS TO be INVALID
1974: * IF either the CZ_CONFIG_HDRS.config_status field IS SET TO INCOMPLETE OR
1975: * the CZ_CONFIG_HDRS.has_failures field IS SET TO TRUE, otherwise, it will be SET TO VALID
1976: */
1977: PROCEDURE Update_Instances_Status
1978: (

Line 1975: * the CZ_CONFIG_HDRS.has_failures field IS SET TO TRUE, otherwise, it will be SET TO VALID

1971: /**
1972: * The method will UPDATE the status OF the IB instance
1973: * <=> CSI_T_TRANSACTION_LINES.CONFIG_VALID_STATUS / CSI_ITEM_INSTANCES.CONFIG_VALID_STATUS TO be INVALID
1974: * IF either the CZ_CONFIG_HDRS.config_status field IS SET TO INCOMPLETE OR
1975: * the CZ_CONFIG_HDRS.has_failures field IS SET TO TRUE, otherwise, it will be SET TO VALID
1976: */
1977: PROCEDURE Update_Instances_Status
1978: (
1979: p_config_instance_tbl IN SYSTEM.cz_config_instance_tbl_type,

Line 1996: FOR k IN (SELECT config_status,has_failures FROM cz_config_hdrs

1992: END IF;
1993:
1994: FOR i IN p_config_instance_tbl.FIRST..p_config_instance_tbl.LAST
1995: LOOP
1996: FOR k IN (SELECT config_status,has_failures FROM cz_config_hdrs
1997: WHERE config_hdr_id=p_config_instance_tbl(i).config_hdr_id AND
1998: config_rev_nbr=p_config_instance_tbl(i).new_config_rev_nbr AND deleted_flag=NO_FLAG)
1999: LOOP
2000: IF (k.config_status=INCOMPLETE_CONFIG_STATUS OR k.has_failures=YES_FLAG) THEN