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.EGO_AG_BULKLOAD_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 847: FROM EGO_FND_DSC_FLX_CTX_EXT efdfce

843: Nvl(program_id,G_PROGRAM_ID),
844: Nvl(program_update_date,SYSDATE)
845: FROM ego_attr_groups_interface eagi
846: WHERE EXISTS (SELECT 1
847: FROM EGO_FND_DSC_FLX_CTX_EXT efdfce
848: WHERE efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE = eagi.attr_group_name
849: AND efdfce.DESCRIPTIVE_FLEXFIELD_NAME = G_EGO_ITEMMGMT_GROUP
850: AND efdfce.APPLICATION_ID = G_EGO_APPLICATION_ID)
851: AND eagi.transaction_id IS NOT NULL

Line 863: FROM EGO_FND_DSC_FLX_CTX_EXT efdfce

859: last_updated_by = G_USER_ID,
860: last_update_date = SYSDATE,
861: last_update_login = G_LOGIN_ID
862: WHERE EXISTS (SELECT 1
863: FROM EGO_FND_DSC_FLX_CTX_EXT efdfce
864: WHERE efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE = eagi.attr_group_name
865: AND efdfce.DESCRIPTIVE_FLEXFIELD_NAME = G_EGO_ITEMMGMT_GROUP
866: AND efdfce.APPLICATION_ID = G_EGO_APPLICATION_ID)
867: AND eagi.transaction_id IS NOT NULL

Line 1159: FROM ego_fnd_dsc_flx_ctx_ext eagd

1155: Nvl(program_id,G_PROGRAM_ID),
1156: Nvl(program_update_date,SYSDATE)
1157: FROM ego_attr_groups_dl_interface eagdi
1158: WHERE EXISTS (SELECT 1
1159: FROM ego_fnd_dsc_flx_ctx_ext eagd
1160: WHERE eagd.attr_group_id = eagdi.attr_group_id
1161: AND eagd.variant = 'Y'
1162: /*Added for bug 9719196*/
1163: UNION ALL

Line 1186: FROM ego_fnd_dsc_flx_ctx_ext eagd

1182: last_updated_by = G_USER_ID,
1183: last_update_date = SYSDATE,
1184: last_update_login = G_LOGIN_ID
1185: WHERE EXISTS (SELECT 1
1186: FROM ego_fnd_dsc_flx_ctx_ext eagd
1187: WHERE eagd.attr_group_id = eagdi.attr_group_id
1188: AND eagd.variant = 'Y'
1189: /*Added for bug 9719196*/
1190: UNION ALL

Line 1259: FROM ego_fnd_dsc_flx_ctx_ext eagd

1255: Nvl(program_id,G_PROGRAM_ID),
1256: Nvl(program_update_date,SYSDATE)
1257: FROM ego_attr_groups_dl_interface eagdi
1258: WHERE EXISTS (SELECT 1
1259: FROM ego_fnd_dsc_flx_ctx_ext eagd
1260: WHERE eagd.attr_group_id = eagdi.attr_group_id
1261: AND Nvl(eagd.variant,'N') = 'N')
1262: AND eagdi.data_level_name NOT IN (G_DL_ITEM_LEVEL,G_DL_ITEM_REV_LEVEL,G_DL_ITEM_ORG,G_DL_ITEM_SUP,
1263: G_DL_ITEM_SUP_SITE,G_DL_ITEM_SUP_SITE_ORG)

Line 1275: FROM ego_fnd_dsc_flx_ctx_ext eagd

1271: last_updated_by = G_USER_ID,
1272: last_update_date = SYSDATE,
1273: last_update_login = G_LOGIN_ID
1274: WHERE EXISTS (SELECT 1
1275: FROM ego_fnd_dsc_flx_ctx_ext eagd
1276: WHERE eagd.attr_group_id = eagdi.attr_group_id
1277: AND Nvl(eagd.variant,'N') = 'N')
1278: AND eagdi.data_level_name NOT IN (G_DL_ITEM_LEVEL,G_DL_ITEM_REV_LEVEL,G_DL_ITEM_ORG,G_DL_ITEM_SUP,
1279: G_DL_ITEM_SUP_SITE,G_DL_ITEM_SUP_SITE_ORG)

Line 1337: FROM ego_fnd_dsc_flx_ctx_ext eagd

1333: Nvl(program_id,G_PROGRAM_ID),
1334: Nvl(program_update_date,SYSDATE)
1335: FROM ego_attr_groups_dl_interface eagdi
1336: WHERE EXISTS (SELECT 1
1337: FROM ego_fnd_dsc_flx_ctx_ext eagd
1338: WHERE eagd.attr_group_id = eagdi.attr_group_id
1339: AND Nvl(eagd.variant,'N') = 'N')
1340: AND ((eagdi.data_level_name IN (G_DL_ITEM_LEVEL,G_DL_ITEM_REV_LEVEL,G_DL_ITEM_ORG,G_DL_ITEM_SUP,
1341: G_DL_ITEM_SUP_SITE,G_DL_ITEM_SUP_SITE_ORG)

Line 1356: FROM ego_fnd_dsc_flx_ctx_ext eagd

1352: last_updated_by = G_USER_ID,
1353: last_update_date = SYSDATE,
1354: last_update_login = G_LOGIN_ID
1355: WHERE EXISTS (SELECT 1
1356: FROM ego_fnd_dsc_flx_ctx_ext eagd
1357: WHERE eagd.attr_group_id = eagdi.attr_group_id
1358: AND Nvl(eagd.variant,'N') = 'N')
1359: AND ((eagdi.data_level_name IN (G_DL_ITEM_LEVEL,G_DL_ITEM_REV_LEVEL,G_DL_ITEM_ORG,G_DL_ITEM_SUP,
1360: G_DL_ITEM_SUP_SITE,G_DL_ITEM_SUP_SITE_ORG)

Line 1587: FROM EGO_FND_DSC_FLX_CTX_EXT efdfce

1583: AND ((G_SET_PROCESS_ID IS NULL)
1584: OR (set_process_id = G_SET_PROCESS_ID))
1585: AND NOT EXISTS /*Modified the where clause for bug 9886739*/
1586: (SELECT 1
1587: FROM EGO_FND_DSC_FLX_CTX_EXT efdfce
1588: WHERE efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE = eagdl.attr_group_name
1589: AND efdfce.DESCRIPTIVE_FLEXFIELD_NAME = G_EGO_ITEMMGMT_GROUP
1590: AND efdfce.APPLICATION_ID = G_EGO_APPLICATION_ID
1591: AND efdfce.VARIANT = 'Y')

Line 1614: FROM EGO_FND_DSC_FLX_CTX_EXT efdfce

1610: AND ((G_SET_PROCESS_ID IS NULL)
1611: OR (set_process_id = G_SET_PROCESS_ID))
1612: AND NOT EXISTS /*Modified the where clause for bug 9886739*/
1613: (SELECT 1
1614: FROM EGO_FND_DSC_FLX_CTX_EXT efdfce
1615: WHERE efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE = eagdl.attr_group_name
1616: AND efdfce.DESCRIPTIVE_FLEXFIELD_NAME = G_EGO_ITEMMGMT_GROUP
1617: AND efdfce.APPLICATION_ID = G_EGO_APPLICATION_ID
1618: AND efdfce.VARIANT = 'Y')

Line 2293: FROM ego_fnd_dsc_flx_ctx_ext

2289:
2290: /*Sets the Attribute group id when the Internal Attribute group name is given*/
2291: UPDATE ego_attr_groups_interface eagi
2292: SET eagi.attr_group_id = (SELECT attr_group_id
2293: FROM ego_fnd_dsc_flx_ctx_ext
2294: WHERE application_id = g_ego_application_id
2295: AND descriptive_flexfield_name = eagi.attr_group_type
2296: AND descriptive_flex_context_code = eagi.attr_group_name),
2297: eagi.transaction_type = decode(transaction_type,G_OPR_SYNC,G_OPR_UPDATE,transaction_type),

Line 2361: FROM ego_fnd_dsc_flx_ctx_ext

2357:
2358: /*Sets the Attribute group id when the Internal Attribute group name is given*/
2359: UPDATE ego_attr_groups_dl_interface eagdi
2360: SET eagdi.attr_group_id = (SELECT attr_group_id
2361: FROM ego_fnd_dsc_flx_ctx_ext
2362: WHERE application_id = g_ego_application_id
2363: AND descriptive_flexfield_name = eagdi.attr_group_type
2364: AND descriptive_flex_context_code = eagdi.attr_group_name),
2365: last_updated_by = G_USER_ID,

Line 2548: FROM ego_fnd_dsc_flx_ctx_ext

2544:
2545: /*Sets the Attribute group id when the Internal Attribute group name is given*/
2546: UPDATE ego_attr_group_cols_intf eagci
2547: SET eagci.attr_group_id = (SELECT attr_group_id
2548: FROM ego_fnd_dsc_flx_ctx_ext
2549: WHERE application_id = g_ego_application_id
2550: AND descriptive_flexfield_name = eagci.attr_group_type
2551: AND descriptive_flex_context_code = eagci.attr_group_name),
2552: eagci.last_updated_by = G_USER_ID,

Line 2674: FROM ego_fnd_dsc_flx_ctx_ext

2670:
2671: /*Sets the Internal Attribute group name when the attribute group id is given*/
2672: UPDATE ego_attr_groups_interface eagi
2673: SET eagi.attr_group_name = (SELECT attr_group_name
2674: FROM ego_fnd_dsc_flx_ctx_ext
2675: WHERE application_id = g_ego_application_id
2676: AND descriptive_flexfield_name = eagi.attr_group_type
2677: AND attr_group_id = eagi.attr_group_id),
2678: last_updated_by = G_USER_ID,

Line 2736: FROM ego_fnd_dsc_flx_ctx_ext

2732:
2733: /*Sets the Internal Attribute group name when the attribute group id is given*/
2734: UPDATE ego_attr_groups_dl_interface eagdi
2735: SET eagdi.attr_group_name = (SELECT attr_group_name
2736: FROM ego_fnd_dsc_flx_ctx_ext
2737: WHERE application_id = g_ego_application_id
2738: AND descriptive_flexfield_name = eagdi.attr_group_type
2739: AND attr_group_id = eagdi.attr_group_id),
2740: last_updated_by = G_USER_ID,

Line 2875: FROM ego_fnd_dsc_flx_ctx_ext

2871:
2872: /*Sets the Internal Attribute group name when the Attribute group id is given*/
2873: UPDATE ego_attr_group_cols_intf eagci
2874: SET eagci.attr_group_name = (SELECT descriptive_flex_context_code
2875: FROM ego_fnd_dsc_flx_ctx_ext
2876: WHERE application_id = g_ego_application_id
2877: AND descriptive_flexfield_name = eagci.attr_group_type
2878: AND attr_group_id = eagci.attr_group_id),
2879: eagci.last_updated_by = G_USER_ID,

Line 3878: FROM ego_fnd_dsc_flx_ctx_ext

3874: BEGIN
3875: SELECT attr_group_id,
3876: 'UPDATE'
3877: INTO P_ag_tbl(i).attr_group_id,P_ag_tbl(i).transaction_type
3878: FROM ego_fnd_dsc_flx_ctx_ext
3879: WHERE application_id = g_ego_application_id
3880: AND descriptive_flexfield_name = P_ag_tbl(i).attr_group_type
3881: AND descriptive_flex_context_code = P_ag_tbl(i).attr_group_name;
3882: EXCEPTION

Line 4158: FROM ego_fnd_dsc_flx_ctx_ext

4154: AND P_attr_tbl(i).attr_group_name IS NOT NULL) THEN
4155: BEGIN
4156: SELECT attr_group_id
4157: INTO P_attr_tbl(i).attr_group_id
4158: FROM ego_fnd_dsc_flx_ctx_ext
4159: WHERE application_id = g_ego_application_id
4160: AND descriptive_flexfield_name = P_attr_tbl(i).attr_group_type
4161: AND descriptive_flex_context_code = P_attr_tbl(i).attr_group_name;
4162: EXCEPTION

Line 4317: RETURN ego_fnd_dsc_flx_ctx_ext%ROWTYPE IS

4313: -- sreharih. Fri Apr 29 10:22:42 PDT 2011
4314: --
4315:
4316: FUNCTION get_old_ag_record (p_attr_group_id IN NUMBER)
4317: RETURN ego_fnd_dsc_flx_ctx_ext%ROWTYPE IS
4318:
4319: l_ret ego_fnd_dsc_flx_ctx_ext%ROWTYPE;
4320:
4321: CURSOR c IS

Line 4319: l_ret ego_fnd_dsc_flx_ctx_ext%ROWTYPE;

4315:
4316: FUNCTION get_old_ag_record (p_attr_group_id IN NUMBER)
4317: RETURN ego_fnd_dsc_flx_ctx_ext%ROWTYPE IS
4318:
4319: l_ret ego_fnd_dsc_flx_ctx_ext%ROWTYPE;
4320:
4321: CURSOR c IS
4322: SELECT *
4323: FROM ego_fnd_dsc_flx_ctx_ext ed

Line 4323: FROM ego_fnd_dsc_flx_ctx_ext ed

4319: l_ret ego_fnd_dsc_flx_ctx_ext%ROWTYPE;
4320:
4321: CURSOR c IS
4322: SELECT *
4323: FROM ego_fnd_dsc_flx_ctx_ext ed
4324: WHERE ed.attr_group_id = p_attr_group_id;
4325:
4326: BEGIN
4327:

Line 4346: l_old_ag_record ego_fnd_dsc_flx_ctx_ext%ROWTYPE; -- Bug 12394675.

4342: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
4343: IS
4344: lv_smt NUMBER; --Statement counter
4345: lv_proc VARCHAR2(30) := 'Common_ag_validations';
4346: l_old_ag_record ego_fnd_dsc_flx_ctx_ext%ROWTYPE; -- Bug 12394675.
4347: BEGIN
4348: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Entering Common_ag_validations');
4349:
4350: x_return_status := G_RET_STS_SUCCESS;

Line 4589: FROM ego_fnd_dsc_flx_ctx_ext

4585: /*Sets the attr_group_id if its still NULL and if its present in the system.*/
4586: IF (p_agdl_tbl(i).attr_group_id IS NULL) THEN
4587: BEGIN
4588: SELECT attr_group_id INTO p_agdl_tbl(i).attr_group_id
4589: FROM ego_fnd_dsc_flx_ctx_ext
4590: WHERE application_id = G_EGO_APPLICATION_ID
4591: AND descriptive_flexfield_name = p_agdl_tbl(i).attr_group_type
4592: AND descriptive_flex_context_code = p_agdl_tbl(i).attr_group_name;
4593: EXCEPTION

Line 5313: FROM ego_fnd_dsc_flx_ctx_ext

5309: AND P_agdl_tbl(i).attr_group_id IS NULL) THEN
5310: BEGIN
5311: SELECT attr_group_id
5312: INTO P_agdl_tbl(i).attr_group_id
5313: FROM ego_fnd_dsc_flx_ctx_ext
5314: WHERE application_id = g_ego_application_id
5315: AND descriptive_flexfield_name = P_agdl_tbl(i).attr_group_type
5316: AND descriptive_flex_context_code = P_agdl_tbl(i).attr_group_name;
5317: EXCEPTION

Line 5427: FROM ego_fnd_dsc_flx_ctx_ext

5423: AND P_ag_tbl(i).transaction_type = G_OPR_UPDATE) THEN
5424: BEGIN
5425: SELECT descriptive_flex_context_code
5426: INTO P_ag_tbl(i).attr_group_name
5427: FROM ego_fnd_dsc_flx_ctx_ext
5428: WHERE application_id = g_ego_application_id
5429: AND descriptive_flexfield_name = P_ag_tbl(i).attr_group_type
5430: AND descriptive_flex_context_code = P_ag_tbl(i).attr_group_id;
5431: EXCEPTION

Line 5497: FROM ego_fnd_dsc_flx_ctx_ext

5493: AND P_agdl_tbl(i).transaction_type = G_OPR_UPDATE) THEN
5494: BEGIN
5495: SELECT descriptive_flex_context_code
5496: INTO P_agdl_tbl(i).attr_group_name
5497: FROM ego_fnd_dsc_flx_ctx_ext
5498: WHERE application_id = g_ego_application_id
5499: AND descriptive_flexfield_name = P_agdl_tbl(i).attr_group_type
5500: AND descriptive_flex_context_code = P_agdl_tbl(i).attr_group_id;
5501: EXCEPTION

Line 5731: FROM ego_fnd_dsc_flx_ctx_ext

5727: OR P_agdl_tbl(i).defaulting IS NOT NULL)) THEN
5728: BEGIN
5729: SELECT Nvl(variant,'N')
5730: INTO lv_flag
5731: FROM ego_fnd_dsc_flx_ctx_ext
5732: WHERE attr_group_id = P_agdl_tbl(i).attr_group_id;
5733:
5734: IF (lv_flag = 'Y') THEN
5735: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Attribute group of type Variant can only set ITEM as the business entity and with SKU as NULL');

Line 5786: FROM ego_fnd_dsc_flx_ctx_ext

5782: ELSE
5783: BEGIN
5784: SELECT Nvl(variant,'N')
5785: INTO lv_flag
5786: FROM ego_fnd_dsc_flx_ctx_ext
5787: WHERE attr_group_id = P_agdl_tbl(i).attr_group_id;
5788:
5789: IF (lv_flag = 'N') THEN
5790: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'The Behaviour and Business Entity combination is incorrect');

Line 5843: FROM ego_fnd_dsc_flx_ctx_ext

5839: ELSE
5840: BEGIN
5841: SELECT Nvl(variant,'N')
5842: INTO lv_flag
5843: FROM ego_fnd_dsc_flx_ctx_ext
5844: WHERE attr_group_id = P_agdl_tbl(i).attr_group_id;
5845:
5846: IF (lv_flag = 'N') THEN
5847: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Attribute Group behaviour, business entity and the style to SKU combination in invalid');

Line 5972: FROM ego_fnd_dsc_flx_ctx_ext

5968: AND P_attr_tbl(i).attr_group_name IS NULL) THEN
5969: BEGIN
5970: SELECT descriptive_flex_context_code
5971: INTO P_attr_tbl(i).attr_group_name
5972: FROM ego_fnd_dsc_flx_ctx_ext
5973: WHERE application_id = g_ego_application_id
5974: AND descriptive_flexfield_name = P_attr_tbl(i).attr_group_type
5975: AND attr_group_id = P_attr_tbl(i).attr_group_id;
5976: EXCEPTION

Line 6341: FROM EGO_FND_DSC_FLX_CTX_EXT

6337: BEGIN
6338: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Smt 1');
6339:
6340: SELECT NUM_OF_COLS, NUM_OF_ROWS, MULTI_ROW, VARIANT INTO lv_num_of_cols, lv_num_of_rows, lv_multi_row, lv_variant
6341: FROM EGO_FND_DSC_FLX_CTX_EXT
6342: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_ag_tbl(i).attr_group_type
6343: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_ag_tbl(i).attr_group_name
6344: AND APPLICATION_ID = G_EGO_APPLICATION_ID;
6345:

Line 6587: FROM ego_fnd_dsc_flx_ctx_ext efd

6583: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
6584: IS
6585: CURSOR cur_ag_none_dl IS
6586: SELECT attr_group_id
6587: FROM ego_fnd_dsc_flx_ctx_ext efd
6588: WHERE application_id = G_EGO_APPLICATION_ID
6589: AND DESCRIPTIVE_FLEXFIELD_NAME = G_EGO_ITEMMGMT_GROUP
6590: AND NOT EXISTS (SELECT 1
6591: FROM EGO_ATTR_GROUP_DL