DBA Data[Home] [Help]

APPS.ASO_PA_APR_PUB_W dependencies on JTF_DATE_TABLE

Line 26: p_date_sent IN jtf_date_table := 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,
26: p_date_sent IN jtf_date_table := NULL,
27: p_date_received IN jtf_date_table := NULL
28: )
29: RETURN ASO_PA_APR_PUB.Approvers_List_Tbl_Type;
30:

Line 27: p_date_received IN jtf_date_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,
26: p_date_sent IN jtf_date_table := NULL,
27: p_date_received IN jtf_date_table := NULL
28: )
29: RETURN ASO_PA_APR_PUB.Approvers_List_Tbl_Type;
30:
31: PROCEDURE Set_Approvers_List_Tbl_Out(

Line 54: x_date_sent OUT NOCOPY jtf_date_table,

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,
54: x_date_sent OUT NOCOPY jtf_date_table,
55: x_date_received OUT NOCOPY jtf_date_table
56: );
57:
58: PROCEDURE Set_Rules_List_Tbl_Out(

Line 55: x_date_received OUT NOCOPY jtf_date_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,
54: x_date_sent OUT NOCOPY jtf_date_table,
55: x_date_received OUT NOCOPY jtf_date_table
56: );
57:
58: PROCEDURE Set_Rules_List_Tbl_Out(
59: p_qte_rules_list_tbl IN ASO_PA_Apr_Pub.Rules_List_Tbl_Type,

Line 92: x_qa_date_sent OUT NOCOPY jtf_date_table ,

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,
92: x_qa_date_sent OUT NOCOPY jtf_date_table ,
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 ,

Line 93: x_qa_date_received OUT NOCOPY jtf_date_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,
92: x_qa_date_sent OUT NOCOPY jtf_date_table ,
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 ,

Line 145: p_qa_date_sent IN jtf_date_table := 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,
145: p_qa_date_sent IN jtf_date_table := NULL,
146: p_qa_date_received IN jtf_date_table := NULL,
147: x_object_approval_id OUT NOCOPY NUMBER,
148: x_approval_instance_id OUT NOCOPY NUMBER,
149: x_return_status OUT NOCOPY VARCHAR2,

Line 146: p_qa_date_received IN jtf_date_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,
145: p_qa_date_sent IN jtf_date_table := NULL,
146: p_qa_date_received IN jtf_date_table := NULL,
147: x_object_approval_id OUT NOCOPY NUMBER,
148: x_approval_instance_id OUT NOCOPY NUMBER,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,