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_VS_BULKLOAD_PVT dependencies on EGO_FLEX_VALUE_SET_INTF

Line 98: G_ENTITY_VS_HEADER_TAB CONSTANT VARCHAR2(240) := 'EGO_FLEX_VALUE_SET_INTF';

94: G_ENTITY_VS_VAL CONSTANT VARCHAR2(30) := 'VS_VALUE';
95: G_ENTITY_VS_VER CONSTANT VARCHAR2(30) := 'VS_VERSION';
96: G_ENTITY_VS_TABLE CONSTANT VARCHAR2(30) := 'VS_TABLE';
97:
98: G_ENTITY_VS_HEADER_TAB CONSTANT VARCHAR2(240) := 'EGO_FLEX_VALUE_SET_INTF';
99: G_ENTITY_VAL_HEADER_TAB CONSTANT VARCHAR2(240) := 'EGO_FLEX_VALUE_INTF';
100: G_ENTITY_VAL_TL_HEADER_TAB CONSTANT VARCHAR2(240) := 'EGO_FLEX_VALUE_TL_INTF';
101:
102: --------------------------------------------------------------

Line 109: G_TABLE_NAME CONSTANT VARCHAR2(30) := 'EGO_FLEX_VALUE_SET_INTF';

105: G_OBJECT_VALUE_SET CONSTANT VARCHAR2(30) := 'EGO_VALUE_SET';
106: G_P4TP_PROFILE_ENABLED BOOLEAN := FALSE;
107:
108:
109: G_TABLE_NAME CONSTANT VARCHAR2(30) := 'EGO_FLEX_VALUE_SET_INTF';
110: G_TOKEN_TBL Error_Handler.Token_Tbl_Type;
111:
112: --------------------------------------------------------------
113: -- The Entity Codes are used for error-handling purposes. --

Line 1402: UPDATE Ego_Flex_Value_Set_Intf efvsi

1398: -- Update transaction type for value set inteface table.
1399: ---------------------------------------------------
1400:
1401: -- Create Mode Value Set
1402: UPDATE Ego_Flex_Value_Set_Intf efvsi
1403: SET efvsi.transaction_type= G_CREATE,
1404: efvsi.last_updated_by = g_user_id,
1405: efvsi.last_update_date = SYSDATE,
1406: efvsi.last_update_login = g_login_id

Line 1420: UPDATE Ego_Flex_Value_Set_Intf efvsi

1416: AND Upper(efvsi.transaction_type) =G_SYNC;
1417:
1418:
1419: -- Update Mode Value Set
1420: UPDATE Ego_Flex_Value_Set_Intf efvsi
1421: SET efvsi.transaction_type= G_UPDATE,
1422: efvsi.last_updated_by = g_user_id,
1423: efvsi.last_update_date = SYSDATE,
1424: efvsi.last_update_login = g_login_id

Line 1459: --Ego_Flex_Value_Set_Intf EVS

1455: (
1456: SELECT flex_value
1457: FROM fnd_flex_value_sets FVS,
1458: fnd_flex_values FVSV
1459: --Ego_Flex_Value_Set_Intf EVS
1460: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id
1461: AND fvs.flex_value_set_name = evsvi.value_set_name
1462: --AND evs.value_set_name = evsv.value_set_name
1463:

Line 1483: --Ego_Flex_Value_Set_Intf EVS

1479: (
1480: SELECT FVSV.flex_value
1481: FROM fnd_flex_value_sets FVS,
1482: fnd_flex_values FVSV
1483: --Ego_Flex_Value_Set_Intf EVS
1484: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id
1485: AND fvs.flex_value_set_name = evsv.value_set_name
1486: --AND evs.value_set_name = evsv.value_set_name
1487:

Line 1510: Ego_Flex_Value_Set_Intf EVS,

1506: SELECT fvsv.flex_value
1507: FROM fnd_flex_value_sets FVS,
1508: fnd_flex_values FVSV,
1509: fnd_flex_values_tl FVSTV,
1510: Ego_Flex_Value_Set_Intf EVS,
1511: Ego_Flex_Value_Intf EVSV
1512: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id
1513: AND fvsv.flex_value_id= fvstv.flex_value_id
1514: AND fvs.flex_value_set_name = EVSTV.value_set_name

Line 1539: Ego_Flex_Value_Set_Intf EVS

1535: SELECT fvsv.flex_value
1536: FROM fnd_flex_value_sets FVS,
1537: fnd_flex_values FVSV,
1538: fnd_flex_values_tl FVSTV,
1539: Ego_Flex_Value_Set_Intf EVS
1540: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id
1541: AND fvsv.flex_value_id= fvstv.flex_value_id
1542: AND fvs.flex_value_set_name = evs.value_set_name
1543: AND evstv.flex_value= fvsv.flex_value

Line 1588: -- Insert record for invalida transaction type into error for table EGO_FLEX_VALUE_SET_INTF

1584: ---------------------------------------------------
1585: -- Insert errored record for value Set inteface table.
1586: ---------------------------------------------------
1587:
1588: -- Insert record for invalida transaction type into error for table EGO_FLEX_VALUE_SET_INTF
1589: INSERT
1590: INTO
1591: MTL_INTERFACE_ERRORS
1592: (

Line 1631: FROM Ego_Flex_Value_Set_Intf evsi

1627: G_REQUEST_ID,
1628: NVL(PROGRAM_APPLICATION_ID, G_PROG_APPL_ID),
1629: NVL(PROGRAM_ID, G_PROGRAM_ID),
1630: NVL(PROGRAM_UPDATE_DATE, sysdate)
1631: FROM Ego_Flex_Value_Set_Intf evsi
1632: WHERE (p_set_process_id IS NULL
1633: OR set_process_id = p_set_process_id
1634: )
1635: AND Upper(transaction_type) NOT IN (G_CREATE, G_UPDATE,G_SYNC)

Line 1641: UPDATE Ego_Flex_Value_Set_Intf

1637:
1638:
1639:
1640: -- Error out record for those where transaction_type NOT IN (G_CREATE,G_UPDATE)
1641: UPDATE Ego_Flex_Value_Set_Intf
1642: SET process_status=G_ERROR_RECORD
1643: WHERE (p_set_process_id IS NULL
1644: OR set_process_id = p_set_process_id
1645: )

Line 2909: UPDATE Ego_Flex_Value_Set_Intf

2905:
2906:
2907:
2908: FORALL i IN p_valueset_tbl.first..p_valueset_tbl.last
2909: UPDATE Ego_Flex_Value_Set_Intf
2910: SET ROW = p_valueset_tbl(i)
2911: WHERE transaction_id = l_trans_id(i);
2912:
2913:

Line 3098: TYPE Value_name_Tbl IS TABLE OF EGO_FLEX_VALUE_SET_INTF.value_set_name%TYPE INDEX BY BINARY_INTEGER;

3094:
3095:
3096: l_api_name VARCHAR2(100) := 'Initialize_VS_Interface';
3097:
3098: TYPE Value_name_Tbl IS TABLE OF EGO_FLEX_VALUE_SET_INTF.value_set_name%TYPE INDEX BY BINARY_INTEGER;
3099: l_name_tab VALUE_NAME_TBL; --:= value_name_tbl();
3100: l_err_message_name VARCHAR2(240);
3101: l_err_message_text VARCHAR2(2000);
3102: l_return_status VARCHAR2(1);

Line 3111: FROM Ego_Flex_Value_Set_Intf

3107: --Get value set name from interface table.
3108: CURSOR cur_valueset
3109: IS
3110: SELECT value_set_name
3111: FROM Ego_Flex_Value_Set_Intf
3112: WHERE (p_set_process_id IS NULL
3113: OR set_process_id = p_set_process_id
3114: )
3115: AND process_status=G_PROCESS_RECORD

Line 3123: FROM Ego_Flex_Value_Set_Intf

3119: --Get value set name from interface table for those which has version as negative .
3120: CURSOR cur_version_valueset
3121: IS
3122: SELECT value_set_name
3123: FROM Ego_Flex_Value_Set_Intf
3124: WHERE (p_set_process_id IS NULL
3125: OR set_process_id = p_set_process_id
3126: )
3127: AND process_status=G_PROCESS_RECORD

Line 3135: FROM Ego_Flex_Value_Set_Intf

3131: --Get child value set name .
3132: CURSOR cur_child_valueset
3133: IS
3134: SELECT value_set_name
3135: FROM Ego_Flex_Value_Set_Intf
3136: WHERE (p_set_process_id IS NULL
3137: OR set_process_id = p_set_process_id
3138: )
3139: AND process_status=G_PROCESS_RECORD

Line 3151: UPDATE Ego_Flex_Value_Set_Intf

3147:
3148:
3149:
3150: -- Update value for transaction_id in value set interface table.
3151: UPDATE Ego_Flex_Value_Set_Intf
3152: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,
3153: transaction_type = Upper(transaction_type),
3154: last_updated_by = G_USER_ID,
3155: last_update_date =sysdate,

Line 3272: UPDATE Ego_Flex_Value_Set_Intf -- Do bulk update

3268: /*OPEN cur_version_valueset;
3269: LOOP
3270: FETCH cur_version_valueset BULK COLLECT INTO l_name_tab limit 2000;
3271: FORALL i IN 1..l_name_tab.Count
3272: UPDATE Ego_Flex_Value_Set_Intf -- Do bulk update
3273: SET process_status= 3
3274: WHERE value_set_name=l_name_tab(i);
3275:
3276: EXIT WHEN cur_version_valueset%NOTFOUND;

Line 3288: UPDATE Ego_Flex_Value_Set_Intf -- Do bulk update

3284: OPEN cur_child_valueset;
3285: LOOP
3286: FETCH cur_child_valueset BULK COLLECT INTO l_name_tab limit 2000;
3287: FORALL i IN 1..l_name_tab.Count
3288: UPDATE Ego_Flex_Value_Set_Intf -- Do bulk update
3289: SET process_status= 3
3290: WHERE value_set_name=l_name_tab(i)
3291: AND validation_type NOT IN (G_TABLE_VALIDATION_CODE);
3292:

Line 3400: FROM Ego_Flex_Value_Set_Intf evsi

3396: G_REQUEST_ID,
3397: NVL(PROGRAM_APPLICATION_ID, G_PROG_APPL_ID),
3398: NVL(PROGRAM_ID, G_PROGRAM_ID),
3399: NVL(PROGRAM_UPDATE_DATE, sysdate)
3400: FROM Ego_Flex_Value_Set_Intf evsi
3401: WHERE (p_set_process_id IS NULL
3402: OR set_process_id = p_set_process_id
3403: )
3404: AND process_status=G_PROCESS_RECORD

Line 3410: UPDATE Ego_Flex_Value_Set_Intf

3406:
3407:
3408:
3409: -- Error out version related records
3410: UPDATE Ego_Flex_Value_Set_Intf
3411: SET process_status=G_ERROR_RECORD
3412: WHERE (p_set_process_id IS NULL
3413: OR set_process_id = p_set_process_id
3414: )

Line 3908: FROM Ego_Flex_Value_Set_Intf

3904: -- Cursor to get non versioned parent value Set
3905: CURSOR Cur_Non_Vers_VS
3906: IS
3907: SELECT *
3908: FROM Ego_Flex_Value_Set_Intf
3909: WHERE (p_set_process_id IS NULL
3910: OR set_process_id = p_set_process_id
3911: )
3912: AND version_seq_id IS NULL

Line 3935: FROM Ego_Flex_Value_Set_Intf evsi

3931: AND evsvi.version_seq_id IS NULL
3932:
3933: AND EXISTS
3934: ( SELECT 1
3935: FROM Ego_Flex_Value_Set_Intf evsi
3936: WHERE
3937: ( (p_set_process_id IS NULL
3938: OR evsi.set_process_id = p_set_process_id
3939: )

Line 4003: Ego_Flex_Value_Set_Intf evsi

3999:
4000: AND EXISTS
4001: ( SELECT 1
4002: FROM Ego_Flex_Value_Intf evsvi,
4003: Ego_Flex_Value_Set_Intf evsi
4004: WHERE
4005: ( (p_set_process_id IS NULL
4006: OR evsvi.set_process_id = p_set_process_id
4007: )

Line 4155: FROM Ego_Flex_Value_Set_Intf

4151: -- Cursor to get versioned value Set
4152: CURSOR Cur_Vers_VS
4153: IS
4154: SELECT *
4155: FROM Ego_Flex_Value_Set_Intf
4156: WHERE (p_set_process_id IS NULL
4157: OR set_process_id = p_set_process_id
4158: )
4159: AND version_seq_id IS NOT NULL

Line 4184: FROM Ego_Flex_Value_Set_Intf evsi

4180: )
4181: AND evsvi.version_seq_id = cp_version_seq_id
4182: AND EXISTS
4183: ( SELECT 1
4184: FROM Ego_Flex_Value_Set_Intf evsi
4185: WHERE
4186: ( (p_set_process_id IS NULL
4187: OR evsi.set_process_id = p_set_process_id
4188: )

Line 4229: Ego_Flex_Value_Set_Intf evsi

4225: )
4226: AND EXISTS
4227: ( SELECT 1
4228: FROM Ego_Flex_Value_Intf evsvi,
4229: Ego_Flex_Value_Set_Intf evsi
4230: WHERE
4231: ( (p_set_process_id IS NULL
4232: OR evsvi.set_process_id = p_set_process_id
4233: )

Line 4276: FROM Ego_Flex_Value_Set_Intf

4272: -- Cursor to get Child value Set
4273: CURSOR Cur_Child_VS
4274: IS
4275: SELECT *
4276: FROM Ego_Flex_Value_Set_Intf
4277: WHERE (p_set_process_id IS NULL
4278: OR set_process_id = p_set_process_id
4279: )
4280: AND process_status=G_PROCESS_RECORD

Line 4302: FROM Ego_Flex_Value_Set_Intf evsi

4298: AND evsvi.version_seq_id IS NULL
4299: AND EXISTS
4300:
4301: ( SELECT 1
4302: FROM Ego_Flex_Value_Set_Intf evsi
4303: WHERE
4304: ( (p_set_process_id IS NULL
4305: OR evsi.set_process_id = p_set_process_id
4306: )

Line 4492: FROM Ego_Flex_Value_Set_Intf evsi

4488: )
4489: AND EXISTS
4490:
4491: ( SELECT 1
4492: FROM Ego_Flex_Value_Set_Intf evsi
4493: WHERE
4494: ( (p_set_process_id IS NULL
4495: OR evsi.set_process_id = p_set_process_id
4496: )

Line 4549: FROM Ego_Flex_Value_Set_Intf evsi

4545:
4546: AND EXISTS
4547:
4548: ( SELECT 1
4549: FROM Ego_Flex_Value_Set_Intf evsi
4550: WHERE
4551: ( (p_set_process_id IS NULL
4552: OR evsi.set_process_id = p_set_process_id
4553: )

Line 12004: DELETE FROM ego_flex_value_set_intf

12000:
12001: write_debug(G_PKG_Name,l_api_name,'Start of API. ');
12002: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||'Start of API. ');
12003:
12004: DELETE FROM ego_flex_value_set_intf
12005: WHERE process_status = G_SUCCESS_RECORD
12006: AND (p_set_process_id IS NULL
12007: OR set_process_id = p_set_process_id);
12008: