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_ATTR_GROUP_COLS_INTF

Line 89: UPDATE ego_attr_group_cols_intf

85: lv_smt := 4;
86:
87: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
88:
89: UPDATE ego_attr_group_cols_intf
90: SET transaction_id = mtl_system_items_interface_s.nextval,
91: transaction_type = Upper(transaction_type),
92: application_id = g_ego_application_id,
93: created_by = G_USER_ID,

Line 108: FROM ego_attr_group_cols_intf

104: AND ((G_SET_PROCESS_ID IS NULL)
105: OR (set_process_id = G_SET_PROCESS_ID));
106:
107: SELECT COUNT(1) INTO G_ATTR_COUNT
108: FROM ego_attr_group_cols_intf
109: WHERE process_status = G_PROCESS_RECORD
110: AND ((G_SET_PROCESS_ID IS NULL)
111: OR (set_process_id = G_SET_PROCESS_ID));
112:

Line 310: FROM ego_attr_group_cols_intf

306: G_REQUEST_ID,
307: Nvl(program_application_id,G_PROG_APPL_ID),
308: Nvl(program_id,G_PROGRAM_ID),
309: Nvl(program_update_date,SYSDATE)
310: FROM ego_attr_group_cols_intf
311: WHERE (transaction_type IS NULL
312: OR transaction_type NOT IN (G_OPR_CREATE,G_OPR_UPDATE,G_OPR_DELETE,G_OPR_SYNC))
313: AND transaction_id IS NOT NULL
314: AND process_status = G_PROCESS_RECORD

Line 318: UPDATE ego_attr_group_cols_intf

314: AND process_status = G_PROCESS_RECORD
315: AND ((G_SET_PROCESS_ID IS NULL)
316: OR (set_process_id = G_SET_PROCESS_ID));
317:
318: UPDATE ego_attr_group_cols_intf
319: SET process_status = G_ERROR_RECORD,
320: last_updated_by = G_USER_ID,
321: last_update_date = SYSDATE,
322: last_update_login = G_LOGIN_ID

Line 1851: FROM ego_attr_group_cols_intf eagi

1847: G_REQUEST_ID,
1848: Nvl(program_application_id,G_PROG_APPL_ID),
1849: Nvl(program_id,G_PROGRAM_ID),
1850: Nvl(program_update_date,SYSDATE)
1851: FROM ego_attr_group_cols_intf eagi
1852: WHERE attr_group_type <> G_EGO_ITEMMGMT_GROUP
1853: AND transaction_id IS NOT NULL
1854: AND process_status = G_PROCESS_RECORD
1855: AND ((G_SET_PROCESS_ID IS NULL)

Line 1858: UPDATE ego_attr_group_cols_intf

1854: AND process_status = G_PROCESS_RECORD
1855: AND ((G_SET_PROCESS_ID IS NULL)
1856: OR (set_process_id = G_SET_PROCESS_ID));
1857:
1858: UPDATE ego_attr_group_cols_intf
1859: SET process_status = G_ERROR_RECORD,
1860: last_updated_by = G_USER_ID,
1861: last_update_date = SYSDATE,
1862: last_update_login = G_LOGIN_ID

Line 1918: FROM ego_attr_group_cols_intf eagi

1914: G_REQUEST_ID,
1915: Nvl(program_application_id,G_PROG_APPL_ID),
1916: Nvl(program_id,G_PROGRAM_ID),
1917: Nvl(program_update_date,SYSDATE)
1918: FROM ego_attr_group_cols_intf eagi
1919: WHERE EXISTS (SELECT 1
1920: FROM FND_DESCR_FLEX_COLUMN_USAGES
1921: WHERE APPLICATION_ID = G_EGO_APPLICATION_ID
1922: AND DESCRIPTIVE_FLEXFIELD_NAME = G_EGO_ITEMMGMT_GROUP

Line 1932: UPDATE ego_attr_group_cols_intf eagi

1928: AND process_status = G_PROCESS_RECORD
1929: AND ((G_SET_PROCESS_ID IS NULL)
1930: OR (set_process_id = G_SET_PROCESS_ID));
1931:
1932: UPDATE ego_attr_group_cols_intf eagi
1933: SET process_status = G_ERROR_RECORD,
1934: last_updated_by = G_USER_ID,
1935: last_update_date = SYSDATE,
1936: last_update_login = G_LOGIN_ID

Line 2004: FROM ego_attr_group_cols_intf eagci

2000: G_REQUEST_ID,
2001: Nvl(program_application_id,G_PROG_APPL_ID),
2002: Nvl(program_id,G_PROGRAM_ID),
2003: Nvl(program_update_date,SYSDATE)
2004: FROM ego_attr_group_cols_intf eagci
2005: WHERE (eagci.attr_group_id IS NULL
2006: OR eagci.attr_group_name IS NULL)
2007: AND eagci.transaction_id IS NOT NULL
2008: AND NOT EXISTS (SELECT 1

Line 2017: UPDATE ego_attr_group_cols_intf eagci

2013: AND eagci.process_status = G_PROCESS_RECORD
2014: AND ((G_SET_PROCESS_ID IS NULL)
2015: OR (set_process_id = G_SET_PROCESS_ID));
2016:
2017: UPDATE ego_attr_group_cols_intf eagci
2018: SET eagci.process_status = G_ERROR_RECORD,
2019: eagci.last_updated_by = G_USER_ID,
2020: eagci.last_update_date = SYSDATE,
2021: eagci.last_update_login = G_LOGIN_ID

Line 2082: FROM ego_attr_group_cols_intf eagci

2078: G_REQUEST_ID,
2079: Nvl(program_application_id,G_PROG_APPL_ID),
2080: Nvl(program_id,G_PROGRAM_ID),
2081: Nvl(program_update_date,SYSDATE)
2082: FROM ego_attr_group_cols_intf eagci
2083: WHERE ((eagci.attr_id IS NULL
2084: AND eagci.internal_name IS NOT NULL)
2085: OR (eagci.internal_name IS NULL
2086: AND eagci.attr_id IS NOT NULL))

Line 2093: UPDATE ego_attr_group_cols_intf eagci

2089: AND eagci.process_status = G_PROCESS_RECORD
2090: AND ((G_SET_PROCESS_ID IS NULL)
2091: OR (set_process_id = G_SET_PROCESS_ID));
2092:
2093: UPDATE ego_attr_group_cols_intf eagci
2094: SET eagci.process_status = G_ERROR_RECORD,
2095: eagci.last_updated_by = G_USER_ID,
2096: eagci.last_update_date = SYSDATE,
2097: eagci.last_update_login = G_LOGIN_ID

Line 2156: FROM ego_attr_group_cols_intf eagci

2152: G_REQUEST_ID,
2153: Nvl(program_application_id,G_PROG_APPL_ID),
2154: Nvl(program_id,G_PROGRAM_ID),
2155: Nvl(program_update_date,SYSDATE)
2156: FROM ego_attr_group_cols_intf eagci
2157: WHERE ((eagci.flex_value_set_id IS NULL
2158: AND eagci.flex_value_set_name IS NOT NULL
2159: AND eagci.flex_value_set_name <> G_NULL_CHAR)
2160: OR (eagci.flex_value_set_name IS NULL

Line 2168: UPDATE ego_attr_group_cols_intf eagci

2164: AND eagci.process_status = G_PROCESS_RECORD
2165: AND ((G_SET_PROCESS_ID IS NULL)
2166: OR (set_process_id = G_SET_PROCESS_ID));
2167:
2168: UPDATE ego_attr_group_cols_intf eagci
2169: SET eagci.process_status = G_ERROR_RECORD,
2170: eagci.last_updated_by = G_USER_ID,
2171: eagci.last_update_date = SYSDATE,
2172: eagci.last_update_login = G_LOGIN_ID

Line 2233: FROM ego_attr_group_cols_intf eagdl

2229: G_REQUEST_ID,
2230: Nvl(program_application_id,G_PROG_APPL_ID),
2231: Nvl(program_id,G_PROGRAM_ID),
2232: Nvl(program_update_date,SYSDATE)
2233: FROM ego_attr_group_cols_intf eagdl
2234: WHERE transaction_type = G_OPR_DELETE
2235: AND EXISTS (SELECT 1
2236: FROM EGO_OBJ_AG_ASSOCS_B
2237: WHERE ATTR_GROUP_ID = eagdl.attr_group_id

Line 2244: UPDATE ego_attr_group_cols_intf eagdl

2240: AND process_status = G_PROCESS_RECORD
2241: AND ((G_SET_PROCESS_ID IS NULL)
2242: OR (set_process_id = G_SET_PROCESS_ID));
2243:
2244: UPDATE ego_attr_group_cols_intf eagdl
2245: SET process_status = G_ERROR_RECORD,
2246: last_updated_by = G_USER_ID,
2247: last_update_date = SYSDATE,
2248: last_update_login = G_LOGIN_ID

Line 2546: UPDATE ego_attr_group_cols_intf eagci

2542:
2543: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
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

Line 2566: UPDATE ego_attr_group_cols_intf

2562:
2563: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
2564:
2565: /*Set the application id*/
2566: UPDATE ego_attr_group_cols_intf
2567: SET application_id = g_ego_application_id,
2568: last_updated_by = G_USER_ID,
2569: last_update_date = SYSDATE,
2570: last_update_login = G_LOGIN_ID

Line 2581: UPDATE ego_attr_group_cols_intf eagci

2577:
2578: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
2579:
2580: /*Sets the Attr_id for the update and sync flow*/
2581: UPDATE ego_attr_group_cols_intf eagci
2582: SET eagci.attr_id = (SELECT efdcue.attr_id
2583: FROM fnd_descr_flex_column_usages fdfcu,
2584: ego_fnd_df_col_usgs_ext efdcue
2585: WHERE fdfcu.application_id = efdcue.application_id

Line 2605: UPDATE ego_attr_group_cols_intf eagci

2601:
2602: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
2603:
2604: /*Sets the value set id when the value set name is given*/
2605: UPDATE ego_attr_group_cols_intf eagci
2606: SET eagci.flex_value_set_id = (SELECT ffvs.flex_value_set_id
2607: FROM fnd_flex_value_sets ffvs
2608: WHERE ffvs.flex_value_set_name = eagci.flex_value_set_name)
2609: WHERE eagci.flex_value_set_id IS NULL

Line 2620: UPDATE ego_attr_group_cols_intf

2616:
2617: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
2618:
2619: /*Sets the Sync type to UPDATE*/
2620: UPDATE ego_attr_group_cols_intf
2621: SET transaction_type = G_OPR_UPDATE
2622: WHERE transaction_type = G_OPR_SYNC
2623: AND attr_id IS NOT NULL
2624: AND process_status = G_PROCESS_RECORD

Line 2633: UPDATE ego_attr_group_cols_intf

2629:
2630: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 6');
2631:
2632: /*Sets the Sync type to CREATE*/
2633: UPDATE ego_attr_group_cols_intf
2634: SET transaction_type = G_OPR_CREATE
2635: WHERE transaction_type = G_OPR_SYNC
2636: AND attr_id IS NULL
2637: AND process_status = G_PROCESS_RECORD

Line 2873: UPDATE ego_attr_group_cols_intf eagci

2869:
2870: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
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

Line 2892: UPDATE ego_attr_group_cols_intf eagci

2888:
2889: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
2890:
2891: /*Sets the Internal Attribute name when then Attr id is given*/
2892: UPDATE ego_attr_group_cols_intf eagci
2893: SET eagci.internal_name = (SELECT fdfcu.end_user_column_name
2894: FROM fnd_descr_flex_column_usages fdfcu,
2895: ego_fnd_df_col_usgs_ext efdcue
2896: WHERE fdfcu.application_id = efdcue.application_id

Line 2915: UPDATE ego_attr_group_cols_intf eagci

2911:
2912: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
2913:
2914: /*Sets the value set name when the value set id is given*/
2915: UPDATE ego_attr_group_cols_intf eagci
2916: SET eagci.flex_value_set_name = (SELECT ffvs.flex_value_set_name
2917: FROM fnd_flex_value_sets ffvs
2918: WHERE ffvs.flex_value_set_id = eagci.flex_value_set_id)
2919: WHERE eagci.flex_value_set_id IS NOT NULL

Line 3721: /Cursor to load plsql table from ego_attr_group_cols_intf table/

3717: SELECT *
3718: FROM ego_attr_groups_dl_interface
3719: WHERE process_status = G_PROCESS_RECORD
3720: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id);
3721: /*Cursor to load plsql table from ego_attr_group_cols_intf table*/
3722: CURSOR c_attr IS
3723: SELECT *
3724: FROM ego_attr_group_cols_intf
3725: WHERE process_status = G_PROCESS_RECORD

Line 3724: FROM ego_attr_group_cols_intf

3720: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id);
3721: /*Cursor to load plsql table from ego_attr_group_cols_intf table*/
3722: CURSOR c_attr IS
3723: SELECT *
3724: FROM ego_attr_group_cols_intf
3725: WHERE process_status = G_PROCESS_RECORD
3726: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id);
3727:
3728: l_ego_ag_tbl ego_metadata_pub.ego_attr_groups_tbl;

Line 6203: UPDATE ego_attr_group_cols_intf

6199: trans_id(i) := p_attr_tbl(i).transaction_id;
6200: END LOOP;
6201:
6202: FORALL i IN p_attr_tbl.FIRST..p_attr_tbl.LAST
6203: UPDATE ego_attr_group_cols_intf
6204: SET ROW = P_attr_tbl(i)
6205: WHERE transaction_id = trans_id(i);
6206:
6207: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Exit update_intf_attribute');

Line 6296: DELETE FROM ego_attr_group_cols_intf

6292: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Entering delete_processed_attributes');
6293:
6294: x_return_status := G_RET_STS_SUCCESS;
6295:
6296: DELETE FROM ego_attr_group_cols_intf
6297: WHERE process_status = G_SUCCESS_RECORD
6298: AND (x_set_process_id IS NULL
6299: OR set_process_id = x_set_process_id);
6300: