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_IMPORT_PKG dependencies on EGO_DATA_LEVEL_B

Line 836: FROM EGO_DATA_LEVEL_B

832: BEGIN
833: d_progress := 330;
834: SELECT DATA_LEVEL_NAME
835: INTO l_data_level
836: FROM EGO_DATA_LEVEL_B
837: WHERE APPLICATION_ID = 201
838: AND ATTR_GROUP_TYPE = l_attr_group_type
839: AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE'
840: AND ATTR_GROUP_TYPE NOT LIKE '%DUMMY%';

Line 1245: FROM EGO_DATA_LEVEL_B

1241: BEGIN
1242: d_progress := 70;
1243: SELECT DATA_LEVEL_NAME, DATA_LEVEL_ID
1244: INTO l_data_level_name, l_data_level_id
1245: FROM EGO_DATA_LEVEL_B
1246: WHERE ATTR_GROUP_TYPE = l_attr_row_obj.ATTR_GROUP_TYPE
1247: AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE';
1248:
1249: d_progress := 80;

Line 2477: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE'));

2473: po_lines_all_ext_b
2474: WHERE draft_id = l_draft_id_tbl(i)
2475: AND attr_group_id = l_attr_group_id_tbl(i)
2476: AND po_line_id = l_po_lines_tbl(i)
2477: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE'));
2478:
2479: EXCEPTION
2480: WHEN No_Data_Found
2481: THEN NULL;

Line 2615: ,(SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE')

2611: (SELECT
2612: pl_new.extension_id
2613: ,pl_old.ATTR_GROUP_ID
2614: ,(pl_old.PO_LINE_ID * -1 )
2615: ,(SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE')
2616: ,l_draft_id_tbl(i) * -1
2617: ,pl_new.PK2_VALUE
2618: ,pl_new.PK3_VALUE
2619: ,pl_new.PK4_VALUE

Line 2724: AND pl_old.data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE')

2720: AND pl_old.ATTR_GROUP_ID = pl_new.ATTR_GROUP_ID
2721: AND pl_old.data_level_id = pl_new.data_level_id
2722: AND pl_old.ATTR_GROUP_ID = l_attr_group_id_tbl(i)
2723: AND pl_old.po_line_id = l_po_lines_tbl(i)
2724: AND pl_old.data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE')
2725: AND pl_new.draft_id = l_draft_id_tbl(i)
2726: AND pl_old.draft_id = -1);
2727:
2728: ELSE

Line 2845: ,(SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE')

2841: SELECT
2842: EGO_EXTFWK_S.NEXTVAL
2843: ,pl_old.ATTR_GROUP_ID
2844: ,(pl_old.PO_LINE_ID * -1 )
2845: ,(SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE')
2846: ,l_draft_id_tbl(i) * -1
2847: ,pl_new.PK2_VALUE
2848: ,pl_new.PK3_VALUE
2849: ,pl_new.PK4_VALUE

Line 2954: AND pl_old.data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE')

2950: AND pl_old.ATTR_GROUP_ID = pl_new.ATTR_GROUP_ID
2951: AND pl_old.data_level_id = pl_new.data_level_id
2952: AND pl_old.ATTR_GROUP_ID = l_attr_group_id_tbl(i)
2953: AND pl_old.po_line_id = l_po_lines_tbl(i)
2954: AND pl_old.data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE')
2955: AND pl_new.draft_id = l_draft_id_tbl(i)
2956: AND pl_old.draft_id = -1;
2957:
2958: --insert old archive record

Line 3072: ,(SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_OLD_ARCHIVE')

3068: SELECT
3069: EGO_EXTFWK_S.NEXTVAL
3070: ,pl_old.ATTR_GROUP_ID
3071: ,pl_old.PO_LINE_ID
3072: ,(SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_OLD_ARCHIVE')
3073: ,l_draft_id_tbl(i)
3074: ,pl_old.PK2_VALUE
3075: ,pl_old.PK3_VALUE
3076: ,pl_old.PK4_VALUE

Line 3181: AND pl_old.data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE')

3177: AND pl_old.ATTR_GROUP_ID = pl_new.ATTR_GROUP_ID
3178: AND pl_old.data_level_id = pl_new.data_level_id
3179: AND pl_old.ATTR_GROUP_ID = l_attr_group_id_tbl(i)
3180: AND pl_old.po_line_id = l_po_lines_tbl(i)
3181: AND pl_old.data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE')
3182: AND pl_new.draft_id = l_draft_id_tbl(i)
3183: AND pl_old.draft_id = -1;
3184:
3185: END IF;

Line 3215: (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE'),

3211:
3212: EXTENSION_ID,
3213: attr_group_id,
3214: po_line_id,
3215: (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE'),
3216: l_po_lines_tbl(i)*-1 ,
3217: USERENV('LANG'),
3218: l_language_code_tbl(j),
3219: SYSDATE,

Line 3230: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE'));

3226: FROM po_lines_all_ext_b
3227: WHERE ATTR_GROUP_ID = l_attr_group_id_tbl(i)
3228: AND PO_LINE_ID = -1* l_po_lines_tbl(i)
3229: AND draft_id = l_draft_id_tbl(i) * -1
3230: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE'));
3231:
3232: ELSE
3233:
3234: --insert into tl table

Line 3256: (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE'),

3252: SELECT
3253: EXTENSION_ID,
3254: attr_group_id,
3255: po_line_id,
3256: (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE'),
3257: l_po_lines_tbl(i)*-1 ,
3258: USERENV('LANG'),
3259: l_language_code_tbl(j),
3260: SYSDATE,

Line 3271: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE');

3267: FROM po_lines_all_ext_b
3268: WHERE ATTR_GROUP_ID = l_attr_group_id_tbl(i)
3269: AND PO_LINE_ID = -1* l_po_lines_tbl(i)
3270: AND draft_id = l_draft_id_tbl(i) * -1
3271: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE');
3272:
3273: --Insert old arcive record in tl table
3274: INSERT INTO po_lines_all_ext_tl
3275: (

Line 3296: (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_OLD_ARCHIVE'),

3292:
3293: EXTENSION_ID,
3294: attr_group_id,
3295: po_line_id,
3296: (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_OLD_ARCHIVE'),
3297: l_po_lines_tbl(i),
3298: USERENV('LANG'),
3299: l_language_code_tbl(j),
3300: SYSDATE,

Line 3311: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_OLD_ARCHIVE');

3307: FROM po_lines_all_ext_b
3308: WHERE ATTR_GROUP_ID = l_attr_group_id_tbl(i)
3309: AND PO_LINE_ID = l_po_lines_tbl(i)
3310: AND draft_id = -1
3311: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_OLD_ARCHIVE');
3312:
3313: IF (PO_LOG.d_stmt) THEN
3314: PO_LOG.stmt(d_module, d_position, 'Delta and old records inserted ');
3315: END IF;