DBA Data[Home] [Help]

APPS.EGO_VS_BULKLOAD_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 1614: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1610: PROGRAM_UPDATE_DATE
1611: )
1612: SELECT
1613: evsi.transaction_id,
1614: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1615: NULL,
1616: NULL,
1617: G_ENTITY_VS_HEADER_TAB,
1618: l_err_message_name,

Line 1677: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1673: PROGRAM_UPDATE_DATE
1674: )
1675: SELECT
1676: evsvi.transaction_id,
1677: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1678: NULL,
1679: NULL,
1680: G_ENTITY_VAL_HEADER_TAB,
1681: l_err_message_name,

Line 1739: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1735: PROGRAM_UPDATE_DATE
1736: )
1737: SELECT
1738: evstvi.transaction_id,
1739: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1740: NULL,
1741: NULL,
1742: G_ENTITY_VAL_TL_HEADER_TAB,
1743: l_err_message_name,

Line 3152: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,

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,
3156: last_update_login=G_LOGIN_ID,

Line 3172: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,

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,
3176: last_update_login=G_LOGIN_ID,

Line 3194: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL ,

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,
3198: last_update_login= G_LOGIN_ID ,

Line 3383: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

3379: PROGRAM_UPDATE_DATE
3380: )
3381: SELECT
3382: evsi.transaction_id,
3383: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
3384: NULL,
3385: NULL,
3386: G_ENTITY_VS_HEADER_TAB,
3387: l_err_message_name,

Line 3446: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

3442: PROGRAM_UPDATE_DATE
3443: )
3444: SELECT
3445: evsvi.transaction_id,
3446: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
3447: NULL,
3448: NULL,
3449: G_ENTITY_VAL_HEADER_TAB,
3450: l_err_message_name,

Line 3508: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

3504: PROGRAM_UPDATE_DATE
3505: )
3506: SELECT
3507: evstvi.transaction_id,
3508: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
3509: NULL,
3510: NULL,
3511: G_ENTITY_VAL_TL_HEADER_TAB,
3512: l_err_message_name,

Line 4466: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

4462: PROGRAM_UPDATE_DATE
4463: )
4464: SELECT
4465: evsvi.transaction_id,
4466: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
4467: NULL,
4468: NULL,
4469: G_ENTITY_VAL_HEADER_TAB,
4470: G_BO_IDENTIFIER_VS,

Line 4618: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

4614: PROGRAM_UPDATE_DATE
4615: )
4616: SELECT
4617: evstvi.transaction_id,
4618: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
4619: NULL,
4620: NULL,
4621: G_ENTITY_VAL_TL_HEADER_TAB,
4622: G_BO_IDENTIFIER_VS,