APPS.HXC_HTR_UPLOAD_PKG SQL Statements

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

Line: 9

        , p_appl_update_process             IN VARCHAR2
        , p_appl_validation_process         IN VARCHAR2
        , p_appl_period_function            IN VARCHAR2
        , p_appl_dyn_template_process       IN VARCHAR2
        , p_extension_function1             IN VARCHAR2
        , p_extension_function2             IN VARCHAR2
	, p_last_update_date                IN VARCHAR2 DEFAULT NULL) IS

l_time_recipient_id	hxc_time_recipients.time_recipient_id%TYPE;

Line: 23

l_appl_update_process    	hxc_time_recipients.application_update_process%TYPE := NULL;

Line: 29

l_last_update_date_db           hxc_time_recipients.last_update_date%TYPE;

Line: 30

l_last_updated_by_db            hxc_time_recipients.last_updated_by%TYPE;

Line: 31

l_last_updated_by_f             hxc_time_recipients.last_updated_by%TYPE;

Line: 32

l_last_update_date_f            hxc_time_recipients.last_update_date%TYPE;

Line: 41

SELECT	1
FROM	dual
WHERE EXISTS (
SELECT	1
FROM	all_tables
WHERE	owner = p_hxc_schema
AND	table_name = 'HXC_TIME_RECIPIENTS' );

Line: 83

SELECT	1
FROM	dual
WHERE EXISTS (
SELECT  1
FROM	user_objects
WHERE	object_name	= p_process
AND	object_type	= 'PACKAGE BODY'
);

Line: 115

SELECT	app.application_id
FROM	fnd_application app
WHERE	app.application_short_name = p_application_name;

Line: 153

IF ( p_appl_update_process IS NOT NULL )
THEN
	IF ( chk_process_exists ( p_appl_update_process ) )
	THEN
		l_appl_update_process := p_appl_update_process;

Line: 201

l_last_updated_by_f := fnd_load_util.owner_id(p_owner);

Line: 202

l_last_update_date_f := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 203

	SELECT	tr.time_recipient_id
	,	tr.object_version_number
	,tr.last_update_date
			,tr.last_updated_by
	INTO	l_time_recipient_id
	,	l_ovn
	,l_last_update_date_db
                        ,l_last_updated_by_db
	FROM	hxc_time_recipients tr
	WHERE	tr.name	= P_NAME;

Line: 214

	IF (fnd_load_util.upload_test(	l_last_updated_by_f,
					l_last_update_date_f,
	                        	 l_last_updated_by_db,
					l_last_update_date_db ,
					 p_custom_mode))
	THEN
		hxc_time_recipient_api.update_time_recipient (
	   p_time_recipient_id         => l_time_recipient_id
	 , p_application_id	       => l_application_id
	 , p_object_version_number     => l_ovn
	 , p_name                      => p_name
         , p_appl_retrieval_function   => l_appl_retrieval_function
         , p_appl_update_process       => l_appl_update_process
         , p_appl_validation_process   => l_appl_validation_process
         , p_appl_period_function      => l_appl_period_function
         , p_appl_dyn_template_process => l_appl_dyn_template_process
         , p_extension_function1       => l_extension_function1
         , p_extension_function2       => l_extension_function2);

Line: 247

         , p_appl_update_process       => l_appl_update_process
         , p_appl_validation_process   => l_appl_validation_process
         , p_appl_period_function      => l_appl_period_function
         , p_appl_dyn_template_process => l_appl_dyn_template_process
         , p_extension_function1       => l_extension_function1
         , p_extension_function2       => l_extension_function2);