APPS.PA_PAGE_CONTENTS_PKG dependencies on PA_PAGE_CONTENTS

Line 1: PACKAGE BODY PA_PAGE_CONTENTS_PKG AS

1: PACKAGE BODY PA_PAGE_CONTENTS_PKG AS
2: --$Header: PAPGCTTB.pls 115.1 2002/12/03 18:20:01 mwasowic noship $
3:
4:
5: procedure INSERT_PAGE_CONTENTS_ROW (

Line 22: cursor C is select ROWID from PA_PAGE_CONTENTS

18: ) is
19:
20: l_ROWID ROWID;
21:
22: cursor C is select ROWID from PA_PAGE_CONTENTS
23: where Page_content_id = P_PAGE_CONTENT_ID;
24:
25: BEGIN
26:

Line 30: --SELECT pa.pa_page_contents_s.nextval

26:
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: --get the unique page content id from the Oracle Sequence
30: --SELECT pa.pa_page_contents_s.nextval
31: --INTO l_content_id
32: --FROM DUAL;
33:
34:

Line 35: insert into PA_PAGE_CONTENTS (

31: --INTO l_content_id
32: --FROM DUAL;
33:
34:
35: insert into PA_PAGE_CONTENTS (
36: PAGE_CONTENT_ID,
37: OBJECT_TYPE,
38: PK1_VALUE,
39: PK2_VALUE,

Line 100: update PA_PAGE_CONTENTS set

96: begin
97:
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: update PA_PAGE_CONTENTS set
101: PAGE_CONTENT = empty_clob(),
102: RECORD_VERSION_NUMBER = record_version_number +1,
103: LAST_UPDATED_BY = fnd_global.user_id,
104: LAST_UPDATE_DATE = sysdate,

Line 138: update PA_PAGE_CONTENTS set

134: ) is
135: begin
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137:
138: update PA_PAGE_CONTENTS set
139: OBJECT_TYPE = Nvl(p_object_type, object_type),
140: PK1_VALUE = Nvl(P_PK1_VALUE, PK1_VALUE),
141: PK2_VALUE = Nvl(P_PK2_VALUE, PK2_VALUE),
142: PK3_VALUE = Nvl(P_PK3_VALUE, PK3_VALUE),

Line 175: DELETE FROM PA_PAGE_CONTENTS

171: ) is
172: begin
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175: DELETE FROM PA_PAGE_CONTENTS
176: where page_content_id = P_PAGE_CONTENT_ID;
177:
178:
179: EXCEPTION

Line 185: END PA_PAGE_CONTENTS_PKG;

181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
182: RAISE;
183: end DELETE_PAGE_CONTENTS_ROW;
184:
185: END PA_PAGE_CONTENTS_PKG;