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_VARCHAR2_TABLE_300

Line 34: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,

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,
36: x_date_received OUT NOCOPY jtf_date_table
37: )
38: AS

Line 49: x_approval_comments := jtf_varchar2_table_300();

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();
51: x_date_received := jtf_date_table();
52: IF p_qte_approvers_list_tbl.count > 0 THEN
53: x_approval_det_id.extend(p_qte_approvers_list_tbl.count);

Line 94: x_rule_description OUT NOCOPY jtf_varchar2_table_300,

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
98: ddindx binary_integer; indx binary_integer;

Line 95: x_approval_level OUT NOCOPY jtf_varchar2_table_300

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
98: ddindx binary_integer; indx binary_integer;
99: BEGIN

Line 103: x_rule_description := jtf_varchar2_table_300();

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);
107: x_object_approval_id.extend(p_qte_rules_list_tbl.count);

Line 104: x_approval_level := jtf_varchar2_table_300();

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);
107: x_object_approval_id.extend(p_qte_rules_list_tbl.count);
108: x_rule_action_id.extend(p_qte_rules_list_tbl.count);

Line 138: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,

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

Line 144: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,

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

Line 145: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,

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

Line 235: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,

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

Line 236: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,

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