eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_HTR_UPLOAD_PKG dependencies on HXC_TIME_RECIPIENTS

Line 17: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;

13: , p_extension_function1 IN VARCHAR2
14: , p_extension_function2 IN VARCHAR2
15: , p_last_update_date IN VARCHAR2 DEFAULT NULL) IS
16:
17: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
18: l_application_id hxc_time_recipients.application_id%TYPE;
19: l_ovn hxc_time_recipients.object_version_number%TYPE;
20: l_owner VARCHAR2(6);
21:

Line 18: l_application_id hxc_time_recipients.application_id%TYPE;

14: , p_extension_function2 IN VARCHAR2
15: , p_last_update_date IN VARCHAR2 DEFAULT NULL) IS
16:
17: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
18: l_application_id hxc_time_recipients.application_id%TYPE;
19: l_ovn hxc_time_recipients.object_version_number%TYPE;
20: l_owner VARCHAR2(6);
21:
22: l_appl_retrieval_function hxc_time_recipients.application_retrieval_function%TYPE := NULL;

Line 19: l_ovn hxc_time_recipients.object_version_number%TYPE;

15: , p_last_update_date IN VARCHAR2 DEFAULT NULL) IS
16:
17: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
18: l_application_id hxc_time_recipients.application_id%TYPE;
19: l_ovn hxc_time_recipients.object_version_number%TYPE;
20: l_owner VARCHAR2(6);
21:
22: l_appl_retrieval_function hxc_time_recipients.application_retrieval_function%TYPE := NULL;
23: l_appl_update_process hxc_time_recipients.application_update_process%TYPE := NULL;

Line 22: l_appl_retrieval_function hxc_time_recipients.application_retrieval_function%TYPE := NULL;

18: l_application_id hxc_time_recipients.application_id%TYPE;
19: l_ovn hxc_time_recipients.object_version_number%TYPE;
20: l_owner VARCHAR2(6);
21:
22: l_appl_retrieval_function hxc_time_recipients.application_retrieval_function%TYPE := NULL;
23: l_appl_update_process hxc_time_recipients.application_update_process%TYPE := NULL;
24: l_appl_validation_process hxc_time_recipients.appl_validation_process%TYPE := NULL;
25: l_appl_period_function hxc_time_recipients.application_period_function%TYPE := NULL;
26: l_appl_dyn_template_process hxc_time_recipients.appl_dynamic_template_process%TYPE := NULL;

Line 23: l_appl_update_process hxc_time_recipients.application_update_process%TYPE := NULL;

19: l_ovn hxc_time_recipients.object_version_number%TYPE;
20: l_owner VARCHAR2(6);
21:
22: l_appl_retrieval_function hxc_time_recipients.application_retrieval_function%TYPE := NULL;
23: l_appl_update_process hxc_time_recipients.application_update_process%TYPE := NULL;
24: l_appl_validation_process hxc_time_recipients.appl_validation_process%TYPE := NULL;
25: l_appl_period_function hxc_time_recipients.application_period_function%TYPE := NULL;
26: l_appl_dyn_template_process hxc_time_recipients.appl_dynamic_template_process%TYPE := NULL;
27: l_extension_function1 hxc_time_recipients.extension_function1%TYPE := NULL;

Line 24: l_appl_validation_process hxc_time_recipients.appl_validation_process%TYPE := NULL;

20: l_owner VARCHAR2(6);
21:
22: l_appl_retrieval_function hxc_time_recipients.application_retrieval_function%TYPE := NULL;
23: l_appl_update_process hxc_time_recipients.application_update_process%TYPE := NULL;
24: l_appl_validation_process hxc_time_recipients.appl_validation_process%TYPE := NULL;
25: l_appl_period_function hxc_time_recipients.application_period_function%TYPE := NULL;
26: l_appl_dyn_template_process hxc_time_recipients.appl_dynamic_template_process%TYPE := NULL;
27: l_extension_function1 hxc_time_recipients.extension_function1%TYPE := NULL;
28: l_extension_function2 hxc_time_recipients.extension_function2%TYPE := NULL;

Line 25: l_appl_period_function hxc_time_recipients.application_period_function%TYPE := NULL;

21:
22: l_appl_retrieval_function hxc_time_recipients.application_retrieval_function%TYPE := NULL;
23: l_appl_update_process hxc_time_recipients.application_update_process%TYPE := NULL;
24: l_appl_validation_process hxc_time_recipients.appl_validation_process%TYPE := NULL;
25: l_appl_period_function hxc_time_recipients.application_period_function%TYPE := NULL;
26: l_appl_dyn_template_process hxc_time_recipients.appl_dynamic_template_process%TYPE := NULL;
27: l_extension_function1 hxc_time_recipients.extension_function1%TYPE := NULL;
28: l_extension_function2 hxc_time_recipients.extension_function2%TYPE := NULL;
29: l_last_update_date_db hxc_time_recipients.last_update_date%TYPE;

Line 26: l_appl_dyn_template_process hxc_time_recipients.appl_dynamic_template_process%TYPE := NULL;

22: l_appl_retrieval_function hxc_time_recipients.application_retrieval_function%TYPE := NULL;
23: l_appl_update_process hxc_time_recipients.application_update_process%TYPE := NULL;
24: l_appl_validation_process hxc_time_recipients.appl_validation_process%TYPE := NULL;
25: l_appl_period_function hxc_time_recipients.application_period_function%TYPE := NULL;
26: l_appl_dyn_template_process hxc_time_recipients.appl_dynamic_template_process%TYPE := NULL;
27: l_extension_function1 hxc_time_recipients.extension_function1%TYPE := NULL;
28: l_extension_function2 hxc_time_recipients.extension_function2%TYPE := NULL;
29: l_last_update_date_db hxc_time_recipients.last_update_date%TYPE;
30: l_last_updated_by_db hxc_time_recipients.last_updated_by%TYPE;

Line 27: l_extension_function1 hxc_time_recipients.extension_function1%TYPE := NULL;

23: l_appl_update_process hxc_time_recipients.application_update_process%TYPE := NULL;
24: l_appl_validation_process hxc_time_recipients.appl_validation_process%TYPE := NULL;
25: l_appl_period_function hxc_time_recipients.application_period_function%TYPE := NULL;
26: l_appl_dyn_template_process hxc_time_recipients.appl_dynamic_template_process%TYPE := NULL;
27: l_extension_function1 hxc_time_recipients.extension_function1%TYPE := NULL;
28: l_extension_function2 hxc_time_recipients.extension_function2%TYPE := NULL;
29: l_last_update_date_db hxc_time_recipients.last_update_date%TYPE;
30: l_last_updated_by_db hxc_time_recipients.last_updated_by%TYPE;
31: l_last_updated_by_f hxc_time_recipients.last_updated_by%TYPE;

Line 28: l_extension_function2 hxc_time_recipients.extension_function2%TYPE := NULL;

24: l_appl_validation_process hxc_time_recipients.appl_validation_process%TYPE := NULL;
25: l_appl_period_function hxc_time_recipients.application_period_function%TYPE := NULL;
26: l_appl_dyn_template_process hxc_time_recipients.appl_dynamic_template_process%TYPE := NULL;
27: l_extension_function1 hxc_time_recipients.extension_function1%TYPE := NULL;
28: l_extension_function2 hxc_time_recipients.extension_function2%TYPE := NULL;
29: l_last_update_date_db hxc_time_recipients.last_update_date%TYPE;
30: l_last_updated_by_db hxc_time_recipients.last_updated_by%TYPE;
31: l_last_updated_by_f hxc_time_recipients.last_updated_by%TYPE;
32: l_last_update_date_f hxc_time_recipients.last_update_date%TYPE;

Line 29: l_last_update_date_db hxc_time_recipients.last_update_date%TYPE;

25: l_appl_period_function hxc_time_recipients.application_period_function%TYPE := NULL;
26: l_appl_dyn_template_process hxc_time_recipients.appl_dynamic_template_process%TYPE := NULL;
27: l_extension_function1 hxc_time_recipients.extension_function1%TYPE := NULL;
28: l_extension_function2 hxc_time_recipients.extension_function2%TYPE := NULL;
29: l_last_update_date_db hxc_time_recipients.last_update_date%TYPE;
30: l_last_updated_by_db hxc_time_recipients.last_updated_by%TYPE;
31: l_last_updated_by_f hxc_time_recipients.last_updated_by%TYPE;
32: l_last_update_date_f hxc_time_recipients.last_update_date%TYPE;
33: --

Line 30: l_last_updated_by_db hxc_time_recipients.last_updated_by%TYPE;

26: l_appl_dyn_template_process hxc_time_recipients.appl_dynamic_template_process%TYPE := NULL;
27: l_extension_function1 hxc_time_recipients.extension_function1%TYPE := NULL;
28: l_extension_function2 hxc_time_recipients.extension_function2%TYPE := NULL;
29: l_last_update_date_db hxc_time_recipients.last_update_date%TYPE;
30: l_last_updated_by_db hxc_time_recipients.last_updated_by%TYPE;
31: l_last_updated_by_f hxc_time_recipients.last_updated_by%TYPE;
32: l_last_update_date_f hxc_time_recipients.last_update_date%TYPE;
33: --
34:

Line 31: l_last_updated_by_f hxc_time_recipients.last_updated_by%TYPE;

27: l_extension_function1 hxc_time_recipients.extension_function1%TYPE := NULL;
28: l_extension_function2 hxc_time_recipients.extension_function2%TYPE := NULL;
29: l_last_update_date_db hxc_time_recipients.last_update_date%TYPE;
30: l_last_updated_by_db hxc_time_recipients.last_updated_by%TYPE;
31: l_last_updated_by_f hxc_time_recipients.last_updated_by%TYPE;
32: l_last_update_date_f hxc_time_recipients.last_update_date%TYPE;
33: --
34:
35: FUNCTION chk_schema_exists RETURN BOOLEAN IS

Line 32: l_last_update_date_f hxc_time_recipients.last_update_date%TYPE;

28: l_extension_function2 hxc_time_recipients.extension_function2%TYPE := NULL;
29: l_last_update_date_db hxc_time_recipients.last_update_date%TYPE;
30: l_last_updated_by_db hxc_time_recipients.last_updated_by%TYPE;
31: l_last_updated_by_f hxc_time_recipients.last_updated_by%TYPE;
32: l_last_update_date_f hxc_time_recipients.last_update_date%TYPE;
33: --
34:
35: FUNCTION chk_schema_exists RETURN BOOLEAN IS
36:

Line 47: AND table_name = 'HXC_TIME_RECIPIENTS' );

43: WHERE EXISTS (
44: SELECT 1
45: FROM all_tables
46: WHERE owner = p_hxc_schema
47: AND table_name = 'HXC_TIME_RECIPIENTS' );
48:
49: l_result boolean;
50: l_prod_status varchar2(1);
51: l_industry varchar2(1);

Line 112: l_application_id hxc_time_recipients.application_id%TYPE;

108: END chk_process_exists;
109:
110: FUNCTION get_application_id ( p_application_name VARCHAR2 ) RETURN NUMBER IS
111:
112: l_application_id hxc_time_recipients.application_id%TYPE;
113:
114: CURSOR csr_get_app_id IS
115: SELECT app.application_id
116: FROM fnd_application app

Line 211: FROM hxc_time_recipients tr

207: INTO l_time_recipient_id
208: , l_ovn
209: ,l_last_update_date_db
210: ,l_last_updated_by_db
211: FROM hxc_time_recipients tr
212: WHERE tr.name = P_NAME;
213:
214: IF (fnd_load_util.upload_test( l_last_updated_by_f,
215: l_last_update_date_f,