APPS.PA_PAGE_LAYOUT_PKG dependencies on PA_PAGE_LAYOUTS

Line 25: FROM pa_page_layouts

21: l_page_id NUMBER;
22:
23: CURSOR c1 IS
24: SELECT rowid
25: FROM pa_page_layouts
26: WHERE page_id = l_page_id;
27:
28: begin
29: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 32: -- SELECT pa_page_layouts_s.NEXTVAL

28: begin
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30:
31:
32: -- SELECT pa_page_layouts_s.NEXTVAL
33: -- INTO l_page_id
34: -- FROM dual;
35:
36: insert into PA_PAGE_LAYOUTS (

Line 36: insert into PA_PAGE_LAYOUTS (

32: -- SELECT pa_page_layouts_s.NEXTVAL
33: -- INTO l_page_id
34: -- FROM dual;
35:
36: insert into PA_PAGE_LAYOUTS (
37: PAGE_ID,
38: PAGE_NAME,
39: PAGE_TYPE_CODE,
40: DESCRIPTION,

Line 53: pa_page_layouts_s.NEXTVAL,

49: LAST_UPDATE_LOGIN,
50: PERS_FUNCTION_NAME)
51: VALUES
52: (
53: pa_page_layouts_s.NEXTVAL,
54: P_PAGE_NAME,
55: P_PAGE_TYPE,
56: P_DESCRIPTION,
57: P_START_DATE,

Line 103: update PA_PAGE_LAYOUTS set

99: ) is
100: BEGIN
101:
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103: update PA_PAGE_LAYOUTS set
104: PAGE_NAME = P_PAGE_NAME,
105: PAGE_TYPE_CODE = Nvl(p_page_type, page_type_code),
106: DESCRIPTION = P_DESCRIPTION,
107: START_DATE_active = P_START_DATE,

Line 145: delete from PA_PAGE_LAYOUTS

141: BEGIN
142:
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: delete from PA_PAGE_LAYOUTS
146: where PAGE_ID = p_page_id
147: AND nvl(p_record_version_number, record_version_number) = record_version_number;
148:
149: --