DBA Data[Home] [Help]

APPS.CN_RULE_PVT dependencies on CN_RULES_ALL_B

Line 6: rule_id cn_rules_all_b.rule_id%TYPE,

2: --$Header: cnvrules.pls 120.3 2006/03/07 04:57:59 hanaraya ship $
3:
4: TYPE rule_rec_type IS RECORD
5: (ruleset_id cn_rulesets_all_b.ruleset_id%TYPE,
6: rule_id cn_rules_all_b.rule_id%TYPE,
7: rule_name VARCHAR2(80),
8: parent_rule_id cn_rules_all_b.rule_id%TYPE,
9: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,

Line 8: parent_rule_id cn_rules_all_b.rule_id%TYPE,

4: TYPE rule_rec_type IS RECORD
5: (ruleset_id cn_rulesets_all_b.ruleset_id%TYPE,
6: rule_id cn_rules_all_b.rule_id%TYPE,
7: rule_name VARCHAR2(80),
8: parent_rule_id cn_rules_all_b.rule_id%TYPE,
9: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
11: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
12: sequence_number cn_rules_hierarchy.sequence_number%TYPE,

Line 10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,

6: rule_id cn_rules_all_b.rule_id%TYPE,
7: rule_name VARCHAR2(80),
8: parent_rule_id cn_rules_all_b.rule_id%TYPE,
9: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
11: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
12: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
13: org_id cn_rules_all_b.org_id%TYPE,
14: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE

Line 11: liability_ccid cn_rules_all_b.liability_ccid%TYPE,

7: rule_name VARCHAR2(80),
8: parent_rule_id cn_rules_all_b.rule_id%TYPE,
9: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
11: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
12: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
13: org_id cn_rules_all_b.org_id%TYPE,
14: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
15: );

Line 13: org_id cn_rules_all_b.org_id%TYPE,

9: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
11: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
12: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
13: org_id cn_rules_all_b.org_id%TYPE,
14: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
15: );
16:
17: TYPE rule_out_rec_type IS RECORD

Line 14: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE

10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
11: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
12: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
13: org_id cn_rules_all_b.org_id%TYPE,
14: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
15: );
16:
17: TYPE rule_out_rec_type IS RECORD
18: (ruleset_id cn_rulesets_all_b.ruleset_id%TYPE,

Line 20: rule_id cn_rules_all_b.rule_id%TYPE,

16:
17: TYPE rule_out_rec_type IS RECORD
18: (ruleset_id cn_rulesets_all_b.ruleset_id%TYPE,
19: ruleset_name cn_rulesets_all_tl.name%TYPE,
20: rule_id cn_rules_all_b.rule_id%TYPE,
21: rule_name cn_rules_all_tl.name%TYPE,
22: expense_desc Varchar2(2000),
23: liability_desc Varchar2(2000),
24: revenue_class_name cn_revenue_classes.name%TYPE,

Line 25: parent_rule_id cn_rules_all_b.rule_id%TYPE,

21: rule_name cn_rules_all_tl.name%TYPE,
22: expense_desc Varchar2(2000),
23: liability_desc Varchar2(2000),
24: revenue_class_name cn_revenue_classes.name%TYPE,
25: parent_rule_id cn_rules_all_b.rule_id%TYPE,
26: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
27: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
28: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
29: sequence_number cn_rules_hierarchy.sequence_number%TYPE,

Line 27: expense_ccid cn_rules_all_b.expense_ccid%TYPE,

23: liability_desc Varchar2(2000),
24: revenue_class_name cn_revenue_classes.name%TYPE,
25: parent_rule_id cn_rules_all_b.rule_id%TYPE,
26: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
27: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
28: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
29: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
30: org_id cn_rules_all_b.org_id%TYPE,
31: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE

Line 28: liability_ccid cn_rules_all_b.liability_ccid%TYPE,

24: revenue_class_name cn_revenue_classes.name%TYPE,
25: parent_rule_id cn_rules_all_b.rule_id%TYPE,
26: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
27: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
28: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
29: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
30: org_id cn_rules_all_b.org_id%TYPE,
31: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
32: );

Line 30: org_id cn_rules_all_b.org_id%TYPE,

26: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
27: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
28: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
29: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
30: org_id cn_rules_all_b.org_id%TYPE,
31: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
32: );
33:
34: TYPE rule_tbl_type IS TABLE OF rule_out_rec_type

Line 31: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE

27: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
28: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
29: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
30: org_id cn_rules_all_b.org_id%TYPE,
31: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
32: );
33:
34: TYPE rule_tbl_type IS TABLE OF rule_out_rec_type
35: INDEX BY BINARY_INTEGER;

Line 167: p_rule_id IN cn_rules_all_b.rule_id%TYPE,

163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: x_loading_status OUT NOCOPY VARCHAR2,
167: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
168: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
169: p_org_id IN cn_rules_all_b.org_id%TYPE
170: );
171:

Line 168: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,

164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: x_loading_status OUT NOCOPY VARCHAR2,
167: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
168: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
169: p_org_id IN cn_rules_all_b.org_id%TYPE
170: );
171:
172: --============================================================================

Line 169: p_org_id IN cn_rules_all_b.org_id%TYPE

165: x_msg_data OUT NOCOPY VARCHAR2,
166: x_loading_status OUT NOCOPY VARCHAR2,
167: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
168: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
169: p_org_id IN cn_rules_all_b.org_id%TYPE
170: );
171:
172: --============================================================================
173: -- Start of Comments