DBA Data[Home] [Help]

APPS.ASO_PA_APR_INT dependencies on ASO_PA_APR_PUB

Line 22: x_approvers_list OUT NOCOPY /* file.sql.39 change */ ASO_PA_APR_PUB.approvers_list_tbl_type,

18: p_data_flag IN VARCHAR2 :='Y',
19: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
21: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
22: x_approvers_list OUT NOCOPY /* file.sql.39 change */ ASO_PA_APR_PUB.approvers_list_tbl_type,
23: x_rules_list OUT NOCOPY /* file.sql.39 change */ ASO_PA_APR_PUB.rules_list_tbl_type
24: ) IS
25: l_api_name CONSTANT VARCHAR2 (30) := 'GET_ALL_APPROVERS';
26: l_api_version CONSTANT NUMBER := 1.0;

Line 23: x_rules_list OUT NOCOPY /* file.sql.39 change */ ASO_PA_APR_PUB.rules_list_tbl_type

19: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
21: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
22: x_approvers_list OUT NOCOPY /* file.sql.39 change */ ASO_PA_APR_PUB.approvers_list_tbl_type,
23: x_rules_list OUT NOCOPY /* file.sql.39 change */ ASO_PA_APR_PUB.rules_list_tbl_type
24: ) IS
25: l_api_name CONSTANT VARCHAR2 (30) := 'GET_ALL_APPROVERS';
26: l_api_version CONSTANT NUMBER := 1.0;
27:

Line 724: p_del_appr_table IN ASO_PA_APR_PUB.approvers_list_tbl_type,

720: p_object_id IN NUMBER,
721: p_object_type IN VARCHAR2,
722: p_application_id IN NUMBER,
723: p_requester_comments IN VARCHAR2,
724: p_del_appr_table IN ASO_PA_APR_PUB.approvers_list_tbl_type,
725: x_object_approval_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
726: x_approval_instance_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
727: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
728: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1867: (approvertblin IN aso_pa_apr_pub.approvers_list_tbl_type,

1863: );
1864: END upd_status_self_appr;
1865:
1866: procedure insert_approvers_gtt
1867: (approvertblin IN aso_pa_apr_pub.approvers_list_tbl_type,
1868: p_object_appr_id IN number,
1869: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1870: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1871: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)