DBA Data[Home] [Help]

APPS.ASO_PA_APR_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 12: p_name IN jtf_varchar2_table_300 := 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,
16: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,

Line 14: p_approval_comments IN jtf_varchar2_table_300 := 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,
18: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,

Line 21: p_action_type IN jtf_varchar2_table_300 := 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,
25: p_authority IN jtf_varchar2_table_100 := NULL,

Line 40: x_name OUT NOCOPY jtf_varchar2_table_300,

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

Line 42: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,

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,
46: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,

Line 49: x_action_type OUT NOCOPY jtf_varchar2_table_300,

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,
53: x_authority OUT NOCOPY jtf_varchar2_table_100,

Line 63: x_rule_description OUT NOCOPY jtf_varchar2_table_300,

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

Line 65: x_approval_level OUT NOCOPY jtf_varchar2_table_300,

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

Line 78: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,

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

Line 80: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300,

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,
84: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,

Line 87: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300,

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,
91: x_qa_authority OUT NOCOPY jtf_varchar2_table_100,

Line 97: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,

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 ,
101: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,

Line 99: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,

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 ,
103: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 131: p_qa_name IN jtf_varchar2_table_300 := 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,
135: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,

Line 133: p_qa_approval_comments IN jtf_varchar2_table_300 := 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,
137: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,

Line 140: p_qa_action_type IN jtf_varchar2_table_300 := 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,
144: p_qa_authority IN jtf_varchar2_table_100 := NULL,