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 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 773: ctx_ddl.add_zone_section(p_dsname, p_attr,p_attr);

769: p_attr VARCHAR2,
770: p_stype VARCHAR2) IS
771: BEGIN
772: IF p_stype = 'ZONE' THEN
773: ctx_ddl.add_zone_section(p_dsname, p_attr,p_attr);
774: ELSE
775: ctx_ddl.add_field_section(p_dsname, p_attr,p_attr,TRUE);
776: END IF;
777: END;

Line 775: ctx_ddl.add_field_section(p_dsname, p_attr,p_attr,TRUE);

771: BEGIN
772: IF p_stype = 'ZONE' THEN
773: ctx_ddl.add_zone_section(p_dsname, p_attr,p_attr);
774: ELSE
775: ctx_ddl.add_field_section(p_dsname, p_attr,p_attr,TRUE);
776: END IF;
777: END;
778:
779:

Line 813: ctx_ddl.drop_section_group(g_schema_name || '.HZ_DQM_PARTY_GRP');

809: log('In generate_datastore_prefs for ' || p_entity);
810: log('Trying to update the temp_section of HZ_TRANS_ATTRIBUTES_B for ' || p_entity);
811: BEGIN
812: IF p_entity='PARTY' THEN
813: ctx_ddl.drop_section_group(g_schema_name || '.HZ_DQM_PARTY_GRP');
814: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
815: WHERE ENTITY_NAME='PARTY';
816: END IF;
817:

Line 819: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_PS_GRP');

815: WHERE ENTITY_NAME='PARTY';
816: END IF;
817:
818: IF p_entity='PARTY_SITES' THEN
819: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_PS_GRP');
820: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
821: WHERE ENTITY_NAME='PARTY_SITES';
822: END IF;
823:

Line 825: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_CONTACT_GRP');

821: WHERE ENTITY_NAME='PARTY_SITES';
822: END IF;
823:
824: IF p_entity='CONTACTS' THEN
825: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_CONTACT_GRP');
826: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
827: WHERE ENTITY_NAME='CONTACTS';
828: END IF;
829:

Line 831: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_CPT_GRP');

827: WHERE ENTITY_NAME='CONTACTS';
828: END IF;
829:
830: IF p_entity='CONTACT_POINTS' THEN
831: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_CPT_GRP');
832: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
833: WHERE ENTITY_NAME='CONTACT_POINTS';
834: END IF;
835: log('Update of HZ_TRANS_ATTRIBUTES_B successful for ' || p_entity);

Line 843: ctx_ddl.create_section_group(G_SCHEMA_NAME || '.HZ_DQM_PARTY_GRP','BASIC_SECTION_GROUP');

839: END;
840:
841: IF p_entity='PARTY' THEN
842: log('Creating party_ds..',FALSE);
843: ctx_ddl.create_section_group(G_SCHEMA_NAME || '.HZ_DQM_PARTY_GRP','BASIC_SECTION_GROUP');
844: OPEN c_num_attrs('PARTY');
845: FETCH c_num_attrs INTO l_cnt;
846: CLOSE c_num_attrs;
847: l_cnt := l_cnt+4;

Line 879: ctx_ddl.create_section_group(G_SCHEMA_NAME || '.HZ_DQM_PS_GRP','BASIC_SECTION_GROUP');

875: END IF;
876:
877: IF p_entity='PARTY_SITES' THEN
878: log('Creating party_site_ds..',FALSE);
879: ctx_ddl.create_section_group(G_SCHEMA_NAME || '.HZ_DQM_PS_GRP','BASIC_SECTION_GROUP');
880: OPEN c_num_attrs('PARTY_SITES');
881: FETCH c_num_attrs INTO l_cnt;
882: CLOSE c_num_attrs;
883: l_cnt := l_cnt;

Line 910: ctx_ddl.create_section_group(G_SCHEMA_NAME || '.HZ_DQM_CONTACT_GRP','BASIC_SECTION_GROUP');

906: END IF;
907:
908: IF p_entity='CONTACTS' THEN
909: log('Creating contact_ds..',FALSE);
910: ctx_ddl.create_section_group(G_SCHEMA_NAME || '.HZ_DQM_CONTACT_GRP','BASIC_SECTION_GROUP');
911: OPEN c_num_attrs('CONTACTS');
912: FETCH c_num_attrs INTO l_cnt;
913: CLOSE c_num_attrs;
914: l_cnt := l_cnt;

Line 941: ctx_ddl.create_section_group(G_SCHEMA_NAME || '.HZ_DQM_CPT_GRP','BASIC_SECTION_GROUP');

937: END IF;
938:
939: IF p_entity='CONTACT_POINTS' THEN
940: log('Creating contact_pt_ds..',FALSE);
941: ctx_ddl.create_section_group(G_SCHEMA_NAME || '.HZ_DQM_CPT_GRP','BASIC_SECTION_GROUP');
942: add_section(G_SCHEMA_NAME || '.HZ_DQM_CPT_GRP','CONTACT_POINT_TYPE',l_stype);
943: OPEN c_num_attrs('CONTACT_POINTS');
944: FETCH c_num_attrs INTO l_cnt;
945: CLOSE c_num_attrs;

Line 1489: ctx_ddl.drop_preference('HZ_DQM_STORAGE');

1485: l_num_prll := NULL;
1486: END IF;
1487:
1488: BEGIN
1489: ctx_ddl.drop_preference('HZ_DQM_STORAGE');
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: NULL;
1493: END;

Line 1505: ctx_ddl.create_preference('HZ_DQM_STORAGE', 'BASIC_STORAGE');

1501: from fnd_product_installations
1502: where application_id = '222';
1503: END IF;
1504:
1505: ctx_ddl.create_preference('HZ_DQM_STORAGE', 'BASIC_STORAGE');
1506: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp|| ' storage (initial 4K next 8M pctincrease 0)');
1507: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'K_TABLE_CLAUSE', 'tablespace ' || ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0)');
1508: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'R_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0) lob (data) store as (cache) ');
1509: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_INDEX_CLAUSE', 'tablespace '|| ctx_index_tbsp || ' storage (initial 4K next 8M pctincrease 0) compress 2');

Line 1506: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp|| ' storage (initial 4K next 8M pctincrease 0)');

1502: where application_id = '222';
1503: END IF;
1504:
1505: ctx_ddl.create_preference('HZ_DQM_STORAGE', 'BASIC_STORAGE');
1506: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp|| ' storage (initial 4K next 8M pctincrease 0)');
1507: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'K_TABLE_CLAUSE', 'tablespace ' || ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0)');
1508: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'R_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0) lob (data) store as (cache) ');
1509: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_INDEX_CLAUSE', 'tablespace '|| ctx_index_tbsp || ' storage (initial 4K next 8M pctincrease 0) compress 2');
1510:

Line 1507: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'K_TABLE_CLAUSE', 'tablespace ' || ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0)');

1503: END IF;
1504:
1505: ctx_ddl.create_preference('HZ_DQM_STORAGE', 'BASIC_STORAGE');
1506: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp|| ' storage (initial 4K next 8M pctincrease 0)');
1507: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'K_TABLE_CLAUSE', 'tablespace ' || ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0)');
1508: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'R_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0) lob (data) store as (cache) ');
1509: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_INDEX_CLAUSE', 'tablespace '|| ctx_index_tbsp || ' storage (initial 4K next 8M pctincrease 0) compress 2');
1510:
1511: END IF;

Line 1508: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'R_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0) lob (data) store as (cache) ');

1504:
1505: ctx_ddl.create_preference('HZ_DQM_STORAGE', 'BASIC_STORAGE');
1506: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp|| ' storage (initial 4K next 8M pctincrease 0)');
1507: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'K_TABLE_CLAUSE', 'tablespace ' || ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0)');
1508: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'R_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0) lob (data) store as (cache) ');
1509: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_INDEX_CLAUSE', 'tablespace '|| ctx_index_tbsp || ' storage (initial 4K next 8M pctincrease 0) compress 2');
1510:
1511: END IF;
1512:

Line 1509: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_INDEX_CLAUSE', 'tablespace '|| ctx_index_tbsp || ' storage (initial 4K next 8M pctincrease 0) compress 2');

1505: ctx_ddl.create_preference('HZ_DQM_STORAGE', 'BASIC_STORAGE');
1506: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp|| ' storage (initial 4K next 8M pctincrease 0)');
1507: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'K_TABLE_CLAUSE', 'tablespace ' || ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0)');
1508: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'R_TABLE_CLAUSE', 'tablespace '|| ctx_tbsp || ' storage (initial 4K next 8M pctincrease 0) lob (data) store as (cache) ');
1509: ctx_ddl.set_attribute('HZ_DQM_STORAGE', 'I_INDEX_CLAUSE', 'tablespace '|| ctx_index_tbsp || ' storage (initial 4K next 8M pctincrease 0) compress 2');
1510:
1511: END IF;
1512:
1513: BEGIN

Line 1514: ctx_ddl.drop_preference('dqm_lexer');

1510:
1511: END IF;
1512:
1513: BEGIN
1514: ctx_ddl.drop_preference('dqm_lexer');
1515: EXCEPTION
1516: WHEN OTHERS THEN
1517: null;
1518: END;

Line 1520: ctx_ddl.create_preference('dqm_lexer', 'BASIC_LEXER');

1516: WHEN OTHERS THEN
1517: null;
1518: END;
1519:
1520: ctx_ddl.create_preference('dqm_lexer', 'BASIC_LEXER');
1521: ctx_ddl.set_attribute ( 'dqm_lexer', 'index_themes', 'NO');
1522: ctx_ddl.set_attribute ( 'dqm_lexer', 'index_text', 'YES');
1523:
1524: IF l_command = 'GENERATE_MAP_PROC' THEN

Line 1521: ctx_ddl.set_attribute ( 'dqm_lexer', 'index_themes', 'NO');

1517: null;
1518: END;
1519:
1520: ctx_ddl.create_preference('dqm_lexer', 'BASIC_LEXER');
1521: ctx_ddl.set_attribute ( 'dqm_lexer', 'index_themes', 'NO');
1522: ctx_ddl.set_attribute ( 'dqm_lexer', 'index_text', 'YES');
1523:
1524: IF l_command = 'GENERATE_MAP_PROC' THEN
1525: log (' In the GENERATE_MAP_PROC flow');

Line 1522: ctx_ddl.set_attribute ( 'dqm_lexer', 'index_text', 'YES');

1518: END;
1519:
1520: ctx_ddl.create_preference('dqm_lexer', 'BASIC_LEXER');
1521: ctx_ddl.set_attribute ( 'dqm_lexer', 'index_themes', 'NO');
1522: ctx_ddl.set_attribute ( 'dqm_lexer', 'index_text', 'YES');
1523:
1524: IF l_command = 'GENERATE_MAP_PROC' THEN
1525: log (' In the GENERATE_MAP_PROC flow');
1526: generate_map_pkg;

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);