DBA Data[Home] [Help]

APPS.ASO_APR_PUB_W dependencies on JTF_DATE_TABLE

Line 35: x_date_sent OUT NOCOPY jtf_date_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
39: ddindx binary_integer; indx binary_integer;

Line 36: x_date_received OUT NOCOPY jtf_date_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
39: ddindx binary_integer; indx binary_integer;
40: BEGIN

Line 50: x_date_sent := jtf_date_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);
54: x_object_approval_id.extend(p_qte_approvers_list_tbl.count);

Line 51: x_date_received := jtf_date_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);
54: x_object_approval_id.extend(p_qte_approvers_list_tbl.count);
55: x_approver_person_id.extend(p_qte_approvers_list_tbl.count);

Line 139: x_qa_date_sent OUT NOCOPY jtf_date_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 ,
143: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,

Line 140: x_qa_date_received OUT NOCOPY jtf_date_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 ,
143: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
144: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,