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_EDA_DATATEMPLATE_PKG dependencies on PO_EDA_UDA_ATTR_VALUES

Line 432: DELETE po_eda_uda_attr_values WHERE pk1_value = DOCUMENTID AND lvl = 'AWARDHEADER' AND pk2_value = DRAFTID;

428: L_SQL2 VARCHAR2(32767);
429: l_value VARCHAR2(4000);
430:
431: BEGIN
432: DELETE po_eda_uda_attr_values WHERE pk1_value = DOCUMENTID AND lvl = 'AWARDHEADER' AND pk2_value = DRAFTID;
433: FOR REC IN C_ATTR_GRP LOOP
434: FOR R IN C_ATTR_MD(REC.ATTR_GROUP, REC.DESC_FLEXFLD_NAME) LOOP
435: l_sql2 := 'select '||R.APPLICATION_COLUMN_NAME || ' from po_headers_all_ext_vl where po_header_id = ' || DOCUMENTID ||
436: ' AND draft_id = ' || DRAFTID || ' AND pk1_value IS NULL and attr_group_id = ' || REC.ATTR_GROUP_ID;

Line 442: INSERT INTO po_eda_uda_attr_values(pk1_value,pk2_value,lvl,attr, attrval) VALUES (DOCUMENTID, DRAFTID,'AWARDHEADER',REC.ATTR_GROUP||'_'||R.END_USER_COLUMN_NAME,l_value);

438: EXECUTE IMMEDIATE l_sql2 INTO l_value;
439: EXCEPTION WHEN OTHERS THEN
440: CONTINUE;
441: END;
442: INSERT INTO po_eda_uda_attr_values(pk1_value,pk2_value,lvl,attr, attrval) VALUES (DOCUMENTID, DRAFTID,'AWARDHEADER',REC.ATTR_GROUP||'_'||R.END_USER_COLUMN_NAME,l_value);
443: END LOOP;
444: END LOOP;
445:
446: RETURN true;

Line 505: DELETE FROM po_eda_uda_attr_values WHERE pk1_value = c.po_line_id AND lvl='AWARDLINE' AND pk2_value = DRAFTID;

501: l_uda_xml XMLTYPE;
502: BEGIN
503:
504: FOR c IN c_line LOOP
505: DELETE FROM po_eda_uda_attr_values WHERE pk1_value = c.po_line_id AND lvl='AWARDLINE' AND pk2_value = DRAFTID;
506: FOR REC IN C_ATTR_GRP(c.po_line_id,p_draft_id) LOOP
507: FOR R IN C_ATTR_MD(REC.ATTR_GROUP, REC.DESC_FLEXFLD_NAME) LOOP
508:
509: l_sql2 := 'select '||R.APPLICATION_COLUMN_NAME || ' from po_lines_all_ext_vl where po_line_id = ' || c.po_line_id ||

Line 514: INSERT INTO po_eda_uda_attr_values(pk1_value,pk2_value,lvl,attr, attrval) VALUES (c.po_line_id,

510: ' AND draft_id = ' || DRAFTID || ' AND pk1_value IS NULL and attr_group_id = ' || REC.ATTR_GROUP_ID;
511: EXECUTE IMMEDIATE l_sql2 INTO l_value;
512:
513:
514: INSERT INTO po_eda_uda_attr_values(pk1_value,pk2_value,lvl,attr, attrval) VALUES (c.po_line_id,
515: DRAFTID,'AWARDLINE',REC.ATTR_GROUP||'_'||R.END_USER_COLUMN_NAME,l_value);
516:
517: END LOOP;
518: END LOOP;

Line 584: DELETE po_eda_uda_attr_values WHERE pk1_value = c.LINE_LOCATION_ID AND lvl = 'AWARDLINELOC' AND pk2_value = DRAFTID;

580:
581: BEGIN
582:
583: FOR c IN c_line_loc LOOP
584: DELETE po_eda_uda_attr_values WHERE pk1_value = c.LINE_LOCATION_ID AND lvl = 'AWARDLINELOC' AND pk2_value = DRAFTID;
585: FOR REC IN C_ATTR_GRP(c.LINE_LOCATION_ID,p_draft_id) LOOP
586: FOR R IN C_ATTR_MD(REC.ATTR_GROUP, REC.DESC_FLEXFLD_NAME) LOOP
587:
588: l_sql2 := 'select '||R.APPLICATION_COLUMN_NAME || ' from po_line_locations_all_ext_vl where line_location_id = ' ||

Line 592: INSERT INTO po_eda_uda_attr_values(pk1_value,pk2_value,lvl,attr, attrval) VALUES (c.LINE_LOCATION_ID,DRAFTID

588: l_sql2 := 'select '||R.APPLICATION_COLUMN_NAME || ' from po_line_locations_all_ext_vl where line_location_id = ' ||
589: c.LINE_LOCATION_ID || ' AND draft_id = ' || DRAFTID ||
590: ' AND pk1_value IS NULL and attr_group_id = ' || REC.ATTR_GROUP_ID;
591: EXECUTE IMMEDIATE l_sql2 INTO l_value;
592: INSERT INTO po_eda_uda_attr_values(pk1_value,pk2_value,lvl,attr, attrval) VALUES (c.LINE_LOCATION_ID,DRAFTID
593: ,'AWARDLINELOC',REC.ATTR_GROUP||'_'||R.END_USER_COLUMN_NAME,l_value);
594:
595: END LOOP;
596: END LOOP;

Line 2762: FROM po_eda_uda_attr_values a WHERE

2758: DRAFT_ID = DRAFTID;
2759:
2760: SELECT A.ATTRVAL
2761: INTO v_mod_authority
2762: FROM po_eda_uda_attr_values a WHERE
2763: a.PK1_VALUE = DOCUMENTID AND
2764: a.PK2_VALUE = DRAFTID AND
2765: a.LVL = 'AWARDHEADER' AND
2766: a.attr = 'mod_Just_mod_auth';

Line 2813: FROM po_eda_uda_attr_values

2809:
2810: BEGIN
2811: SELECT attrval
2812: INTO v_duns
2813: FROM po_eda_uda_attr_values
2814: WHERE attr = 'SUPPLIER_DTLS_DUNS_NUM'
2815: AND PK1_VALUE = DOCUMENTID AND PK2_VALUE = DRAFTID
2816: AND attrval <> (SELECT attrval
2817: FROM po_eda_uda_attr_values

Line 2817: FROM po_eda_uda_attr_values

2813: FROM po_eda_uda_attr_values
2814: WHERE attr = 'SUPPLIER_DTLS_DUNS_NUM'
2815: AND PK1_VALUE = DOCUMENTID AND PK2_VALUE = DRAFTID
2816: AND attrval <> (SELECT attrval
2817: FROM po_eda_uda_attr_values
2818: WHERE attr = 'SUPPLIER_DTLS_DUNS_NUM' AND
2819: PK1_VALUE = DOCUMENTID AND PK2_VALUE = -1);
2820: EXCEPTION
2821: WHEN OTHERS THEN

Line 3071: FROM po_eda_uda_attr_values WHERE

3067: BEGIN
3068:
3069: SELECT attrval
3070: INTO l_mod_serial_num
3071: FROM po_eda_uda_attr_values WHERE
3072: PK1_VALUE = p_header_id
3073: AND PK2_value = p_draft_id
3074: AND LVL = 'AWARDHEADER'
3075: AND attr LIKE 'DOD_ORD_MOD_SERIAL_NUMBER';

Line 3079: FROM po_eda_uda_attr_values WHERE

3075: AND attr LIKE 'DOD_ORD_MOD_SERIAL_NUMBER';
3076:
3077: SELECT attrval
3078: INTO l_mod_type
3079: FROM po_eda_uda_attr_values WHERE
3080: PK1_VALUE = p_header_id
3081: AND PK2_value = p_draft_id
3082: AND LVL = 'AWARDHEADER'
3083: AND attr LIKE 'DOD_ORD_MOD_MODIF_TYPE';

Line 3121: FROM po_eda_uda_attr_values WHERE

3117: BEGIN
3118:
3119: SELECT attrval
3120: INTO l_mod_serial_num
3121: FROM po_eda_uda_attr_values WHERE
3122: PK1_VALUE = p_header_id
3123: AND PK2_value = p_draft_id
3124: AND LVL = 'AWARDHEADER'
3125: AND attr LIKE 'DOD_AWD_MOD_SERIAL_NUMBER';

Line 3129: FROM po_eda_uda_attr_values WHERE

3125: AND attr LIKE 'DOD_AWD_MOD_SERIAL_NUMBER';
3126:
3127: SELECT attrval
3128: INTO l_mod_type
3129: FROM po_eda_uda_attr_values WHERE
3130: PK1_VALUE = p_header_id
3131: AND PK2_value = p_draft_id
3132: AND LVL = 'AWARDHEADER'
3133: AND attr LIKE 'DOD_AWD_MOD_MODIF_TYPE';