APPS.AMW_LOAD_RC_DATA dependencies on AMW_CONTROL_ASSOCIATIONS

Line 12: /* Insert into AMW_CONTROL_ASSOCIATIONS */

8: /* following tables: */
9: /* INSERTS OR UPDATES ARE DONE AGAINIST THE FOLLOWING TABLES */
10: /* Insert into AMW_RISKS_B and AMW_RISKS_TL */
11: /* Insert into AMW_CONTROLS_B and AMW_CONTROLS_TL */
12: /* Insert into AMW_CONTROL_ASSOCIATIONS */
13: /* Insert into AMW_RISK_ASSOCIATIONS */
14: /* Insert into AMW_CONTROL_OBJECTIVES */
15: /* Insert into AMW_CONTROL_ASSERTIONS */
16: /* Updates amw_risk-ctrl_interface, with error messages */

Line 1027: FROM AMW_CONTROL_ASSOCIATIONS

1023: fnd_file.PUT_LINE(fnd_file.log, 'L_PROCESS_ID: '||L_PROCESS_ID||', LX_RISK_ID: '||LX_RISK_ID);
1024: BEGIN
1025: SELECT CONTROL_ASSOCIATION_ID,APPROVAL_DATE
1026: INTO L_CONTROL_ASSOCIATION_ID,L_APPROVAL_DATE
1027: FROM AMW_CONTROL_ASSOCIATIONS
1028: WHERE CONTROL_ID=LX_CONTROL_ID
1029: AND PK1=L_PROCESS_ID
1030: AND PK2=LX_RISK_ID
1031: AND OBJECT_TYPE='RISK'

Line 1069: UPDATE AMW_CONTROL_ASSOCIATIONS

1065: IF(L_APPROVAL_DATE IS NOT NULL and l_has_risk_ctrl_assn_access = 'T') THEN
1066: --THIS MEANS THAT THIS IS LATEST REVISION FOR THIS ASSOCIATION
1067: --AND IS APPROVED, SO
1068: BEGIN
1069: UPDATE AMW_CONTROL_ASSOCIATIONS
1070: SET DELETION_DATE=SYSDATE
1071: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
1072: ,LAST_UPDATE_DATE=SYSDATE
1073: ,LAST_UPDATED_BY=G_USER_ID

Line 2600: INSERT INTO amw_control_associations(

2596: --03.02.2005 npanandi: imposing the foll. IF condition to
2597: --create the association only if access privilege is present
2598: if(l_has_risk_ctrl_assn_access = 'T') then
2599: **/
2600: INSERT INTO amw_control_associations(
2601: control_association_id
2602: ,last_update_date
2603: ,last_updated_by
2604: ,creation_date

Line 2615: amw_control_associations_s.NEXTVAL

2611: ,effective_date_to
2612: ,ASSOCIATION_CREATION_DATE
2613: ,OBJECT_VERSION_NUMBER)
2614: VALUES (
2615: amw_control_associations_s.NEXTVAL
2616: ,SYSDATE
2617: ,v_user_id
2618: ,SYSDATE
2619: ,v_user_id