DBA Data[Home] [Help]

APPS.CZ_LOGIC_GEN dependencies on CZ_SIGNATURE_ARGUMENTS

Line 89: TYPE tArgumentName IS TABLE OF cz_signature_arguments.argument_name%TYPE INDEX BY BINARY_INTEGER;

85:
86: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
87: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE tArgumentName IS TABLE OF cz_signature_arguments.argument_name%TYPE INDEX BY BINARY_INTEGER;
90: TYPE tArgumentIndex IS TABLE OF cz_signature_arguments.argument_index%TYPE INDEX BY BINARY_INTEGER;
91: TYPE tDataType IS TABLE OF cz_signature_arguments.data_type%TYPE INDEX BY BINARY_INTEGER;
92:
93: commit_counter PLS_INTEGER := 0;

Line 90: TYPE tArgumentIndex IS TABLE OF cz_signature_arguments.argument_index%TYPE INDEX BY BINARY_INTEGER;

86: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
87: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE tArgumentName IS TABLE OF cz_signature_arguments.argument_name%TYPE INDEX BY BINARY_INTEGER;
90: TYPE tArgumentIndex IS TABLE OF cz_signature_arguments.argument_index%TYPE INDEX BY BINARY_INTEGER;
91: TYPE tDataType IS TABLE OF cz_signature_arguments.data_type%TYPE INDEX BY BINARY_INTEGER;
92:
93: commit_counter PLS_INTEGER := 0;
94: CommitBlockSize PLS_INTEGER;

Line 91: TYPE tDataType IS TABLE OF cz_signature_arguments.data_type%TYPE INDEX BY BINARY_INTEGER;

87: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE tArgumentName IS TABLE OF cz_signature_arguments.argument_name%TYPE INDEX BY BINARY_INTEGER;
90: TYPE tArgumentIndex IS TABLE OF cz_signature_arguments.argument_index%TYPE INDEX BY BINARY_INTEGER;
91: TYPE tDataType IS TABLE OF cz_signature_arguments.data_type%TYPE INDEX BY BINARY_INTEGER;
92:
93: commit_counter PLS_INTEGER := 0;
94: CommitBlockSize PLS_INTEGER;
95: OptimizeNotTrue PLS_INTEGER;

Line 969: v_data_type cz_signature_arguments.data_type%TYPE;

965: p_signature_id IN NUMBER,
966: x_mutable IN OUT NOCOPY VARCHAR2,
967: x_collection IN OUT NOCOPY VARCHAR2)
968: RETURN NUMBER IS
969: v_data_type cz_signature_arguments.data_type%TYPE;
970: BEGIN
971: SELECT data_type, mutable_flag, collection_flag INTO v_data_type, x_mutable, x_collection
972: FROM cz_signature_arguments
973: WHERE deleted_flag = FLAG_NOT_DELETED

Line 972: FROM cz_signature_arguments

968: RETURN NUMBER IS
969: v_data_type cz_signature_arguments.data_type%TYPE;
970: BEGIN
971: SELECT data_type, mutable_flag, collection_flag INTO v_data_type, x_mutable, x_collection
972: FROM cz_signature_arguments
973: WHERE deleted_flag = FLAG_NOT_DELETED
974: AND argument_signature_id = p_signature_id
975: AND argument_index = p_param_index;
976: RETURN v_data_type;

Line 985: v_data_type cz_signature_arguments.data_type%TYPE;

981: ---------------------------------------------------------------------------------------
982: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_id IN NUMBER) RETURN BOOLEAN IS
983: v_null PLS_INTEGER;
984: v_ps_node_id NUMBER;
985: v_data_type cz_signature_arguments.data_type%TYPE;
986: v_mutable cz_signature_arguments.mutable_flag%TYPE;
987: v_collection cz_signature_arguments.collection_flag%TYPE;
988: BEGIN
989:

Line 986: v_mutable cz_signature_arguments.mutable_flag%TYPE;

982: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_id IN NUMBER) RETURN BOOLEAN IS
983: v_null PLS_INTEGER;
984: v_ps_node_id NUMBER;
985: v_data_type cz_signature_arguments.data_type%TYPE;
986: v_mutable cz_signature_arguments.mutable_flag%TYPE;
987: v_collection cz_signature_arguments.collection_flag%TYPE;
988: BEGIN
989:
990: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded

Line 987: v_collection cz_signature_arguments.collection_flag%TYPE;

983: v_null PLS_INTEGER;
984: v_ps_node_id NUMBER;
985: v_data_type cz_signature_arguments.data_type%TYPE;
986: v_mutable cz_signature_arguments.mutable_flag%TYPE;
987: v_collection cz_signature_arguments.collection_flag%TYPE;
988: BEGIN
989:
990: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded
991: --rules are not real statement rules, so they are not supposed to have any user error in them and in this

Line 1029: v_data_type cz_signature_arguments.data_type%TYPE;

1025: ---------------------------------------------------------------------------------------
1026: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_name IN VARCHAR2) RETURN BOOLEAN IS
1027: v_null PLS_INTEGER;
1028: v_ps_node_id NUMBER;
1029: v_data_type cz_signature_arguments.data_type%TYPE;
1030: v_mutable cz_signature_arguments.mutable_flag%TYPE;
1031: v_collection cz_signature_arguments.collection_flag%TYPE;
1032: BEGIN
1033:

Line 1030: v_mutable cz_signature_arguments.mutable_flag%TYPE;

1026: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_name IN VARCHAR2) RETURN BOOLEAN IS
1027: v_null PLS_INTEGER;
1028: v_ps_node_id NUMBER;
1029: v_data_type cz_signature_arguments.data_type%TYPE;
1030: v_mutable cz_signature_arguments.mutable_flag%TYPE;
1031: v_collection cz_signature_arguments.collection_flag%TYPE;
1032: BEGIN
1033:
1034: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded

Line 1031: v_collection cz_signature_arguments.collection_flag%TYPE;

1027: v_null PLS_INTEGER;
1028: v_ps_node_id NUMBER;
1029: v_data_type cz_signature_arguments.data_type%TYPE;
1030: v_mutable cz_signature_arguments.mutable_flag%TYPE;
1031: v_collection cz_signature_arguments.collection_flag%TYPE;
1032: BEGIN
1033:
1034: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded
1035: --rules are not real statement rules, so they are not supposed to have any user error in them and in this