DBA Data[Home] [Help]

APPS.QA_CHART_GENERIC_PKG dependencies on FND_GLOBAL

Line 52: -- fnd_global.user_id,

48: -- line,
49: -- x_value,
50: -- y_value)
51: -- SELECT
52: -- fnd_global.user_id,
53: -- sysdate,
54: -- fnd_global.user_id,
55: -- sysdate,
56: -- fnd_global.login_id,

Line 54: -- fnd_global.user_id,

50: -- y_value)
51: -- SELECT
52: -- fnd_global.user_id,
53: -- sysdate,
54: -- fnd_global.user_id,
55: -- sysdate,
56: -- fnd_global.login_id,
57: -- :1,
58: -- rownum,' ||

Line 56: -- fnd_global.login_id,

52: -- fnd_global.user_id,
53: -- sysdate,
54: -- fnd_global.user_id,
55: -- sysdate,
56: -- fnd_global.login_id,
57: -- :1,
58: -- rownum,' ||
59: -- l_sql;
60: --

Line 67: -- (SELECT fnd_global.user_id, sysdate ... etc FROM dual),

63: -- Dev Notes: A different method has been investigated to
64: -- see if there is really a need to chop off the SELECT:
65: --
66: -- SELECT * FROM
67: -- (SELECT fnd_global.user_id, sysdate ... etc FROM dual),
68: -- ();
69: --
70: -- It seems to work, except there doesn't seem to be a way
71: -- to generate incremental line numbers for the line column.

Line 127: fnd_global.user_id, -- created_by

123: line,
124: x_value,
125: y_value)
126: VALUES (
127: fnd_global.user_id, -- created_by
128: sysdate, -- creation_date
129: fnd_global.user_id, -- last_updated_by
130: sysdate, -- last_update_date
131: fnd_global.login_id, -- last_update_login

Line 129: fnd_global.user_id, -- last_updated_by

125: y_value)
126: VALUES (
127: fnd_global.user_id, -- created_by
128: sysdate, -- creation_date
129: fnd_global.user_id, -- last_updated_by
130: sysdate, -- last_update_date
131: fnd_global.login_id, -- last_update_login
132: p_chart_id, -- chart_id
133: l_line_values(i), -- line

Line 131: fnd_global.login_id, -- last_update_login

127: fnd_global.user_id, -- created_by
128: sysdate, -- creation_date
129: fnd_global.user_id, -- last_updated_by
130: sysdate, -- last_update_date
131: fnd_global.login_id, -- last_update_login
132: p_chart_id, -- chart_id
133: l_line_values(i), -- line
134: l_x_values(i), -- x_value
135: l_y_values(i)); -- y_value