eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_ORG_HIERARCHY_PKG dependencies on AMW_ACCT_ASSOCIATIONS

Line 1025: insert into amw_acct_associations

1021: end if;
1022:
1023: end loop;
1024:
1025: insert into amw_acct_associations
1026: (ACCT_ASSOC_ID,
1027: NATURAL_ACCOUNT_ID,
1028: PK1,
1029: PK2,

Line 1045: AMW_ACCT_ASSOCIATIONS_S.nextval,

1041: CREATED_BY,
1042: LAST_UPDATE_LOGIN,
1043: OBJECT_VERSION_NUMBER)
1044: (select
1045: AMW_ACCT_ASSOCIATIONS_S.nextval,
1046: NATURAL_ACCOUNT_ID,
1047: p_org_id,
1048: PK1,
1049: STATEMENT_ID,

Line 1063: from amw_acct_associations

1059: sysdate,
1060: G_USER_ID,
1061: G_LOGIN_ID,
1062: 1
1063: from amw_acct_associations
1064: where PK1 = p_child_process_id
1065: and object_type = 'PROCESS'
1066: and approval_date is not null
1067: and deletion_approval_date is null);

Line 1443: update amw_acct_associations

1439:
1440: -- apply process key accounts
1441:
1442: -- delete existing accounts
1443: update amw_acct_associations
1444: set DELETION_DATE = sysdate
1445: where pk1 = p_org_id
1446: and pk2 = p_process_id
1447: and object_type = 'PROCESS_ORG'

Line 1450: delete amw_acct_associations

1446: and pk2 = p_process_id
1447: and object_type = 'PROCESS_ORG'
1448: and deletion_date is null;
1449: --ko, delete the rows that are not approved..happens in case of synchronizing latest revision and the some accounts are added to that revision..
1450: delete amw_acct_associations
1451: where pk1 = p_org_id
1452: and pk2 = p_process_id
1453: and object_type = 'PROCESS_ORG'
1454: and approval_date is null;

Line 4960: delete from amw_acct_associations

4956: l_control_exists := TRUE;
4957: END IF;
4958:
4959:
4960: delete from amw_acct_associations
4961: where pk1 = p_organization_id
4962: and pk2 = p_process_id
4963: and approval_date is null
4964: and object_type = 'PROCESS_ORG';

Line 4966: update amw_acct_associations

4962: and pk2 = p_process_id
4963: and approval_date is null
4964: and object_type = 'PROCESS_ORG';
4965:
4966: update amw_acct_associations
4967: set deletion_date = null
4968: where pk1 = p_organization_id
4969: and pk2 = p_process_id
4970: and object_type = 'PROCESS_ORG'

Line 5418: delete amw_acct_associations

5414:
5415: -- apply process key accounts -- Delete the accounts that does not exists in the rl process...
5416:
5417: --ko, delete all the unapproved rows
5418: delete amw_acct_associations
5419: where pk1 = p_org_id
5420: and pk2 = p_process_id
5421: and object_type = 'PROCESS_ORG'
5422: and approval_date is null;

Line 5425: update amw_acct_associations

5421: and object_type = 'PROCESS_ORG'
5422: and approval_date is null;
5423:
5424: -- delete existing accounts that are not found in RL process...
5425: update amw_acct_associations
5426: set DELETION_DATE = sysdate
5427: where pk1 = p_org_id
5428: and pk2 = p_process_id
5429: and object_type = 'PROCESS_ORG'

Line 5432: from amw_acct_associations

5428: and pk2 = p_process_id
5429: and object_type = 'PROCESS_ORG'
5430: and deletion_date is null
5431: and natural_account_id not in (select natural_account_id
5432: from amw_acct_associations
5433: where pk1 = p_process_id
5434: and object_type = 'PROCESS'
5435: and approval_date is not null
5436: and deletion_approval_date is null);

Line 5439: insert into amw_acct_associations(

5435: and approval_date is not null
5436: and deletion_approval_date is null);
5437:
5438:
5439: insert into amw_acct_associations(
5440: ACCT_ASSOC_ID,
5441: NATURAL_ACCOUNT_ID,
5442: PK1,
5443: PK2,

Line 5459: AMW_ACCT_ASSOCIATIONS_S.nextval,

5455: CREATED_BY,
5456: LAST_UPDATE_LOGIN,
5457: OBJECT_VERSION_NUMBER)
5458: (select
5459: AMW_ACCT_ASSOCIATIONS_S.nextval,
5460: NATURAL_ACCOUNT_ID,
5461: p_org_id,
5462: PK1,
5463: STATEMENT_ID,

Line 5477: from amw_acct_associations

5473: sysdate,
5474: G_USER_ID,
5475: G_LOGIN_ID,
5476: 1
5477: from amw_acct_associations
5478: where PK1 = p_process_id
5479: and object_type = 'PROCESS'
5480: and approval_date is not null
5481: and deletion_approval_date is null

Line 5483: from amw_acct_associations

5479: and object_type = 'PROCESS'
5480: and approval_date is not null
5481: and deletion_approval_date is null
5482: and NATURAL_ACCOUNT_ID not in(select natural_account_id
5483: from amw_acct_associations
5484: where pk1 = p_org_id
5485: and pk2 = p_process_id
5486: and object_type = 'PROCESS_ORG'
5487: and deletion_date is null));

Line 5691: delete amw_acct_associations

5687: -- apply process key accounts -- Delete the accounts that does not exists in the rl process...
5688:
5689: --ko, delete all the unapproved rows
5690: FORALL indx IN Org_Ids.FIRST .. Org_Ids.LAST
5691: delete amw_acct_associations
5692: where pk1 = Org_Ids(indx)
5693: and pk2 = p_process_id
5694: and object_type = 'PROCESS_ORG'
5695: and approval_date is null;

Line 5699: update amw_acct_associations

5695: and approval_date is null;
5696:
5697: -- delete existing accounts that are not found in RL process...
5698: FORALL indx IN Org_Ids.FIRST .. Org_Ids.LAST
5699: update amw_acct_associations
5700: set DELETION_DATE = sysdate
5701: where pk1 = Org_Ids(indx)
5702: and pk2 = p_process_id
5703: and object_type = 'PROCESS_ORG'

Line 5706: from amw_acct_associations

5702: and pk2 = p_process_id
5703: and object_type = 'PROCESS_ORG'
5704: and deletion_date is null
5705: and natural_account_id not in (select natural_account_id
5706: from amw_acct_associations
5707: where pk1 = p_process_id
5708: and object_type = 'PROCESS'
5709: and approval_date is not null
5710: and deletion_approval_date is null);

Line 5713: insert into amw_acct_associations(

5709: and approval_date is not null
5710: and deletion_approval_date is null);
5711:
5712: FORALL indx IN Org_Ids.FIRST .. Org_Ids.LAST
5713: insert into amw_acct_associations(
5714: ACCT_ASSOC_ID,
5715: NATURAL_ACCOUNT_ID,
5716: PK1,
5717: PK2,

Line 5733: AMW_ACCT_ASSOCIATIONS_S.nextval,

5729: CREATED_BY,
5730: LAST_UPDATE_LOGIN,
5731: OBJECT_VERSION_NUMBER)
5732: (select
5733: AMW_ACCT_ASSOCIATIONS_S.nextval,
5734: NATURAL_ACCOUNT_ID,
5735: Org_Ids(indx),
5736: PK1,
5737: STATEMENT_ID,

Line 5751: from amw_acct_associations

5747: sysdate,
5748: G_USER_ID,
5749: G_LOGIN_ID,
5750: 1
5751: from amw_acct_associations
5752: where PK1 = p_process_id
5753: and object_type = 'PROCESS'
5754: and approval_date is not null
5755: and deletion_approval_date is null

Line 5757: from amw_acct_associations

5753: and object_type = 'PROCESS'
5754: and approval_date is not null
5755: and deletion_approval_date is null
5756: and NATURAL_ACCOUNT_ID not in (select natural_account_id
5757: from amw_acct_associations
5758: where pk1 = Org_Ids(indx)
5759: and pk2 = p_process_id
5760: and object_type = 'PROCESS_ORG'
5761: and deletion_date is null));