APPS.AMW_LOAD_RCM_ORG_DATA dependencies on AMW_OBJECTIVE_ASSOCIATIONS

Line 1350: FROM AMW_OBJECTIVE_ASSOCIATIONS

1346: --post AMW.D+
1347: BEGIN
1348: SELECT OBJECTIVE_ASSOCIATION_ID,APPROVAL_DATE
1349: INTO L_PROC_OBJ_ASSOCIATION_ID,L_PROC_OBJ_APPROVAL_DATE
1350: FROM AMW_OBJECTIVE_ASSOCIATIONS
1351: WHERE PROCESS_OBJECTIVE_ID=l_process_objective_id
1352: AND PK1=l_organization_id
1353: ---01.13.2005 npanandi: added the below
1354: and pk2=l_process_id

Line 1365: FND_FILE.PUT_LINE(FND_FILE.LOG,'Need to change the way data is inserted in amw_objective_associations');

1361:
1362: IF (L_PROC_OBJ_ASSOCIATION_ID IS NULL) THEN
1363: --NO ROW RETRIEVED, SO ASSOCIATION DOESN'T EXIST YET
1364: --CREATE AN ASSOCIATION, SET ASSOCIATION_CREATION_DATE=SYSDATE
1365: FND_FILE.PUT_LINE(FND_FILE.LOG,'Need to change the way data is inserted in amw_objective_associations');
1366: CREATE_AMW_OBJ_ASSOC(
1367: P_PROCESS_OBJECTIVE_ID => l_process_objective_id
1368: ,P_PK1 => l_organization_id
1369: ---01.13.2005 npanandi: added below columns

Line 1384: UPDATE AMW_OBJECTIVE_ASSOCIATIONS

1380: IF(L_PROC_OBJ_APPROVAL_DATE IS NOT NULL) THEN
1381: --THIS MEANS THAT THIS IS LATEST REVISION FOR THIS ASSOCIATION
1382: --AND IS APPROVED, SO
1383: BEGIN
1384: UPDATE AMW_OBJECTIVE_ASSOCIATIONS
1385: SET DELETION_DATE=SYSDATE
1386: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
1387: ,LAST_UPDATE_DATE=SYSDATE
1388: ,LAST_UPDATED_BY=G_USER_ID

Line 1427: FROM AMW_OBJECTIVE_ASSOCIATIONS

1423: --npanandi 10/26/2004: changed the way check is done post AMW.D
1424: BEGIN
1425: SELECT OBJECTIVE_ASSOCIATION_ID,APPROVAL_DATE
1426: INTO L_RISK_OBJ_ASSOCIATION_ID,L_RISK_OBJ_APPROVAL_DATE
1427: FROM AMW_OBJECTIVE_ASSOCIATIONS
1428: WHERE PROCESS_OBJECTIVE_ID=l_process_objective_id
1429: AND PK1=lx_risk_id
1430: AND OBJECT_TYPE='RISK'
1431: AND DELETION_DATE IS NULL;

Line 1457: UPDATE AMW_OBJECTIVE_ASSOCIATIONS

1453: IF(L_RISK_OBJ_APPROVAL_DATE IS NOT NULL) THEN
1454: --THIS MEANS THAT THIS IS LATEST REVISION FOR THIS ASSOCIATION
1455: --AND IS APPROVED, SO
1456: BEGIN
1457: UPDATE AMW_OBJECTIVE_ASSOCIATIONS
1458: SET DELETION_DATE=SYSDATE
1459: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
1460: ,LAST_UPDATE_DATE=SYSDATE
1461: ,LAST_UPDATED_BY=G_USER_ID

Line 1509: FROM AMW_OBJECTIVE_ASSOCIATIONS

1505: --npanandi 10/26/2004: changed the way check is done post AMW.D
1506: BEGIN
1507: SELECT OBJECTIVE_ASSOCIATION_ID,APPROVAL_DATE,process_objective_id
1508: INTO L_ctrl_OBJ_ASSOCIATION_ID,L_ctrl_OBJ_APPROVAL_DATE,l_ctrl_objective_id
1509: FROM AMW_OBJECTIVE_ASSOCIATIONS
1510: WHERE
1511: -- PROCESS_OBJECTIVE_ID=l_process_objective_id AND
1512: PK1=l_organization_id
1513: --01.13.2005 npanandi: added below 2 columns in where clause

Line 1551: UPDATE AMW_OBJECTIVE_ASSOCIATIONS

1547: --THIS MEANS THAT THIS IS LATEST REVISION FOR THIS ASSOCIATION
1548: --AND IS APPROVED, SO
1549: if (l_ctrl_objective_id <> l_process_objective_id) then
1550: BEGIN
1551: UPDATE AMW_OBJECTIVE_ASSOCIATIONS
1552: SET DELETION_DATE=SYSDATE
1553: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
1554: ,LAST_UPDATE_DATE=SYSDATE
1555: ,LAST_UPDATED_BY=G_USER_ID

Line 1578: delete from AMW_OBJECTIVE_ASSOCIATIONS

1574: end if;
1575: else
1576: if (l_ctrl_objective_id <> l_process_objective_id) then
1577: BEGIN
1578: delete from AMW_OBJECTIVE_ASSOCIATIONS
1579: WHERE OBJECTIVE_ASSOCIATION_ID=L_CTRL_OBJ_ASSOCIATION_ID;
1580:
1581: -- ...AND CREATE A NEW ROW FOR THE LATEST ASSOCIATION
1582: CREATE_AMW_OBJ_ASSOC(

Line 3010: INSERT INTO amw_objective_associations(

3006: )
3007: IS
3008:
3009: BEGIN
3010: INSERT INTO amw_objective_associations(
3011: objective_association_id
3012: ,last_update_date
3013: ,last_updated_by
3014: ,creation_date

Line 3028: amw_objective_associations_s.NEXTVAL

3024: ,effective_date_from
3025: ,ASSOCIATION_CREATION_DATE
3026: ,OBJECT_VERSION_NUMBER)
3027: VALUES (
3028: amw_objective_associations_s.NEXTVAL
3029: ,SYSDATE
3030: ,v_user_id
3031: ,SYSDATE
3032: ,v_user_id