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.AMS_DMEXTRACT_PVT dependencies on AMS_DM_PARTY_DETAILS_TIME

Line 65: -- and ams_dm_party_details_time. The commits done at

61: PROCEDURE UpdatePartyDetailsTime;
62:
63: -- kbasavar migrated chi's changes for bug 3089951
64: -- Synchronizes the records of both ams_dm_party_details
65: -- and ams_dm_party_details_time. The commits done at
66: -- the end of each procedure to release rollback space
67: -- could cause the records to go out of sync if one table's
68: -- insert completes while the other fails.
69: PROCEDURE sync_party_tables;

Line 3246: INSERT -- /+ APPEND PARALLEL(AMS_DM_PARTY_DETAILS_TIME,DEFAULT,DEFAULT)/

3242:
3243: ----------------------- Insert ----------------------
3244: -- Move Data from Staging to Party Details Time (Insert Process)
3245:
3246: INSERT -- /*+ APPEND PARALLEL(AMS_DM_PARTY_DETAILS_TIME,DEFAULT,DEFAULT)*/
3247: INTO ams_dm_party_details_time (
3248: party_id,
3249: created_by,
3250: creation_date,

Line 3247: INTO ams_dm_party_details_time (

3243: ----------------------- Insert ----------------------
3244: -- Move Data from Staging to Party Details Time (Insert Process)
3245:
3246: INSERT -- /*+ APPEND PARALLEL(AMS_DM_PARTY_DETAILS_TIME,DEFAULT,DEFAULT)*/
3247: INTO ams_dm_party_details_time (
3248: party_id,
3249: created_by,
3250: creation_date,
3251: last_updated_by,

Line 3701: UPDATE /+ PARALLEL(AMS_DM_PARTY_DETAILS_TIME)/

3697:
3698: ----------------------- Insert ----------------------
3699: -- Update Party Details Time with changed data from Staging Area
3700:
3701: UPDATE /*+ PARALLEL(AMS_DM_PARTY_DETAILS_TIME)*/
3702: ams_dm_party_details_time pdtt SET (
3703: last_updated_by,
3704: last_update_date,
3705: last_update_login,

Line 3702: ams_dm_party_details_time pdtt SET (

3698: ----------------------- Insert ----------------------
3699: -- Update Party Details Time with changed data from Staging Area
3700:
3701: UPDATE /*+ PARALLEL(AMS_DM_PARTY_DETAILS_TIME)*/
3702: ams_dm_party_details_time pdtt SET (
3703: last_updated_by,
3704: last_update_date,
3705: last_update_login,
3706: age,

Line 4267: tabname => 'AMS_DM_PARTY_DETAILS_TIME',

4263: );
4264:
4265: DBMS_STATS.gather_table_stats (
4266: ownname => l_ams_schema,
4267: tabname => 'AMS_DM_PARTY_DETAILS_TIME',
4268: estimate_percent => 99,
4269: cascade => TRUE
4270: );
4271:

Line 4286: -- and ams_dm_party_details_time by deleting from party

4282: -- sync_party_tables
4283: --
4284: -- DESCRIPTION
4285: -- Synchronizes the party records of ams_dm_party_details
4286: -- and ams_dm_party_details_time by deleting from party
4287: -- details. This procedure is meant to be called if the
4288: -- insert for party details time fails.
4289: --
4290: -- HISTORY

Line 4297: WHERE NOT EXISTS (SELECT 1 FROM ams_dm_party_details_time t

4293: PROCEDURE sync_party_tables
4294: IS
4295: BEGIN
4296: DELETE FROM ams_dm_party_details d
4297: WHERE NOT EXISTS (SELECT 1 FROM ams_dm_party_details_time t
4298: WHERE t.party_id = d.party_id)
4299: ;
4300: END;
4301: