123: END IF;
124:
125: l_stmt_id := 20;
126: -- Package level variables for the user logged in
127: s_user_id := nvl(fnd_global.user_id, -1);
128: s_login_id := nvl(fnd_global.login_id, -1);
129: s_program_id := nvl (fnd_global.conc_program_id, -1);
130: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
131: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
124:
125: l_stmt_id := 20;
126: -- Package level variables for the user logged in
127: s_user_id := nvl(fnd_global.user_id, -1);
128: s_login_id := nvl(fnd_global.login_id, -1);
129: s_program_id := nvl (fnd_global.conc_program_id, -1);
130: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
131: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
132: s_request_id := nvl (fnd_global.conc_request_id, -1);
125: l_stmt_id := 20;
126: -- Package level variables for the user logged in
127: s_user_id := nvl(fnd_global.user_id, -1);
128: s_login_id := nvl(fnd_global.login_id, -1);
129: s_program_id := nvl (fnd_global.conc_program_id, -1);
130: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
131: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
132: s_request_id := nvl (fnd_global.conc_request_id, -1);
133:
126: -- Package level variables for the user logged in
127: s_user_id := nvl(fnd_global.user_id, -1);
128: s_login_id := nvl(fnd_global.login_id, -1);
129: s_program_id := nvl (fnd_global.conc_program_id, -1);
130: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
131: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
132: s_request_id := nvl (fnd_global.conc_request_id, -1);
133:
134: l_stmt_id := 30;
127: s_user_id := nvl(fnd_global.user_id, -1);
128: s_login_id := nvl(fnd_global.login_id, -1);
129: s_program_id := nvl (fnd_global.conc_program_id, -1);
130: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
131: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
132: s_request_id := nvl (fnd_global.conc_request_id, -1);
133:
134: l_stmt_id := 30;
135: -- Get the weight reporting UOM.
128: s_login_id := nvl(fnd_global.login_id, -1);
129: s_program_id := nvl (fnd_global.conc_program_id, -1);
130: s_program_login_id := nvl (fnd_global.conc_login_id, -1);
131: s_program_application_id := nvl (fnd_global.prog_appl_id, -1);
132: s_request_id := nvl (fnd_global.conc_request_id, -1);
133:
134: l_stmt_id := 30;
135: -- Get the weight reporting UOM.
136: OPEN get_rep_uom_csr (C_WT_MEASURE_CODE);