APPS.AMW_PROC_ORG_HIERARCHY_PVT dependencies on AMW_ACCT_ASSOCIATIONS

Line 1287: from amw_acct_associations

1283: attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,
1284: attribute11,attribute12,---attribute13,
1285: attribute14,attribute15,
1286: security_group_id,object_version_number
1287: from amw_acct_associations
1288: where object_type='PROCESS'
1289: and pk1=l_process_id;
1290: l_aaa_row c1%rowtype;
1291:

Line 1294: from amw_acct_associations where object_type='PROCESS_ORG'

1290: l_aaa_row c1%rowtype;
1291:
1292: cursor c2 is
1293: select acct_assoc_id,natural_account_id
1294: from amw_acct_associations where object_type='PROCESS_ORG'
1295: and pk1=l_process_organization_id; ---and risk_id=;
1296: l_update c2%rowtype;
1297:
1298: row_count number := 0;

Line 1304: FROM amw_acct_associations

1300: x_rowid number;
1301:
1302: CURSOR c_id_exists (l_id IN NUMBER) IS
1303: SELECT 1
1304: FROM amw_acct_associations
1305: WHERE acct_assoc_id = l_id;
1306:
1307: begin
1308: savepoint assoc_acct_pvt;

Line 1333: select count(*) into row_count from amw_acct_associations

1329: loop
1330: fetch c1 into l_aaa_row;
1331: exit when c1%notfound;
1332:
1333: select count(*) into row_count from amw_acct_associations
1334: where object_type='PROCESS_ORG'
1335: and pk1=l_process_organization_id
1336: and natural_account_id=l_aaa_row.natural_account_id;
1337:

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 1347: insert into amw_acct_associations (acct_assoc_id,last_update_date,

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,
1348: last_updated_by,creation_date,created_by,
1349: last_update_login,object_type,pk1,pk2,pk3,pk4,pk5,
1350: natural_account_id,statement_id,statement_line_id,
1351: attribute_category,attribute1,attribute2,

Line 1391: delete from amw_acct_associations

1387: loop
1388: fetch c2 into l_update;
1389: exit when c2%notfound;
1390:
1391: delete from amw_acct_associations
1392: where acct_assoc_id=l_update.acct_assoc_id
1393: and object_type='PROCESS_ORG'
1394: and pk1=p_process_organization_id;
1395: