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_GROUPS_DL_INTERFACE

Line 61: UPDATE ego_attr_groups_dl_interface

57: lv_smt := 3;
58:
59: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
60:
61: UPDATE ego_attr_groups_dl_interface
62: SET transaction_id = mtl_system_items_interface_s.nextval,
63: transaction_type = Upper(transaction_type),
64: application_id = g_ego_application_id,
65: created_by = G_USER_ID,

Line 80: FROM ego_attr_groups_dl_interface

76: AND ((G_SET_PROCESS_ID IS NULL)
77: OR (set_process_id = G_SET_PROCESS_ID));
78:
79: SELECT COUNT(1) INTO G_DL_COUNT
80: FROM ego_attr_groups_dl_interface
81: WHERE process_status = G_PROCESS_RECORD
82: AND ((G_SET_PROCESS_ID IS NULL)
83: OR (set_process_id = G_SET_PROCESS_ID));
84:

Line 249: FROM ego_attr_groups_dl_interface

245: G_REQUEST_ID,
246: Nvl(program_application_id,G_PROG_APPL_ID),
247: Nvl(program_id,G_PROGRAM_ID),
248: Nvl(program_update_date,SYSDATE)
249: FROM ego_attr_groups_dl_interface
250: WHERE (transaction_type IS NULL
251: OR transaction_type NOT IN (G_OPR_CREATE,G_OPR_UPDATE,G_OPR_DELETE,G_OPR_SYNC))
252: AND transaction_id IS NOT NULL
253: AND process_status = G_PROCESS_RECORD

Line 257: UPDATE ego_attr_groups_dl_interface

253: AND process_status = G_PROCESS_RECORD
254: AND ((G_SET_PROCESS_ID IS NULL)
255: OR (set_process_id = G_SET_PROCESS_ID));
256:
257: UPDATE ego_attr_groups_dl_interface
258: SET process_status = G_ERROR_RECORD,
259: last_updated_by = G_USER_ID,
260: last_update_date = SYSDATE,
261: last_update_login = G_LOGIN_ID

Line 552: FROM ego_attr_groups_dl_interface eagi

548: G_REQUEST_ID,
549: Nvl(program_application_id,G_PROG_APPL_ID),
550: Nvl(program_id,G_PROGRAM_ID),
551: Nvl(program_update_date,SYSDATE)
552: FROM ego_attr_groups_dl_interface eagi
553: WHERE attr_group_type <> G_EGO_ITEMMGMT_GROUP
554: AND transaction_id IS NOT NULL
555: AND process_status = G_PROCESS_RECORD
556: AND ((G_SET_PROCESS_ID IS NULL)

Line 559: UPDATE ego_attr_groups_dl_interface

555: AND process_status = G_PROCESS_RECORD
556: AND ((G_SET_PROCESS_ID IS NULL)
557: OR (set_process_id = G_SET_PROCESS_ID));
558:
559: UPDATE ego_attr_groups_dl_interface
560: SET process_status = G_ERROR_RECORD,
561: last_updated_by = G_USER_ID,
562: last_update_date = SYSDATE,
563: last_update_login = G_LOGIN_ID

Line 619: FROM ego_attr_groups_dl_interface eagi

615: G_REQUEST_ID,
616: Nvl(program_application_id,G_PROG_APPL_ID),
617: Nvl(program_id,G_PROGRAM_ID),
618: Nvl(program_update_date,SYSDATE)
619: FROM ego_attr_groups_dl_interface eagi
620: WHERE (attr_group_type IS NULL
621: OR attr_group_name IS NULL
622: OR data_level_name IS NULL)
623: AND transaction_id IS NOT NULL

Line 628: UPDATE ego_attr_groups_dl_interface

624: AND process_status = G_PROCESS_RECORD
625: AND ((G_SET_PROCESS_ID IS NULL)
626: OR (set_process_id = G_SET_PROCESS_ID));
627:
628: UPDATE ego_attr_groups_dl_interface
629: SET process_status = G_ERROR_RECORD,
630: last_updated_by = G_USER_ID,
631: last_update_date = SYSDATE,
632: last_update_login = G_LOGIN_ID

Line 764: FROM ego_attr_groups_dl_interface eagdi

760: G_REQUEST_ID,
761: Nvl(program_application_id,G_PROG_APPL_ID),
762: Nvl(program_id,G_PROGRAM_ID),
763: Nvl(program_update_date,SYSDATE)
764: FROM ego_attr_groups_dl_interface eagdi
765: WHERE (eagdi.attr_group_id IS NULL
766: OR eagdi.attr_group_name IS NULL)
767: AND eagdi.transaction_id IS NOT NULL
768: AND NOT EXISTS (SELECT 1

Line 777: UPDATE ego_attr_groups_dl_interface eagdi

773: AND eagdi.process_status = G_PROCESS_RECORD
774: AND ((G_SET_PROCESS_ID IS NULL)
775: OR (set_process_id = G_SET_PROCESS_ID));
776:
777: UPDATE ego_attr_groups_dl_interface eagdi
778: SET eagdi.process_status = G_ERROR_RECORD,
779: last_updated_by = G_USER_ID,
780: last_update_date = SYSDATE,
781: last_update_login = G_LOGIN_ID

Line 926: FROM ego_attr_groups_dl_interface eagdi

922: Nvl(program_id,G_PROGRAM_ID),
923: Nvl(program_update_date,SYSDATE)
924: FROM ego_attr_groups_interface eagi
925: WHERE NOT EXISTS (SELECT 1
926: FROM ego_attr_groups_dl_interface eagdi
927: WHERE eagdi.attr_group_name = eagi.attr_group_name
928: AND eagdi.transaction_type = eagi.transaction_type
929: AND eagdi.process_status = G_PROCESS_RECORD
930: AND ((G_SET_PROCESS_ID IS NULL)

Line 944: FROM ego_attr_groups_dl_interface eagdi

940: last_updated_by = G_USER_ID,
941: last_update_date = SYSDATE,
942: last_update_login = G_LOGIN_ID
943: WHERE NOT EXISTS (SELECT 1
944: FROM ego_attr_groups_dl_interface eagdi
945: WHERE eagdi.attr_group_name = eagi.attr_group_name
946: AND eagdi.transaction_type = eagi.transaction_type
947: AND eagdi.process_status = G_PROCESS_RECORD
948: AND ((G_SET_PROCESS_ID IS NULL)

Line 1005: FROM ego_attr_groups_dl_interface eagi

1001: G_REQUEST_ID,
1002: Nvl(program_application_id,G_PROG_APPL_ID),
1003: Nvl(program_id,G_PROGRAM_ID),
1004: Nvl(program_update_date,SYSDATE)
1005: FROM ego_attr_groups_dl_interface eagi
1006: WHERE EXISTS (SELECT 1
1007: FROM EGO_ATTR_GROUP_DL eagdl
1008: WHERE eagdl.attr_group_id = eagi.attr_group_id
1009: AND eagdl.data_level_id = (SELECT data_level_id FROM ego_data_level_b

Line 1020: UPDATE ego_attr_groups_dl_interface eagi

1016: AND eagi.process_status = G_PROCESS_RECORD
1017: AND ((G_SET_PROCESS_ID IS NULL)
1018: OR (set_process_id = G_SET_PROCESS_ID));
1019:
1020: UPDATE ego_attr_groups_dl_interface eagi
1021: SET eagi.process_status = G_ERROR_RECORD,
1022: last_updated_by = G_USER_ID,
1023: last_update_date = SYSDATE,
1024: last_update_login = G_LOGIN_ID

Line 1088: FROM ego_attr_groups_dl_interface

1084: G_REQUEST_ID,
1085: Nvl(program_application_id,G_PROG_APPL_ID),
1086: Nvl(program_id,G_PROGRAM_ID),
1087: Nvl(program_update_date,SYSDATE)
1088: FROM ego_attr_groups_dl_interface
1089: WHERE (data_level_id IS NULL
1090: OR data_level_name IS NULL)
1091: AND transaction_id IS NOT NULL
1092: AND process_status = G_PROCESS_RECORD

Line 1096: UPDATE ego_attr_groups_dl_interface

1092: AND process_status = G_PROCESS_RECORD
1093: AND ((G_SET_PROCESS_ID IS NULL)
1094: OR (set_process_id = G_SET_PROCESS_ID));
1095:
1096: UPDATE ego_attr_groups_dl_interface
1097: SET process_status = G_ERROR_RECORD,
1098: last_updated_by = G_USER_ID,
1099: last_update_date = SYSDATE,
1100: last_update_login = G_LOGIN_ID

Line 1157: FROM ego_attr_groups_dl_interface eagdi

1153: G_REQUEST_ID,
1154: Nvl(program_application_id,G_PROG_APPL_ID),
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'

Line 1180: UPDATE ego_attr_groups_dl_interface eagdi

1176: AND eagdi.process_status = G_PROCESS_RECORD
1177: AND ((G_SET_PROCESS_ID IS NULL)
1178: OR (set_process_id = G_SET_PROCESS_ID));
1179:
1180: UPDATE ego_attr_groups_dl_interface eagdi
1181: SET eagdi.process_status = G_ERROR_RECORD,
1182: last_updated_by = G_USER_ID,
1183: last_update_date = SYSDATE,
1184: last_update_login = G_LOGIN_ID

Line 1257: FROM ego_attr_groups_dl_interface eagdi

1253: G_REQUEST_ID,
1254: Nvl(program_application_id,G_PROG_APPL_ID),
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')

Line 1269: UPDATE ego_attr_groups_dl_interface eagdi

1265: AND eagdi.process_status = G_PROCESS_RECORD
1266: AND ((G_SET_PROCESS_ID IS NULL)
1267: OR (set_process_id = G_SET_PROCESS_ID));
1268:
1269: UPDATE ego_attr_groups_dl_interface eagdi
1270: SET eagdi.process_status = G_ERROR_RECORD,
1271: last_updated_by = G_USER_ID,
1272: last_update_date = SYSDATE,
1273: last_update_login = G_LOGIN_ID

Line 1335: FROM ego_attr_groups_dl_interface eagdi

1331: G_REQUEST_ID,
1332: Nvl(program_application_id,G_PROG_APPL_ID),
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')

Line 1350: UPDATE ego_attr_groups_dl_interface eagdi

1346: AND eagdi.process_status = G_PROCESS_RECORD
1347: AND ((G_SET_PROCESS_ID IS NULL)
1348: OR (set_process_id = G_SET_PROCESS_ID));
1349:
1350: UPDATE ego_attr_groups_dl_interface eagdi
1351: SET eagdi.process_status = G_ERROR_RECORD,
1352: last_updated_by = G_USER_ID,
1353: last_update_date = SYSDATE,
1354: last_update_login = G_LOGIN_ID

Line 1418: FROM ego_attr_groups_dl_interface

1414: G_REQUEST_ID,
1415: Nvl(program_application_id,G_PROG_APPL_ID),
1416: Nvl(program_id,G_PROGRAM_ID),
1417: Nvl(program_update_date,SYSDATE)
1418: FROM ego_attr_groups_dl_interface
1419: WHERE ((view_privilege_id IS NULL
1420: AND view_privilege_name IS NOT NULL
1421: and view_privilege_name <> G_NULL_CHAR)
1422: OR (view_privilege_name IS NULL

Line 1430: UPDATE ego_attr_groups_dl_interface

1426: AND process_status = G_PROCESS_RECORD
1427: AND ((G_SET_PROCESS_ID IS NULL)
1428: OR (set_process_id = G_SET_PROCESS_ID));
1429:
1430: UPDATE ego_attr_groups_dl_interface
1431: SET process_status = G_ERROR_RECORD,
1432: last_updated_by = G_USER_ID,
1433: last_update_date = SYSDATE,
1434: last_update_login = G_LOGIN_ID

Line 1501: FROM ego_attr_groups_dl_interface

1497: G_REQUEST_ID,
1498: Nvl(program_application_id,G_PROG_APPL_ID),
1499: Nvl(program_id,G_PROGRAM_ID),
1500: Nvl(program_update_date,SYSDATE)
1501: FROM ego_attr_groups_dl_interface
1502: WHERE ((edit_privilege_id IS NULL
1503: AND edit_privilege_name IS NOT NULL
1504: AND edit_privilege_name <> G_NULL_CHAR)
1505: OR (edit_privilege_name IS NULL

Line 1513: UPDATE ego_attr_groups_dl_interface

1509: AND process_status = G_PROCESS_RECORD
1510: AND ((G_SET_PROCESS_ID IS NULL)
1511: OR (set_process_id = G_SET_PROCESS_ID));
1512:
1513: UPDATE ego_attr_groups_dl_interface
1514: SET process_status = G_ERROR_RECORD,
1515: last_updated_by = G_USER_ID,
1516: last_update_date = SYSDATE,
1517: last_update_login = G_LOGIN_ID

Line 1576: FROM ego_attr_groups_dl_interface eagdl

1572: G_REQUEST_ID,
1573: Nvl(program_application_id,G_PROG_APPL_ID),
1574: Nvl(program_id,G_PROGRAM_ID),
1575: Nvl(program_update_date,SYSDATE)
1576: FROM ego_attr_groups_dl_interface eagdl
1577: WHERE data_level_name <> 'ITEM_REVISION_LEVEL'
1578: AND transaction_type <> G_OPR_DELETE
1579: AND (defaulting IS NULL
1580: OR defaulting_name IS NULL)

Line 1599: UPDATE ego_attr_groups_dl_interface eagdl

1595: WHERE ATTR_GROUP_NAME = eagdl.attr_group_name
1596: AND ATTR_GROUP_TYPE = G_EGO_ITEMMGMT_GROUP
1597: AND variant = 'Y');
1598:
1599: UPDATE ego_attr_groups_dl_interface eagdl
1600: SET process_status = G_ERROR_RECORD,
1601: last_updated_by = G_USER_ID,
1602: last_update_date = SYSDATE,
1603: last_update_login = G_LOGIN_ID

Line 1675: FROM ego_attr_groups_dl_interface eagdl

1671: G_REQUEST_ID,
1672: Nvl(program_application_id,G_PROG_APPL_ID),
1673: Nvl(program_id,G_PROGRAM_ID),
1674: Nvl(program_update_date,SYSDATE)
1675: FROM ego_attr_groups_dl_interface eagdl
1676: WHERE transaction_type = G_OPR_DELETE
1677: AND EXISTS (SELECT 1
1678: FROM EGO_OBJ_AG_ASSOCS_B
1679: WHERE ATTR_GROUP_ID = eagdl.attr_group_id

Line 1686: UPDATE ego_attr_groups_dl_interface eagdl

1682: AND process_status = G_PROCESS_RECORD
1683: AND ((G_SET_PROCESS_ID IS NULL)
1684: OR (set_process_id = G_SET_PROCESS_ID));
1685:
1686: UPDATE ego_attr_groups_dl_interface eagdl
1687: SET process_status = G_ERROR_RECORD,
1688: last_updated_by = G_USER_ID,
1689: last_update_date = SYSDATE,
1690: last_update_login = G_LOGIN_ID

Line 2359: UPDATE ego_attr_groups_dl_interface eagdi

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

Line 2380: UPDATE ego_attr_groups_dl_interface eagdl

2376:
2377: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
2378:
2379: /*Set the View Privilege ID when the View Privilege Name or User View privilege name is given*/
2380: UPDATE ego_attr_groups_dl_interface eagdl
2381: SET eagdl.view_privilege_id = (SELECT function_id
2382: FROM fnd_form_functions
2383: WHERE function_name = eagdl.view_privilege_name),
2384: last_updated_by = G_USER_ID,

Line 2393: UPDATE ego_attr_groups_dl_interface eagdl

2389: AND eagdl.process_status = G_PROCESS_RECORD
2390: AND ((G_SET_PROCESS_ID IS NULL)
2391: OR (set_process_id = G_SET_PROCESS_ID));
2392:
2393: UPDATE ego_attr_groups_dl_interface eagdl
2394: SET view_privilege_id = (SELECT function_id
2395: FROM fnd_form_functions_vl
2396: WHERE user_function_name = eagdl.user_view_priv_name),
2397: last_updated_by = G_USER_ID,

Line 2411: UPDATE ego_attr_groups_dl_interface eagdl

2407:
2408: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
2409:
2410: /*Set the Edit Privilege ID when the Edit Privilege Name or user edit priviledge name is given*/
2411: UPDATE ego_attr_groups_dl_interface eagdl
2412: SET edit_privilege_id = (SELECT function_id
2413: FROM fnd_form_functions
2414: WHERE function_name = eagdl.edit_privilege_name),
2415: last_updated_by = G_USER_ID,

Line 2424: UPDATE ego_attr_groups_dl_interface eagdl

2420: AND eagdl.process_status = G_PROCESS_RECORD
2421: AND ((G_SET_PROCESS_ID IS NULL)
2422: OR (set_process_id = G_SET_PROCESS_ID));
2423:
2424: UPDATE ego_attr_groups_dl_interface eagdl
2425: SET edit_privilege_id = (SELECT function_id
2426: FROM fnd_form_functions_vl
2427: WHERE user_function_name = eagdl.user_edit_priv_name),
2428: last_updated_by = G_USER_ID,

Line 2442: UPDATE ego_attr_groups_dl_interface eagdi

2438:
2439: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
2440:
2441: /*Set the Data Level ID when the data level is given*/
2442: UPDATE ego_attr_groups_dl_interface eagdi
2443: SET eagdi.data_level_id = (SELECT data_level_id
2444: FROM ego_data_level_b
2445: WHERE attr_group_type = eagdi.attr_group_type
2446: AND application_id = g_ego_application_id

Line 2462: UPDATE ego_attr_groups_dl_interface eagdi

2458:
2459: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 6');
2460:
2461: /*Sets the SYNC transaction type to UPDATE*/
2462: UPDATE ego_attr_groups_dl_interface eagdi
2463: SET eagdi.transaction_type = G_OPR_UPDATE,
2464: last_updated_by = G_USER_ID,
2465: last_update_date = SYSDATE,
2466: last_update_login = G_LOGIN_ID

Line 2483: UPDATE ego_attr_groups_dl_interface eagdi

2479:
2480: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 7');
2481:
2482: /*Sets the SYNC transaction type to CREATE*/
2483: UPDATE ego_attr_groups_dl_interface eagdi
2484: SET eagdi.transaction_type = G_OPR_CREATE,
2485: last_updated_by = G_USER_ID,
2486: last_update_date = SYSDATE,
2487: last_update_login = G_LOGIN_ID

Line 2504: UPDATE ego_attr_groups_dl_interface eagdi

2500:
2501: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 7.1');
2502:
2503: /*Sets the SYNC transaction type to CREATE*/
2504: UPDATE ego_attr_groups_dl_interface eagdi
2505: SET eagdi.transaction_type = G_OPR_CREATE,
2506: last_updated_by = G_USER_ID,
2507: last_update_date = SYSDATE,
2508: last_update_login = G_LOGIN_ID

Line 2734: UPDATE ego_attr_groups_dl_interface eagdi

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

Line 2753: UPDATE ego_attr_groups_dl_interface eagdl

2749:
2750: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
2751:
2752: /*Set the View Privilege when the id is given*/
2753: UPDATE ego_attr_groups_dl_interface eagdl
2754: SET (view_privilege_name,user_view_priv_name) = (SELECT function_name, user_function_name
2755: FROM fnd_form_functions_vl
2756: WHERE function_id = eagdl.view_privilege_id),
2757: last_updated_by = G_USER_ID,

Line 2770: UPDATE ego_attr_groups_dl_interface eagdl

2766:
2767: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
2768:
2769: /*Set the Edit Privilege when the id is given*/
2770: UPDATE ego_attr_groups_dl_interface eagdl
2771: SET (edit_privilege_name,user_edit_priv_name) = (SELECT function_name, user_function_name
2772: FROM fnd_form_functions_vl
2773: WHERE function_id = eagdl.edit_privilege_id),
2774: last_updated_by = G_USER_ID,

Line 2788: UPDATE ego_attr_groups_dl_interface eagdl

2784: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
2785:
2786: /*Set the defaulting when defaulting name is given*/
2787:
2788: UPDATE ego_attr_groups_dl_interface eagdl
2789: SET eagdl.defaulting = (SELECT lookup_code
2790: FROM fnd_lookup_values
2791: WHERE lookup_type = 'EGO_EF_AG_DL_BEHAVIOR'
2792: AND meaning = eagdl.defaulting_name

Line 2809: UPDATE ego_attr_groups_dl_interface eagdl

2805:
2806: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
2807:
2808: /*Set the defaulting name when defaulting is given*/
2809: UPDATE ego_attr_groups_dl_interface eagdl
2810: SET eagdl.defaulting_name = (SELECT meaning
2811: FROM fnd_lookup_values
2812: WHERE lookup_type = 'EGO_EF_AG_DL_BEHAVIOR'
2813: AND lookup_code = eagdl.defaulting

Line 2828: UPDATE ego_attr_groups_dl_interface eagdi

2824:
2825: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 6');
2826:
2827: /*Set the Data Level when the data level id is given*/
2828: UPDATE ego_attr_groups_dl_interface eagdi
2829: SET eagdi.data_level_name = (SELECT data_level_name
2830: FROM ego_data_level_b
2831: WHERE attr_group_type = eagdi.attr_group_type
2832: AND application_id = g_ego_application_id

Line 3715: /Cursor to load plsql table from ego_attr_groups_dl_interface table/

3711: SELECT *
3712: FROM ego_attr_groups_interface
3713: WHERE process_status = G_PROCESS_RECORD
3714: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id);
3715: /*Cursor to load plsql table from ego_attr_groups_dl_interface table*/
3716: CURSOR c_agdl IS
3717: SELECT *
3718: FROM ego_attr_groups_dl_interface
3719: WHERE process_status = G_PROCESS_RECORD

Line 3718: FROM ego_attr_groups_dl_interface

3714: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id);
3715: /*Cursor to load plsql table from ego_attr_groups_dl_interface table*/
3716: CURSOR c_agdl IS
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

Line 6166: UPDATE ego_attr_groups_dl_interface

6162: trans_id(i) := p_agdl_tbl(i).transaction_id;
6163: END LOOP;
6164:
6165: FORALL i IN p_agdl_tbl.FIRST..p_agdl_tbl.LAST
6166: UPDATE ego_attr_groups_dl_interface
6167: SET ROW = p_agdl_tbl(i)
6168: WHERE transaction_id = trans_id(i);
6169:
6170:

Line 6265: DELETE FROM ego_attr_groups_dl_interface

6261: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Entering delete_processed_data_level');
6262:
6263: x_return_status := G_RET_STS_SUCCESS;
6264:
6265: DELETE FROM ego_attr_groups_dl_interface
6266: WHERE process_status = G_SUCCESS_RECORD
6267: AND (x_set_process_id IS NULL
6268: OR set_process_id = x_set_process_id);
6269: