APPS.IBW_PAGE_INSTANCES_PVT dependencies on IBW_PAGE_INSTANCES

Line 1: PACKAGE BODY IBW_PAGE_INSTANCES_PVT AS

1: PACKAGE BODY IBW_PAGE_INSTANCES_PVT AS
2: /* $Header: IBWPGIB.pls 120.4 2005/11/09 03:44 vekancha noship $*/
3:
4:
5: --

Line 16: -- Offline engine uses this API to insert into IBW_PAGE_INSTANCES table.

12: -- PURPOSE
13: -- Private API for inserting records into page instances table. Mainly used by offline engine
14: --
15: -- NOTES
16: -- Offline engine uses this API to insert into IBW_PAGE_INSTANCES table.
17:
18: -- HISTORY
19: -- 05/10/2005 VEKANCHA Created
20:

Line 23: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBW_PAGE_INSTANCES_PVT';

19: -- 05/10/2005 VEKANCHA Created
20:
21: -- **************************************************************************
22:
23: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBW_PAGE_INSTANCES_PVT';
24: G_FILE_NAME CONSTANT VARCHAR2(12):= 'IBWPGIB.pls';
25:
26:
27: -- ****************************************************************************

Line 61: CURSOR c IS SELECT ibw_page_instances_s1.nextval FROM dual;

57: program_login_id NUMBER;
58: program_app_id NUMBER;
59: request_id NUMBER;
60:
61: CURSOR c IS SELECT ibw_page_instances_s1.nextval FROM dual;
62:
63: CURSOR c1 IS SELECT page_instance_id FROM ibw_page_instances
64: WHERE page_instance_id = x_page_inst_id;
65:

Line 63: CURSOR c1 IS SELECT page_instance_id FROM ibw_page_instances

59: request_id NUMBER;
60:
61: CURSOR c IS SELECT ibw_page_instances_s1.nextval FROM dual;
62:
63: CURSOR c1 IS SELECT page_instance_id FROM ibw_page_instances
64: WHERE page_instance_id = x_page_inst_id;
65:
66:
67: BEGIN

Line 92: INSERT INTO ibw_page_instances (page_instance_id, page_id, business_context, business_context_value, created_by, creation_date,

88: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', program_app_id);
89:
90: FND_PROFILE.GET('CONC_REQUEST_ID', request_id);
91:
92: INSERT INTO ibw_page_instances (page_instance_id, page_id, business_context, business_context_value, created_by, creation_date,
93: last_updated_by, last_update_date, last_update_login, object_version_number,
94: program_id, program_login_id, program_application_id, request_id)
95: VALUES (x_page_inst_id, x_page_id, x_bus_context, x_bus_context_value, created_by, creation_date,
96: last_updated_by, last_update_date, last_update_login, obj_ver_number,

Line 111: END IBW_PAGE_INSTANCES_PVT;

107: -- COMMIT;
108:
109: END insert_row;
110:
111: END IBW_PAGE_INSTANCES_PVT;