PACKAGE: APPS.AMS_IBA_PS_RULES_PKG

Source

1 PACKAGE AMS_IBA_PS_RULES_PKG AS
2 /* $Header: amstruls.pls 120.0 2005/05/31 16:01:37 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_IBA_PS_RULES_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 PROCEDURE Insert_Row(
17           p_created_by    NUMBER,
18           p_creation_date    DATE,
19           p_last_updated_by    NUMBER,
20           p_last_update_date    DATE,
21           p_last_update_login    NUMBER,
22           px_object_version_number   IN OUT NOCOPY NUMBER,
23           px_rule_id   IN OUT NOCOPY NUMBER,
24           p_rulegroup_id    NUMBER,
25           p_posting_id    NUMBER,
26           p_strategy_id    NUMBER,
27 	  p_exec_priority  NUMBER,
28           p_bus_priority_code    VARCHAR2,
29           p_bus_priority_disp_order    VARCHAR2,
30           p_clausevalue1    VARCHAR2,
31           p_clausevalue2    NUMBER,
32           p_clausevalue3    VARCHAR2,
33           p_clausevalue4    VARCHAR2,
34           p_clausevalue5    NUMBER,
35           p_clausevalue6    VARCHAR2,
36           p_clausevalue7    VARCHAR2,
37           p_clausevalue8    VARCHAR2,
38           p_clausevalue9    VARCHAR2,
39           p_clausevalue10    VARCHAR2,
40 	  p_use_clause6	     VARCHAR2,
41 	  p_use_clause7	     VARCHAR2,
42 	  p_use_clause8	     VARCHAR2,
43 	  p_use_clause9	     VARCHAR2,
44 	  p_use_clause10     VARCHAR2);
45 
46 PROCEDURE Update_Row(
47           p_created_by    NUMBER,
48           p_creation_date    DATE,
49           p_last_updated_by    NUMBER,
50           p_last_update_date    DATE,
51           p_last_update_login    NUMBER,
52           p_object_version_number    NUMBER,
53           p_rule_id    NUMBER,
54           p_rulegroup_id    NUMBER,
55           p_posting_id    NUMBER,
56           p_strategy_id    NUMBER,
57 	  p_exec_priority  NUMBER,
58           p_bus_priority_code    VARCHAR2,
59           p_bus_priority_disp_order    VARCHAR2,
60           p_clausevalue1    VARCHAR2,
61           p_clausevalue2    NUMBER,
62           p_clausevalue3    VARCHAR2,
63           p_clausevalue4    VARCHAR2,
64           p_clausevalue5    NUMBER,
65           p_clausevalue6    VARCHAR2,
66           p_clausevalue7    VARCHAR2,
67           p_clausevalue8    VARCHAR2,
68           p_clausevalue9    VARCHAR2,
69           p_clausevalue10    VARCHAR2,
70           p_use_clause6      VARCHAR2,
71           p_use_clause7      VARCHAR2,
72           p_use_clause8      VARCHAR2,
73           p_use_clause9      VARCHAR2,
74           p_use_clause10     VARCHAR2);
75 
76 PROCEDURE Delete_Row(
77     p_RULE_ID  NUMBER);
78 PROCEDURE Lock_Row(
79           p_created_by    NUMBER,
80           p_creation_date    DATE,
81           p_last_updated_by    NUMBER,
82           p_last_update_date    DATE,
83           p_last_update_login    NUMBER,
84           p_object_version_number    NUMBER,
85           p_rule_id    NUMBER,
86           p_rulegroup_id    NUMBER,
87           p_posting_id    NUMBER,
88           p_strategy_id    NUMBER,
89           p_bus_priority_code    VARCHAR2,
90           p_bus_priority_disp_order    VARCHAR2,
91           p_clausevalue1    VARCHAR2,
92           p_clausevalue2    NUMBER,
93           p_clausevalue3    VARCHAR2,
94           p_clausevalue4    VARCHAR2,
95           p_clausevalue5    NUMBER,
96           p_clausevalue6    VARCHAR2,
97           p_clausevalue7    VARCHAR2,
98           p_clausevalue8    VARCHAR2,
99           p_clausevalue9    VARCHAR2,
100           p_clausevalue10    VARCHAR2);
101 
102 END AMS_IBA_PS_RULES_PKG;