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 HZ_TRANS_FUNCTIONS_VL

Line 123: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

119: (
120: -- will get all staged attribute columns corresponding to active transformations
121: -- that are defined on party site denorm attributes
122: SELECT b.staged_attribute_column as attrib_column
123: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
124: where a.entity_name = 'PARTY_SITES'
125: and nvl(a.denorm_flag,'N') = 'Y'
126: and a.attribute_id = b.attribute_id
127: and nvl( b.active_flag, 'Y') = 'Y'

Line 151: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

147: (
148: -- will get all staged attribute columns corresponding to active transformations
149: -- that are defined on contact denorm attributes
150: SELECT b.staged_attribute_column as attrib_column
151: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
152: where a.entity_name = 'CONTACTS'
153: and nvl(a.denorm_flag,'N') = 'Y'
154: and a.attribute_id = b.attribute_id
155: and nvl( b.active_flag, 'Y') = 'Y'

Line 180: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

176: (
177: -- will get all staged attribute columns corresponding to active transformations
178: -- that are defined on contact point denorm attributes
179: SELECT b.staged_attribute_column as attrib_column
180: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
181: where a.entity_name = 'CONTACT_POINTS'
182: and nvl(a.denorm_flag,'N') = 'Y'
183: and a.attribute_id = b.attribute_id
184: and nvl( b.active_flag, 'Y') = 'Y'

Line 229: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

225:
226: FOR col_cur in
227: (
228: SELECT b.staged_attribute_column as attrib_column
229: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
230: where a.entity_name = 'PARTY_SITES'
231: and nvl(a.denorm_flag,'N') = 'Y'
232: and a.attribute_id = b.attribute_id
233: and nvl( b.active_flag, 'Y') = 'Y'

Line 269: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

265:
266: FOR col_cur in
267: (
268: SELECT b.staged_attribute_column as attrib_column
269: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
270: where a.entity_name = 'CONTACTS'
271: and nvl(a.denorm_flag,'N') = 'Y'
272: and a.attribute_id = b.attribute_id
273: and nvl( b.active_flag, 'Y') = 'Y'

Line 310: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b

306:
307: FOR col_cur in
308: (
309: SELECT b.staged_attribute_column as attrib_column
310: from HZ_TRANS_ATTRIBUTES_VL a, hz_trans_functions_vl b
311: where a.entity_name = 'CONTACT_POINTS'
312: and nvl(a.denorm_flag,'N') = 'Y'
313: and a.attribute_id = b.attribute_id
314: and nvl( b.active_flag, 'Y') = 'Y'

Line 347: SELECT 1 from hz_trans_functions_vl f

343: SELECT count(1) into l_count
344: from hz_trans_attributes_vl a
345: where a.entity_name = p_entity
346: and exists (
347: SELECT 1 from hz_trans_functions_vl f
348: where a.attribute_id = f.attribute_id
349: and nvl(f.ACTIVE_FLAG,'Y') = 'Y'
350: and primary_flag = 'Y'
351: AND NVL(STAGED_FLAG,'N') ='N');

Line 470: SELECT 1 FROM hz_trans_functions_vl f

466: AND (upper(prv_value) like '%'||p_stg_col||' %'
467: OR upper(prv_value) like '%'||p_stg_col||'||%');
468:
469: CURSOR check_any_tx(p_ATTRIBUTE_ID NUMBER) IS
470: SELECT 1 FROM hz_trans_functions_vl f
471: where f.attribute_id = p_attribute_id
472: and nvl(f.ACTIVE_FLAG,'Y') = 'Y'
473: and primary_flag = 'Y'
474: AND NVL(STAGED_FLAG,'N') ='Y';

Line 503: FROM HZ_TRANS_FUNCTIONS_VL f

499: prefattrs := '';
500: FUNCSF:=FALSE;
501: FOR FUNCS IN (
502: SELECT STAGED_ATTRIBUTE_COLUMN
503: FROM HZ_TRANS_FUNCTIONS_VL f
504: WHERE ATTRIBUTE_ID = ATTRS.ATTRIBUTE_ID
505: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
506: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y') LOOP
507:

Line 580: FROM HZ_TRANS_FUNCTIONS_VL f

576: prefattrs := '';
577: FUNCSF:=FALSE;
578: FOR FUNCS IN (
579: SELECT STAGED_ATTRIBUTE_COLUMN
580: FROM HZ_TRANS_FUNCTIONS_VL f
581: WHERE ATTRIBUTE_ID = ATTRS.ATTRIBUTE_ID
582: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
583: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y') LOOP
584:

Line 710: SELECT 1 from hz_trans_functions_vl f

706: SELECT ATTRIBUTE_ID
707: from hz_trans_attributes_vl a
708: where a.entity_name = p_entity
709: and exists (
710: SELECT 1 from hz_trans_functions_vl f
711: where a.attribute_id = f.attribute_id
712: and nvl(f.ACTIVE_FLAG,'Y') = 'Y'
713: and primary_flag = 'Y'
714: AND NVL(STAGED_FLAG,'N') ='N')

Line 785: AND EXISTS (SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL f

781: CURSOR c_num_attrs(cp_entity VARCHAR2) IS
782: SELECT COUNT(1)
783: FROM HZ_TRANS_ATTRIBUTES_VL a
784: WHERE ENTITY_NAME = cp_entity
785: AND EXISTS (SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL f
786: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
787: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
788: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y');
789:

Line 794: AND EXISTS (SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL f

790: CURSOR c_attrs(cp_entity VARCHAR2) IS
791: SELECT 'A'||ATTRIBUTE_ID
792: FROM HZ_TRANS_ATTRIBUTES_VL a
793: WHERE ENTITY_NAME = cp_entity
794: AND EXISTS (SELECT 1 FROM HZ_TRANS_FUNCTIONS_VL f
795: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
796: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
797: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y');
798:

Line 1059: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f

1055: BEGIN
1056: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
1057: FOR IDX in (
1058: SELECT OWNER||'.'||INDEX_NAME idx_name
1059: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
1060: WHERE f.attribute_id = a.attribute_id
1061: AND i.owner = l_owner1
1062: AND f.index_required_flag in ('Y','T')
1063: AND i.INDEX_NAME = decode(a.entity_name,'PARTY','HZ_STAGED_PARTIES',

Line 1152: SELECT 1 from hz_trans_functions_vl f

1148: SELECT count(1)
1149: from hz_trans_attributes_vl a
1150: where a.entity_name = p_entity
1151: and exists (
1152: SELECT 1 from hz_trans_functions_vl f
1153: where a.attribute_id = f.attribute_id
1154: and nvl(f.ACTIVE_FLAG,'Y') = 'Y'
1155: and primary_flag = 'Y'
1156: AND NVL(STAGED_FLAG,'N') ='N');

Line 1289: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

1285: message VARCHAR2(32000);
1286:
1287: CURSOR c_primary(cp_entity_name VARCHAR2) IS
1288: SELECT f.TRANSFORMATION_NAME, f.STAGED_ATTRIBUTE_COLUMN
1289: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
1290: WHERE PRIMARY_FLAG = 'Y'
1291: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
1292: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
1293: AND a.ENTITY_NAME = cp_entity_name;

Line 1295: l_trans_name HZ_TRANS_FUNCTIONS_VL.TRANSFORMATION_NAME%TYPE;

1291: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
1292: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
1293: AND a.ENTITY_NAME = cp_entity_name;
1294:
1295: l_trans_name HZ_TRANS_FUNCTIONS_VL.TRANSFORMATION_NAME%TYPE;
1296: l_stg_attr HZ_TRANS_FUNCTIONS_VL.STAGED_ATTRIBUTE_COLUMN%TYPE;
1297:
1298: l_cols VARCHAR2(4000);
1299: l_message VARCHAR2(4000);

Line 1296: l_stg_attr HZ_TRANS_FUNCTIONS_VL.STAGED_ATTRIBUTE_COLUMN%TYPE;

1292: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
1293: AND a.ENTITY_NAME = cp_entity_name;
1294:
1295: l_trans_name HZ_TRANS_FUNCTIONS_VL.TRANSFORMATION_NAME%TYPE;
1296: l_stg_attr HZ_TRANS_FUNCTIONS_VL.STAGED_ATTRIBUTE_COLUMN%TYPE;
1297:
1298: l_cols VARCHAR2(4000);
1299: l_message VARCHAR2(4000);
1300: l_status VARCHAR2(255) := 'NORMAL';

Line 3007: from hz_trans_functions_vl t, hz_trans_attributes_b a

3003: FUNCTION new_primary_trans(p_entity VARCHAR2
3004: ) RETURN BOOLEAN IS
3005: cursor is_new_tran (p_entity VARCHAR2) is
3006: select 'Y'
3007: from hz_trans_functions_vl t, hz_trans_attributes_b a
3008: where a.attribute_id = t.attribute_id
3009: and ENTITY_NAME = p_entity
3010: and nvl(staged_flag, 'N') = 'N'
3011: and primary_flag = 'Y'

Line 3087: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

3083:
3084: CURSOR c_num_attrs (p_entity VARCHAR2) IS
3085: SELECT count(1) FROM
3086: (SELECT distinct f.staged_attribute_column
3087: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
3088: WHERE PRIMARY_FLAG = 'Y'
3089: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
3090: and f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3091: AND a.entity_name = p_entity

Line 4157: FROM HZ_TRANS_FUNCTIONS_VL

4153: WHERE ENTITY_NAME = p_entity)
4154:
4155: LOOP
4156: for FUNCS IN (SELECT PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN
4157: FROM HZ_TRANS_FUNCTIONS_VL
4158: WHERE ATTRIBUTE_ID = ATTRS.ATTRIBUTE_ID
4159: AND nvl(ACTIVE_FLAG,'Y') = 'Y'
4160: AND NVL(STAGED_FLAG,'N') <> 'Y')
4161: LOOP

Line 4205: FROM HZ_TRANS_FUNCTIONS_VL

4201: FROM HZ_TRANS_ATTRIBUTES_VL
4202: WHERE ENTITY_NAME = p_entity)
4203: LOOP
4204: for FUNCS IN (SELECT PROCEDURE_NAME, STAGED_ATTRIBUTE_COLUMN
4205: FROM HZ_TRANS_FUNCTIONS_VL
4206: WHERE ATTRIBUTE_ID = ATTRS.ATTRIBUTE_ID
4207: AND nvl(ACTIVE_FLAG,'Y') = 'Y')
4208: LOOP
4209: l(' l_stage_rec.'||FUNCS.STAGED_ATTRIBUTE_COLUMN || ' := ');

Line 4535: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

4531: pref_cols VARCHAR2(1000);
4532: proc_cols VARCHAR2(2000);
4533: fetch_cols VARCHAR2(2000);
4534: CURSOR l_ent_cur(l_ent_name VARCHAR2) IS (SELECT STAGED_ATTRIBUTE_COLUMN
4535: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
4536: WHERE ENTITY_NAME = l_ent_name
4537: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
4538: AND nvl(f.PRIMARY_FLAG,'Y') = 'Y'
4539: AND nvl(a.DENORM_FLAG,'N') = 'Y'

Line 4867: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

4863: a.CUSTOM_ATTRIBUTE_PROCEDURE,
4864: f.PROCEDURE_NAME,
4865: f.STAGED_ATTRIBUTE_COLUMN,
4866: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
4867: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
4868: WHERE ENTITY_NAME = 'PARTY'
4869: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
4870: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
4871: ORDER BY COLNUM) LOOP

Line 4889: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

4885: END IF;
4886: l_mincol_list(ATTRS.COLNUM) := 'N';
4887:
4888: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
4889: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
4890: WHERE ENTITY_NAME = 'PARTY'
4891: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
4892: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
4893: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 5093: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

5089: a.CUSTOM_ATTRIBUTE_PROCEDURE,
5090: f.PROCEDURE_NAME,
5091: f.STAGED_ATTRIBUTE_COLUMN,
5092: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
5093: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
5094: WHERE ENTITY_NAME = 'PARTY'
5095: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5096: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5097: ORDER BY COLNUM) LOOP

Line 5115: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

5111: END IF;
5112: l_mincol_list(ATTRS.COLNUM) := 'N';
5113:
5114: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
5115: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
5116: WHERE ENTITY_NAME = 'PARTY'
5117: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5118: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5119: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 5571: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

5567: f.PROCEDURE_NAME,
5568: f.STAGED_ATTRIBUTE_COLUMN,
5569: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
5570: nvl(TAG,'C') column_data_type --Bug No: 4279469
5571: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
5572: WHERE ENTITY_NAME = 'PARTY'
5573: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5574: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5575: AND lkp.LOOKUP_TYPE = 'PARTY_LOGICAL_ATTRIBUTE_LIST' --Bug No: 4279469

Line 5595: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

5591: END IF;
5592: l_mincol_list(ATTRS.COLNUM) := 'N';
5593:
5594: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
5595: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
5596: WHERE ENTITY_NAME = 'PARTY'
5597: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5598: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5599: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 6391: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6387: a.CUSTOM_ATTRIBUTE_PROCEDURE,
6388: f.PROCEDURE_NAME,
6389: f.STAGED_ATTRIBUTE_COLUMN,
6390: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
6391: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6392: WHERE ENTITY_NAME = 'PARTY_SITES'
6393: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6394: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6395: ORDER BY COLNUM) LOOP

Line 6411: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6407: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''PARTY_SITES'')';
6408: END IF;
6409:
6410: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
6411: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6412: WHERE ENTITY_NAME = 'PARTY_SITES'
6413: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6414: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6415: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 6546: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6542: a.CUSTOM_ATTRIBUTE_PROCEDURE,
6543: f.PROCEDURE_NAME,
6544: f.STAGED_ATTRIBUTE_COLUMN,
6545: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
6546: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6547: WHERE ENTITY_NAME = 'PARTY_SITES'
6548: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6549: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6550: ORDER BY COLNUM) LOOP

Line 6566: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6562: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''PARTY_SITES'')';
6563: END IF;
6564:
6565: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
6566: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6567: WHERE ENTITY_NAME = 'PARTY_SITES'
6568: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6569: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6570: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 6976: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

6972: f.PROCEDURE_NAME,
6973: f.STAGED_ATTRIBUTE_COLUMN,
6974: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
6975: nvl(lkp.tag,'C') column_data_type
6976: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
6977: WHERE ENTITY_NAME = 'PARTY_SITES'
6978: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6979: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6980: AND lkp.lookup_type = 'PARTY_SITE_LOGICAL_ATTRIB_LIST'

Line 6998: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

6994: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''PARTY_SITES'')';
6995: END IF;
6996:
6997: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
6998: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
6999: WHERE ENTITY_NAME = 'PARTY_SITES'
7000: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7001: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7002: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 7165: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7161: a.CUSTOM_ATTRIBUTE_PROCEDURE,
7162: f.PROCEDURE_NAME,
7163: f.STAGED_ATTRIBUTE_COLUMN,
7164: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
7165: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7166: WHERE ENTITY_NAME = 'PARTY_SITES'
7167: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7168: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7169: AND nvl(a.DENORM_FLAG,'N') = 'Y') LOOP

Line 7647: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7643: a.CUSTOM_ATTRIBUTE_PROCEDURE,
7644: f.PROCEDURE_NAME,
7645: f.STAGED_ATTRIBUTE_COLUMN,
7646: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
7647: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7648: WHERE ENTITY_NAME = 'CONTACTS'
7649: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7650: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7651: ORDER BY COLNUM) LOOP

Line 7667: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7663: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACTS'')';
7664: END IF;
7665:
7666: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
7667: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7668: WHERE ENTITY_NAME = 'CONTACTS'
7669: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7670: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7671: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 7847: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7843: a.CUSTOM_ATTRIBUTE_PROCEDURE,
7844: f.PROCEDURE_NAME,
7845: f.STAGED_ATTRIBUTE_COLUMN,
7846: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
7847: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7848: WHERE ENTITY_NAME = 'CONTACTS'
7849: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7850: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7851: ORDER BY COLNUM) LOOP

Line 7867: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

7863: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACTS'')';
7864: END IF;
7865:
7866: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
7867: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
7868: WHERE ENTITY_NAME = 'CONTACTS'
7869: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
7870: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
7871: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 8280: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

8276: f.PROCEDURE_NAME,
8277: f.STAGED_ATTRIBUTE_COLUMN,
8278: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
8279: nvl(lkp.tag,'C') column_data_type
8280: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
8281: WHERE ENTITY_NAME = 'CONTACTS'
8282: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8283: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8284: AND lkp.LOOKUP_TYPE='CONTACT_LOGICAL_ATTRIB_LIST'

Line 8302: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8298: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACTS'')';
8299: END IF;
8300:
8301: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
8302: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8303: WHERE ENTITY_NAME = 'CONTACTS'
8304: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8305: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8306: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 8477: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8473: a.CUSTOM_ATTRIBUTE_PROCEDURE,
8474: f.PROCEDURE_NAME,
8475: f.STAGED_ATTRIBUTE_COLUMN,
8476: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
8477: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8478: WHERE ENTITY_NAME = 'CONTACTS'
8479: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8480: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8481: AND nvl(a.DENORM_FLAG,'N') = 'Y') LOOP

Line 8942: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8938: a.CUSTOM_ATTRIBUTE_PROCEDURE,
8939: f.PROCEDURE_NAME,
8940: f.STAGED_ATTRIBUTE_COLUMN,
8941: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
8942: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8943: WHERE ENTITY_NAME = 'CONTACT_POINTS'
8944: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8945: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8946: ORDER BY COLNUM) LOOP

Line 8961: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

8957: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACT_POINTS'')';
8958: END IF;
8959:
8960: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
8961: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
8962: WHERE ENTITY_NAME = 'CONTACT_POINTS'
8963: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8964: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8965: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 9111: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

9107: a.CUSTOM_ATTRIBUTE_PROCEDURE,
9108: f.PROCEDURE_NAME,
9109: f.STAGED_ATTRIBUTE_COLUMN,
9110: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
9111: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
9112: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9113: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9114: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9115: ORDER BY COLNUM) LOOP

Line 9130: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

9126: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACT_POINTS'')';
9127: END IF;
9128:
9129: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
9130: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
9131: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9132: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9133: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9134: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 9559: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

9555: f.PROCEDURE_NAME,
9556: f.STAGED_ATTRIBUTE_COLUMN,
9557: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
9558: nvl(lkp.tag,'C') column_data_type
9559: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
9560: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9561: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9562: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9563: -- REPURI. Added the 2 lines here for bug 4957189, which were missed in bug 4279469 fix.

Line 9581: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

9577: l_forall_list(ATTRS.COLNUM) := ATTRS.PROCEDURE_NAME || '(H_TX'||ATTRS.COLNUM||'(I),NULL, ''' || ATTRS.ATTRIBUTE_NAME || ''',''CONTACT_POINTS'')';
9578: END IF;
9579:
9580: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
9581: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
9582: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9583: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9584: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9585: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME;

Line 9754: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

9750: a.CUSTOM_ATTRIBUTE_PROCEDURE,
9751: f.PROCEDURE_NAME,
9752: f.STAGED_ATTRIBUTE_COLUMN,
9753: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
9754: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
9755: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9756: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9757: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9758: AND nvl(a.DENORM_FLAG,'N') = 'Y') LOOP

Line 10261: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10257: a.CUSTOM_ATTRIBUTE_PROCEDURE,
10258: f.PROCEDURE_NAME,
10259: f.STAGED_ATTRIBUTE_COLUMN,
10260: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
10261: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10262: WHERE ENTITY_NAME = 'PARTY'
10263: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10264: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10265: AND f.STAGED_FLAG='N'

Line 10302: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10298: l_oth_select(idx) := 'p.'||ATTRS.ATTRIBUTE_NAME;
10299: END IF;
10300: ELSE
10301: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
10302: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10303: WHERE ENTITY_NAME = 'PARTY'
10304: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10305: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10306: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 10523: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10519: a.CUSTOM_ATTRIBUTE_PROCEDURE,
10520: f.PROCEDURE_NAME,
10521: f.STAGED_ATTRIBUTE_COLUMN,
10522: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
10523: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10524: WHERE ENTITY_NAME = 'CONTACTS'
10525: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10526: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10527: AND f.staged_flag='N'

Line 10553: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10549: l_select(idx) := 'r.'||ATTRS.ATTRIBUTE_NAME;
10550: END IF;
10551: ELSE
10552: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
10553: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10554: WHERE ENTITY_NAME = 'CONTACTS'
10555: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10556: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10557: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 10860: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10856: a.CUSTOM_ATTRIBUTE_PROCEDURE,
10857: f.PROCEDURE_NAME,
10858: f.STAGED_ATTRIBUTE_COLUMN,
10859: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
10860: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10861: WHERE ENTITY_NAME = 'PARTY_SITES'
10862: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10863: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10864: AND f.staged_flag='N'

Line 10888: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

10884: l_select(idx) := 'ps.'||ATTRS.ATTRIBUTE_NAME;
10885: END IF;
10886: ELSE
10887: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
10888: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
10889: WHERE ENTITY_NAME = 'PARTY_SITES'
10890: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
10891: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10892: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 11179: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

11175: a.CUSTOM_ATTRIBUTE_PROCEDURE,
11176: f.PROCEDURE_NAME,
11177: f.STAGED_ATTRIBUTE_COLUMN,
11178: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM
11179: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
11180: WHERE ENTITY_NAME = 'CONTACT_POINTS'
11181: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
11182: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
11183: AND f.STAGED_FLAG='N'

Line 11203: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f

11199: IF ATTRS.CUSTOM_ATTRIBUTE_PROCEDURE IS NULL THEN
11200: l_select(idx) := 'cp.'||ATTRS.ATTRIBUTE_NAME;
11201: ELSE
11202: SELECT min(to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3))) INTO l_min_colnum
11203: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f
11204: WHERE ENTITY_NAME = 'CONTACT_POINTS'
11205: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
11206: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
11207: AND a.ATTRIBUTE_NAME=ATTRS.ATTRIBUTE_NAME

Line 11477: FROM hz_trans_attributes_vl a, hz_trans_functions_vl f

11473: decode(a.entity_name,'PARTY','HZ_SRCH_PARTIES',
11474: 'PARTY_SITES','HZ_SRCH_PSITES','CONTACTS','HZ_SRCH_CONTACTS',
11475: 'CONTACT_POINTS','HZ_SRCH_CPTS') srch_table_name,
11476: f.staged_attribute_column column_name
11477: FROM hz_trans_attributes_vl a, hz_trans_functions_vl f
11478: WHERE f.attribute_id = a.attribute_id
11479: AND f.index_required_flag = 'Y'
11480: AND a.entity_name = p_entity;
11481:

Line 11609: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a

11605: c NUMBER;
11606: l_custom BOOLEAN;
11607: BEGIN
11608: FOR FUNCS IN (SELECT PROCEDURE_NAME, a.ENTITY_NAME, a.ATTRIBUTE_NAME, f.TRANSFORMATION_NAME
11609: FROM HZ_TRANS_FUNCTIONS_VL f, HZ_TRANS_ATTRIBUTES_VL a
11610: WHERE a.ATTRIBUTE_ID = f.ATTRIBUTE_ID
11611: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y' )
11612: LOOP
11613: BEGIN

Line 11637: AND EXISTS (select 1 from HZ_TRANS_FUNCTIONS_VL f

11633: FOR FUNCS IN (SELECT custom_attribute_procedure, ENTITY_NAME, ATTRIBUTE_NAME
11634: FROM HZ_TRANS_ATTRIBUTES_VL a
11635: WHERE source_table = 'CUSTOM' OR
11636: custom_attribute_procedure is NOT NULL
11637: AND EXISTS (select 1 from HZ_TRANS_FUNCTIONS_VL f
11638: WHERE f.attribute_id = a.attribute_id
11639: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'))
11640: LOOP
11641: BEGIN