APPS.IBW_PAGE_INSTANCES_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

PROCEDURE insert_row (
	page_id  OUT NOCOPY NUMBER,
	x_page_id IN NUMBER,
	x_bus_context IN VARCHAR2,
	x_bus_context_value IN VARCHAR2,
	error_messages OUT NOCOPY VARCHAR2
)

IS

	x_page_inst_id	NUMBER;

Line: 52

	last_updated_by	NUMBER;

Line: 53

	last_update_date	DATE;

Line: 54

	last_update_login	NUMBER;

Line: 61

	CURSOR c IS SELECT ibw_page_instances_s1.nextval FROM dual;

Line: 63

	CURSOR c1 IS SELECT page_instance_id  FROM ibw_page_instances
	    WHERE page_instance_id = x_page_inst_id;

Line: 78

	last_updated_by := created_by;

Line: 80

	last_update_date := SYSDATE;

Line: 82

	FND_PROFILE.GET('LOGIN_ID', last_update_login);

Line: 92

	INSERT INTO ibw_page_instances (page_instance_id, page_id, business_context, business_context_value, created_by, creation_date,
							last_updated_by, last_update_date, last_update_login, object_version_number,
							program_id, program_login_id, program_application_id, request_id)
			VALUES (x_page_inst_id, x_page_id, x_bus_context, x_bus_context_value, created_by, creation_date,
						last_updated_by, last_update_date, last_update_login, obj_ver_number,
						program_id, program_login_id, program_app_id, request_id);

Line: 109

END insert_row;