APPS.AMW_PROC_ORG_HIERARCHY_PVT dependencies on DUAL

Line 694: SELECT AMW_PROCESS_organization_s.NEXTVAL FROM dual;

690: l_obj_num number := 0;
691: process_end_date date := sysdate;
692:
693: CURSOR c_proc_org_s IS
694: SELECT AMW_PROCESS_organization_s.NEXTVAL FROM dual;
695:
696: cursor get_counts is
697: select nvl(risk_count,0) as risk_count,
698: nvl(control_count,0) as control_count from amw_process

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 1183: select amw_CONTROL_associations_s.nextval into l_CONTROL_association_id from dual;

1179:
1180: exception
1181: when no_data_found then
1182: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');
1183: select amw_CONTROL_associations_s.nextval into l_CONTROL_association_id from dual;
1184:
1185: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_CONTROL_ASSOCIATIONS');
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_association_id: '||l_CONTROL_association_id);
1187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_id: '||p_CONTROL_id);

Line 1343: select amw_acct_associations_s.nextval into l_acct_assoc_id from dual;

1339: ---------------dbms_output.put_line('In amw_risk_associations: pk1: '||l_process_organization_id);
1340: --------------dbms_output.put_line('In amw_risk_associations: risk_id: '||l_ara_row.risk_id);
1341:
1342: if row_count = 0 then
1343: select amw_acct_associations_s.nextval into l_acct_assoc_id from dual;
1344:
1345: --------------------dbms_output.put_line('In amw_risk_associations: inserting');
1346:
1347: insert into amw_acct_associations (acct_assoc_id,last_update_date,

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,

Line 1782: select amw_control_associations_s.nextval into l_control_association_id from dual;

1778: and pk1=l_risk_association_id
1779: and control_id=l_aca_row.control_id;
1780:
1781: if row_count = 0 then
1782: select amw_control_associations_s.nextval into l_control_association_id from dual;
1783:
1784: -----------------dbms_output.put_line('INSERTING IN AMW_CONTROL_ASSOCIATIONS');
1785: ----------------------dbms_output.put_line('control_association_id: '||l_control_association_id);
1786: insert into amw_control_associations(control_association_id,last_update_date,

Line 2036: select amw_ap_associations_s.nextval into l_ap_association_id from dual;

2032: and audit_procedure_id=l_aaa_row.audit_procedure_id;
2033:
2034:
2035: if row_count = 0 then
2036: select amw_ap_associations_s.nextval into l_ap_association_id from dual;
2037:
2038:
2039: insert into amw_ap_associations(ap_association_id,last_update_date,
2040: last_updated_by,creation_date,created_by,