1: PACKAGE BODY AMW_FINSTMT_CERT_MIG_PKG AS
2: /* $Header: amwfmigb.pls 120.0 2005/09/09 14:50:09 appldev noship $ */
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_FINSTMT_CERT_MIG_PKG';
8: G_API_NAME CONSTANT VARCHAR2 (15) := 'amwfmigb.pls';
1: PACKAGE BODY AMW_FINSTMT_CERT_MIG_PKG AS
2: /* $Header: amwfmigb.pls 120.0 2005/09/09 14:50:09 appldev noship $ */
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_FINSTMT_CERT_MIG_PKG';
8: G_API_NAME CONSTANT VARCHAR2 (15) := 'amwfmigb.pls';
9:
707: p_certification_id,
708: risk_rec.PK1,
709: risk_rec.PK2,
710: m_opinion_log_id,
711: FND_GLOBAL.USER_ID,
712: SYSDATE,
713: SYSDATE,
714: FND_GLOBAL.USER_ID,
715: FND_GLOBAL.USER_ID,
710: m_opinion_log_id,
711: FND_GLOBAL.USER_ID,
712: SYSDATE,
713: SYSDATE,
714: FND_GLOBAL.USER_ID,
715: FND_GLOBAL.USER_ID,
716: 1,
717: 'PROCESS_FINCERT',
718: risk_rec.ASSOCIATION_CREATION_DATE,
711: FND_GLOBAL.USER_ID,
712: SYSDATE,
713: SYSDATE,
714: FND_GLOBAL.USER_ID,
715: FND_GLOBAL.USER_ID,
716: 1,
717: 'PROCESS_FINCERT',
718: risk_rec.ASSOCIATION_CREATION_DATE,
719: risk_rec.APPROVAL_DATE,
913: control_rec.PK1,
914: control_rec.PK2,
915: control_rec.PK3,
916: m_opinion_log_id,
917: FND_GLOBAL.USER_ID,
918: SYSDATE,
919: SYSDATE,
920: FND_GLOBAL.USER_ID,
921: FND_GLOBAL.USER_ID,
916: m_opinion_log_id,
917: FND_GLOBAL.USER_ID,
918: SYSDATE,
919: SYSDATE,
920: FND_GLOBAL.USER_ID,
921: FND_GLOBAL.USER_ID,
922: 1,
923: 'RISK_FINCERT',
924: control_rec.ASSOCIATION_CREATION_DATE,
917: FND_GLOBAL.USER_ID,
918: SYSDATE,
919: SYSDATE,
920: FND_GLOBAL.USER_ID,
921: FND_GLOBAL.USER_ID,
922: 1,
923: 'RISK_FINCERT',
924: control_rec.ASSOCIATION_CREATION_DATE,
925: control_rec.APPROVAL_DATE,
1121: ap_rec.PK1,
1122: ap_rec.PK2,
1123: ap_rec.PK3,
1124: m_opinion_id,
1125: FND_GLOBAL.USER_ID,
1126: SYSDATE,
1127: SYSDATE,
1128: FND_GLOBAL.USER_ID,
1129: FND_GLOBAL.USER_ID,
1124: m_opinion_id,
1125: FND_GLOBAL.USER_ID,
1126: SYSDATE,
1127: SYSDATE,
1128: FND_GLOBAL.USER_ID,
1129: FND_GLOBAL.USER_ID,
1130: 1,
1131: 'CTRL_FINCERT',
1132: ap_rec.ASSOCIATION_CREATION_DATE,
1125: FND_GLOBAL.USER_ID,
1126: SYSDATE,
1127: SYSDATE,
1128: FND_GLOBAL.USER_ID,
1129: FND_GLOBAL.USER_ID,
1130: 1,
1131: 'CTRL_FINCERT',
1132: ap_rec.ASSOCIATION_CREATION_DATE,
1133: ap_rec.APPROVAL_DATE,