APPS.AMW_PROC_ORG_HIERARCHY_PVT dependencies on AMW_RISK_ASSOCIATIONS_S

Line 1118: select amw_risk_associations_s.nextval into l_risk_association_id from dual;

1114:
1115: exception
1116: when no_data_found then
1117: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');
1118: select amw_risk_associations_s.nextval into l_risk_association_id from dual;
1119:
1120: open c1(p_batch_id,p_rcm_org_intf_id);
1121: fetch c1 into l_c1_type;
1122: close c1;

Line 1148: ---amw_risk_associations_s.nextval,

1144: risk_likelihood_code,
1145: risk_impact_code,
1146: material,
1147: material_value) values (
1148: ---amw_risk_associations_s.nextval,
1149: l_risk_association_id,
1150: sysdate,
1151: G_USER_ID,
1152: sysdate,

Line 1201: ---amw_risk_associations_s.nextval,

1197: pk1,
1198: object_type,
1199: object_version_number,
1200: effective_date_from) values (
1201: ---amw_risk_associations_s.nextval,
1202: l_CONTROL_association_id,
1203: sysdate,
1204: G_USER_ID,
1205: sysdate,

Line 1555: select amw_risk_associations_s.nextval into l_risk_association_id from dual;

1551: ---------------dbms_output.put_line('In amw_risk_associations: pk1: '||l_process_organization_id);
1552: --------------dbms_output.put_line('In amw_risk_associations: risk_id: '||l_ara_row.risk_id);
1553:
1554: if row_count = 0 then
1555: select amw_risk_associations_s.nextval into l_risk_association_id from dual;
1556:
1557: --------------------dbms_output.put_line('In amw_risk_associations: inserting');
1558:
1559: insert into amw_risk_associations (risk_association_id,last_update_date,