DBA Data[Home] [Help]

APPS.QA_CHART_HEADERS_PKG dependencies on QA_CHART_HEADERS

Line 1: PACKAGE BODY qa_chart_headers_pkg AS

1: PACKAGE BODY qa_chart_headers_pkg AS
2: /* $Header: qachartb.pls 120.1 2006/03/20 10:51:15 bso noship $ */
3:
4: --
5: -- Tracking Bug 4939897

Line 11: -- Create a new record in qa_chart_headers. Return

7: --
8:
9: PROCEDURE create_chart(
10: --
11: -- Create a new record in qa_chart_headers. Return
12: -- the newly generated chart header ID in x_chart_id.
13: --
14: -- bso Mon Jan 9 15:19:52 PST 2006
15: --

Line 24: INSERT INTO qa_chart_headers(

20: p_y_label VARCHAR2,
21: x_chart_id OUT NOCOPY NUMBER) IS
22:
23: BEGIN
24: INSERT INTO qa_chart_headers(
25: created_by,
26: creation_date,
27: last_updated_by,
28: last_update_date,

Line 42: qa_chart_headers_s.nextval,

38: sysdate,
39: fnd_global.user_id,
40: sysdate,
41: fnd_global.login_id,
42: qa_chart_headers_s.nextval,
43: p_criteria_id,
44: p_title,
45: p_description,
46: p_x_label,

Line 74: FROM qa_chart_headers

70: -- First delete the header, get the criteria ID FK as a
71: -- side effect.
72: --
73: DELETE
74: FROM qa_chart_headers
75: WHERE chart_id = p_chart_id
76: RETURNING criteria_id
77: INTO l_criteria_id;
78:

Line 170: UPDATE qa_chart_headers

166:
167:
168: PROCEDURE set_x_label(p_chart_id NUMBER, p_label VARCHAR2) IS
169: BEGIN
170: UPDATE qa_chart_headers
171: SET x_label = p_label
172: WHERE chart_id = p_chart_id;
173: END set_x_label;
174:

Line 178: UPDATE qa_chart_headers

174:
175:
176: PROCEDURE set_y_label(p_chart_id NUMBER, p_label VARCHAR2) IS
177: BEGIN
178: UPDATE qa_chart_headers
179: SET y_label = p_label
180: WHERE chart_id = p_chart_id;
181: END set_y_label;
182:

Line 206: END qa_chart_headers_pkg;

202: RETURN fnd_message.get;
203: END IF;
204: END get_function_axis_label;
205:
206: END qa_chart_headers_pkg;