[Home] [Help]
3194:
3195: ELSIF (l_object_name = 'AMW_ORG_AP_CONTROL') THEN
3196: fnd_file.put_line(fnd_file.LOG, 'before ap_evaluation_handler: org_id=' || l_pk3 || 'control_id=' || l_pk1 || ' opinion_log_id= ' || l_opinion_log_id || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
3197:
3198: UPDATE AMW_AP_ASSOCIATIONS
3199: SET LAST_UPDATE_DATE = sysdate,
3200: last_updated_by = fnd_global.user_id,
3201: last_update_login = fnd_global.conc_login_id,
3202: /**05.02.2006 npanandi: fixing the below bug, since it is actually
3402: (p_certification_id => p_certification_id,
3403: x_return_status => l_return_status,
3404: x_msg_count => l_msg_count,
3405: x_msg_data => l_msg_data);
3406: fnd_file.put_line(fnd_file.LOG, 'finish populating amw_ap_associations table:p_certification_id = ' || p_certification_id || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
3407: l_start_time := sysdate;
3408: INSERT_FIN_CERT_SCOPE
3409: (p_certification_id => p_certification_id,
3410: x_return_status => l_return_status,
5263: ap.DELETION_DATE,
5264: ap.DELETION_APPROVAL_DATE,
5265: apb.AUDIT_PROCEDURE_REV_ID
5266: FROM
5267: AMW_AP_ASSOCIATIONS ap,
5268: AMW_CONTROL_ASSOCIATIONS controls,
5269: AMW_AUDIT_PROCEDURES_B apb
5270: WHERE
5271: ap.object_type='CTRL_ORG'
5289: ap.DELETION_DATE,
5290: ap.DELETION_APPROVAL_DATE,
5291: apb.AUDIT_PROCEDURE_REV_ID
5292: FROM
5293: AMW_AP_ASSOCIATIONS ap,
5294: AMW_CONTROL_ASSOCIATIONS controls,
5295: AMW_AUDIT_PROCEDURES_B apb
5296: WHERE
5297: ap.object_type='ENTITY_CTRL_AP'
5363: x_return_status := FND_API.G_RET_STS_SUCCESS;
5364:
5365:
5366:
5367: SELECT COUNT(1) INTO l_count FROM AMW_AP_ASSOCIATIONS
5368: WHERE OBJECT_TYPE = 'CTRL_FINCERT'
5369: and PK1 = p_certification_id;
5370:
5371: IF (l_count = 0) THEN
5377: FETCH last_evaluation INTO m_opinion_id;
5378: CLOSE last_evaluation;
5379:
5380:
5381: INSERT INTO AMW_AP_ASSOCIATIONS(
5382: AP_ASSOCIATION_ID,
5383: AUDIT_PROCEDURE_ID,
5384: PK1, /*certificationId*/
5385: PK2, /*organizationId*/
5397: APPROVAL_DATE,
5398: DELETION_DATE,
5399: DELETION_APPROVAL_DATE,
5400: AUDIT_PROCEDURE_REV_ID)
5401: VALUES (AMW_AP_ASSOCIATIONS_S.nextval,
5402: ap_rec.audit_procedure_id,
5403: p_certification_id, /*certificationId*/
5404: ap_rec.PK1, /*organizationId*/
5405: ap_rec.PK2, /*processId*/
5431: FETCH last_evaluation INTO m_opinion_id;
5432: CLOSE last_evaluation;
5433:
5434:
5435: update AMW_AP_ASSOCIATIONS
5436: set PK5 = m_opinion_id
5437: ,LAST_UPDATE_DATE = SYSDATE
5438: ,LAST_UPDATED_BY = FND_GLOBAL.USER_ID
5439: ,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
10437: ap.DELETION_DATE,
10438: ap.DELETION_APPROVAL_DATE,
10439: apb.AUDIT_PROCEDURE_REV_ID
10440: FROM
10441: AMW_AP_ASSOCIATIONS ap,
10442: AMW_CONTROL_ASSOCIATIONS controls,
10443: AMW_AUDIT_PROCEDURES_B apb
10444: WHERE
10445: ap.object_type='CTRL_ORG'
10461: ap.DELETION_DATE,
10462: ap.DELETION_APPROVAL_DATE,
10463: apb.AUDIT_PROCEDURE_REV_ID
10464: FROM
10465: AMW_AP_ASSOCIATIONS ap,
10466: AMW_CONTROL_ASSOCIATIONS controls,
10467: AMW_AUDIT_PROCEDURES_B apb
10468: WHERE
10469: ap.object_type='ENTITY_CTRL_AP'
10533: x_return_status := FND_API.G_RET_STS_SUCCESS;
10534:
10535:
10536:
10537: SELECT COUNT(1) INTO l_count FROM AMW_AP_ASSOCIATIONS
10538: WHERE OBJECT_TYPE = 'CTRL_FINCERT'
10539: and PK1 = p_certification_id;
10540:
10541: IF (l_count = 0) THEN
10547: FETCH last_evaluation INTO m_opinion_id;
10548: CLOSE last_evaluation;
10549:
10550:
10551: INSERT INTO AMW_AP_ASSOCIATIONS(
10552: AP_ASSOCIATION_ID,
10553: AUDIT_PROCEDURE_ID,
10554: PK1,
10555: PK2,
10567: APPROVAL_DATE,
10568: DELETION_DATE,
10569: DELETION_APPROVAL_DATE,
10570: AUDIT_PROCEDURE_REV_ID)
10571: VALUES (AMW_AP_ASSOCIATIONS_S.nextval,
10572: ap_rec.audit_procedure_id,
10573: p_certification_id,
10574: ap_rec.PK1,
10575: ap_rec.PK2,