DBA Data[Home] [Help]

APPS.CZ_RULE_IMPORT dependencies on CZ_RULES_S

Line 414: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM dual;

410:
411: IF((last_id_allocated IS NULL) OR
412: (next_id_to_use = (NVL(last_id_allocated, 0) + id_increment)))THEN
413:
414: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM dual;
415: next_id_to_use := last_id_allocated;
416: END IF;
417:
418: id_to_return := next_id_to_use;

Line 872: UPDATE cz_rules SET

868: --FORALL i IN 1..t_rule_id.COUNT does not work in 8i because rule_text and noted are CLOB columns.
869:
870: FOR i IN 1..t_rule_id.COUNT LOOP
871:
872: UPDATE cz_rules SET
873: reason_id = t_reason_id(i),
874: rule_folder_id = t_rule_folder_id(i),
875: devl_project_id = t_devl_project_id(i),
876: invalid_flag = t_invalid_flag(i),

Line 1079: UPDATE cz_rules SET

1075: BEGIN
1076:
1077: SAVEPOINT update_rule_record;
1078:
1079: UPDATE cz_rules SET
1080: reason_id = t_reason_id(i),
1081: rule_folder_id = t_rule_folder_id(i),
1082: devl_project_id = t_devl_project_id(i),
1083: invalid_flag = t_invalid_flag(i),