APPS.BIX_UWQ_TEMP_PKG dependencies on BIX_DM_BIN

Line 116: --This procedure populates the BIX_DM_BIN table for the UWQ Activity bin.

112: END get_param_values;
113:
114: PROCEDURE POPULATE_BIN (p_context IN VARCHAR2 DEFAULT NULL)
115: --
116: --This procedure populates the BIX_DM_BIN table for the UWQ Activity bin.
117: --
118: IS
119:
120: v_max_date DATE;

Line 154: delete from bix_dm_bin

150:
151: v_session_id := NULL;
152: v_session_id := icx_sec.g_session_id; -- this is used to insert the session id
153:
154: delete from bix_dm_bin
155: where bin_code = 'BIX_UWQ_ACTIVITY_BIN'
156: and session_id = v_session_id;
157:
158: commit;

Line 214: INSERT INTO bix_dm_bin (bin_code, col2, col3, col4, col5, col6, session_id)

210: --
211: --Now we have one resource id. Find the login and duration information for this agent.
212: --
213:
214: INSERT INTO bix_dm_bin (bin_code, col2, col3, col4, col5, col6, session_id)
215: SELECT 'BIX_UWQ_ACTIVITY_BIN',
216: rec_child_agents.RNAME,
217: 'A'||to_char(v_max_date,'DD-MON-YYYY')||rec_child_agents.RID,
218: DAY_LOGIN,

Line 238: INSERT INTO bix_dm_bin (bin_code, col2, col3, col4, col5, col6, session_id)

234:
235: FOR rec_child_groups IN c_child_groups(v_default_group_id)
236: LOOP
237:
238: INSERT INTO bix_dm_bin (bin_code, col2, col3, col4, col5, col6, session_id)
239: SELECT 'BIX_UWQ_ACTIVITY_BIN',
240: vl.group_name,
241: 'G'||to_char(v_max_date,'DD-MON-YYYY')||rec_child_groups.GID,
242: DAY_LOGIN,