DBA Data[Home] [Help]

APPS.ASO_APR_PUB_W dependencies on JTF_NUMBER_TABLE

Line 6: x_approval_det_id OUT NOCOPY jtf_number_table,

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,

Line 7: x_object_approval_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,

Line 8: x_approver_person_id 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,

Line 9: x_approver_user_id OUT NOCOPY jtf_number_table,

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,

Line 10: x_notification_id OUT NOCOPY jtf_number_table,

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,

Line 11: x_approver_sequence 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,
15: x_date_sent OUT NOCOPY jtf_date_table,

Line 21: x_rule_id OUT NOCOPY jtf_number_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

Line 22: x_object_approval_id OUT NOCOPY jtf_number_table,

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: );

Line 23: x_rule_action_id OUT NOCOPY jtf_number_table,

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:

Line 29: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,

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 ,

Line 30: x_qa_object_approval_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 ,

Line 31: x_qa_approver_person_id 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 ,

Line 32: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,

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 ,

Line 33: x_qa_notification_id OUT NOCOPY jtf_number_table ,

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 ,

Line 34: x_qa_approver_sequence 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 ,
38: x_qa_date_sent OUT NOCOPY jtf_date_table ,

Line 40: x_qr_rule_id OUT NOCOPY jtf_number_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 ,

Line 41: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,

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 ,

Line 42: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,

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,

Line 57: x_qr_rule_id OUT NOCOPY jtf_number_table ,

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 ,

Line 58: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,

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 ,

Line 59: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,

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 ,