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.HZ_PARTY_STAGE dependencies on AD_CTX_DDL

Line 85: ad_ctx_ddl.drop_preference(p_ds_name);

81: log ('-----------------------------------------------------------');
82: log( 'In create_pref '); -- VJN ADDED
83: log ('length of p_columns is ' || length(p_columns) ); -- VJN ADDED
84: BEGIN
85: ad_ctx_ddl.drop_preference(p_ds_name);
86: EXCEPTION
87: WHEN OTHERS THEN
88: log('exception thrown while dropping preference for ' || p_ds_name );
89: null;

Line 95: ad_ctx_ddl.create_preference(p_ds_name, 'MULTI_COLUMN_DATASTORE');

91:
92: -- Bug Fix for 4359525 ( This is a forward port for bug 4382012 originally reported on 11i.HZ.M )
93: -- Create preference only if there are any columns to be associated to the preference
94: IF length(p_columns) > 0 THEN
95: ad_ctx_ddl.create_preference(p_ds_name, 'MULTI_COLUMN_DATASTORE');
96: ad_ctx_ddl.set_attribute(p_ds_name,'columns',p_columns);
97: log('Preference successfully created for ' || p_ds_name );
98: ELSE
99: log('Preference ' || p_ds_name || ' not created since there are no associated columns');

Line 96: ad_ctx_ddl.set_attribute(p_ds_name,'columns',p_columns);

92: -- Bug Fix for 4359525 ( This is a forward port for bug 4382012 originally reported on 11i.HZ.M )
93: -- Create preference only if there are any columns to be associated to the preference
94: IF length(p_columns) > 0 THEN
95: ad_ctx_ddl.create_preference(p_ds_name, 'MULTI_COLUMN_DATASTORE');
96: ad_ctx_ddl.set_attribute(p_ds_name,'columns',p_columns);
97: log('Preference successfully created for ' || p_ds_name );
98: ELSE
99: log('Preference ' || p_ds_name || ' not created since there are no associated columns');
100: END IF ;

Line 3303: AD_CTX_DDL.sync_index(l_index_owner|| '.hz_stage_parties_t1');

3299: and rownum<1001 ) a )
3300: where rnum = 1000;
3301: update hz_staged_parties set d_ps = 'SYNC', d_ct = 'SYNC', d_cpt = 'SYNC', concat_col = concat_col
3302: where party_id between l_min_id and tmp;
3303: AD_CTX_DDL.sync_index(l_index_owner|| '.hz_stage_parties_t1');
3304: FND_Concurrent.af_commit;
3305: l_min_id:=tmp+1;
3306: END LOOP;
3307: EXCEPTION

Line 3312: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');

3308: WHEN NO_DATA_FOUND THEN
3309: update hz_staged_parties set concat_col = concat_col,
3310: d_ps = 'SYNC', d_ct = 'SYNC', d_cpt = 'SYNC'
3311: where party_id between l_min_id and l_max_id ;
3312: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');
3313: FND_Concurrent.af_commit;
3314: WHEN OTHERS THEN
3315: FND_FILE.put_line(FND_FILE.log, 'Error during DENORM PARTY Index Synchronization SQLEERM=' ||SQLERRM);
3316: retcode := 2;

Line 3342: AD_CTX_DDL.sync_index(l_index_owner|| '.hz_stage_parties_t1');

3338: where rnum = 1000;
3339: update hz_staged_parties set concat_col = concat_col
3340: where party_id between l_min_id and tmp;
3341: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');
3342: AD_CTX_DDL.sync_index(l_index_owner|| '.hz_stage_parties_t1');
3343: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');
3344: FND_Concurrent.af_commit;
3345: l_min_id:=tmp+1;
3346: END LOOP;

Line 3352: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');

3348: WHEN NO_DATA_FOUND THEN
3349: update hz_staged_parties set concat_col = concat_col
3350: where party_id between l_min_id and l_max_id ;
3351: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');
3352: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');
3353: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');
3354: FND_Concurrent.af_commit;
3355: WHEN OTHERS THEN
3356: FND_FILE.put_line(FND_FILE.log, 'Error during PARTY Index Synchronization SQLEERM=' ||SQLERRM);

Line 3389: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_party_sites_t1');

3385: where rnum = 1000;
3386: update hz_staged_party_sites set concat_col = concat_col
3387: where party_id between l_min_id and tmp;
3388: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_party_sites_t1 index');
3389: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_party_sites_t1');
3390: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_party_sites_t1 index successful');
3391: FND_Concurrent.af_commit;
3392: l_min_id:=tmp+1;
3393: END LOOP;

Line 3399: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_party_sites_t1');

3395: WHEN NO_DATA_FOUND THEN
3396: update hz_staged_party_sites set concat_col = concat_col
3397: where party_site_id between l_min_id and l_max_id ;
3398: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_party_sites_t1 index');
3399: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_party_sites_t1');
3400: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_party_sites_t1 index successful');
3401: FND_Concurrent.af_commit;
3402: WHEN OTHERS THEN
3403: FND_FILE.put_line(FND_FILE.log, 'Error during PARTY SITES Index Synchronization SQLEERM=' ||SQLERRM);

Line 3437: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_contact_t1');

3433: where rnum = 1000;
3434: update hz_staged_contacts set concat_col = concat_col
3435: where org_contact_id between l_min_id and tmp;
3436: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_contact_t1 index');
3437: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_contact_t1');
3438: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_contact_t1 index successful');
3439: FND_Concurrent.af_commit;
3440: l_min_id:=tmp+1;
3441: END LOOP;

Line 3447: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_contact_t1');

3443: WHEN NO_DATA_FOUND THEN
3444: update hz_staged_contacts set concat_col = concat_col
3445: where org_contact_id between l_min_id and l_max_id ;
3446: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_contact_t1 index');
3447: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_contact_t1');
3448: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_contact_t1 index successful');
3449: FND_Concurrent.af_commit;
3450: WHEN OTHERS THEN
3451: FND_FILE.put_line(FND_FILE.log, 'Error during CONTACTS Index Synchronization SQLEERM=' ||SQLERRM);

Line 3485: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_cpt_t1');

3481: where rnum = 1000;
3482: update hz_staged_contact_points set concat_col = concat_col
3483: where contact_point_id between l_min_id and tmp;
3484: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_cpt_t1 index');
3485: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_cpt_t1');
3486: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_cpt_t1 index successful');
3487: FND_Concurrent.af_commit;
3488: l_min_id:=tmp+1;
3489: END LOOP;

Line 3495: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_cpt_t1');

3491: WHEN NO_DATA_FOUND THEN
3492: update hz_staged_contact_points set concat_col = concat_col
3493: where contact_point_id between l_min_id and l_max_id ;
3494: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_cpt_t1 index');
3495: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_cpt_t1');
3496: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_cpt_t1 index successful');
3497: FND_Concurrent.af_commit;
3498: WHEN OTHERS THEN
3499: FND_FILE.put_line(FND_FILE.log, 'Error during CONTACT POINTS Index Synchronization SQLEERM=' ||SQLERRM);