162: l_msg_data VARCHAR2(10000);
163:
164: BEGIN
165:
166: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
167: aso_debug_pub.ADD (
168: 'Begin calling ASO_Apr_Pub.Get_All_Approvers',
169: 1,
170: 'N'
163:
164: BEGIN
165:
166: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
167: aso_debug_pub.ADD (
168: 'Begin calling ASO_Apr_Pub.Get_All_Approvers',
169: 1,
170: 'N'
171: );
183: x_msg_data => l_msg_data,
184: x_approvers_list => lx_approvers_list_tbl,
185: x_rules_list => lx_rules_list_tbl);
186:
187: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
188: aso_debug_pub.ADD (
189: 'Returning from ASO_Apr_Pub.Get_All_Approvers',
190: 1,
191: 'N'
184: x_approvers_list => lx_approvers_list_tbl,
185: x_rules_list => lx_rules_list_tbl);
186:
187: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
188: aso_debug_pub.ADD (
189: 'Returning from ASO_Apr_Pub.Get_All_Approvers',
190: 1,
191: 'N'
192: );
246: lx_rules_list_tbl ASO_Apr_Pub.Rules_List_Tbl_Type;
247: l_debug VARCHAR2(1);
248: BEGIN
249:
250: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
251: aso_debug_pub.ADD (
252: 'Begin calling ASO_Apr_Pub.Get_Rule_Details',
253: 1,
254: 'N'
247: l_debug VARCHAR2(1);
248: BEGIN
249:
250: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
251: aso_debug_pub.ADD (
252: 'Begin calling ASO_Apr_Pub.Get_Rule_Details',
253: 1,
254: 'N'
255: );
264: x_msg_count => x_msg_count,
265: x_msg_data => x_msg_data,
266: x_rules_list => lx_rules_list_tbl);
267:
268: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
269: aso_debug_pub.ADD (
270: 'Returning from ASO_Apr_Pub.Get_Rule_Details',
271: 1,
272: 'N'
265: x_msg_data => x_msg_data,
266: x_rules_list => lx_rules_list_tbl);
267:
268: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
269: aso_debug_pub.ADD (
270: 'Returning from ASO_Apr_Pub.Get_Rule_Details',
271: 1,
272: 'N'
273: );
281: x_rule_description => x_qr_rule_description,
282: x_approval_level => x_qr_approval_level
283: );
284:
285: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
286: aso_debug_pub.ADD (
287: 'Returning from Set_Rules_List_Tbl_Out',
288: 1,
289: 'N'
282: x_approval_level => x_qr_approval_level
283: );
284:
285: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
286: aso_debug_pub.ADD (
287: 'Returning from Set_Rules_List_Tbl_Out',
288: 1,
289: 'N'
290: );