APPS.PA_REPORT_TYPES_PKG dependencies on PA_REPORT_TYPES

Line 1: PACKAGE BODY PA_REPORT_TYPES_PKG AS

1: PACKAGE BODY PA_REPORT_TYPES_PKG AS
2: --$Header: PARTYPHB.pls 120.1 2005/08/19 17:02:24 mwasowic noship $
3:
4:
5: procedure INSERT_ROW (

Line 24: FROM pa_report_Types

20: l_row_id ROWID;
21:
22: CURSOR c1 IS
23: SELECT rowid
24: FROM pa_report_Types
25: WHERE report_type_id = x_report_type_id;
26:
27: begin
28:

Line 29: insert into PA_REPORT_TYPES (

25: WHERE report_type_id = x_report_type_id;
26:
27: begin
28:
29: insert into PA_REPORT_TYPES (
30: REPORT_TYPE_ID,
31: NAME,
32: PAGE_ID,
33: OVERRIDE_PAGE_LAYOUT,

Line 46: pa_report_types_s.NEXTVAL,

42: CREATED_BY,
43: LAST_UPDATE_LOGIN)
44: VALUES
45: (
46: pa_report_types_s.NEXTVAL,
47: P_NAME,
48: P_PAGE_ID,
49: P_OVERRIDE_PAGE_LAYOUT,
50: P_DESCRIPTION,

Line 91: update PA_REPORT_TYPES set

87: ) is
88: BEGIN
89:
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: update PA_REPORT_TYPES set
92: NAME = decode(P_NAME,'^',name,p_name),
93: PAGE_ID = decode(p_page_id,'-99',page_id,p_page_id),
94: OVERRIDE_PAGE_LAYOUT = decode(p_OVERRIDE_PAGE_LAYOUT,'^',OVERRIDE_PAGE_LAYOUT,p_OVERRIDE_PAGE_LAYOUT),
95: DESCRIPTION = decode(P_DESCRIPTION,'^',DESCRIPTION,P_DESCRIPTION),

Line 130: delete from PA_REPORT_TYPES

126: BEGIN
127:
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: delete from PA_REPORT_TYPES
131: where REPORT_TYPE_ID = p_report_type_id
132: AND nvl(p_record_version_number, record_version_number) = record_version_number;
133:
134:

Line 149: END PA_REPORT_TYPES_PKG;

145: RAISE;
146: end DELETE_ROW;
147:
148:
149: END PA_REPORT_TYPES_PKG;