APPS.PA_REPORT_TYPES_PUB dependencies on PA_REPORT_TYPES

Line 1: package body PA_REPORT_TYPES_PUB as

1: package body PA_REPORT_TYPES_PUB as
2: /* $Header: PARTYPPB.pls 120.1 2005/08/19 17:02:31 mwasowic noship $ */
3:
4: PROCEDURE CREATE_REPORT_TYPE
5: (

Line 31: PA_DEBUG.init_err_stack('PA_REPORT_TYPES_PUB.Create_Report_Type');

27: l_dummy varchar2(1) := 'N';
28: l_msg_index_out number;
29: BEGIN
30: -- Initialize the Error Stack
31: PA_DEBUG.init_err_stack('PA_REPORT_TYPES_PUB.Create_Report_Type');
32:
33: -- Initialize the return status to success
34: x_return_status := 'S';
35:

Line 54: from pa_report_types

50: else
51: begin
52: select 'Y'
53: into l_dummy
54: from pa_report_types
55: where upper(name) = upper(p_name);
56: exception when no_data_found then
57: null;
58: end;

Line 74: pa_report_Types_utils.get_page_id_from_layout(p_init_msg_list => 'F',

70: ,p_msg_name => 'PA_PAGE_LAYOUT_NAME_INV');
71: x_return_status := 'E';
72: else
73: --- get page_id from page layout
74: pa_report_Types_utils.get_page_id_from_layout(p_init_msg_list => 'F',
75: p_page_layout => p_page_layout,
76: x_page_id => l_page_id,
77: x_return_status => x_return_status,
78: x_msg_count => x_msg_count,

Line 109: pa_report_types_pkg.Insert_Row

105: end if;
106:
107: IF (p_validate_only <> 'T' AND x_return_status = 'S') then
108:
109: pa_report_types_pkg.Insert_Row
110: (
111: p_name => p_name,
112: p_page_id => l_page_id,
113: p_override_page_layout => p_override_page_layout,

Line 181: PA_DEBUG.init_err_stack('PA_REPORT_TYPES_PUB.Update_Report_Type');

177: l_msg_index_out number;
178:
179: BEGIN
180: -- Initialize the Error Stack
181: PA_DEBUG.init_err_stack('PA_REPORT_TYPES_PUB.Update_Report_Type');
182:
183: -- Initialize the return status to success
184: x_return_status := 'S';
185:

Line 199: from pa_report_Types

195: /* -- check if the record is seeded or not
196: begin
197: select created_by
198: into l_created_by
199: from pa_report_Types
200: where report_Type_id = p_report_type_id;
201: exception when others then
202: null;
203: end;

Line 221: from pa_report_types

217: else
218: begin
219: select 'Y'
220: into l_dummy
221: from pa_report_types
222: where upper(name) = upper(p_name)
223: and report_type_id <> p_report_type_id;
224: exception when no_data_found then
225: null;

Line 242: pa_report_Types_utils.get_page_id_from_layout(p_init_msg_list => 'F',

238: ,p_msg_name => 'PA_PAGE_LAYOUT_NAME_INV');
239: x_return_status := 'E';
240: else
241: --- get page_id from page layout
242: pa_report_Types_utils.get_page_id_from_layout(p_init_msg_list => 'F',
243: p_page_layout => p_page_layout,
244: x_page_id => l_page_id,
245: x_return_status => x_return_status,
246: x_msg_count => x_msg_count,

Line 288: pa_report_types_pkg.Update_Row

284: end if;
285:
286: IF (p_validate_only <> 'T' AND x_return_status = 'S') then
287:
288: pa_report_types_pkg.Update_Row
289: (
290: p_name => p_name,
291: p_page_id => l_page_id,
292: p_override_page_layout => p_override_page_layout,

Line 348: PA_DEBUG.init_err_stack('PA_REPORT_TYPES_PUB.Delete_Report_Type');

344: l_created_by number;
345: l_msg_index_out number;
346: BEGIN
347: -- Initialize the Error Stack
348: PA_DEBUG.init_err_stack('PA_REPORT_TYPES_PUB.Delete_Report_Type');
349:
350: -- Initialize the return status to success
351: x_return_status := 'S';
352:

Line 366: from pa_report_Types

362: -- check if the record is seeded or not
363: begin
364: select created_by
365: into l_created_by
366: from pa_report_Types
367: where report_Type_id = p_report_type_id;
368: exception when others then
369: null;
370: end;

Line 395: pa_report_Types_pkg.delete_row(P_REPORT_TYPE_ID => p_report_Type_id,

391: ,p_msg_name => 'PA_REPORT_TYPE_IN_USE');
392: x_return_status := 'E';
393: else
394: if (p_validate_only <> 'T' and x_return_status = 'S') then
395: pa_report_Types_pkg.delete_row(P_REPORT_TYPE_ID => p_report_Type_id,
396: P_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,
397: x_return_status => x_return_status);
398: end if;
399: end if;

Line 429: END PA_REPORT_TYPES_PUB;

425: RAISE; -- This is optional depending on the needs
426:
427: END delete_report_type;
428:
429: END PA_REPORT_TYPES_PUB;
430: