DBA Data[Home] [Help]

APPS.QP_LOADER_DIST_PUB dependencies on QP_PRC_CONTEXTS_TL

Line 66: update qp_prc_contexts_tl set

62: --Bug#5237456 RAVI
63: --Seeded data does not contain application ID
64: -- if x_application_id = '661' then
65:
66: update qp_prc_contexts_tl set
67: user_prc_context_name = decode(seeded_prc_context_name, user_prc_context_name, x_seeded_prc_context_name, user_prc_context_name),
68: --seeded_prc_context_name = nvl(seeded_prc_context_name, x_seeded_prc_context_name),
69: seeded_prc_context_name = nvl(x_seeded_prc_context_name, seeded_prc_context_name),
70: user_description = decode(seeded_description, user_description, x_seeded_description, user_description),

Line 129: update qp_prc_contexts_tl set

125: last_update_date = nvl(to_date(x_last_update_date,'YYYY/MM/DD'),sysdate),
126: last_update_login = 0
127: where prc_context_id = l_prc_context_id;
128:
129: update qp_prc_contexts_tl set
130: user_prc_context_name = decode(seeded_prc_context_name, user_prc_context_name, x_seeded_prc_context_name, user_prc_context_name),
131: seeded_prc_context_name = nvl(seeded_prc_context_name, x_seeded_prc_context_name),
132: user_description = decode(seeded_description, user_description, x_seeded_description, user_description),
133: seeded_description = nvl(seeded_description, x_seeded_description),

Line 171: insert into qp_prc_contexts_tl (

167: l_user_id
168: );
169: commit;
170:
171: insert into qp_prc_contexts_tl (
172: prc_context_id,
173: seeded_prc_context_name,
174: user_prc_context_name,
175: seeded_description,

Line 201: from qp_prc_contexts_tl t

197: from fnd_languages l
198: where l.installed_flag in ('I', 'B')
199: and not exists
200: (select null
201: from qp_prc_contexts_tl t
202: where t.prc_context_id = l_prc_context_id
203: and t.language = l.language_code);
204: commit;
205: exception