216: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_true,
217: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
218: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
219: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
220: x_approvers_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.approvers_list_tbl_type,
221: x_rules_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.rules_list_tbl_type
222: ) IS
223: l_api_name CONSTANT VARCHAR2 (30) := 'GET_ALL_APPROVERS';
224: l_api_version CONSTANT NUMBER := 1.0;
217: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
218: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
219: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
220: x_approvers_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.approvers_list_tbl_type,
221: x_rules_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.rules_list_tbl_type
222: ) IS
223: l_api_name CONSTANT VARCHAR2 (30) := 'GET_ALL_APPROVERS';
224: l_api_version CONSTANT NUMBER := 1.0;
225: approvers ame_util.approverstable;
610: p_rule_id NUMBER;
611: l_return_status VARCHAR2 (10);
612: l_msg_count NUMBER;
613: l_msg_data VARCHAR2 (240);
614: x_approvers_list aso_apr_pub.approvers_list_tbl_type;
615: x_rules_list aso_apr_pub.rules_list_tbl_type;
616: l_approver_status VARCHAR2 (30);
617: l_approver_sequence NUMBER;
618: p_sender_name VARCHAR2 (240);
611: l_return_status VARCHAR2 (10);
612: l_msg_count NUMBER;
613: l_msg_data VARCHAR2 (240);
614: x_approvers_list aso_apr_pub.approvers_list_tbl_type;
615: x_rules_list aso_apr_pub.rules_list_tbl_type;
616: l_approver_status VARCHAR2 (30);
617: l_approver_sequence NUMBER;
618: p_sender_name VARCHAR2 (240);
619: l_requester_group_id NUMBER;
1661: p_api_version_number IN NUMBER,
1662: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1663: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1664: p_object_approval_id IN NUMBER,
1665: x_rules_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.rules_list_tbl_type,
1666: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1667: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1668: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1669: IS