DBA Data[Home] [Help]

APPS.AMW_PROCESS_CERT_SUMMARY dependencies on AMW_FINDINGS_PKG

Line 671: l_open_findings := amw_findings_pkg.calculate_open_findings('AMW_PROJ_FINDING',

667: l_var_org_process_cert;
668: l_org_process_cert_issues := l_org_process_cert_issues +
669: l_var_org_proc_cert_issues;
670:
671: l_open_findings := amw_findings_pkg.calculate_open_findings('AMW_PROJ_FINDING',
672: 'PROJ_ORG_PROC',
673: p_process_id,
674: 'PROJ_ORG',
675: p_org_id,

Line 680: l_open_issues := amw_findings_pkg.calculate_open_findings('AMW_PROC_CERT_ISSUES',

676: null, null,
677: null, null,
678: null, null);
679:
680: l_open_issues := amw_findings_pkg.calculate_open_findings('AMW_PROC_CERT_ISSUES',
681: 'PROCESS',
682: p_process_id,
683: 'ORGANIZATION',
684: p_org_id,

Line 1632: l_open_findings := amw_findings_pkg.calculate_open_findings(

1628: fnd_file.put_line(fnd_file.LOG, 'start timestamp :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1629:
1630:
1631: FOR proc_rec IN get_all_processes LOOP
1632: l_open_findings := amw_findings_pkg.calculate_open_findings(
1633: 'AMW_PROJ_FINDING',
1634: 'PROJ_ORG_PROC',
1635: proc_rec.process_id,
1636: 'PROJ_ORG',

Line 1642: l_open_issues := amw_findings_pkg.calculate_open_findings(

1638: null, null,
1639: null, null,
1640: null, null);
1641:
1642: l_open_issues := amw_findings_pkg.calculate_open_findings(
1643: 'AMW_PROC_CERT_ISSUES',
1644: 'PROCESS',
1645: proc_rec.process_id,
1646: 'ORGANIZATION',

Line 1665: l_open_findings := amw_findings_pkg.calculate_open_findings(

1661: AND organization_id = proc_rec.organization_id;
1662: END LOOP;
1663:
1664: FOR org_rec IN get_all_orgs LOOP
1665: l_open_findings := amw_findings_pkg.calculate_open_findings(
1666: 'AMW_PROJ_FINDING',
1667: 'PROJ_ORG',
1668: org_rec.organization_id,
1669: null, null,

Line 1674: l_open_issues := amw_findings_pkg.calculate_open_findings(

1670: null, null,
1671: null, null,
1672: null, null);
1673:
1674: l_open_issues := amw_findings_pkg.calculate_open_findings(
1675: 'AMW_PROC_CERT_ISSUES',
1676: 'ORGANIZATION',
1677: org_rec.organization_id,
1678: 'CERTIFICATION',