DBA Data[Home] [Help]

APPS.ASO_PA_APR_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 11: p_approver_status IN jtf_varchar2_table_100 := 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,
15: p_approver_category IN jtf_varchar2_table_100 := NULL,

Line 13: p_approver_name IN jtf_varchar2_table_100 := 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,
15: p_approver_category IN jtf_varchar2_table_100 := NULL,
16: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
17: p_approver_type_desc IN jtf_varchar2_table_100 := NULL,

Line 15: p_approver_category IN jtf_varchar2_table_100 := 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,
15: p_approver_category IN jtf_varchar2_table_100 := NULL,
16: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
17: p_approver_type_desc IN jtf_varchar2_table_100 := NULL,
18: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,
19: p_item_id IN jtf_varchar2_table_100 := NULL,

Line 16: p_approver_category_desc 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,
15: p_approver_category IN jtf_varchar2_table_100 := NULL,
16: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
17: p_approver_type_desc IN jtf_varchar2_table_100 := 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,

Line 17: p_approver_type_desc IN jtf_varchar2_table_100 := NULL,

13: p_approver_name IN jtf_varchar2_table_100 := NULL,
14: p_approval_comments IN jtf_varchar2_table_300 := NULL,
15: p_approver_category IN jtf_varchar2_table_100 := NULL,
16: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
17: p_approver_type_desc IN jtf_varchar2_table_100 := 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,

Line 18: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,

14: p_approval_comments IN jtf_varchar2_table_300 := NULL,
15: p_approver_category IN jtf_varchar2_table_100 := NULL,
16: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
17: p_approver_type_desc IN jtf_varchar2_table_100 := 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,

Line 19: p_item_id IN jtf_varchar2_table_100 := NULL,

15: p_approver_category IN jtf_varchar2_table_100 := NULL,
16: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
17: p_approver_type_desc IN jtf_varchar2_table_100 := 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,

Line 20: p_item_class IN jtf_varchar2_table_100 := NULL,

16: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
17: p_approver_type_desc IN jtf_varchar2_table_100 := 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,

Line 25: p_authority 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: )
29: RETURN ASO_PA_APR_PUB.Approvers_List_Tbl_Type;

Line 39: x_approver_status OUT NOCOPY jtf_varchar2_table_100,

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,
43: x_approver_category OUT NOCOPY jtf_varchar2_table_100,

Line 41: x_approver_name OUT NOCOPY jtf_varchar2_table_100,

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,
43: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
44: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
45: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,

Line 43: x_approver_category OUT NOCOPY jtf_varchar2_table_100,

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,
43: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
44: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
45: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
46: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
47: x_item_id OUT NOCOPY jtf_varchar2_table_100,

Line 44: x_approver_category_desc 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,
43: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
44: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
45: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
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,

Line 45: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,

41: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
42: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
43: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
44: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
45: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
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,

Line 46: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,

42: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
43: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
44: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
45: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
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,

Line 47: x_item_id OUT NOCOPY jtf_varchar2_table_100,

43: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
44: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
45: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
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,

Line 48: x_item_class OUT NOCOPY jtf_varchar2_table_100,

44: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
45: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
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,

Line 53: x_authority 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: );
57:

Line 64: x_rule_type OUT NOCOPY jtf_varchar2_table_100,

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,
67: x_rule_category_desc OUT NOCOPY jtf_varchar2_table_100
68: );

Line 66: x_rule_item_class OUT NOCOPY jtf_varchar2_table_100,

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,
67: x_rule_category_desc OUT NOCOPY jtf_varchar2_table_100
68: );
69:
70: PROCEDURE Get_All_Approvers(

Line 67: x_rule_category_desc OUT NOCOPY jtf_varchar2_table_100

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

Line 77: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,

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,
81: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100,

Line 79: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100,

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,
81: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100,
82: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
83: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,

Line 81: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100,

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,
81: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100,
82: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
83: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
84: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
85: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100,

Line 82: x_qa_approver_category_desc 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,
81: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100,
82: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
83: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
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,

Line 83: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,

79: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100,
80: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300,
81: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100,
82: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
83: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
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,

Line 84: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,

80: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300,
81: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100,
82: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
83: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
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,

Line 85: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100,

81: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100,
82: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
83: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
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,

Line 86: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100,

82: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
83: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
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,

Line 91: x_qa_authority 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 ,
95: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,

Line 98: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,

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 ,
101: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
102: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 100: x_qr_rule_item_class OUT NOCOPY jtf_varchar2_table_100 ,

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 ,
101: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
102: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
103: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 101: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,

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 ,
101: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
102: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
103: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,
105: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 130: p_qa_approver_status IN jtf_varchar2_table_100 := 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,
134: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,

Line 132: p_qa_approver_name IN jtf_varchar2_table_100 := 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,
134: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
135: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
136: p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,

Line 134: p_qa_approver_category IN jtf_varchar2_table_100 := 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,
134: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
135: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
136: p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,
137: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,
138: p_qa_item_id IN jtf_varchar2_table_100 := NULL,

Line 135: p_qa_approver_category_desc 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,
134: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
135: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
136: p_qa_approver_type_desc IN jtf_varchar2_table_100 := 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,

Line 136: p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,

132: p_qa_approver_name IN jtf_varchar2_table_100 := NULL,
133: p_qa_approval_comments IN jtf_varchar2_table_300 := NULL,
134: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
135: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
136: p_qa_approver_type_desc IN jtf_varchar2_table_100 := 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,

Line 137: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,

133: p_qa_approval_comments IN jtf_varchar2_table_300 := NULL,
134: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
135: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
136: p_qa_approver_type_desc IN jtf_varchar2_table_100 := 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,

Line 138: p_qa_item_id IN jtf_varchar2_table_100 := NULL,

134: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
135: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
136: p_qa_approver_type_desc IN jtf_varchar2_table_100 := 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,

Line 139: p_qa_item_class IN jtf_varchar2_table_100 := NULL,

135: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
136: p_qa_approver_type_desc IN jtf_varchar2_table_100 := 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,

Line 144: p_qa_authority 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,
148: x_approval_instance_id OUT NOCOPY NUMBER,