eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_PS_RULE_PVT dependencies on FND_API

Line 32: name VARCHAR2(30) := FND_API.G_MISS_CHAR,

28: --
29: -- End of Comments
30: TYPE ps_rules_tuple_rec_type IS RECORD
31: (
32: name VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: value VARCHAR2(30) := FND_API.G_MISS_CHAR
34: );
35:
36: g_miss_ps_rules_tuple_rec ps_rules_tuple_rec_type;

Line 33: value VARCHAR2(30) := FND_API.G_MISS_CHAR

29: -- End of Comments
30: TYPE ps_rules_tuple_rec_type IS RECORD
31: (
32: name VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: value VARCHAR2(30) := FND_API.G_MISS_CHAR
34: );
35:
36: g_miss_ps_rules_tuple_rec ps_rules_tuple_rec_type;
37: TYPE ps_rules_tuple_tbl_type IS TABLE OF ps_rules_tuple_rec_type INDEX BY BINARY_INTEGER;

Line 90: created_by NUMBER := FND_API.G_MISS_NUM,

86: );
87:
88: TYPE ps_rules_rec_type IS RECORD
89: (
90: created_by NUMBER := FND_API.G_MISS_NUM,
91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 91: creation_date DATE := FND_API.G_MISS_DATE,

87:
88: TYPE ps_rules_rec_type IS RECORD
89: (
90: created_by NUMBER := FND_API.G_MISS_NUM,
91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 92: last_updated_by NUMBER := FND_API.G_MISS_NUM,

88: TYPE ps_rules_rec_type IS RECORD
89: (
90: created_by NUMBER := FND_API.G_MISS_NUM,
91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,

Line 93: last_update_date DATE := FND_API.G_MISS_DATE,

89: (
90: created_by NUMBER := FND_API.G_MISS_NUM,
91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,

Line 94: last_update_login NUMBER := FND_API.G_MISS_NUM,

90: created_by NUMBER := FND_API.G_MISS_NUM,
91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,

Line 95: object_version_number NUMBER := FND_API.G_MISS_NUM,

91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,

Line 96: rule_id NUMBER := FND_API.G_MISS_NUM,

92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,

Line 97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,

93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 98: posting_id NUMBER := FND_API.G_MISS_NUM,

94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 99: strategy_id NUMBER := FND_API.G_MISS_NUM,

95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 100: exec_priority NUMBER := FND_API.G_MISS_NUM,

96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,

Line 101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,

98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,

99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,

Line 104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,

100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,

101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,

102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,

103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,

104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,

105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,

106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,

107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,

108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,

109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,
117: use_clause10 VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,

110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,
117: use_clause10 VARCHAR2(1) := FND_API.G_MISS_CHAR
118: );

Line 115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,

111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,
117: use_clause10 VARCHAR2(1) := FND_API.G_MISS_CHAR
118: );
119:

Line 116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,

112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,
117: use_clause10 VARCHAR2(1) := FND_API.G_MISS_CHAR
118: );
119:
120: g_miss_ps_rules_rec ps_rules_rec_type;

Line 117: use_clause10 VARCHAR2(1) := FND_API.G_MISS_CHAR

113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,
117: use_clause10 VARCHAR2(1) := FND_API.G_MISS_CHAR
118: );
119:
120: g_miss_ps_rules_rec ps_rules_rec_type;
121: TYPE ps_rules_tbl_type IS TABLE OF ps_rules_rec_type INDEX BY BINARY_INTEGER;

Line 137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

133: -- Parameters
134: --
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_ps_rules_rec IN ps_rules_rec_type Required
141: --

Line 138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

134: --
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_ps_rules_rec IN ps_rules_rec_type Required
141: --
142: -- OUT

Line 139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_ps_rules_rec IN ps_rules_rec_type Required
141: --
142: -- OUT
143: -- x_return_status OUT VARCHAR2

Line 156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

152: --
153:
154: PROCEDURE Create_Ps_Rule(
155: p_api_version_number IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159:
160: x_return_status OUT NOCOPY VARCHAR2,

Line 157: p_commit IN VARCHAR2 := FND_API.G_FALSE,

153:
154: PROCEDURE Create_Ps_Rule(
155: p_api_version_number IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159:
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,

Line 158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

154: PROCEDURE Create_Ps_Rule(
155: p_api_version_number IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159:
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,

Line 182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

178: -- Parameters
179: --
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_ps_rules_rec IN ps_rules_rec_type Required
186: --

Line 183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

179: --
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_ps_rules_rec IN ps_rules_rec_type Required
186: --
187: -- OUT

Line 184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_ps_rules_rec IN ps_rules_rec_type Required
186: --
187: -- OUT
188: -- x_return_status OUT VARCHAR2

Line 201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

197: --
198:
199: PROCEDURE Update_Ps_Rule(
200: p_api_version_number IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204:
205: x_return_status OUT NOCOPY VARCHAR2,

Line 202: p_commit IN VARCHAR2 := FND_API.G_FALSE,

198:
199: PROCEDURE Update_Ps_Rule(
200: p_api_version_number IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204:
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,

Line 203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

199: PROCEDURE Update_Ps_Rule(
200: p_api_version_number IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204:
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,

Line 219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

215:
216:
217: PROCEDURE Update_Ps_Rule_Alt(
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222:
223: x_return_status OUT NOCOPY VARCHAR2,

Line 220: p_commit IN VARCHAR2 := FND_API.G_FALSE,

216:
217: PROCEDURE Update_Ps_Rule_Alt(
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222:
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,

Line 221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

217: PROCEDURE Update_Ps_Rule_Alt(
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222:
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,

Line 251: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

247: -- Parameters
248: --
249: -- IN
250: -- p_api_version_number IN NUMBER Required
251: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
252: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254: -- p_RULE_ID IN NUMBER
255: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 252: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

248: --
249: -- IN
250: -- p_api_version_number IN NUMBER Required
251: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
252: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254: -- p_RULE_ID IN NUMBER
255: -- p_object_version_number IN NUMBER Optional Default = NULL
256: --

Line 253: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

249: -- IN
250: -- p_api_version_number IN NUMBER Required
251: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
252: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254: -- p_RULE_ID IN NUMBER
255: -- p_object_version_number IN NUMBER Optional Default = NULL
256: --
257: -- OUT

Line 271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

267: --
268:
269: PROCEDURE Delete_Ps_Rule(
270: p_api_version_number IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,

Line 272: p_commit IN VARCHAR2 := FND_API.G_FALSE,

268:
269: PROCEDURE Delete_Ps_Rule(
270: p_api_version_number IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,

Line 273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

269: PROCEDURE Delete_Ps_Rule(
270: p_api_version_number IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,
277: p_rule_id IN NUMBER,

Line 283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

279: );
280:
281: PROCEDURE Delete_Ps_Rule_Alt(
282: p_api_version_number IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,

Line 284: p_commit IN VARCHAR2 := FND_API.G_FALSE,

280:
281: PROCEDURE Delete_Ps_Rule_Alt(
282: p_api_version_number IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,

Line 285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

281: PROCEDURE Delete_Ps_Rule_Alt(
282: p_api_version_number IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,
289: p_ps_rules_rec IN ps_rules_rec_type,

Line 306: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

302: -- Parameters
303: --
304: -- IN
305: -- p_api_version_number IN NUMBER Required
306: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
307: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
308: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
309: -- p_ps_rules_rec IN ps_rules_rec_type Required
310: --

Line 307: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

303: --
304: -- IN
305: -- p_api_version_number IN NUMBER Required
306: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
307: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
308: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
309: -- p_ps_rules_rec IN ps_rules_rec_type Required
310: --
311: -- OUT

Line 308: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

304: -- IN
305: -- p_api_version_number IN NUMBER Required
306: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
307: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
308: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
309: -- p_ps_rules_rec IN ps_rules_rec_type Required
310: --
311: -- OUT
312: -- x_return_status OUT VARCHAR2

Line 325: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

321: --
322:
323: PROCEDURE Lock_Ps_Rule(
324: p_api_version_number IN NUMBER,
325: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
326:
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
329: x_msg_data OUT NOCOPY VARCHAR2,

Line 350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

346:
347:
348: PROCEDURE Validate_ps_rule(
349: p_api_version_number IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
352: p_ps_rules_rec IN ps_rules_rec_type,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_msg_count OUT NOCOPY NUMBER,

Line 351: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

347:
348: PROCEDURE Validate_ps_rule(
349: p_api_version_number IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
352: p_ps_rules_rec IN ps_rules_rec_type,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_msg_count OUT NOCOPY NUMBER,
355: x_msg_data OUT NOCOPY VARCHAR2

Line 409: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

405: -- End of Comments
406:
407: PROCEDURE Validate_ps_rules_rec(
408: p_api_version_number IN NUMBER,
409: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
410: x_return_status OUT NOCOPY VARCHAR2,
411: x_msg_count OUT NOCOPY NUMBER,
412: x_msg_data OUT NOCOPY VARCHAR2,
413: p_ps_rules_rec IN ps_rules_rec_type