[Home] [Help]
253: END UPDATE_SUBSET_RT_INFO;
254:
255: PROCEDURE CHECK_OUT_ENTRIES
256: (P_SERVER_ID IN NUMBER
257: ,P_RETURNS_ID_TAB IN SYSTEM.NUMBER_TBL_TYPE
258: )
259: AS
260:
261: ----------------------------------------------------------------
283: ,P_SCHEDULE_ID IN NUMBER
284: ,P_LIST_ID IN NUMBER
285: ,P_VIEW_NAME IN VARCHAR2
286: ,P_RLSE_CTRL_ALG_ID IN NUMBER
287: ,X_RETURNS_ID_TAB OUT NOCOPY SYSTEM.NUMBER_TBL_TYPE
288: ,X_RETURN_CODE IN OUT NOCOPY VARCHAR2
289: )
290: AS
291: CURSOR l_callback_query_cursor(L_LIST_ID NUMBER) IS
318: order by c.priority;
319: l_record_id NUMBER(15);
320: l_index BINARY_INTEGER := 0;
321: l_callback_count BINARY_INTEGER := 0;
322: l_returns_id_tab SYSTEM.NUMBER_TBL_TYPE;
323:
324: l_list_entry_id IEC_G_RETURN_ENTRIES.LIST_ENTRY_ID%TYPE;
325: l_subset_priority IEC_G_LIST_SUBSETS.PRIORITY%TYPE;
326: l_returns_id IEC_G_RETURN_ENTRIES.RETURNS_ID%TYPE;
333: -- Initialize the status string to send back to success.
334: ---------------------------------------------------------
335: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
336:
337: l_returns_id_tab := SYSTEM.NUMBER_TBL_TYPE();
338:
339: ---------------------------------------------------------
340: -- Check to see if the campaign is locked.
341: ---------------------------------------------------------
455: ,P_LIST_ID IN NUMBER
456: ,P_COUNT IN NUMBER
457: ,P_VIEW_NAME IN VARCHAR2
458: ,P_RLSE_CTRL_ALG_ID IN NUMBER
459: ,X_RETURNS_ID_TAB OUT NOCOPY SYSTEM.NUMBER_TBL_TYPE
460: ,X_RETURN_CODE IN OUT NOCOPY VARCHAR2
461: )
462: AS
463:
492:
493: l_record_id NUMBER(15);
494: l_index BINARY_INTEGER := 0;
495: l_callback_count BINARY_INTEGER := 0;
496: l_returns_id_tab SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();
497:
498: l_list_entry_id IEC_G_RETURN_ENTRIES.LIST_ENTRY_ID%TYPE;
499: l_subset_priority IEC_G_LIST_SUBSETS.PRIORITY%TYPE;
500: l_returns_id IEC_G_RETURN_ENTRIES.RETURNS_ID%TYPE;
631: ,P_COUNT IN NUMBER
632: ,P_RLSE_CTRL_ALG_ID IN IEC_G_EXECUTING_LISTS_V.RELEASE_CONTROL_ALG_ID%TYPE
633: ,P_VIEW_NAME IN VARCHAR2
634: ,X_RETURN_CODE IN OUT NOCOPY VARCHAR2
635: ,X_RETURNS_ID_TAB IN OUT NOCOPY SYSTEM.NUMBER_TBL_TYPE
636: )
637: AS
638:
639: CURSOR l_entry_query_cursor(L_SUBSET_ID NUMBER) IS
735: ,P_COUNT IN NUMBER
736: ,P_VIEW_NAME IN VARCHAR2
737: ,P_RLSE_CTRL_ALG_ID IN NUMBER
738: ,X_RETURN_CODE IN OUT NOCOPY VARCHAR2
739: ,X_RETURNS_ID_TAB IN OUT NOCOPY SYSTEM.NUMBER_TBL_TYPE
740: )
741: AS
742:
743: l_subset_priority_tbl SUBSET_PRIORITY;
753: l_subset_updated_tbl FLAG_COLLECTION;
754: l_subset_empty_tbl FLAG_COLLECTION;
755: l_entries_released_tbl QUOTA;
756:
757: l_reg_returns_id_tab SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();
758:
759: l_has_records NUMBER(1);
760:
761: l_fetch_records NUMBER(10) := 0;
1278: ,P_TARGET_GROUP_ID IN NUMBER
1279: ,P_COUNT IN NUMBER
1280: ,P_VIEW_NAME IN VARCHAR2
1281: ,P_RLSE_CTRL_ALG_ID IN NUMBER
1282: ,X_CACHE_RECORDS OUT NOCOPY SYSTEM.NUMBER_TBL_TYPE
1283: ,X_RETURN_CODE OUT NOCOPY VARCHAR2
1284: )
1285: AS
1286:
1285: AS
1286:
1287: l_result_code varchar2( 1 );
1288: l_count NUMBER := 0;
1289: l_returns_id_tab SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();
1290: l_return_code VARCHAR2(1);
1291: L_CALLBACK_AVAILABLE_COUNT NUMBER := 0;
1292: L_AVAILABLE_COUNT NUMBER := 0;
1293: L_CALLBACK_CHECKED_OUT_COUNT NUMBER := 0;