APPS.IEC_RECORD_FILTER_PVT dependencies on IEC_G_RETURN_ENTRIES

Line 68: -- the DO_NOT_USE_FLAG to 'N' in IEC_G_RETURN_ENTRIES. Report counts

64: -- API name : Make_ListEntriesAvailable
65: -- Type : Private
66: -- Pre-reqs : None
67: -- Function : Makes list entries with specified do not use reason available by setting
68: -- the DO_NOT_USE_FLAG to 'N' in IEC_G_RETURN_ENTRIES. Report counts
69: -- are updated to reflect that these entries are now available.
70: --
71: -- Parameters : p_list_header_id IN NUMBER Required
72: -- p_dnu_reason_code IN NUMBER Required

Line 101: FROM IEC_G_RETURN_ENTRIES

97: IF p_dnu_reason_code IS NOT NULL THEN
98:
99: SELECT RETURNS_ID, ITM_CC_TZ_ID
100: BULK COLLECT INTO l_returns_ids, l_itm_cc_tz_ids
101: FROM IEC_G_RETURN_ENTRIES
102: WHERE LIST_HEADER_ID = P_LIST_HEADER_ID AND DO_NOT_USE_FLAG = 'Y' AND DO_NOT_USE_REASON = P_DNU_REASON_CODE;
103:
104: ELSE
105:

Line 108: FROM IEC_G_RETURN_ENTRIES

104: ELSE
105:
106: SELECT RETURNS_ID, ITM_CC_TZ_ID
107: BULK COLLECT INTO l_returns_ids, l_itm_cc_tz_ids
108: FROM IEC_G_RETURN_ENTRIES
109: WHERE LIST_HEADER_ID = P_LIST_HEADER_ID AND DO_NOT_USE_FLAG = 'Y';
110:
111: END IF;
112:

Line 116: UPDATE IEC_G_RETURN_ENTRIES

112:
113: IF l_returns_ids IS NOT NULL AND l_returns_ids.COUNT > 0 THEN
114:
115: FORALL I IN l_returns_ids.FIRST..l_returns_ids.LAST
116: UPDATE IEC_G_RETURN_ENTRIES
117: SET DO_NOT_USE_FLAG = 'N'
118: , DO_NOT_USE_REASON = NULL
119: WHERE RETURNS_ID = l_returns_ids(I);
120: