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 980: v_data_type cz_signature_arguments.data_type%TYPE;

976: p_signature_id IN NUMBER,
977: x_mutable IN OUT NOCOPY VARCHAR2,
978: x_collection IN OUT NOCOPY VARCHAR2)
979: RETURN NUMBER IS
980: v_data_type cz_signature_arguments.data_type%TYPE;
981: BEGIN
982: SELECT data_type, mutable_flag, collection_flag INTO v_data_type, x_mutable, x_collection
983: FROM cz_signature_arguments
984: WHERE deleted_flag = FLAG_NOT_DELETED

Line 983: FROM cz_signature_arguments

979: RETURN NUMBER IS
980: v_data_type cz_signature_arguments.data_type%TYPE;
981: BEGIN
982: SELECT data_type, mutable_flag, collection_flag INTO v_data_type, x_mutable, x_collection
983: FROM cz_signature_arguments
984: WHERE deleted_flag = FLAG_NOT_DELETED
985: AND argument_signature_id = p_signature_id
986: AND argument_index = p_param_index;
987: RETURN v_data_type;

Line 996: v_data_type cz_signature_arguments.data_type%TYPE;

992: ---------------------------------------------------------------------------------------
993: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_id IN NUMBER) RETURN BOOLEAN IS
994: v_null PLS_INTEGER;
995: v_ps_node_id NUMBER;
996: v_data_type cz_signature_arguments.data_type%TYPE;
997: v_mutable cz_signature_arguments.mutable_flag%TYPE;
998: v_collection cz_signature_arguments.collection_flag%TYPE;
999: BEGIN
1000:

Line 997: v_mutable cz_signature_arguments.mutable_flag%TYPE;

993: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_id IN NUMBER) RETURN BOOLEAN IS
994: v_null PLS_INTEGER;
995: v_ps_node_id NUMBER;
996: v_data_type cz_signature_arguments.data_type%TYPE;
997: v_mutable cz_signature_arguments.mutable_flag%TYPE;
998: v_collection cz_signature_arguments.collection_flag%TYPE;
999: BEGIN
1000:
1001: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded

Line 998: v_collection cz_signature_arguments.collection_flag%TYPE;

994: v_null PLS_INTEGER;
995: v_ps_node_id NUMBER;
996: v_data_type cz_signature_arguments.data_type%TYPE;
997: v_mutable cz_signature_arguments.mutable_flag%TYPE;
998: v_collection cz_signature_arguments.collection_flag%TYPE;
999: BEGIN
1000:
1001: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded
1002: --rules are not real statement rules, so they are not supposed to have any user error in them and in this

Line 1040: v_data_type cz_signature_arguments.data_type%TYPE;

1036: ---------------------------------------------------------------------------------------
1037: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_name IN VARCHAR2) RETURN BOOLEAN IS
1038: v_null PLS_INTEGER;
1039: v_ps_node_id NUMBER;
1040: v_data_type cz_signature_arguments.data_type%TYPE;
1041: v_mutable cz_signature_arguments.mutable_flag%TYPE;
1042: v_collection cz_signature_arguments.collection_flag%TYPE;
1043: BEGIN
1044:

Line 1041: v_mutable cz_signature_arguments.mutable_flag%TYPE;

1037: FUNCTION APPLICABLE_SYS_PROP(j IN PLS_INTEGER, p_ps_node_id IN NUMBER, p_rule_name IN VARCHAR2) RETURN BOOLEAN IS
1038: v_null PLS_INTEGER;
1039: v_ps_node_id NUMBER;
1040: v_data_type cz_signature_arguments.data_type%TYPE;
1041: v_mutable cz_signature_arguments.mutable_flag%TYPE;
1042: v_collection cz_signature_arguments.collection_flag%TYPE;
1043: BEGIN
1044:
1045: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded

Line 1042: v_collection cz_signature_arguments.collection_flag%TYPE;

1038: v_null PLS_INTEGER;
1039: v_ps_node_id NUMBER;
1040: v_data_type cz_signature_arguments.data_type%TYPE;
1041: v_mutable cz_signature_arguments.mutable_flag%TYPE;
1042: v_collection cz_signature_arguments.collection_flag%TYPE;
1043: BEGIN
1044:
1045: --Some of the upgraded rules may not have param_index and param_signature_id populated. However, upgraded
1046: --rules are not real statement rules, so they are not supposed to have any user error in them and in this