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.PAY_UPGRADE_PARAMETERS_PKG dependencies on PAY_UPGRADE_PARAMETERS

Line 1: PACKAGE BODY PAY_UPGRADE_PARAMETERS_PKG AS

1: PACKAGE BODY PAY_UPGRADE_PARAMETERS_PKG AS
2: /* $Header: pypup01t.pkb 120.1 2005/07/07 03:58 rajeesha noship $ */
3:
4: g_package varchar2(33) := ' pay_upgrade_parameters_pkg.';
5:

Line 4: g_package varchar2(33) := ' pay_upgrade_parameters_pkg.';

1: PACKAGE BODY PAY_UPGRADE_PARAMETERS_PKG AS
2: /* $Header: pypup01t.pkb 120.1 2005/07/07 03:58 rajeesha noship $ */
3:
4: g_package varchar2(33) := ' pay_upgrade_parameters_pkg.';
5:
6:
7: PROCEDURE chk_mandatory_arg( p_argument in varchar2 , p_column in varchar2)
8: is

Line 71: insert into PAY_UPGRADE_PARAMETERS (

67: fnd_message.raise_error;
68: END IF;
69: CLOSE csr_exists;
70:
71: insert into PAY_UPGRADE_PARAMETERS (
72: UPGRADE_DEFINITION_ID,
73: PARAMETER_NAME,
74: PARAMETER_VALUE,
75: LAST_UPDATE_DATE,

Line 117: update PAY_UPGRADE_PARAMETERS set

113:
114: chk_mandatory_arg( p_parameter_name, 'PARAMETER_NAME' );
115:
116:
117: update PAY_UPGRADE_PARAMETERS set
118: parameter_value = p_parameter_value,
119: last_update_date= p_last_update_date,
120: last_updated_by = p_last_updated_by,
121: last_update_login = p_last_update_login

Line 144: l_created_by PAY_UPGRADE_PARAMETERS.CREATED_BY%TYPE;

140: l_proc varchar2(100) := g_package || 'Load_Row';
141: l_upgrade_def_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;
142:
143: l_sysdate date := sysdate;
144: l_created_by PAY_UPGRADE_PARAMETERS.CREATED_BY%TYPE;
145: l_creation_date PAY_UPGRADE_PARAMETERS.CREATION_DATE%TYPE;
146: l_last_updated_by PAY_UPGRADE_PARAMETERS.LAST_UPDATED_BY%TYPE;
147: l_last_update_login PAY_UPGRADE_PARAMETERS.LAST_UPDATE_LOGIN%TYPE;
148: l_last_update_date PAY_UPGRADE_PARAMETERS.LAST_UPDATE_DATE%TYPE;

Line 145: l_creation_date PAY_UPGRADE_PARAMETERS.CREATION_DATE%TYPE;

141: l_upgrade_def_id PAY_UPGRADE_DEFINITIONS.UPGRADE_DEFINITION_ID%TYPE;
142:
143: l_sysdate date := sysdate;
144: l_created_by PAY_UPGRADE_PARAMETERS.CREATED_BY%TYPE;
145: l_creation_date PAY_UPGRADE_PARAMETERS.CREATION_DATE%TYPE;
146: l_last_updated_by PAY_UPGRADE_PARAMETERS.LAST_UPDATED_BY%TYPE;
147: l_last_update_login PAY_UPGRADE_PARAMETERS.LAST_UPDATE_LOGIN%TYPE;
148: l_last_update_date PAY_UPGRADE_PARAMETERS.LAST_UPDATE_DATE%TYPE;
149:

Line 146: l_last_updated_by PAY_UPGRADE_PARAMETERS.LAST_UPDATED_BY%TYPE;

142:
143: l_sysdate date := sysdate;
144: l_created_by PAY_UPGRADE_PARAMETERS.CREATED_BY%TYPE;
145: l_creation_date PAY_UPGRADE_PARAMETERS.CREATION_DATE%TYPE;
146: l_last_updated_by PAY_UPGRADE_PARAMETERS.LAST_UPDATED_BY%TYPE;
147: l_last_update_login PAY_UPGRADE_PARAMETERS.LAST_UPDATE_LOGIN%TYPE;
148: l_last_update_date PAY_UPGRADE_PARAMETERS.LAST_UPDATE_DATE%TYPE;
149:
150:

Line 147: l_last_update_login PAY_UPGRADE_PARAMETERS.LAST_UPDATE_LOGIN%TYPE;

143: l_sysdate date := sysdate;
144: l_created_by PAY_UPGRADE_PARAMETERS.CREATED_BY%TYPE;
145: l_creation_date PAY_UPGRADE_PARAMETERS.CREATION_DATE%TYPE;
146: l_last_updated_by PAY_UPGRADE_PARAMETERS.LAST_UPDATED_BY%TYPE;
147: l_last_update_login PAY_UPGRADE_PARAMETERS.LAST_UPDATE_LOGIN%TYPE;
148: l_last_update_date PAY_UPGRADE_PARAMETERS.LAST_UPDATE_DATE%TYPE;
149:
150:
151: cursor csr_existing_upd_def is

Line 148: l_last_update_date PAY_UPGRADE_PARAMETERS.LAST_UPDATE_DATE%TYPE;

144: l_created_by PAY_UPGRADE_PARAMETERS.CREATED_BY%TYPE;
145: l_creation_date PAY_UPGRADE_PARAMETERS.CREATION_DATE%TYPE;
146: l_last_updated_by PAY_UPGRADE_PARAMETERS.LAST_UPDATED_BY%TYPE;
147: l_last_update_login PAY_UPGRADE_PARAMETERS.LAST_UPDATE_LOGIN%TYPE;
148: l_last_update_date PAY_UPGRADE_PARAMETERS.LAST_UPDATE_DATE%TYPE;
149:
150:
151: cursor csr_existing_upd_def is
152: select upgrade_definition_id

Line 158: from pay_upgrade_parameters

154: where upper(short_name) = upper(p_short_name) ;
155:
156: cursor csr_existing_upd_param(p_def_id in varchar2) is
157: select null
158: from pay_upgrade_parameters
159: where UPGRADE_DEFINITION_ID = p_def_id
160: and PARAMETER_NAME = P_PARAMETER_NAME;
161:
162: l_exists varchar2(1);

Line 237: END PAY_UPGRADE_PARAMETERS_PKG;

233: hr_utility.set_location('Leaving:'|| l_proc, 20);
234: --
235: END Load_Row;
236:
237: END PAY_UPGRADE_PARAMETERS_PKG;
238: