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_LOCKER_TYPES_UPLOAD_PKG dependencies on HXC_LOCKER_TYPES

Line 1: PACKAGE BODY hxc_locker_types_upload_pkg AS

1: PACKAGE BODY hxc_locker_types_upload_pkg AS
2: /* $Header: hxclocktypesload.pkb 115.1 2004/05/13 02:18:43 dragarwa noship $ */
3:
4: PROCEDURE load_locker_types_row (
5: p_process_type IN VARCHAR2

Line 10: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;

6: , p_locker_type IN VARCHAR2
7: , p_owner IN VARCHAR2
8: , p_custom_mode IN VARCHAR2 ) IS
9:
10: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;
11: l_locker_type hxc_locker_types.locker_type%TYPE;
12: l_process_type hxc_locker_types.process_type%TYPE;
13: l_owner VARCHAR2(4000);
14:

Line 11: l_locker_type hxc_locker_types.locker_type%TYPE;

7: , p_owner IN VARCHAR2
8: , p_custom_mode IN VARCHAR2 ) IS
9:
10: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;
11: l_locker_type hxc_locker_types.locker_type%TYPE;
12: l_process_type hxc_locker_types.process_type%TYPE;
13: l_owner VARCHAR2(4000);
14:
15: BEGIN

Line 12: l_process_type hxc_locker_types.process_type%TYPE;

8: , p_custom_mode IN VARCHAR2 ) IS
9:
10: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;
11: l_locker_type hxc_locker_types.locker_type%TYPE;
12: l_process_type hxc_locker_types.process_type%TYPE;
13: l_owner VARCHAR2(4000);
14:
15: BEGIN
16:

Line 28: FROM hxc_locker_types lot

24: ,l_owner
25: ,l_locker_type
26: ,l_process_type
27:
28: FROM hxc_locker_types lot
29: WHERE lot.process_type = p_process_type
30: AND lot.locker_type = p_locker_type;
31:
32:

Line 62: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;

58: , p_locker_type IN VARCHAR2
59: , p_owner IN VARCHAR2
60: , p_custom_mode IN VARCHAR2
61: ,p_last_update_date IN VARCHAR2 ) IS
62: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;
63: l_locker_type hxc_locker_types.locker_type%TYPE;
64: l_process_type hxc_locker_types.process_type%TYPE;
65:
66: l_last_update_date_db hxc_locker_types.last_update_date%TYPE;

Line 63: l_locker_type hxc_locker_types.locker_type%TYPE;

59: , p_owner IN VARCHAR2
60: , p_custom_mode IN VARCHAR2
61: ,p_last_update_date IN VARCHAR2 ) IS
62: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;
63: l_locker_type hxc_locker_types.locker_type%TYPE;
64: l_process_type hxc_locker_types.process_type%TYPE;
65:
66: l_last_update_date_db hxc_locker_types.last_update_date%TYPE;
67: l_last_updated_by_db hxc_locker_types.last_updated_by%TYPE;

Line 64: l_process_type hxc_locker_types.process_type%TYPE;

60: , p_custom_mode IN VARCHAR2
61: ,p_last_update_date IN VARCHAR2 ) IS
62: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;
63: l_locker_type hxc_locker_types.locker_type%TYPE;
64: l_process_type hxc_locker_types.process_type%TYPE;
65:
66: l_last_update_date_db hxc_locker_types.last_update_date%TYPE;
67: l_last_updated_by_db hxc_locker_types.last_updated_by%TYPE;
68: l_last_updated_by_f hxc_locker_types.last_updated_by%TYPE;

Line 66: l_last_update_date_db hxc_locker_types.last_update_date%TYPE;

62: l_locker_type_id hxc_locker_types.locker_type_id%TYPE;
63: l_locker_type hxc_locker_types.locker_type%TYPE;
64: l_process_type hxc_locker_types.process_type%TYPE;
65:
66: l_last_update_date_db hxc_locker_types.last_update_date%TYPE;
67: l_last_updated_by_db hxc_locker_types.last_updated_by%TYPE;
68: l_last_updated_by_f hxc_locker_types.last_updated_by%TYPE;
69: l_last_update_date_f hxc_locker_types.last_update_date%TYPE;
70: BEGIN

Line 67: l_last_updated_by_db hxc_locker_types.last_updated_by%TYPE;

63: l_locker_type hxc_locker_types.locker_type%TYPE;
64: l_process_type hxc_locker_types.process_type%TYPE;
65:
66: l_last_update_date_db hxc_locker_types.last_update_date%TYPE;
67: l_last_updated_by_db hxc_locker_types.last_updated_by%TYPE;
68: l_last_updated_by_f hxc_locker_types.last_updated_by%TYPE;
69: l_last_update_date_f hxc_locker_types.last_update_date%TYPE;
70: BEGIN
71:

Line 68: l_last_updated_by_f hxc_locker_types.last_updated_by%TYPE;

64: l_process_type hxc_locker_types.process_type%TYPE;
65:
66: l_last_update_date_db hxc_locker_types.last_update_date%TYPE;
67: l_last_updated_by_db hxc_locker_types.last_updated_by%TYPE;
68: l_last_updated_by_f hxc_locker_types.last_updated_by%TYPE;
69: l_last_update_date_f hxc_locker_types.last_update_date%TYPE;
70: BEGIN
71:
72: BEGIN

Line 69: l_last_update_date_f hxc_locker_types.last_update_date%TYPE;

65:
66: l_last_update_date_db hxc_locker_types.last_update_date%TYPE;
67: l_last_updated_by_db hxc_locker_types.last_updated_by%TYPE;
68: l_last_updated_by_f hxc_locker_types.last_updated_by%TYPE;
69: l_last_update_date_f hxc_locker_types.last_update_date%TYPE;
70: BEGIN
71:
72: BEGIN
73: l_last_updated_by_f := fnd_load_util.owner_id(p_owner);

Line 89: FROM hxc_locker_types lot

85: ,l_process_type
86: ,l_last_update_date_db
87: ,l_last_updated_by_db
88:
89: FROM hxc_locker_types lot
90: WHERE lot.process_type = p_process_type
91: AND lot.locker_type = p_locker_type;
92:
93:

Line 121: END hxc_locker_types_upload_pkg;

117: END;
118:
119: END load_locker_types_row;
120:
121: END hxc_locker_types_upload_pkg;