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.HR_KI_ITF_LOAD_API dependencies on HR_KI_USER_INTERFACES

Line 25: cursor C is select ROWID from HR_KI_USER_INTERFACES

21: X_LAST_UPDATE_LOGIN in NUMBER
22:
23: ) is
24:
25: cursor C is select ROWID from HR_KI_USER_INTERFACES
26: where user_interface_id = X_USER_INTERFACE_ID;
27:
28: begin
29:

Line 30: select HR_KI_USER_INTERFACES_S.NEXTVAL into X_USER_INTERFACE_ID from sys.dual;

26: where user_interface_id = X_USER_INTERFACE_ID;
27:
28: begin
29:
30: select HR_KI_USER_INTERFACES_S.NEXTVAL into X_USER_INTERFACE_ID from sys.dual;
31:
32: insert into HR_KI_USER_INTERFACES (
33: USER_INTERFACE_ID,
34: USER_INTERFACE_KEY,

Line 32: insert into HR_KI_USER_INTERFACES (

28: begin
29:
30: select HR_KI_USER_INTERFACES_S.NEXTVAL into X_USER_INTERFACE_ID from sys.dual;
31:
32: insert into HR_KI_USER_INTERFACES (
33: USER_INTERFACE_ID,
34: USER_INTERFACE_KEY,
35: TYPE,
36: FORM_NAME,

Line 89: l_created_by HR_KI_USER_INTERFACES.created_by%TYPE := 0;

85:
86: is
87: l_proc VARCHAR2(31) := 'HR_KI_ITF_LOAD_API.LOAD_ROW';
88: l_rowid rowid;
89: l_created_by HR_KI_USER_INTERFACES.created_by%TYPE := 0;
90: l_creation_date HR_KI_USER_INTERFACES.creation_date%TYPE := SYSDATE;
91: l_last_update_date HR_KI_USER_INTERFACES.last_update_date%TYPE := SYSDATE;
92: l_last_updated_by HR_KI_USER_INTERFACES.last_updated_by%TYPE := 0;
93: l_last_update_login HR_KI_USER_INTERFACES.last_update_login%TYPE := 0;

Line 90: l_creation_date HR_KI_USER_INTERFACES.creation_date%TYPE := SYSDATE;

86: is
87: l_proc VARCHAR2(31) := 'HR_KI_ITF_LOAD_API.LOAD_ROW';
88: l_rowid rowid;
89: l_created_by HR_KI_USER_INTERFACES.created_by%TYPE := 0;
90: l_creation_date HR_KI_USER_INTERFACES.creation_date%TYPE := SYSDATE;
91: l_last_update_date HR_KI_USER_INTERFACES.last_update_date%TYPE := SYSDATE;
92: l_last_updated_by HR_KI_USER_INTERFACES.last_updated_by%TYPE := 0;
93: l_last_update_login HR_KI_USER_INTERFACES.last_update_login%TYPE := 0;
94: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;

Line 91: l_last_update_date HR_KI_USER_INTERFACES.last_update_date%TYPE := SYSDATE;

87: l_proc VARCHAR2(31) := 'HR_KI_ITF_LOAD_API.LOAD_ROW';
88: l_rowid rowid;
89: l_created_by HR_KI_USER_INTERFACES.created_by%TYPE := 0;
90: l_creation_date HR_KI_USER_INTERFACES.creation_date%TYPE := SYSDATE;
91: l_last_update_date HR_KI_USER_INTERFACES.last_update_date%TYPE := SYSDATE;
92: l_last_updated_by HR_KI_USER_INTERFACES.last_updated_by%TYPE := 0;
93: l_last_update_login HR_KI_USER_INTERFACES.last_update_login%TYPE := 0;
94: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;
95:

Line 92: l_last_updated_by HR_KI_USER_INTERFACES.last_updated_by%TYPE := 0;

88: l_rowid rowid;
89: l_created_by HR_KI_USER_INTERFACES.created_by%TYPE := 0;
90: l_creation_date HR_KI_USER_INTERFACES.creation_date%TYPE := SYSDATE;
91: l_last_update_date HR_KI_USER_INTERFACES.last_update_date%TYPE := SYSDATE;
92: l_last_updated_by HR_KI_USER_INTERFACES.last_updated_by%TYPE := 0;
93: l_last_update_login HR_KI_USER_INTERFACES.last_update_login%TYPE := 0;
94: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;
95:
96: l_object_version_number HR_KI_USER_INTERFACES.object_version_number%TYPE;

Line 93: l_last_update_login HR_KI_USER_INTERFACES.last_update_login%TYPE := 0;

89: l_created_by HR_KI_USER_INTERFACES.created_by%TYPE := 0;
90: l_creation_date HR_KI_USER_INTERFACES.creation_date%TYPE := SYSDATE;
91: l_last_update_date HR_KI_USER_INTERFACES.last_update_date%TYPE := SYSDATE;
92: l_last_updated_by HR_KI_USER_INTERFACES.last_updated_by%TYPE := 0;
93: l_last_update_login HR_KI_USER_INTERFACES.last_update_login%TYPE := 0;
94: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;
95:
96: l_object_version_number HR_KI_USER_INTERFACES.object_version_number%TYPE;
97:

Line 94: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;

90: l_creation_date HR_KI_USER_INTERFACES.creation_date%TYPE := SYSDATE;
91: l_last_update_date HR_KI_USER_INTERFACES.last_update_date%TYPE := SYSDATE;
92: l_last_updated_by HR_KI_USER_INTERFACES.last_updated_by%TYPE := 0;
93: l_last_update_login HR_KI_USER_INTERFACES.last_update_login%TYPE := 0;
94: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;
95:
96: l_object_version_number HR_KI_USER_INTERFACES.object_version_number%TYPE;
97:
98: db_luby number; -- entity owner in db

Line 96: l_object_version_number HR_KI_USER_INTERFACES.object_version_number%TYPE;

92: l_last_updated_by HR_KI_USER_INTERFACES.last_updated_by%TYPE := 0;
93: l_last_update_login HR_KI_USER_INTERFACES.last_update_login%TYPE := 0;
94: l_user_interface_id HR_KI_USER_INTERFACES.user_interface_id%TYPE;
95:
96: l_object_version_number HR_KI_USER_INTERFACES.object_version_number%TYPE;
97:
98: db_luby number; -- entity owner in db
99: db_ludate date; -- entity update date in db
100:

Line 105: from HR_KI_USER_INTERFACES

101:
102:
103: CURSOR C_APPL IS
104: select user_interface_id,object_version_number
105: from HR_KI_USER_INTERFACES
106: where upper(user_interface_key) = upper(X_USER_INTERFACE_KEY);
107:
108: begin
109: --