APPS.IEU_PVT dependencies on IEU_UWQ_SEL_MRT_DATA

Line 2058: (P_RESOURCE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.RESOURCE_ID%TYPE

2054:
2055:
2056: /* Used by UWQ Server to communicate Queue information to client. */
2057: PROCEDURE FORCE_UPDATE_MRT_DATA
2058: (P_RESOURCE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.RESOURCE_ID%TYPE
2059: ,P_SERVER_TYPE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.SVR_TYPE_ID%TYPE
2060: ,P_MEDIA_TYPE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.MEDIA_TYPE_ID%TYPE
2061: ,P_QUEUE_LIST IN SYSTEM.IEU_UWQ_SEL_MRT_QUEUES_NST
2062: )

Line 2059: ,P_SERVER_TYPE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.SVR_TYPE_ID%TYPE

2055:
2056: /* Used by UWQ Server to communicate Queue information to client. */
2057: PROCEDURE FORCE_UPDATE_MRT_DATA
2058: (P_RESOURCE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.RESOURCE_ID%TYPE
2059: ,P_SERVER_TYPE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.SVR_TYPE_ID%TYPE
2060: ,P_MEDIA_TYPE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.MEDIA_TYPE_ID%TYPE
2061: ,P_QUEUE_LIST IN SYSTEM.IEU_UWQ_SEL_MRT_QUEUES_NST
2062: )
2063: AS

Line 2060: ,P_MEDIA_TYPE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.MEDIA_TYPE_ID%TYPE

2056: /* Used by UWQ Server to communicate Queue information to client. */
2057: PROCEDURE FORCE_UPDATE_MRT_DATA
2058: (P_RESOURCE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.RESOURCE_ID%TYPE
2059: ,P_SERVER_TYPE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.SVR_TYPE_ID%TYPE
2060: ,P_MEDIA_TYPE_ID IN IEU.IEU_UWQ_SEL_MRT_DATA.MEDIA_TYPE_ID%TYPE
2061: ,P_QUEUE_LIST IN SYSTEM.IEU_UWQ_SEL_MRT_QUEUES_NST
2062: )
2063: AS
2064: BEGIN

Line 2100: UPDATE IEU_UWQ_SEL_MRT_DATA

2096: --
2097: -- Ray Cardillo (01/24/2000)
2098: --
2099:
2100: UPDATE IEU_UWQ_SEL_MRT_DATA
2101: SET
2102: NOT_VALID = 'Y',
2103: LAST_UPDATE_DATE = SYSDATE
2104: WHERE

Line 2133: UPDATE IEU_UWQ_SEL_MRT_DATA

2129:
2130: -- Added condition for NULL QUEUE_NAME in the where clause because NULL
2131: -- names could not be compared and the update clause always ended up
2132: -- adding new rows to the table when the queue name was NULL
2133: UPDATE IEU_UWQ_SEL_MRT_DATA
2134: SET
2135: NOT_VALID = NULL,
2136: LAST_UPDATE_DATE = SYSDATE,
2137: QUEUE_COUNT = P_QUEUE_LIST(i).QUEUE_COUNT,

Line 2155: INSERT INTO IEU_UWQ_SEL_MRT_DATA

2151: --
2152:
2153: IF (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) THEN
2154:
2155: INSERT INTO IEU_UWQ_SEL_MRT_DATA
2156: ( SEL_MRT_ID,
2157: RESOURCE_ID,
2158: SVR_TYPE_ID,
2159: MEDIA_TYPE_ID,

Line 2166: IEU_UWQ_SEL_MRT_DATA_S1.NEXTVAL,

2162: QUEUE_NAME,
2163: QUEUE_COUNT,
2164: PROVIDER_REF )
2165: VALUES (
2166: IEU_UWQ_SEL_MRT_DATA_S1.NEXTVAL,
2167: P_RESOURCE_ID,
2168: P_SERVER_TYPE_ID,
2169: P_MEDIA_TYPE_ID,
2170: SYSDATE,