2: /* $Header: asowaprs.pls 120.0 2005/06/01 17:59:08 appldev noship $ */
3:
4: PROCEDURE Set_Approvers_List_Tbl_Out(
5: p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
6: x_approval_det_id OUT NOCOPY jtf_number_table,
7: x_object_approval_id OUT NOCOPY jtf_number_table,
8: x_approver_person_id OUT NOCOPY jtf_number_table,
9: x_approver_user_id OUT NOCOPY jtf_number_table,
10: x_notification_id OUT NOCOPY jtf_number_table,
3:
4: PROCEDURE Set_Approvers_List_Tbl_Out(
5: p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
6: x_approval_det_id OUT NOCOPY jtf_number_table,
7: x_object_approval_id OUT NOCOPY jtf_number_table,
8: x_approver_person_id OUT NOCOPY jtf_number_table,
9: x_approver_user_id OUT NOCOPY jtf_number_table,
10: x_notification_id OUT NOCOPY jtf_number_table,
11: x_approver_sequence OUT NOCOPY jtf_number_table,
4: PROCEDURE Set_Approvers_List_Tbl_Out(
5: p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
6: x_approval_det_id OUT NOCOPY jtf_number_table,
7: x_object_approval_id OUT NOCOPY jtf_number_table,
8: x_approver_person_id OUT NOCOPY jtf_number_table,
9: x_approver_user_id OUT NOCOPY jtf_number_table,
10: x_notification_id OUT NOCOPY jtf_number_table,
11: x_approver_sequence OUT NOCOPY jtf_number_table,
12: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
5: p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
6: x_approval_det_id OUT NOCOPY jtf_number_table,
7: x_object_approval_id OUT NOCOPY jtf_number_table,
8: x_approver_person_id OUT NOCOPY jtf_number_table,
9: x_approver_user_id OUT NOCOPY jtf_number_table,
10: x_notification_id OUT NOCOPY jtf_number_table,
11: x_approver_sequence OUT NOCOPY jtf_number_table,
12: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
13: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
6: x_approval_det_id OUT NOCOPY jtf_number_table,
7: x_object_approval_id OUT NOCOPY jtf_number_table,
8: x_approver_person_id OUT NOCOPY jtf_number_table,
9: x_approver_user_id OUT NOCOPY jtf_number_table,
10: x_notification_id OUT NOCOPY jtf_number_table,
11: x_approver_sequence OUT NOCOPY jtf_number_table,
12: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
13: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
14: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
7: x_object_approval_id OUT NOCOPY jtf_number_table,
8: x_approver_person_id OUT NOCOPY jtf_number_table,
9: x_approver_user_id OUT NOCOPY jtf_number_table,
10: x_notification_id OUT NOCOPY jtf_number_table,
11: x_approver_sequence OUT NOCOPY jtf_number_table,
12: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
13: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
14: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
15: x_date_sent OUT NOCOPY jtf_date_table,
17: );
18:
19: PROCEDURE Set_Rules_List_Tbl_Out(
20: p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,
21: x_rule_id OUT NOCOPY jtf_number_table,
22: x_object_approval_id OUT NOCOPY jtf_number_table,
23: x_rule_action_id OUT NOCOPY jtf_number_table,
24: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
25: x_approval_level OUT NOCOPY jtf_varchar2_table_300
18:
19: PROCEDURE Set_Rules_List_Tbl_Out(
20: p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,
21: x_rule_id OUT NOCOPY jtf_number_table,
22: x_object_approval_id OUT NOCOPY jtf_number_table,
23: x_rule_action_id OUT NOCOPY jtf_number_table,
24: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
25: x_approval_level OUT NOCOPY jtf_varchar2_table_300
26: );
19: PROCEDURE Set_Rules_List_Tbl_Out(
20: p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,
21: x_rule_id OUT NOCOPY jtf_number_table,
22: x_object_approval_id OUT NOCOPY jtf_number_table,
23: x_rule_action_id OUT NOCOPY jtf_number_table,
24: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
25: x_approval_level OUT NOCOPY jtf_varchar2_table_300
26: );
27:
25: x_approval_level OUT NOCOPY jtf_varchar2_table_300
26: );
27:
28: PROCEDURE Get_All_Approvers(
29: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
30: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
31: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
32: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
33: x_qa_notification_id OUT NOCOPY jtf_number_table ,
26: );
27:
28: PROCEDURE Get_All_Approvers(
29: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
30: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
31: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
32: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
33: x_qa_notification_id OUT NOCOPY jtf_number_table ,
34: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
27:
28: PROCEDURE Get_All_Approvers(
29: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
30: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
31: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
32: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
33: x_qa_notification_id OUT NOCOPY jtf_number_table ,
34: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
35: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
28: PROCEDURE Get_All_Approvers(
29: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
30: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
31: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
32: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
33: x_qa_notification_id OUT NOCOPY jtf_number_table ,
34: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
35: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
36: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
29: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
30: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
31: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
32: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
33: x_qa_notification_id OUT NOCOPY jtf_number_table ,
34: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
35: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
36: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
37: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
30: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
31: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
32: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
33: x_qa_notification_id OUT NOCOPY jtf_number_table ,
34: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
35: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
36: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
37: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
38: x_qa_date_sent OUT NOCOPY jtf_date_table ,
36: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
37: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
38: x_qa_date_sent OUT NOCOPY jtf_date_table ,
39: x_qa_date_received OUT NOCOPY jtf_date_table ,
40: x_qr_rule_id OUT NOCOPY jtf_number_table ,
41: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
42: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
43: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
44: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
37: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
38: x_qa_date_sent OUT NOCOPY jtf_date_table ,
39: x_qa_date_received OUT NOCOPY jtf_date_table ,
40: x_qr_rule_id OUT NOCOPY jtf_number_table ,
41: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
42: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
43: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
44: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
45: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
38: x_qa_date_sent OUT NOCOPY jtf_date_table ,
39: x_qa_date_received OUT NOCOPY jtf_date_table ,
40: x_qr_rule_id OUT NOCOPY jtf_number_table ,
41: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
42: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
43: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
44: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
45: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
46: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: x_msg_data OUT NOCOPY VARCHAR2
54: );
55:
56: PROCEDURE Get_Rule_Details(
57: x_qr_rule_id OUT NOCOPY jtf_number_table ,
58: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
59: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
60: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
61: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
54: );
55:
56: PROCEDURE Get_Rule_Details(
57: x_qr_rule_id OUT NOCOPY jtf_number_table ,
58: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
59: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
60: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
61: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
62: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,
55:
56: PROCEDURE Get_Rule_Details(
57: x_qr_rule_id OUT NOCOPY jtf_number_table ,
58: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
59: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
60: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
61: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
62: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,
63: p_api_version_number IN NUMBER := 1 ,