APPS.EGO_VS_BULKLOAD_PVT dependencies on EGO_FLEX_VALUE_TL_INTF

Line 100: G_ENTITY_VAL_TL_HEADER_TAB CONSTANT VARCHAR2(240) := 'EGO_FLEX_VALUE_TL_INTF';

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. --
104: --------------------------------------------------------------

Line 1499: UPDATE Ego_Flex_Value_Tl_Intf EVSTV

1495: -- Update transaction type for translatable value inteface table.
1496: ---------------------------------------------------
1497:
1498: -- Create Mode translatable values.
1499: UPDATE Ego_Flex_Value_Tl_Intf EVSTV
1500: SET transaction_type= G_CREATE
1501: WHERE (p_set_process_id IS NULL
1502: OR set_process_id = p_set_process_id
1503: )

Line 1523: UPDATE Ego_Flex_Value_Tl_Intf EVSTV

1519: AND Upper(transaction_type) =G_SYNC;
1520:
1521:
1522: -- Update Mode translatable values.
1523: UPDATE Ego_Flex_Value_Tl_Intf EVSTV
1524: SET transaction_type= G_UPDATE,
1525: last_updated_by = g_user_id,
1526: last_update_date = SYSDATE,
1527: last_update_login = g_login_id

Line 1713: -- Insert record for invalida transaction type in EGO_FLEX_VALUE_TL_INTF

1709:
1710:
1711:
1712:
1713: -- Insert record for invalida transaction type in EGO_FLEX_VALUE_TL_INTF
1714: INSERT
1715: INTO
1716: MTL_INTERFACE_ERRORS
1717: (

Line 1756: FROM Ego_Flex_Value_Tl_Intf evstvi

1752: G_REQUEST_ID,
1753: NVL(PROGRAM_APPLICATION_ID, G_PROG_APPL_ID),
1754: NVL(PROGRAM_ID, G_PROGRAM_ID),
1755: NVL(PROGRAM_UPDATE_DATE, sysdate)
1756: FROM Ego_Flex_Value_Tl_Intf evstvi
1757: WHERE (p_set_process_id IS NULL
1758: OR set_process_id = p_set_process_id
1759: )
1760: AND Upper(transaction_type) NOT IN (G_CREATE, G_UPDATE,G_SYNC)

Line 1766: UPDATE Ego_Flex_Value_Tl_Intf

1762:
1763:
1764:
1765: -- Check transaction_type in translatable value table.
1766: UPDATE Ego_Flex_Value_Tl_Intf
1767: SET process_status=G_ERROR_RECORD
1768: WHERE (p_set_process_id IS NULL
1769: OR set_process_id = p_set_process_id
1770: )

Line 3023: UPDATE Ego_Flex_Value_Tl_Intf

3019:
3020:
3021:
3022: FORALL i IN p_valueset_val_tl_tbl.first..p_valueset_val_tl_tbl.last
3023: UPDATE Ego_Flex_Value_Tl_Intf
3024: SET ROW = p_valueset_val_tl_tbl(i)
3025: WHERE transaction_id = l_trans_id(i);
3026:
3027:

Line 3032: UPDATE Ego_Flex_Value_Tl_Intf

3028:
3029:
3030:
3031: /*FORALL i IN p_valueset_val_tl_tbl.first..p_valueset_val_tl_tbl.last
3032: UPDATE Ego_Flex_Value_Tl_Intf
3033: SET value_set_id = p_valueset_val_tl_tbl(i).value_set_id,
3034: value_set_name = p_valueset_val_tl_tbl(i).value_set_name,
3035: flex_value = p_valueset_val_tl_tbl(i).flex_value,
3036: flex_value_id = p_valueset_val_tl_tbl(i).flex_value_id,

Line 3193: UPDATE Ego_Flex_Value_Tl_Intf

3189: AND process_status=G_PROCESS_RECORD;
3190:
3191:
3192: -- Update value for transaction_id in translatable value interface table.
3193: UPDATE Ego_Flex_Value_Tl_Intf
3194: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL ,
3195: transaction_type = Upper(transaction_type),
3196: last_updated_by = G_USER_ID,
3197: last_update_date = SYSDATE,

Line 3525: FROM Ego_Flex_Value_Tl_Intf evstvi

3521: G_REQUEST_ID,
3522: NVL(PROGRAM_APPLICATION_ID, G_PROG_APPL_ID),
3523: NVL(PROGRAM_ID, G_PROGRAM_ID),
3524: NVL(PROGRAM_UPDATE_DATE, sysdate)
3525: FROM Ego_Flex_Value_Tl_Intf evstvi
3526: WHERE (p_set_process_id IS NULL
3527: OR set_process_id = p_set_process_id
3528: )
3529: AND process_status=G_PROCESS_RECORD

Line 3535: UPDATE Ego_Flex_Value_Tl_Intf

3531:
3532:
3533:
3534: -- Error out version related records
3535: UPDATE Ego_Flex_Value_Tl_Intf
3536: SET process_status=G_ERROR_RECORD
3537: WHERE (p_set_process_id IS NULL
3538: OR set_process_id = p_set_process_id
3539: )

Line 3983: FROM Ego_Flex_Value_tl_Intf evstvi

3979: cp_language_code VARCHAR2 )
3980:
3981: IS
3982: SELECT *
3983: FROM Ego_Flex_Value_tl_Intf evstvi
3984: WHERE
3985: (
3986: ( p_set_process_id IS NULL
3987: OR evstvi.set_process_id = p_set_process_id

Line 4101: FROM Ego_Flex_Value_tl_Intf evstvi

4097: -- Cursor to get orphan translatable values
4098: CURSOR Cur_Orphan_Trans_Values (cp_language_code VARCHAR2 )
4099: IS
4100: SELECT *
4101: FROM Ego_Flex_Value_tl_Intf evstvi
4102: WHERE
4103: (
4104: ( p_set_process_id IS NULL
4105: OR evstvi.set_process_id = p_set_process_id

Line 4210: FROM Ego_Flex_Value_tl_Intf evstvi

4206: cp_flex_value VARCHAR2,
4207: cp_flex_value_id NUMBER )
4208: IS
4209: SELECT *
4210: FROM Ego_Flex_Value_tl_Intf evstvi
4211: WHERE
4212: (
4213: ( p_set_process_id IS NULL
4214: OR evstvi.set_process_id = p_set_process_id

Line 4635: FROM Ego_Flex_Value_Tl_Intf evstvi

4631: G_REQUEST_ID,
4632: NVL(PROGRAM_APPLICATION_ID, G_PROG_APPL_ID),
4633: NVL(PROGRAM_ID, G_PROGRAM_ID),
4634: NVL(PROGRAM_UPDATE_DATE, sysdate)
4635: FROM Ego_Flex_Value_Tl_Intf evstvi
4636: WHERE
4637: (
4638: ( p_set_process_id IS NULL
4639: OR evstvi.set_process_id = p_set_process_id

Line 4668: UPDATE Ego_Flex_Value_Tl_Intf evstvi

4664:
4665:
4666:
4667: -- Before processing value table, Update process flag in value intf table with status 3 for those record which has failed to process
4668: UPDATE Ego_Flex_Value_Tl_Intf evstvi
4669: SET evstvi.process_status=G_ERROR_RECORD,
4670: evstvi.LAST_UPDATED_BY= G_User_Id,
4671: evstvi.LAST_UPDATE_DATE = SYSDATE,
4672: evstvi.LAST_UPDATE_LOGIN = G_LOGIN_ID

Line 12020: DELETE FROM ego_flex_value_tl_intf

12016:
12017: write_debug(G_PKG_Name,l_api_name,' Deleted data from Value Table');
12018: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Deleted data from Value Table');
12019:
12020: DELETE FROM ego_flex_value_tl_intf
12021: WHERE process_status = G_SUCCESS_RECORD
12022: AND (p_set_process_id IS NULL
12023: OR set_process_id = p_set_process_id);
12024: