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 3423: AD_CTX_DDL.sync_index(l_index_owner|| '.hz_stage_parties_t1');

3419: and rownum<1001 ) a )
3420: where rnum = 1000;
3421: update hz_staged_parties set d_ps = 'SYNC', d_ct = 'SYNC', d_cpt = 'SYNC', concat_col = concat_col
3422: where party_id between l_min_id and tmp;
3423: AD_CTX_DDL.sync_index(l_index_owner|| '.hz_stage_parties_t1');
3424: FND_Concurrent.af_commit;
3425: l_min_id:=tmp+1;
3426: END LOOP;
3427: EXCEPTION

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

3428: WHEN NO_DATA_FOUND THEN
3429: update hz_staged_parties set concat_col = concat_col,
3430: d_ps = 'SYNC', d_ct = 'SYNC', d_cpt = 'SYNC'
3431: where party_id between l_min_id and l_max_id ;
3432: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');
3433: FND_Concurrent.af_commit;
3434: WHEN OTHERS THEN
3435: FND_FILE.put_line(FND_FILE.log, 'Error during DENORM PARTY Index Synchronization SQLEERM=' ||SQLERRM);
3436: retcode := 2;

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

3458: where rnum = 1000;
3459: update hz_staged_parties set concat_col = concat_col
3460: where party_id between l_min_id and tmp;
3461: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');
3462: AD_CTX_DDL.sync_index(l_index_owner|| '.hz_stage_parties_t1');
3463: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');
3464: FND_Concurrent.af_commit;
3465: l_min_id:=tmp+1;
3466: END LOOP;

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

3468: WHEN NO_DATA_FOUND THEN
3469: update hz_staged_parties set concat_col = concat_col
3470: where party_id between l_min_id and l_max_id ;
3471: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');
3472: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');
3473: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');
3474: FND_Concurrent.af_commit;
3475: WHEN OTHERS THEN
3476: FND_FILE.put_line(FND_FILE.log, 'Error during PARTY Index Synchronization SQLEERM=' ||SQLERRM);

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

3505: where rnum = 1000;
3506: update hz_staged_party_sites set concat_col = concat_col
3507: where party_id between l_min_id and tmp;
3508: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_party_sites_t1 index');
3509: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_party_sites_t1');
3510: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_party_sites_t1 index successful');
3511: FND_Concurrent.af_commit;
3512: l_min_id:=tmp+1;
3513: END LOOP;

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

3515: WHEN NO_DATA_FOUND THEN
3516: update hz_staged_party_sites set concat_col = concat_col
3517: where party_site_id between l_min_id and l_max_id ;
3518: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_party_sites_t1 index');
3519: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_party_sites_t1');
3520: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_party_sites_t1 index successful');
3521: FND_Concurrent.af_commit;
3522: WHEN OTHERS THEN
3523: FND_FILE.put_line(FND_FILE.log, 'Error during PARTY SITES Index Synchronization SQLEERM=' ||SQLERRM);

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

3553: where rnum = 1000;
3554: update hz_staged_contacts set concat_col = concat_col
3555: where org_contact_id between l_min_id and tmp;
3556: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_contact_t1 index');
3557: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_contact_t1');
3558: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_contact_t1 index successful');
3559: FND_Concurrent.af_commit;
3560: l_min_id:=tmp+1;
3561: END LOOP;

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

3563: WHEN NO_DATA_FOUND THEN
3564: update hz_staged_contacts set concat_col = concat_col
3565: where org_contact_id between l_min_id and l_max_id ;
3566: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_contact_t1 index');
3567: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_contact_t1');
3568: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_contact_t1 index successful');
3569: FND_Concurrent.af_commit;
3570: WHEN OTHERS THEN
3571: FND_FILE.put_line(FND_FILE.log, 'Error during CONTACTS Index Synchronization SQLEERM=' ||SQLERRM);

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

3601: where rnum = 1000;
3602: update hz_staged_contact_points set concat_col = concat_col
3603: where contact_point_id between l_min_id and tmp;
3604: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_cpt_t1 index');
3605: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_cpt_t1');
3606: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_cpt_t1 index successful');
3607: FND_Concurrent.af_commit;
3608: l_min_id:=tmp+1;
3609: END LOOP;

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

3611: WHEN NO_DATA_FOUND THEN
3612: update hz_staged_contact_points set concat_col = concat_col
3613: where contact_point_id between l_min_id and l_max_id ;
3614: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_cpt_t1 index');
3615: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_cpt_t1');
3616: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_cpt_t1 index successful');
3617: FND_Concurrent.af_commit;
3618: WHEN OTHERS THEN
3619: FND_FILE.put_line(FND_FILE.log, 'Error during CONTACT POINTS Index Synchronization SQLEERM=' ||SQLERRM);