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.PO_UDA_TEMPLATES_UTIL dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 75: FROM PO_UDA_AG_TEMPLATE_USAGES

71: l_cur_context20 VARCHAR2
72:
73: )IS
74: SELECT USAGE_ID, ASSOCIATION_ID, ATTRIBUTE_GROUP_SEQUENCE
75: FROM PO_UDA_AG_TEMPLATE_USAGES
76: WHERE TEMPLATE_ID = p_template_id
77: AND NVL(ATTRIBUTE_CATEGORY, '@@@') = l_cur_usage
78: AND NVL(ATTRIBUTE1, '@@@') = l_cur_context1
79: AND NVL(ATTRIBUTE2, '@@@') = l_cur_context2

Line 127: FROM PO_UDA_AG_TEMPLATE_USAGES

123: NVL(ATTRIBUTE14, '@@@'), NVL(ATTRIBUTE15, '@@@'),
124: NVL(ATTRIBUTE16, '@@@'), NVL(ATTRIBUTE17, '@@@'),
125: NVL(ATTRIBUTE18, '@@@'), NVL(ATTRIBUTE19, '@@@'),
126: NVL(ATTRIBUTE20, '@@@')
127: FROM PO_UDA_AG_TEMPLATE_USAGES
128: WHERE TEMPLATE_ID = p_template_id
129: GROUP BY ATTRIBUTE_CATEGORY, ATTRIBUTE1,
130: ATTRIBUTE2, ATTRIBUTE3,
131: ATTRIBUTE4, ATTRIBUTE5,

Line 678: FROM PO_UDA_AG_TEMPLATE_USAGES

674: p_template_id NUMBER
675: )
676: IS
677: SELECT DISTINCT ATTRIBUTE_GROUP_ID
678: FROM PO_UDA_AG_TEMPLATE_USAGES
679: WHERE TEMPLATE_ID = p_template_id;
680:
681: l_ERRBUF_ATTRGRP VARCHAR2(200);
682: l_RETCODE_ATTRGRP VARCHAR2(200);

Line 974: FROM PO_UDA_AG_TEMPLATE_USAGES

970: ELSE
971:
972: SELECT count(*)
973: INTO l_count
974: FROM PO_UDA_AG_TEMPLATE_USAGES
975: WHERE ATTRIBUTE_GROUP_ID = p_attribute_group_id;
976:
977: IF l_count = 0 THEN
978: x_return_status := 'F';

Line 3068: SELECT UNIQUE(association_id) FROM po_uda_ag_template_usages

3064: l_msg_data VARCHAR2(2000);
3065: l_msg_count NUMBER;
3066:
3067: CURSOR association_ids(p_template_id number) IS
3068: SELECT UNIQUE(association_id) FROM po_uda_ag_template_usages
3069: WHERE template_id = p_template_id;
3070:
3071: BEGIN
3072:

Line 3095: DELETE FROM PO_UDA_AG_TEMPLATE_USAGES

3091: x_msg_data => l_msg_data); -- OUT NOCOPY VARCHAR2
3092:
3093: IF (l_return_status = 'S') THEN
3094:
3095: DELETE FROM PO_UDA_AG_TEMPLATE_USAGES
3096: WHERE association_id = association_ids_rec.association_id;
3097:
3098: IF PO_LOG.d_stmt THEN
3099: PO_LOG.stmt(d_module, d_progress, 'Deleted association and usages for association_id:', association_ids_rec.association_id);

Line 3154: FROM po_uda_ag_template_usages

3150: d_progress NUMBER;
3151:
3152: CURSOR c_get_usage_id(p_template_id NUMBER , p_usage_name VARCHAR2 ) IS
3153: SELECT USAGE_ID,ATTRIBUTE_CATEGORY
3154: FROM po_uda_ag_template_usages
3155: WHERE template_id = p_template_id
3156: AND ATTRIBUTE_CATEGORY = p_usage_name ;
3157:
3158: BEGIN

Line 3176: DELETE FROM po_uda_ag_template_usages WHERE usage_id = c_get_usage_id_rec.usage_id;

3172: x_msg_count => x_msg_count,
3173: x_msg_data => x_msg_data
3174: );
3175:
3176: DELETE FROM po_uda_ag_template_usages WHERE usage_id = c_get_usage_id_rec.usage_id;
3177:
3178: END LOOP ;
3179:
3180: COMMIT ;

Line 3613: FROM po_uda_ag_template_usages u,

3609: AND et.DESCRIPTIVE_FLEXFIELD_NAME = pt.entity_code;
3610:
3611: CURSOR c_attr_group_ids(p_template_id NUMBER) IS
3612: SELECT distinct(attribute_group_id)
3613: FROM po_uda_ag_template_usages u,
3614: ego_fnd_dsc_flx_ctx_ext a
3615: WHERE u.template_id = p_template_id
3616: and u.attribute_group_id = a.attr_group_id
3617: and a.multi_row = 'N';

Line 3788: FROM po_uda_ag_template_usages u, po_uda_ag_templates b

3784: WHERE et.DESCRIPTIVE_FLEXFIELD_NAME = p_entity_code;
3785:
3786: CURSOR c_attr_group_ids(p_entity_code VARCHAR2) IS
3787: SELECT DISTINCT(u.attribute_group_id)
3788: FROM po_uda_ag_template_usages u, po_uda_ag_templates b
3789: WHERE b.entity_code = p_entity_code
3790: AND b.template_id = u.template_id;
3791:
3792: CURSOR l_uda_attr_col_name(p_attr_grp_id NUMBER, p_entity_code VARCHAR2) IS

Line 4213: SELECT f.FLEX_VALUE_SET_ID, fv.VALIDATION_TYPE FROM FND_DESCR_FLEX_COL_USAGE_VL f, PO_UDA_AG_TEMPLATE_USAGES t , fnd_flex_value_sets fv

4209: l_query LONG;
4210: l_validation_type VARCHAR2(2);
4211:
4212: CURSOR c_get_value_set_id(p_usage_id NUMBER, p_attr_col VARCHAR2) IS
4213: SELECT f.FLEX_VALUE_SET_ID, fv.VALIDATION_TYPE FROM FND_DESCR_FLEX_COL_USAGE_VL f, PO_UDA_AG_TEMPLATE_USAGES t , fnd_flex_value_sets fv
4214: WHERE DESCRIPTIVE_FLEXFIELD_NAME LIKE 'PO_UDA_TEMPLATE_USAGES'
4215: AND f.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.ATTRIBUTE_CATEGORY
4216: AND t. usage_id = p_usage_id AND f.APPLICATION_COLUMN_NAME = p_attr_col
4217: AND f.FLEX_VALUE_SET_ID = fv.FLEX_VALUE_SET_ID;

Line 4343: SELECT f.FLEX_VALUE_SET_ID, fv.VALIDATION_TYPE FROM FND_DESCR_FLEX_COL_USAGE_VL f, PO_UDA_AG_TEMPLATE_USAGES t , fnd_flex_value_sets fv

4339: l_validation_type VARCHAR2(2);
4340: l_attr_meaning VARCHAR2(100);
4341:
4342: CURSOR c_get_value_set_id(p_usage_id NUMBER, p_attr_col VARCHAR2) IS
4343: SELECT f.FLEX_VALUE_SET_ID, fv.VALIDATION_TYPE FROM FND_DESCR_FLEX_COL_USAGE_VL f, PO_UDA_AG_TEMPLATE_USAGES t , fnd_flex_value_sets fv
4344: WHERE DESCRIPTIVE_FLEXFIELD_NAME LIKE 'PO_UDA_TEMPLATE_USAGES'
4345: AND f.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.ATTRIBUTE_CATEGORY
4346: AND t. usage_id = p_usage_id AND f.APPLICATION_COLUMN_NAME = p_attr_col
4347: AND f.FLEX_VALUE_SET_ID = fv.FLEX_VALUE_SET_ID;

Line 4677: FROM po_uda_ag_template_usages ptu, uda_setup_metadata_v umv

4673: l_errorcode VARCHAR2(30);
4674:
4675: CURSOR c_get_association_id(p_usage_id NUMBER) IS
4676: SELECT ptu.association_id, ptu.attribute_group_id, ptu.template_id, umv.object_id
4677: FROM po_uda_ag_template_usages ptu, uda_setup_metadata_v umv
4678: WHERE ptu.usage_id = p_usage_id
4679: AND ptu.template_id = umv.template_id;
4680:
4681: CURSOR c_get_action_id(p_object_id NUMBER, p_template_id NUMBER, p_attribute_group_id NUMBER) IS

Line 4710: FROM po_uda_ag_template_usages

4706: -- Check if any other usage shares the same attr group information.If so , association and actions are not deleted.
4707:
4708: SELECT Count(USAGE_ID)
4709: INTO l_usage_ag_count
4710: FROM po_uda_ag_template_usages
4711: WHERE attribute_group_id = l_attribute_group_id
4712: AND template_id = l_template_id ;
4713:
4714: IF (l_usage_ag_count = 1 )THEN --no other usage exists with same attribute group .

Line 4847: FROM po_uda_ag_template_usages

4843: SELECT USAGE_ID, ATTRIBUTE_GROUP_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4,
4844: ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
4845: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20,
4846: ATTRIBUTE_GROUP_SEQUENCE
4847: FROM po_uda_ag_template_usages
4848: WHERE template_id = p_src_template_id;
4849:
4850: CURSOR c_get_temp_details(p_src_template_id NUMBER) IS
4851: SELECT object_id, DATA_LEVEL_NAME

Line 4860: SELECT PO_UDA_AG_TEMPLATE_USAGES_S.NEXTVAL

4856: SELECT EGO_ASSOCS_S.NEXTVAL
4857: FROM dual;
4858:
4859: CURSOR c_genusage_seq IS
4860: SELECT PO_UDA_AG_TEMPLATE_USAGES_S.NEXTVAL
4861: FROM dual;
4862:
4863: BEGIN
4864: IF (PO_LOG.d_proc) THEN

Line 4929: INSERT INTO po_uda_ag_template_usages (TEMPLATE_ID,

4925: OPEN c_genusage_seq;
4926: FETCH c_genusage_seq INTO l_usage_id;
4927: CLOSE c_genusage_seq;
4928:
4929: INSERT INTO po_uda_ag_template_usages (TEMPLATE_ID,
4930: ATTRIBUTE_GROUP_ID ,
4931: ATTRIBUTE_CATEGORY,
4932: ATTRIBUTE1,
4933: ATTRIBUTE2,

Line 5049: FROM po_uda_ag_template_usages

5045: SELECT USAGE_ID, ATTRIBUTE_GROUP_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4,
5046: ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
5047: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20,
5048: ATTRIBUTE_GROUP_SEQUENCE
5049: FROM po_uda_ag_template_usages
5050: WHERE template_id = p_src_template_id
5051: AND ATTRIBUTE_CATEGORY = p_usage_name ;
5052:
5053: CURSOR c_get_temp_details(p_src_template_id NUMBER) IS

Line 5063: SELECT PO_UDA_AG_TEMPLATE_USAGES_S.NEXTVAL

5059: SELECT EGO_ASSOCS_S.NEXTVAL
5060: FROM dual;
5061:
5062: CURSOR c_genusage_seq IS
5063: SELECT PO_UDA_AG_TEMPLATE_USAGES_S.NEXTVAL
5064: FROM dual;
5065:
5066:
5067: BEGIN

Line 5084: FROM po_uda_ag_template_usages

5080:
5081: BEGIN
5082: SELECT Max(ATTRIBUTE_GROUP_SEQUENCE)
5083: INTO l_max_attr_grp_seq_num
5084: FROM po_uda_ag_template_usages
5085: WHERE template_id = p_dest_template_id
5086: AND ATTRIBUTE_CATEGORY = p_usage_name ;
5087: EXCEPTION
5088: WHEN No_Data_Found THEN

Line 5162: INSERT INTO po_uda_ag_template_usages (TEMPLATE_ID,

5158: l_max_attr_grp_seq_num := c_get_usage_id_rec. ATTRIBUTE_GROUP_SEQUENCE;
5159:
5160: END IF ;
5161:
5162: INSERT INTO po_uda_ag_template_usages (TEMPLATE_ID,
5163: ATTRIBUTE_GROUP_ID ,
5164: ATTRIBUTE_CATEGORY,
5165: ATTRIBUTE1,
5166: ATTRIBUTE2,

Line 5382: SELECT 'N' FROM po_uda_ag_template_usages

5378: l_uctxag_yn VARCHAR2(1) := 'Y';
5379: l_uctxseq_yn VARCHAR2(1) := 'Y';
5380:
5381: CURSOR c_get_usage_ctx_ag_unique(p_template_id NUMBER, p_attribute_category VARCHAR2, p_attribute_group_id NUMBER, p_concatenated_segments VARCHAR2) IS
5382: SELECT 'N' FROM po_uda_ag_template_usages
5383: WHERE template_id = p_template_id
5384: AND attribute_category = p_attribute_category
5385: AND attribute_group_id = p_attribute_group_id
5386: AND attribute1||'.'|| attribute2||'.'||attribute3||'.'|| attribute4||'.'||attribute5||'.'|| attribute6||'.'||attribute7||'.'|| attribute8||

Line 5392: SELECT 'N' FROM po_uda_ag_template_usages

5388: '.'||attribute17||'.'|| attribute18||'.'||attribute19 ||'.'||attribute20 ||'.'= p_concatenated_segments;
5389:
5390:
5391: CURSOR c_get_usage_ctx_seq_unique(p_template_id NUMBER, p_attribute_category VARCHAR2, p_sequence NUMBER, p_concatenated_segments VARCHAR2) IS
5392: SELECT 'N' FROM po_uda_ag_template_usages
5393: WHERE template_id = p_template_id
5394: AND attribute_category = p_attribute_category
5395: AND attribute_group_sequence = p_sequence
5396: AND attribute1||'.'|| attribute2||'.'||attribute3||'.'|| attribute4||'.'||attribute5||'.'|| attribute6||'.'||attribute7||'.'|| attribute8||

Line 5470: PO_UDA_AG_TEMPLATE_USAGES

5466: get_flex_segment_meaning(1.0,usage_id,'ATTRIBUTE18',attribute18) ||'.'||
5467: get_flex_segment_meaning(1.0,usage_id,'ATTRIBUTE19',attribute19) ||'.'||
5468: get_flex_segment_meaning(1.0,usage_id,'ATTRIBUTE20',attribute20) ||'.','.') AS CONTEXT
5469: FROM
5470: PO_UDA_AG_TEMPLATE_USAGES
5471: WHERE TEMPLATE_ID= p_template_id
5472: AND attribute_category = p_attribute_category)
5473: GROUP BY attribute_category,context;
5474:

Line 5499: PO_UDA_AG_TEMPLATE_USAGES

5495: get_flex_segment_meaning(1.0,usage_id,'ATTRIBUTE18',attribute18) ||'.'||
5496: get_flex_segment_meaning(1.0,usage_id,'ATTRIBUTE19',attribute19) ||'.'||
5497: get_flex_segment_meaning(1.0,usage_id,'ATTRIBUTE20',attribute20) ||'.','.') AS CONTEXT
5498: FROM
5499: PO_UDA_AG_TEMPLATE_USAGES
5500: WHERE TEMPLATE_ID= p_template_id )
5501: GROUP BY attribute_category,attribute_group_sequence,context ;
5502:
5503:

Line 5528: PO_UDA_AG_TEMPLATE_USAGES

5524: get_flex_segment_meaning(1.0,usage_id,'ATTRIBUTE18',attribute18) ||'.'||
5525: get_flex_segment_meaning(1.0,usage_id,'ATTRIBUTE19',attribute19) ||'.'||
5526: get_flex_segment_meaning(1.0,usage_id,'ATTRIBUTE20',attribute20) ||'.','.') AS CONTEXT
5527: FROM
5528: PO_UDA_AG_TEMPLATE_USAGES
5529: WHERE TEMPLATE_ID= p_template_id
5530: AND attribute_category NOT IN (p_attribute_category1,p_attribute_category2,p_attribute_category3))
5531: GROUP BY attribute_category,attribute_group_id,context ;
5532:

Line 5545: FROM po_uda_ag_template_usages

5541: fnd_msg_pub.Initialize;
5542:
5543: SELECT Count(*)
5544: INTO l_count
5545: FROM po_uda_ag_template_usages
5546: WHERE ATTRIBUTE_CATEGORY = 'ADDRESS'
5547: AND template_id = p_template_id;
5548:
5549: IF(l_count > 1) THEN