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_DATE_TABLE

Line 46: p_date_sent IN jtf_date_table := NULL,

42: p_action_type_id IN jtf_number_table := NULL,
43: p_chain_number IN jtf_number_table := NULL,
44: p_occurrence IN jtf_number_table := NULL,
45: p_authority IN jtf_varchar2_table_100 := NULL,
46: p_date_sent IN jtf_date_table := NULL,
47: p_date_received IN jtf_date_table := NULL
48: )RETURN ASO_PA_APR_PUB.approvers_list_tbl_type
49: IS
50: l_approvers_list_tbl ASO_PA_APR_Pub.approvers_list_tbl_type;

Line 47: p_date_received IN jtf_date_table := NULL

43: p_chain_number IN jtf_number_table := NULL,
44: p_occurrence IN jtf_number_table := NULL,
45: p_authority IN jtf_varchar2_table_100 := NULL,
46: p_date_sent IN jtf_date_table := NULL,
47: p_date_received IN jtf_date_table := NULL
48: )RETURN ASO_PA_APR_PUB.approvers_list_tbl_type
49: IS
50: l_approvers_list_tbl ASO_PA_APR_Pub.approvers_list_tbl_type;
51: l_table_size PLS_INTEGER := 0;

Line 206: x_date_sent OUT NOCOPY jtf_date_table,

202: x_action_type_id OUT NOCOPY jtf_number_table,
203: x_chain_number OUT NOCOPY jtf_number_table,
204: x_occurrence OUT NOCOPY jtf_number_table,
205: x_authority OUT NOCOPY jtf_varchar2_table_100,
206: x_date_sent OUT NOCOPY jtf_date_table,
207: x_date_received OUT NOCOPY jtf_date_table
208: )
209: AS
210: ddindx binary_integer; indx binary_integer;

Line 207: x_date_received OUT NOCOPY jtf_date_table

203: x_chain_number OUT NOCOPY jtf_number_table,
204: x_occurrence OUT NOCOPY jtf_number_table,
205: x_authority OUT NOCOPY jtf_varchar2_table_100,
206: x_date_sent OUT NOCOPY jtf_date_table,
207: x_date_received OUT NOCOPY jtf_date_table
208: )
209: AS
210: ddindx binary_integer; indx binary_integer;
211: BEGIN

Line 233: x_date_sent := jtf_date_table();

229: x_action_type_id := jtf_number_table();
230: x_chain_number := jtf_number_table();
231: x_occurrence := jtf_number_table();
232: x_authority := jtf_varchar2_table_100();
233: x_date_sent := jtf_date_table();
234: x_date_received := jtf_date_table();
235: IF p_qte_approvers_list_tbl.count > 0 THEN
236: x_approval_det_id.extend(p_qte_approvers_list_tbl.count);
237: x_object_approval_id.extend(p_qte_approvers_list_tbl.count);

Line 234: x_date_received := jtf_date_table();

230: x_chain_number := jtf_number_table();
231: x_occurrence := jtf_number_table();
232: x_authority := jtf_varchar2_table_100();
233: x_date_sent := jtf_date_table();
234: x_date_received := jtf_date_table();
235: IF p_qte_approvers_list_tbl.count > 0 THEN
236: x_approval_det_id.extend(p_qte_approvers_list_tbl.count);
237: x_object_approval_id.extend(p_qte_approvers_list_tbl.count);
238: x_approver_person_id.extend(p_qte_approvers_list_tbl.count);

Line 370: x_qa_date_sent OUT NOCOPY jtf_date_table ,

366: x_qa_action_type_id OUT NOCOPY jtf_number_table ,
367: x_qa_chain_number OUT NOCOPY jtf_number_table ,
368: x_qa_occurrence OUT NOCOPY jtf_number_table ,
369: x_qa_authority OUT NOCOPY jtf_varchar2_table_100 ,
370: x_qa_date_sent OUT NOCOPY jtf_date_table ,
371: x_qa_date_received OUT NOCOPY jtf_date_table ,
372: x_qr_rule_id OUT NOCOPY jtf_number_table ,
373: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
374: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,

Line 371: x_qa_date_received OUT NOCOPY jtf_date_table ,

367: x_qa_chain_number OUT NOCOPY jtf_number_table ,
368: x_qa_occurrence OUT NOCOPY jtf_number_table ,
369: x_qa_authority OUT NOCOPY jtf_varchar2_table_100 ,
370: x_qa_date_sent OUT NOCOPY jtf_date_table ,
371: x_qa_date_received OUT NOCOPY jtf_date_table ,
372: x_qr_rule_id OUT NOCOPY jtf_number_table ,
373: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
374: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
375: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,

Line 516: p_qa_date_sent IN jtf_date_table := NULL,

512: p_qa_action_type_id IN jtf_number_table := NULL,
513: p_qa_chain_number IN jtf_number_table := NULL,
514: p_qa_occurrence IN jtf_number_table := NULL,
515: p_qa_authority IN jtf_varchar2_table_100 := NULL,
516: p_qa_date_sent IN jtf_date_table := NULL,
517: p_qa_date_received IN jtf_date_table := NULL,
518: x_object_approval_id OUT NOCOPY NUMBER,
519: x_approval_instance_id OUT NOCOPY NUMBER,
520: x_return_status OUT NOCOPY VARCHAR2,

Line 517: p_qa_date_received IN jtf_date_table := NULL,

513: p_qa_chain_number IN jtf_number_table := NULL,
514: p_qa_occurrence IN jtf_number_table := NULL,
515: p_qa_authority IN jtf_varchar2_table_100 := NULL,
516: p_qa_date_sent IN jtf_date_table := NULL,
517: p_qa_date_received IN jtf_date_table := NULL,
518: x_object_approval_id OUT NOCOPY NUMBER,
519: x_approval_instance_id OUT NOCOPY NUMBER,
520: x_return_status OUT NOCOPY VARCHAR2,
521: x_msg_count OUT NOCOPY NUMBER,