eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_PA_APR_PUB_W dependencies on JTF_NUMBER_TABLE

Line 5: p_approval_det_id IN jtf_number_table := NULL,

1: PACKAGE ASO_PA_APR_PUB_W AUTHID CURRENT_USER as
2: /* $Header: asowpaps.pls 120.0.12020000.1 2013/03/19 20:29:51 cazhou noship $ */
3:
4: FUNCTION Construct_Approvers_List_Tbl(
5: p_approval_det_id IN jtf_number_table := NULL,
6: p_object_approval_id IN jtf_number_table := NULL,
7: p_approver_person_id IN jtf_number_table := NULL,
8: p_approver_user_id IN jtf_number_table := NULL,
9: p_notification_id IN jtf_number_table := NULL,

Line 6: p_object_approval_id IN jtf_number_table := NULL,

2: /* $Header: asowpaps.pls 120.0.12020000.1 2013/03/19 20:29:51 cazhou noship $ */
3:
4: FUNCTION Construct_Approvers_List_Tbl(
5: p_approval_det_id IN jtf_number_table := NULL,
6: p_object_approval_id IN jtf_number_table := NULL,
7: p_approver_person_id IN jtf_number_table := NULL,
8: p_approver_user_id IN jtf_number_table := NULL,
9: p_notification_id IN jtf_number_table := NULL,
10: p_approver_sequence IN jtf_number_table := NULL,

Line 7: p_approver_person_id IN jtf_number_table := NULL,

3:
4: FUNCTION Construct_Approvers_List_Tbl(
5: p_approval_det_id IN jtf_number_table := NULL,
6: p_object_approval_id IN jtf_number_table := NULL,
7: p_approver_person_id IN jtf_number_table := NULL,
8: p_approver_user_id IN jtf_number_table := NULL,
9: p_notification_id IN jtf_number_table := NULL,
10: p_approver_sequence IN jtf_number_table := NULL,
11: p_approver_status IN jtf_varchar2_table_100 := NULL,

Line 8: p_approver_user_id IN jtf_number_table := NULL,

4: FUNCTION Construct_Approvers_List_Tbl(
5: p_approval_det_id IN jtf_number_table := NULL,
6: p_object_approval_id IN jtf_number_table := NULL,
7: p_approver_person_id IN jtf_number_table := NULL,
8: p_approver_user_id IN jtf_number_table := NULL,
9: p_notification_id IN jtf_number_table := NULL,
10: p_approver_sequence IN jtf_number_table := NULL,
11: p_approver_status IN jtf_varchar2_table_100 := NULL,
12: p_name IN jtf_varchar2_table_300 := NULL,

Line 9: p_notification_id IN jtf_number_table := NULL,

5: p_approval_det_id IN jtf_number_table := NULL,
6: p_object_approval_id IN jtf_number_table := NULL,
7: p_approver_person_id IN jtf_number_table := NULL,
8: p_approver_user_id IN jtf_number_table := NULL,
9: p_notification_id IN jtf_number_table := NULL,
10: p_approver_sequence IN jtf_number_table := NULL,
11: p_approver_status IN jtf_varchar2_table_100 := NULL,
12: p_name IN jtf_varchar2_table_300 := NULL,
13: p_approver_name IN jtf_varchar2_table_100 := NULL,

Line 10: p_approver_sequence IN jtf_number_table := NULL,

6: p_object_approval_id IN jtf_number_table := NULL,
7: p_approver_person_id IN jtf_number_table := NULL,
8: p_approver_user_id IN jtf_number_table := NULL,
9: p_notification_id IN jtf_number_table := NULL,
10: p_approver_sequence IN jtf_number_table := NULL,
11: p_approver_status IN jtf_varchar2_table_100 := NULL,
12: p_name IN jtf_varchar2_table_300 := NULL,
13: p_approver_name IN jtf_varchar2_table_100 := NULL,
14: p_approval_comments IN jtf_varchar2_table_300 := NULL,

Line 22: p_action_type_id IN jtf_number_table := NULL,

18: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,
19: p_item_id IN jtf_varchar2_table_100 := NULL,
20: p_item_class IN jtf_varchar2_table_100 := NULL,
21: p_action_type IN jtf_varchar2_table_300 := NULL,
22: p_action_type_id IN jtf_number_table := NULL,
23: p_chain_number IN jtf_number_table := NULL,
24: p_occurrence IN jtf_number_table := NULL,
25: p_authority IN jtf_varchar2_table_100 := NULL,
26: p_date_sent IN jtf_date_table := NULL,

Line 23: p_chain_number IN jtf_number_table := NULL,

19: p_item_id IN jtf_varchar2_table_100 := NULL,
20: p_item_class IN jtf_varchar2_table_100 := NULL,
21: p_action_type IN jtf_varchar2_table_300 := NULL,
22: p_action_type_id IN jtf_number_table := NULL,
23: p_chain_number IN jtf_number_table := NULL,
24: p_occurrence IN jtf_number_table := NULL,
25: p_authority IN jtf_varchar2_table_100 := NULL,
26: p_date_sent IN jtf_date_table := NULL,
27: p_date_received IN jtf_date_table := NULL

Line 24: p_occurrence IN jtf_number_table := NULL,

20: p_item_class IN jtf_varchar2_table_100 := NULL,
21: p_action_type IN jtf_varchar2_table_300 := NULL,
22: p_action_type_id IN jtf_number_table := NULL,
23: p_chain_number IN jtf_number_table := NULL,
24: p_occurrence IN jtf_number_table := NULL,
25: p_authority IN jtf_varchar2_table_100 := NULL,
26: p_date_sent IN jtf_date_table := NULL,
27: p_date_received IN jtf_date_table := NULL
28: )

Line 33: x_approval_det_id OUT NOCOPY jtf_number_table,

29: RETURN ASO_PA_APR_PUB.Approvers_List_Tbl_Type;
30:
31: PROCEDURE Set_Approvers_List_Tbl_Out(
32: p_qte_approvers_list_tbl IN ASO_PA_Apr_Pub.Approvers_List_Tbl_Type,
33: x_approval_det_id OUT NOCOPY jtf_number_table,
34: x_object_approval_id OUT NOCOPY jtf_number_table,
35: x_approver_person_id OUT NOCOPY jtf_number_table,
36: x_approver_user_id OUT NOCOPY jtf_number_table,
37: x_notification_id OUT NOCOPY jtf_number_table,

Line 34: x_object_approval_id OUT NOCOPY jtf_number_table,

30:
31: PROCEDURE Set_Approvers_List_Tbl_Out(
32: p_qte_approvers_list_tbl IN ASO_PA_Apr_Pub.Approvers_List_Tbl_Type,
33: x_approval_det_id OUT NOCOPY jtf_number_table,
34: x_object_approval_id OUT NOCOPY jtf_number_table,
35: x_approver_person_id OUT NOCOPY jtf_number_table,
36: x_approver_user_id OUT NOCOPY jtf_number_table,
37: x_notification_id OUT NOCOPY jtf_number_table,
38: x_approver_sequence OUT NOCOPY jtf_number_table,

Line 35: x_approver_person_id OUT NOCOPY jtf_number_table,

31: PROCEDURE Set_Approvers_List_Tbl_Out(
32: p_qte_approvers_list_tbl IN ASO_PA_Apr_Pub.Approvers_List_Tbl_Type,
33: x_approval_det_id OUT NOCOPY jtf_number_table,
34: x_object_approval_id OUT NOCOPY jtf_number_table,
35: x_approver_person_id OUT NOCOPY jtf_number_table,
36: x_approver_user_id OUT NOCOPY jtf_number_table,
37: x_notification_id OUT NOCOPY jtf_number_table,
38: x_approver_sequence OUT NOCOPY jtf_number_table,
39: x_approver_status OUT NOCOPY jtf_varchar2_table_100,

Line 36: x_approver_user_id OUT NOCOPY jtf_number_table,

32: p_qte_approvers_list_tbl IN ASO_PA_Apr_Pub.Approvers_List_Tbl_Type,
33: x_approval_det_id OUT NOCOPY jtf_number_table,
34: x_object_approval_id OUT NOCOPY jtf_number_table,
35: x_approver_person_id OUT NOCOPY jtf_number_table,
36: x_approver_user_id OUT NOCOPY jtf_number_table,
37: x_notification_id OUT NOCOPY jtf_number_table,
38: x_approver_sequence OUT NOCOPY jtf_number_table,
39: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
40: x_name OUT NOCOPY jtf_varchar2_table_300,

Line 37: x_notification_id OUT NOCOPY jtf_number_table,

33: x_approval_det_id OUT NOCOPY jtf_number_table,
34: x_object_approval_id OUT NOCOPY jtf_number_table,
35: x_approver_person_id OUT NOCOPY jtf_number_table,
36: x_approver_user_id OUT NOCOPY jtf_number_table,
37: x_notification_id OUT NOCOPY jtf_number_table,
38: x_approver_sequence OUT NOCOPY jtf_number_table,
39: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
40: x_name OUT NOCOPY jtf_varchar2_table_300,
41: x_approver_name OUT NOCOPY jtf_varchar2_table_100,

Line 38: x_approver_sequence OUT NOCOPY jtf_number_table,

34: x_object_approval_id OUT NOCOPY jtf_number_table,
35: x_approver_person_id OUT NOCOPY jtf_number_table,
36: x_approver_user_id OUT NOCOPY jtf_number_table,
37: x_notification_id OUT NOCOPY jtf_number_table,
38: x_approver_sequence OUT NOCOPY jtf_number_table,
39: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
40: x_name OUT NOCOPY jtf_varchar2_table_300,
41: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
42: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,

Line 50: x_action_type_id OUT NOCOPY jtf_number_table,

46: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
47: x_item_id OUT NOCOPY jtf_varchar2_table_100,
48: x_item_class OUT NOCOPY jtf_varchar2_table_100,
49: x_action_type OUT NOCOPY jtf_varchar2_table_300,
50: x_action_type_id OUT NOCOPY jtf_number_table,
51: x_chain_number OUT NOCOPY jtf_number_table,
52: x_occurrence OUT NOCOPY jtf_number_table,
53: x_authority OUT NOCOPY jtf_varchar2_table_100,
54: x_date_sent OUT NOCOPY jtf_date_table,

Line 51: x_chain_number OUT NOCOPY jtf_number_table,

47: x_item_id OUT NOCOPY jtf_varchar2_table_100,
48: x_item_class OUT NOCOPY jtf_varchar2_table_100,
49: x_action_type OUT NOCOPY jtf_varchar2_table_300,
50: x_action_type_id OUT NOCOPY jtf_number_table,
51: x_chain_number OUT NOCOPY jtf_number_table,
52: x_occurrence OUT NOCOPY jtf_number_table,
53: x_authority OUT NOCOPY jtf_varchar2_table_100,
54: x_date_sent OUT NOCOPY jtf_date_table,
55: x_date_received OUT NOCOPY jtf_date_table

Line 52: x_occurrence OUT NOCOPY jtf_number_table,

48: x_item_class OUT NOCOPY jtf_varchar2_table_100,
49: x_action_type OUT NOCOPY jtf_varchar2_table_300,
50: x_action_type_id OUT NOCOPY jtf_number_table,
51: x_chain_number OUT NOCOPY jtf_number_table,
52: x_occurrence OUT NOCOPY jtf_number_table,
53: x_authority OUT NOCOPY jtf_varchar2_table_100,
54: x_date_sent OUT NOCOPY jtf_date_table,
55: x_date_received OUT NOCOPY jtf_date_table
56: );

Line 60: x_rule_id OUT NOCOPY jtf_number_table,

56: );
57:
58: PROCEDURE Set_Rules_List_Tbl_Out(
59: p_qte_rules_list_tbl IN ASO_PA_Apr_Pub.Rules_List_Tbl_Type,
60: x_rule_id OUT NOCOPY jtf_number_table,
61: x_object_approval_id OUT NOCOPY jtf_number_table,
62: x_rule_action_id OUT NOCOPY jtf_number_table,
63: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
64: x_rule_type OUT NOCOPY jtf_varchar2_table_100,

Line 61: x_object_approval_id OUT NOCOPY jtf_number_table,

57:
58: PROCEDURE Set_Rules_List_Tbl_Out(
59: p_qte_rules_list_tbl IN ASO_PA_Apr_Pub.Rules_List_Tbl_Type,
60: x_rule_id OUT NOCOPY jtf_number_table,
61: x_object_approval_id OUT NOCOPY jtf_number_table,
62: x_rule_action_id OUT NOCOPY jtf_number_table,
63: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
64: x_rule_type OUT NOCOPY jtf_varchar2_table_100,
65: x_approval_level OUT NOCOPY jtf_varchar2_table_300,

Line 62: x_rule_action_id OUT NOCOPY jtf_number_table,

58: PROCEDURE Set_Rules_List_Tbl_Out(
59: p_qte_rules_list_tbl IN ASO_PA_Apr_Pub.Rules_List_Tbl_Type,
60: x_rule_id OUT NOCOPY jtf_number_table,
61: x_object_approval_id OUT NOCOPY jtf_number_table,
62: x_rule_action_id OUT NOCOPY jtf_number_table,
63: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
64: x_rule_type OUT NOCOPY jtf_varchar2_table_100,
65: x_approval_level OUT NOCOPY jtf_varchar2_table_300,
66: x_rule_item_class OUT NOCOPY jtf_varchar2_table_100,

Line 71: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,

67: x_rule_category_desc OUT NOCOPY jtf_varchar2_table_100
68: );
69:
70: PROCEDURE Get_All_Approvers(
71: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
72: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
73: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
74: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
75: x_qa_notification_id OUT NOCOPY jtf_number_table ,

Line 72: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,

68: );
69:
70: PROCEDURE Get_All_Approvers(
71: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
72: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
73: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
74: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
75: x_qa_notification_id OUT NOCOPY jtf_number_table ,
76: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,

Line 73: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,

69:
70: PROCEDURE Get_All_Approvers(
71: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
72: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
73: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
74: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
75: x_qa_notification_id OUT NOCOPY jtf_number_table ,
76: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
77: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,

Line 74: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,

70: PROCEDURE Get_All_Approvers(
71: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
72: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
73: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
74: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
75: x_qa_notification_id OUT NOCOPY jtf_number_table ,
76: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
77: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
78: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,

Line 75: x_qa_notification_id OUT NOCOPY jtf_number_table ,

71: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
72: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
73: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
74: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
75: x_qa_notification_id OUT NOCOPY jtf_number_table ,
76: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
77: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
78: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,
79: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100,

Line 76: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,

72: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
73: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
74: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
75: x_qa_notification_id OUT NOCOPY jtf_number_table ,
76: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
77: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
78: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,
79: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100,
80: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300,

Line 88: x_qa_action_type_id OUT NOCOPY jtf_number_table,

84: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
85: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100,
86: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100,
87: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300,
88: x_qa_action_type_id OUT NOCOPY jtf_number_table,
89: x_qa_chain_number OUT NOCOPY jtf_number_table,
90: x_qa_occurrence OUT NOCOPY jtf_number_table,
91: x_qa_authority OUT NOCOPY jtf_varchar2_table_100,
92: x_qa_date_sent OUT NOCOPY jtf_date_table ,

Line 89: x_qa_chain_number OUT NOCOPY jtf_number_table,

85: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100,
86: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100,
87: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300,
88: x_qa_action_type_id OUT NOCOPY jtf_number_table,
89: x_qa_chain_number OUT NOCOPY jtf_number_table,
90: x_qa_occurrence OUT NOCOPY jtf_number_table,
91: x_qa_authority OUT NOCOPY jtf_varchar2_table_100,
92: x_qa_date_sent OUT NOCOPY jtf_date_table ,
93: x_qa_date_received OUT NOCOPY jtf_date_table ,

Line 90: x_qa_occurrence OUT NOCOPY jtf_number_table,

86: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100,
87: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300,
88: x_qa_action_type_id OUT NOCOPY jtf_number_table,
89: x_qa_chain_number OUT NOCOPY jtf_number_table,
90: x_qa_occurrence OUT NOCOPY jtf_number_table,
91: x_qa_authority OUT NOCOPY jtf_varchar2_table_100,
92: x_qa_date_sent OUT NOCOPY jtf_date_table ,
93: x_qa_date_received OUT NOCOPY jtf_date_table ,
94: x_qr_rule_id OUT NOCOPY jtf_number_table ,

Line 94: x_qr_rule_id OUT NOCOPY jtf_number_table ,

90: x_qa_occurrence OUT NOCOPY jtf_number_table,
91: x_qa_authority OUT NOCOPY jtf_varchar2_table_100,
92: x_qa_date_sent OUT NOCOPY jtf_date_table ,
93: x_qa_date_received OUT NOCOPY jtf_date_table ,
94: x_qr_rule_id OUT NOCOPY jtf_number_table ,
95: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
96: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
97: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
98: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,

Line 95: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,

91: x_qa_authority OUT NOCOPY jtf_varchar2_table_100,
92: x_qa_date_sent OUT NOCOPY jtf_date_table ,
93: x_qa_date_received OUT NOCOPY jtf_date_table ,
94: x_qr_rule_id OUT NOCOPY jtf_number_table ,
95: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
96: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
97: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
98: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,
99: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,

Line 96: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,

92: x_qa_date_sent OUT NOCOPY jtf_date_table ,
93: x_qa_date_received OUT NOCOPY jtf_date_table ,
94: x_qr_rule_id OUT NOCOPY jtf_number_table ,
95: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
96: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
97: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
98: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,
99: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
100: x_qr_rule_item_class OUT NOCOPY jtf_varchar2_table_100 ,

Line 124: p_qa_approval_det_id IN jtf_number_table := NULL,

120: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
121: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_qa_approval_det_id IN jtf_number_table := NULL,
125: p_qa_object_approval_id IN jtf_number_table := NULL,
126: p_qa_approver_person_id IN jtf_number_table := NULL,
127: p_qa_approver_user_id IN jtf_number_table := NULL,
128: p_qa_notification_id IN jtf_number_table := NULL,

Line 125: p_qa_object_approval_id IN jtf_number_table := NULL,

121: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_qa_approval_det_id IN jtf_number_table := NULL,
125: p_qa_object_approval_id IN jtf_number_table := NULL,
126: p_qa_approver_person_id IN jtf_number_table := NULL,
127: p_qa_approver_user_id IN jtf_number_table := NULL,
128: p_qa_notification_id IN jtf_number_table := NULL,
129: p_qa_approver_sequence IN jtf_number_table := NULL,

Line 126: p_qa_approver_person_id IN jtf_number_table := NULL,

122: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_qa_approval_det_id IN jtf_number_table := NULL,
125: p_qa_object_approval_id IN jtf_number_table := NULL,
126: p_qa_approver_person_id IN jtf_number_table := NULL,
127: p_qa_approver_user_id IN jtf_number_table := NULL,
128: p_qa_notification_id IN jtf_number_table := NULL,
129: p_qa_approver_sequence IN jtf_number_table := NULL,
130: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,

Line 127: p_qa_approver_user_id IN jtf_number_table := NULL,

123: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_qa_approval_det_id IN jtf_number_table := NULL,
125: p_qa_object_approval_id IN jtf_number_table := NULL,
126: p_qa_approver_person_id IN jtf_number_table := NULL,
127: p_qa_approver_user_id IN jtf_number_table := NULL,
128: p_qa_notification_id IN jtf_number_table := NULL,
129: p_qa_approver_sequence IN jtf_number_table := NULL,
130: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,
131: p_qa_name IN jtf_varchar2_table_300 := NULL,

Line 128: p_qa_notification_id IN jtf_number_table := NULL,

124: p_qa_approval_det_id IN jtf_number_table := NULL,
125: p_qa_object_approval_id IN jtf_number_table := NULL,
126: p_qa_approver_person_id IN jtf_number_table := NULL,
127: p_qa_approver_user_id IN jtf_number_table := NULL,
128: p_qa_notification_id IN jtf_number_table := NULL,
129: p_qa_approver_sequence IN jtf_number_table := NULL,
130: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,
131: p_qa_name IN jtf_varchar2_table_300 := NULL,
132: p_qa_approver_name IN jtf_varchar2_table_100 := NULL,

Line 129: p_qa_approver_sequence IN jtf_number_table := NULL,

125: p_qa_object_approval_id IN jtf_number_table := NULL,
126: p_qa_approver_person_id IN jtf_number_table := NULL,
127: p_qa_approver_user_id IN jtf_number_table := NULL,
128: p_qa_notification_id IN jtf_number_table := NULL,
129: p_qa_approver_sequence IN jtf_number_table := NULL,
130: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,
131: p_qa_name IN jtf_varchar2_table_300 := NULL,
132: p_qa_approver_name IN jtf_varchar2_table_100 := NULL,
133: p_qa_approval_comments IN jtf_varchar2_table_300 := NULL,

Line 141: p_qa_action_type_id IN jtf_number_table := NULL,

137: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,
138: p_qa_item_id IN jtf_varchar2_table_100 := NULL,
139: p_qa_item_class IN jtf_varchar2_table_100 := NULL,
140: p_qa_action_type IN jtf_varchar2_table_300 := NULL,
141: p_qa_action_type_id IN jtf_number_table := NULL,
142: p_qa_chain_number IN jtf_number_table := NULL,
143: p_qa_occurrence IN jtf_number_table := NULL,
144: p_qa_authority IN jtf_varchar2_table_100 := NULL,
145: p_qa_date_sent IN jtf_date_table := NULL,

Line 142: p_qa_chain_number IN jtf_number_table := NULL,

138: p_qa_item_id IN jtf_varchar2_table_100 := NULL,
139: p_qa_item_class IN jtf_varchar2_table_100 := NULL,
140: p_qa_action_type IN jtf_varchar2_table_300 := NULL,
141: p_qa_action_type_id IN jtf_number_table := NULL,
142: p_qa_chain_number IN jtf_number_table := NULL,
143: p_qa_occurrence IN jtf_number_table := NULL,
144: p_qa_authority IN jtf_varchar2_table_100 := NULL,
145: p_qa_date_sent IN jtf_date_table := NULL,
146: p_qa_date_received IN jtf_date_table := NULL,

Line 143: p_qa_occurrence IN jtf_number_table := NULL,

139: p_qa_item_class IN jtf_varchar2_table_100 := NULL,
140: p_qa_action_type IN jtf_varchar2_table_300 := NULL,
141: p_qa_action_type_id IN jtf_number_table := NULL,
142: p_qa_chain_number IN jtf_number_table := NULL,
143: p_qa_occurrence IN jtf_number_table := NULL,
144: p_qa_authority IN jtf_varchar2_table_100 := NULL,
145: p_qa_date_sent IN jtf_date_table := NULL,
146: p_qa_date_received IN jtf_date_table := NULL,
147: x_object_approval_id OUT NOCOPY NUMBER,