DBA Data[Home] [Help]

APPS.QA_BIS dependencies on STANDARD

Line 77: -- Standard who columns.

73: --
74: g_current_datetime date;
75:
76: --
77: -- Standard who columns.
78: --
79: who_user_id constant number := fnd_global.conc_login_id;
80: who_request_id constant number := fnd_global.conc_request_id;
81: who_last_update_login constant number := fnd_global.conc_login_id;

Line 172: -- Notes on coding standard:

168: -- or an index on qa_last_update_date (preferrable)
169: --
170: -- . QA_BIS_RESULTS must have a unique index on occurrence.
171: --
172: -- Notes on coding standard:
173: -- . Never use WHO columns to quality rows for processing.
174: -- Coding Standards R10SC p. 3-4.
175: -- Therefore, qa_last_update_date is used instead.
176: --

Line 174: -- Coding Standards R10SC p. 3-4.

170: -- . QA_BIS_RESULTS must have a unique index on occurrence.
171: --
172: -- Notes on coding standard:
173: -- . Never use WHO columns to quality rows for processing.
174: -- Coding Standards R10SC p. 3-4.
175: -- Therefore, qa_last_update_date is used instead.
176: --
177: BEGIN
178: DELETE

Line 277: -- :w1 to :w9 standard who columns

273: --
274: -- The final sql statement looks like this:
275: --
276: -- SELECT
277: -- :w1 to :w9 standard who columns
278: -- qr.organization_id,
279: -- 'decoded by view' organization_name,
280: -- qr.plan_id,
281: -- qr.collection_id,