APPS.IEC_CPN_RLSE_STTGY_PVT dependencies on IEC_G_LIST_SUBSETS

Line 52: L_STATUS_CODE IEC_G_LIST_SUBSETS.STATUS_CODE%TYPE;

48: L_STILL_CALLABLE BINARY_INTEGER;
49: L_CALLBACK_FLAG IEC_G_RETURN_ENTRIES.CALLBACK_FLAG%TYPE;
50: L_CHECKED_OUT_FLAG IEC_G_RETURN_ENTRIES.RECORD_OUT_FLAG%TYPE;
51: L_CALLBACK_EXPIRATION BINARY_INTEGER;
52: L_STATUS_CODE IEC_G_LIST_SUBSETS.STATUS_CODE%TYPE;
53: L_GROUP_COUNT NUMBER;
54:
55: L_CALLBACK_AVAILABLE_COUNT NUMBER := 0;
56: L_AVAILABLE_COUNT NUMBER := 0;

Line 75: , iec_g_list_subsets c

71: , c.status_code
72: , count(*)
73: from iec_g_return_entries a
74: , iec_g_mktg_item_Cc_tzs b
75: , iec_g_list_subsets c
76: where a.list_header_id = L_LIST_ID
77: and a.list_header_id = c.list_header_id
78: and a.itm_cc_Tz_id = b.itm_cc_tz_id
79: and a.do_not_use_Flag = 'N'

Line 297: , iec_g_list_subsets c

293: d.list_entry_id,
294: d.returns_id,
295: c.priority
296: from iec_g_return_entries d
297: , iec_g_list_subsets c
298: where itm_cc_tz_id in
299: ( select itm_cc_tz_id
300: from iec_g_mktg_item_cc_tzs
301: where subset_id in

Line 303: from iec_g_list_Subsets a

299: ( select itm_cc_tz_id
300: from iec_g_mktg_item_cc_tzs
301: where subset_id in
302: ( select a.list_Subset_id
303: from iec_g_list_Subsets a
304: , iec_g_subset_rt_info b
305: where a.list_header_id = L_LIST_ID
306: and a.list_subset_id = b.list_subset_id
307: and b.working_quota > 0

Line 325: l_subset_priority IEC_G_LIST_SUBSETS.PRIORITY%TYPE;

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;
327: l_callable_flag VARCHAR2(1);
328: l_return_code VARCHAR2(1);
329: l_error_code NUMBER;

Line 470: , iec_g_list_subsets c

466: d.list_entry_id,
467: d.returns_id,
468: c.priority
469: from iec_g_return_entries d
470: , iec_g_list_subsets c
471: where itm_cc_tz_id in
472: ( select itm_cc_tz_id
473: from iec_g_mktg_item_cc_tzs
474: where subset_id in

Line 476: from iec_g_list_Subsets a

472: ( select itm_cc_tz_id
473: from iec_g_mktg_item_cc_tzs
474: where subset_id in
475: ( select a.list_Subset_id
476: from iec_g_list_Subsets a
477: , iec_g_subset_rt_info b
478: where a.list_header_id = L_LIST_ID
479: and a.list_subset_id = b.list_subset_id
480: and b.working_quota > 0

Line 499: l_subset_priority IEC_G_LIST_SUBSETS.PRIORITY%TYPE;

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;
501: l_callable_flag VARCHAR2(1);
502: l_return_code VARCHAR2(1);
503: l_error_code NUMBER;

Line 834: FROM iec_g_list_subsets a

830: , l_quantum_tbl
831: , l_quota_reset_time_tbl
832: , l_use_flag_tbl
833: , l_quota_reset_tbl
834: FROM iec_g_list_subsets a
835: , iec_g_subset_rt_info b
836: WHERE a.list_header_id = P_LIST_HEADER_ID
837: AND a.list_subset_id = b.list_subset_id
838: AND b.valid_flag = 'Y'