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_INTF

Line 99: G_ENTITY_VAL_HEADER_TAB CONSTANT VARCHAR2(240) := 'EGO_FLEX_VALUE_INTF';

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: --------------------------------------------------------------
103: -- The Object Name for locking and object. --

Line 1445: UPDATE Ego_Flex_Value_Intf evsvi

1441: -- Update transaction type for value inteface table.
1442: ---------------------------------------------------
1443:
1444: -- Create Mode Value.
1445: UPDATE Ego_Flex_Value_Intf evsvi
1446: SET evsvi.transaction_type= G_CREATE,
1447: evsvi.last_updated_by = g_user_id,
1448: evsvi.last_update_date = SYSDATE,
1449: evsvi.last_update_login = g_login_id

Line 1468: UPDATE Ego_Flex_Value_Intf EVSV

1464: )
1465: AND Upper(transaction_type) =G_SYNC;
1466:
1467: -- Update Mode Value.
1468: UPDATE Ego_Flex_Value_Intf EVSV
1469: SET EVSV.transaction_type= G_UPDATE ,
1470: last_updated_by = g_user_id,
1471: last_update_date = SYSDATE,
1472: last_update_login = g_login_id

Line 1511: Ego_Flex_Value_Intf EVSV

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
1515: AND evs.value_set_name= EVSV.value_set_name

Line 1651: -- Insert record for invalida transaction type for table EGO_FLEX_VALUE_INTF

1647:
1648:
1649:
1650:
1651: -- Insert record for invalida transaction type for table EGO_FLEX_VALUE_INTF
1652: INSERT
1653: INTO
1654: MTL_INTERFACE_ERRORS
1655: (

Line 1694: FROM Ego_Flex_Value_Intf evsvi

1690: G_REQUEST_ID,
1691: NVL(PROGRAM_APPLICATION_ID, G_PROG_APPL_ID),
1692: NVL(PROGRAM_ID, G_PROGRAM_ID),
1693: NVL(PROGRAM_UPDATE_DATE, sysdate)
1694: FROM Ego_Flex_Value_Intf evsvi
1695: WHERE (p_set_process_id IS NULL
1696: OR set_process_id = p_set_process_id
1697: )
1698: AND Upper(transaction_type) NOT IN (G_CREATE, G_UPDATE,G_SYNC)

Line 1703: UPDATE Ego_Flex_Value_Intf

1699: AND process_status=G_PROCESS_RECORD;
1700:
1701:
1702: -- Set process_status for invalid transaction_type.
1703: UPDATE Ego_Flex_Value_Intf
1704: SET process_status=G_ERROR_RECORD
1705: WHERE (p_set_process_id IS NULL
1706: OR set_process_id = p_set_process_id
1707: )

Line 2966: UPDATE Ego_Flex_Value_Intf

2962:
2963:
2964:
2965: FORALL i IN p_valueset_val_tbl.first..p_valueset_val_tbl.last
2966: UPDATE Ego_Flex_Value_Intf
2967: SET ROW = p_valueset_val_tbl(i)
2968: WHERE transaction_id = l_trans_id(i);
2969:
2970: END IF;

Line 3171: UPDATE Ego_Flex_Value_Intf

3167: AND process_status=G_PROCESS_RECORD;
3168:
3169:
3170: -- Update value for transaction_id and transaction_type in value interface table.
3171: UPDATE Ego_Flex_Value_Intf
3172: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,
3173: transaction_type = Upper(transaction_type),
3174: last_updated_by = G_USER_ID,
3175: last_update_date =sysdate,

Line 3463: FROM Ego_Flex_Value_Intf evsvi

3459: G_REQUEST_ID,
3460: NVL(PROGRAM_APPLICATION_ID, G_PROG_APPL_ID),
3461: NVL(PROGRAM_ID, G_PROGRAM_ID),
3462: NVL(PROGRAM_UPDATE_DATE, sysdate)
3463: FROM Ego_Flex_Value_Intf evsvi
3464: WHERE (p_set_process_id IS NULL
3465: OR set_process_id = p_set_process_id
3466: )
3467: AND process_status=G_PROCESS_RECORD

Line 3472: UPDATE Ego_Flex_Value_Intf

3468: AND version_seq_id IS NOT NULL;
3469:
3470:
3471: -- Error out version related records
3472: UPDATE Ego_Flex_Value_Intf
3473: SET process_status=G_ERROR_RECORD
3474: WHERE (p_set_process_id IS NULL
3475: OR set_process_id = p_set_process_id
3476: )

Line 3926: FROM Ego_Flex_Value_Intf evsvi

3922: -- Get values.
3923: CURSOR Cur_Non_Vers_Values
3924: IS
3925: SELECT *
3926: FROM Ego_Flex_Value_Intf evsvi
3927: WHERE (p_set_process_id IS NULL
3928: OR evsvi.set_process_id = p_set_process_id
3929: )
3930: AND evsvi.process_status=G_PROCESS_RECORD

Line 4002: FROM Ego_Flex_Value_Intf evsvi,

3998:
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

Line 4034: FROM Ego_Flex_Value_Intf evsvi,

4030: )
4031: UNION
4032:
4033: SELECT 1
4034: FROM Ego_Flex_Value_Intf evsvi,
4035: Fnd_Flex_Value_Sets ffvs
4036: WHERE
4037: ( (p_set_process_id IS NULL
4038: OR evsvi.set_process_id = null

Line 4085: FROM Ego_Flex_Value_Intf evsvi

4081: -- Cursor to get orphan value record
4082: CURSOR Cur_Orphan_val
4083: IS
4084: SELECT *
4085: FROM Ego_Flex_Value_Intf evsvi
4086: WHERE (p_set_process_id IS NULL
4087: OR evsvi.set_process_id = p_set_process_id
4088: )
4089: AND evsvi.process_status=G_PROCESS_RECORD

Line 4171: FROM Ego_Flex_Value_Intf evsvi

4167: cp_value_set_id NUMBER,
4168: cp_version_seq_id NUMBER)
4169: IS
4170: SELECT *
4171: FROM Ego_Flex_Value_Intf evsvi
4172: WHERE (p_set_process_id IS NULL
4173: OR evsvi.set_process_id = p_set_process_id
4174: )
4175: AND evsvi.process_status=G_PROCESS_RECORD

Line 4228: FROM Ego_Flex_Value_Intf evsvi,

4224: evstvi.flex_value_id = cp_flex_value_id
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

Line 4293: FROM Ego_Flex_Value_Intf evsvi

4289:
4290: CURSOR Cur_Child_Values
4291: IS
4292: SELECT *
4293: FROM Ego_Flex_Value_Intf evsvi
4294: WHERE (p_set_process_id IS NULL
4295: OR evsvi.set_process_id = p_set_process_id
4296: )
4297: AND evsvi.process_status=G_PROCESS_RECORD

Line 4483: FROM Ego_Flex_Value_Intf evsvi

4479: G_REQUEST_ID,
4480: NVL(PROGRAM_APPLICATION_ID, G_PROG_APPL_ID),
4481: NVL(PROGRAM_ID, G_PROGRAM_ID),
4482: NVL(PROGRAM_UPDATE_DATE, sysdate)
4483: FROM Ego_Flex_Value_Intf evsvi
4484: WHERE
4485: (
4486: ( p_set_process_id IS NULL
4487: OR evsvi.set_process_id = p_set_process_id

Line 4534: UPDATE ego_flex_value_intf evsvi

4530:
4531:
4532:
4533: -- Before processing value table, Update process flag in value intf table with status 3 for those record which has failed to process
4534: UPDATE ego_flex_value_intf evsvi
4535: SET evsvi.process_status=G_ERROR_RECORD,
4536: evsvi.LAST_UPDATED_BY= G_User_Id,
4537: evsvi.LAST_UPDATE_DATE = SYSDATE,
4538: evsvi.LAST_UPDATE_LOGIN = G_LOGIN_ID

Line 4643: FROM Ego_Flex_Value_Intf evsvi

4639: OR evstvi.set_process_id = p_set_process_id
4640: )
4641: AND EXISTS
4642: ( SELECT 1
4643: FROM Ego_Flex_Value_Intf evsvi
4644: WHERE
4645: ( (p_set_process_id IS NULL
4646: OR evsvi.set_process_id = p_set_process_id
4647: )

Line 4680: FROM Ego_Flex_Value_Intf evsvi

4676: OR evstvi.set_process_id = p_set_process_id
4677: )
4678: AND EXISTS
4679: ( SELECT 1
4680: FROM Ego_Flex_Value_Intf evsvi
4681: WHERE
4682: ( (p_set_process_id IS NULL
4683: OR evsvi.set_process_id = p_set_process_id
4684: )

Line 12012: DELETE FROM ego_flex_value_intf

12008:
12009: write_debug(G_PKG_Name,l_api_name,'Deleted data from value Set Table ');
12010: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||'Deleted data from value Set Table ');
12011:
12012: DELETE FROM ego_flex_value_intf
12013: WHERE process_status = G_SUCCESS_RECORD
12014: AND (p_set_process_id IS NULL
12015: OR set_process_id = p_set_process_id);
12016: