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_APR_PUB_W dependencies on JTF_NUMBER_TABLE

Line 26: x_approval_det_id OUT NOCOPY jtf_number_table,

22: END;
23:
24: PROCEDURE Set_Approvers_List_Tbl_Out(
25: p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
26: x_approval_det_id OUT NOCOPY jtf_number_table,
27: x_object_approval_id OUT NOCOPY jtf_number_table,
28: x_approver_person_id OUT NOCOPY jtf_number_table,
29: x_approver_user_id OUT NOCOPY jtf_number_table,
30: x_notification_id OUT NOCOPY jtf_number_table,

Line 27: x_object_approval_id OUT NOCOPY jtf_number_table,

23:
24: PROCEDURE Set_Approvers_List_Tbl_Out(
25: p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
26: x_approval_det_id OUT NOCOPY jtf_number_table,
27: x_object_approval_id OUT NOCOPY jtf_number_table,
28: x_approver_person_id OUT NOCOPY jtf_number_table,
29: x_approver_user_id OUT NOCOPY jtf_number_table,
30: x_notification_id OUT NOCOPY jtf_number_table,
31: x_approver_sequence OUT NOCOPY jtf_number_table,

Line 28: x_approver_person_id OUT NOCOPY jtf_number_table,

24: PROCEDURE Set_Approvers_List_Tbl_Out(
25: p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
26: x_approval_det_id OUT NOCOPY jtf_number_table,
27: x_object_approval_id OUT NOCOPY jtf_number_table,
28: x_approver_person_id OUT NOCOPY jtf_number_table,
29: x_approver_user_id OUT NOCOPY jtf_number_table,
30: x_notification_id OUT NOCOPY jtf_number_table,
31: x_approver_sequence OUT NOCOPY jtf_number_table,
32: x_approver_status OUT NOCOPY jtf_varchar2_table_100,

Line 29: x_approver_user_id OUT NOCOPY jtf_number_table,

25: p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
26: x_approval_det_id OUT NOCOPY jtf_number_table,
27: x_object_approval_id OUT NOCOPY jtf_number_table,
28: x_approver_person_id OUT NOCOPY jtf_number_table,
29: x_approver_user_id OUT NOCOPY jtf_number_table,
30: x_notification_id OUT NOCOPY jtf_number_table,
31: x_approver_sequence OUT NOCOPY jtf_number_table,
32: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
33: x_approver_name OUT NOCOPY jtf_varchar2_table_100,

Line 30: x_notification_id OUT NOCOPY jtf_number_table,

26: x_approval_det_id OUT NOCOPY jtf_number_table,
27: x_object_approval_id OUT NOCOPY jtf_number_table,
28: x_approver_person_id OUT NOCOPY jtf_number_table,
29: x_approver_user_id OUT NOCOPY jtf_number_table,
30: x_notification_id OUT NOCOPY jtf_number_table,
31: x_approver_sequence OUT NOCOPY jtf_number_table,
32: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
33: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
34: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,

Line 31: x_approver_sequence OUT NOCOPY jtf_number_table,

27: x_object_approval_id OUT NOCOPY jtf_number_table,
28: x_approver_person_id OUT NOCOPY jtf_number_table,
29: x_approver_user_id OUT NOCOPY jtf_number_table,
30: x_notification_id OUT NOCOPY jtf_number_table,
31: x_approver_sequence OUT NOCOPY jtf_number_table,
32: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
33: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
34: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
35: x_date_sent OUT NOCOPY jtf_date_table,

Line 41: x_approval_det_id := jtf_number_table();

37: )
38: AS
39: ddindx binary_integer; indx binary_integer;
40: BEGIN
41: x_approval_det_id := jtf_number_table();
42: x_object_approval_id := jtf_number_table();
43: x_approver_person_id := jtf_number_table();
44: x_approver_user_id := jtf_number_table();
45: x_notification_id := jtf_number_table();

Line 42: x_object_approval_id := jtf_number_table();

38: AS
39: ddindx binary_integer; indx binary_integer;
40: BEGIN
41: x_approval_det_id := jtf_number_table();
42: x_object_approval_id := jtf_number_table();
43: x_approver_person_id := jtf_number_table();
44: x_approver_user_id := jtf_number_table();
45: x_notification_id := jtf_number_table();
46: x_approver_sequence := jtf_number_table();

Line 43: x_approver_person_id := jtf_number_table();

39: ddindx binary_integer; indx binary_integer;
40: BEGIN
41: x_approval_det_id := jtf_number_table();
42: x_object_approval_id := jtf_number_table();
43: x_approver_person_id := jtf_number_table();
44: x_approver_user_id := jtf_number_table();
45: x_notification_id := jtf_number_table();
46: x_approver_sequence := jtf_number_table();
47: x_approver_status := jtf_varchar2_table_100();

Line 44: x_approver_user_id := jtf_number_table();

40: BEGIN
41: x_approval_det_id := jtf_number_table();
42: x_object_approval_id := jtf_number_table();
43: x_approver_person_id := jtf_number_table();
44: x_approver_user_id := jtf_number_table();
45: x_notification_id := jtf_number_table();
46: x_approver_sequence := jtf_number_table();
47: x_approver_status := jtf_varchar2_table_100();
48: x_approver_name := jtf_varchar2_table_100();

Line 45: x_notification_id := jtf_number_table();

41: x_approval_det_id := jtf_number_table();
42: x_object_approval_id := jtf_number_table();
43: x_approver_person_id := jtf_number_table();
44: x_approver_user_id := jtf_number_table();
45: x_notification_id := jtf_number_table();
46: x_approver_sequence := jtf_number_table();
47: x_approver_status := jtf_varchar2_table_100();
48: x_approver_name := jtf_varchar2_table_100();
49: x_approval_comments := jtf_varchar2_table_300();

Line 46: x_approver_sequence := jtf_number_table();

42: x_object_approval_id := jtf_number_table();
43: x_approver_person_id := jtf_number_table();
44: x_approver_user_id := jtf_number_table();
45: x_notification_id := jtf_number_table();
46: x_approver_sequence := jtf_number_table();
47: x_approver_status := jtf_varchar2_table_100();
48: x_approver_name := jtf_varchar2_table_100();
49: x_approval_comments := jtf_varchar2_table_300();
50: x_date_sent := jtf_date_table();

Line 91: x_rule_id OUT NOCOPY jtf_number_table,

87:
88:
89: PROCEDURE Set_Rules_List_Tbl_Out(
90: p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,
91: x_rule_id OUT NOCOPY jtf_number_table,
92: x_object_approval_id OUT NOCOPY jtf_number_table,
93: x_rule_action_id OUT NOCOPY jtf_number_table,
94: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
95: x_approval_level OUT NOCOPY jtf_varchar2_table_300

Line 92: x_object_approval_id OUT NOCOPY jtf_number_table,

88:
89: PROCEDURE Set_Rules_List_Tbl_Out(
90: p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,
91: x_rule_id OUT NOCOPY jtf_number_table,
92: x_object_approval_id OUT NOCOPY jtf_number_table,
93: x_rule_action_id OUT NOCOPY jtf_number_table,
94: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
95: x_approval_level OUT NOCOPY jtf_varchar2_table_300
96: )

Line 93: x_rule_action_id OUT NOCOPY jtf_number_table,

89: PROCEDURE Set_Rules_List_Tbl_Out(
90: p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,
91: x_rule_id OUT NOCOPY jtf_number_table,
92: x_object_approval_id OUT NOCOPY jtf_number_table,
93: x_rule_action_id OUT NOCOPY jtf_number_table,
94: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
95: x_approval_level OUT NOCOPY jtf_varchar2_table_300
96: )
97: AS

Line 100: x_rule_id := jtf_number_table();

96: )
97: AS
98: ddindx binary_integer; indx binary_integer;
99: BEGIN
100: x_rule_id := jtf_number_table();
101: x_object_approval_id := jtf_number_table();
102: x_rule_action_id := jtf_number_table();
103: x_rule_description := jtf_varchar2_table_300();
104: x_approval_level := jtf_varchar2_table_300();

Line 101: x_object_approval_id := jtf_number_table();

97: AS
98: ddindx binary_integer; indx binary_integer;
99: BEGIN
100: x_rule_id := jtf_number_table();
101: x_object_approval_id := jtf_number_table();
102: x_rule_action_id := jtf_number_table();
103: x_rule_description := jtf_varchar2_table_300();
104: x_approval_level := jtf_varchar2_table_300();
105: IF p_qte_rules_list_tbl.count > 0 THEN

Line 102: x_rule_action_id := jtf_number_table();

98: ddindx binary_integer; indx binary_integer;
99: BEGIN
100: x_rule_id := jtf_number_table();
101: x_object_approval_id := jtf_number_table();
102: x_rule_action_id := jtf_number_table();
103: x_rule_description := jtf_varchar2_table_300();
104: x_approval_level := jtf_varchar2_table_300();
105: IF p_qte_rules_list_tbl.count > 0 THEN
106: x_rule_id.extend(p_qte_rules_list_tbl.count);

Line 130: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,

126: END Set_Rules_List_Tbl_Out;
127:
128:
129: PROCEDURE Get_All_Approvers(
130: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
131: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
132: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
133: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
134: x_qa_notification_id OUT NOCOPY jtf_number_table ,

Line 131: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,

127:
128:
129: PROCEDURE Get_All_Approvers(
130: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
131: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
132: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
133: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
134: x_qa_notification_id OUT NOCOPY jtf_number_table ,
135: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,

Line 132: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,

128:
129: PROCEDURE Get_All_Approvers(
130: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
131: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
132: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
133: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
134: x_qa_notification_id OUT NOCOPY jtf_number_table ,
135: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
136: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,

Line 133: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,

129: PROCEDURE Get_All_Approvers(
130: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
131: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
132: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
133: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
134: x_qa_notification_id OUT NOCOPY jtf_number_table ,
135: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
136: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
137: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,

Line 134: x_qa_notification_id OUT NOCOPY jtf_number_table ,

130: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
131: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
132: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
133: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
134: x_qa_notification_id OUT NOCOPY jtf_number_table ,
135: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
136: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
137: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
138: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,

Line 135: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,

131: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
132: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
133: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
134: x_qa_notification_id OUT NOCOPY jtf_number_table ,
135: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
136: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
137: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
138: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
139: x_qa_date_sent OUT NOCOPY jtf_date_table ,

Line 141: x_qr_rule_id OUT NOCOPY jtf_number_table ,

137: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
138: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
139: x_qa_date_sent OUT NOCOPY jtf_date_table ,
140: x_qa_date_received OUT NOCOPY jtf_date_table ,
141: x_qr_rule_id OUT NOCOPY jtf_number_table ,
142: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
143: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
144: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
145: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,

Line 142: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,

138: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
139: x_qa_date_sent OUT NOCOPY jtf_date_table ,
140: x_qa_date_received OUT NOCOPY jtf_date_table ,
141: x_qr_rule_id OUT NOCOPY jtf_number_table ,
142: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
143: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
144: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
145: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
146: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 143: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,

139: x_qa_date_sent OUT NOCOPY jtf_date_table ,
140: x_qa_date_received OUT NOCOPY jtf_date_table ,
141: x_qr_rule_id OUT NOCOPY jtf_number_table ,
142: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
143: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
144: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
145: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
146: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
147: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 232: x_qr_rule_id OUT NOCOPY jtf_number_table ,

228: END Get_All_Approvers;
229:
230:
231: PROCEDURE Get_Rule_Details(
232: x_qr_rule_id OUT NOCOPY jtf_number_table ,
233: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
234: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
235: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
236: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,

Line 233: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,

229:
230:
231: PROCEDURE Get_Rule_Details(
232: x_qr_rule_id OUT NOCOPY jtf_number_table ,
233: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
234: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
235: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
236: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
237: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 234: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,

230:
231: PROCEDURE Get_Rule_Details(
232: x_qr_rule_id OUT NOCOPY jtf_number_table ,
233: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
234: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
235: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
236: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
237: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,
238: p_api_version_number IN NUMBER := 1 ,