DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_SCOPE_PVT

Line 5512: l_subsidiary_tbl amw_scope_pvt.sub_tbl_type;

5508: SELECT distinct organization_id
5509: FROM AMW_FIN_PROCESS_EVAL_SUM
5510: WHERE FIN_CERTIFICATION_ID = p_certification_id;
5511:
5512: l_subsidiary_tbl amw_scope_pvt.sub_tbl_type;
5513: l_lob_tbl amw_scope_pvt.lob_tbl_type;
5514: l_org_tbl amw_scope_pvt.org_tbl_type;
5515: l_proc_tbl amw_scope_pvt.process_tbl_type;
5516:

Line 5513: l_lob_tbl amw_scope_pvt.lob_tbl_type;

5509: FROM AMW_FIN_PROCESS_EVAL_SUM
5510: WHERE FIN_CERTIFICATION_ID = p_certification_id;
5511:
5512: l_subsidiary_tbl amw_scope_pvt.sub_tbl_type;
5513: l_lob_tbl amw_scope_pvt.lob_tbl_type;
5514: l_org_tbl amw_scope_pvt.org_tbl_type;
5515: l_proc_tbl amw_scope_pvt.process_tbl_type;
5516:
5517: l_sub_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;

Line 5514: l_org_tbl amw_scope_pvt.org_tbl_type;

5510: WHERE FIN_CERTIFICATION_ID = p_certification_id;
5511:
5512: l_subsidiary_tbl amw_scope_pvt.sub_tbl_type;
5513: l_lob_tbl amw_scope_pvt.lob_tbl_type;
5514: l_org_tbl amw_scope_pvt.org_tbl_type;
5515: l_proc_tbl amw_scope_pvt.process_tbl_type;
5516:
5517: l_sub_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;
5518: l_lob_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;

Line 5515: l_proc_tbl amw_scope_pvt.process_tbl_type;

5511:
5512: l_subsidiary_tbl amw_scope_pvt.sub_tbl_type;
5513: l_lob_tbl amw_scope_pvt.lob_tbl_type;
5514: l_org_tbl amw_scope_pvt.org_tbl_type;
5515: l_proc_tbl amw_scope_pvt.process_tbl_type;
5516:
5517: l_sub_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;
5518: l_lob_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;
5519:

Line 5604: AMW_SCOPE_PVT.add_scope

5600:
5601: END LOOP;
5602:
5603: IF(l_subsidiary_tbl.count <> 0 ) THEN
5604: AMW_SCOPE_PVT.add_scope
5605: (
5606: p_entity_id => p_certification_id,
5607: p_entity_type => 'FINSTMT_CERTIFICATION',
5608: p_sub_vs => l_sub_vs,