APPS.AMW_ORG_CERT_EVAL_SUM_PVT dependencies on AMW_ORG_CERT_EVAL_SUM

Line 1: PACKAGE BODY AMW_ORG_CERT_EVAL_SUM_PVT AS

1: PACKAGE BODY AMW_ORG_CERT_EVAL_SUM_PVT AS
2: /* $Header: amwocertb.pls 120.4 2005/11/18 19:49:01 appldev noship $ */
3:
4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 7: G_PKG_NAME CONSTANT VARCHAR2 (30) := 'AMW_ORG_CERT_EVAL_SUM_PVT';

3:
4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6:
7: G_PKG_NAME CONSTANT VARCHAR2 (30) := 'AMW_ORG_CERT_EVAL_SUM_PVT';
8: G_FILE_NAME CONSTANT VARCHAR2 (15) := 'amwocertb.pls';
9:
10:
11: PROCEDURE populate_org_cert_summary

Line 583: UPDATE AMW_ORG_CERT_EVAL_SUM

579: p_certification_id,
580: null, null,
581: null, null,
582: null, null);
583: UPDATE AMW_ORG_CERT_EVAL_SUM
584: SET certification_opinion_id = l_certification_opinion_id,
585: evaluation_opinion_id = l_evaluation_opinion_id,
586: evaluation_opinion_log_id= l_evaluation_opinion_log_id,
587: unmitigated_risks = l_unmitigated_risks,

Line 620: INSERT INTO AMW_ORG_CERT_EVAL_SUM(certification_opinion_id,

616:
617: IF (SQL%NOTFOUND)
618: THEN
619:
620: INSERT INTO AMW_ORG_CERT_EVAL_SUM(certification_opinion_id,
621: evaluation_opinion_id,
622: evaluation_opinion_log_id,
623: unmitigated_risks,
624: evaluated_risks,

Line 695: END AMW_ORG_CERT_EVAL_SUM_PVT;

691: p_count => x_msg_count,
692: p_data => x_msg_data);
693: END populate_summary;
694:
695: END AMW_ORG_CERT_EVAL_SUM_PVT;