APPS.ASO_APR_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 14: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,

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,
16: x_date_received OUT NOCOPY jtf_date_table
17: );
18:

Line 24: x_rule_description OUT NOCOPY jtf_varchar2_table_300,

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:
28: PROCEDURE Get_All_Approvers(

Line 25: x_approval_level OUT NOCOPY jtf_varchar2_table_300

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:
28: PROCEDURE Get_All_Approvers(
29: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,

Line 37: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,

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 ,
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 ,

Line 43: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,

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,
47: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 44: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,

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,
47: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,
48: p_api_version_number IN NUMBER := 1 ,

Line 60: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,

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 ,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

Line 61: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,

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 ,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE ,