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.PER_SSHR_CHANGE_PAY dependencies on HR_API_TRANSACTION_VALUES

Line 29: hr_api_transaction_values hatv

25: Cursor csr_gsp_ladder_id Is
26: select hatv.number_value
27: from hr_api_transaction_steps hats,
28: hr_api_transactions hat,
29: hr_api_transaction_values hatv
30: where hats.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
31: and hatv.transaction_step_id = hats.transaction_step_id
32: and hatv.name = 'P_GRADE_LADDER_PGM_ID'
33: and hats.TRANSACTION_ID = hat.TRANSACTION_ID

Line 132: from hr_api_transaction_values

128: max(col2) as pay_basis_id
129: from
130: (select decode(NAME, 'P_ASSIGNMENT_ID', NUMBER_VALUE) col1,
131: decode(NAME, 'P_PAY_BASIS_ID', NUMBER_VALUE) col2
132: from hr_api_transaction_values
133: where TRANSACTION_STEP_ID = c_transaction_step_id);
134: --
135: Cursor csr_pay_basis_exists(c_assignment_id number,c_effective_date date) IS
136: select pay_basis_id

Line 406: update hr_api_transaction_values

402: l_tx_date(l_count) := null;
403: l_tx_type(l_count) := 'NUMBER';
404: --
405: forall i in 1..l_count
406: update hr_api_transaction_values
407: set
408: varchar2_value = l_tx_char(i),
409: number_value = l_tx_num(i),
410: date_value = l_tx_date(i)

Line 1227: insert into hr_api_transaction_values

1223:
1224: -- Insert all other assignment values as unchanged.
1225:
1226: forall i in 1..l_count
1227: insert into hr_api_transaction_values
1228: ( transaction_value_id,
1229: transaction_step_id,
1230: datatype,
1231: name,

Line 1239: ( hr_api_transaction_values_s.nextval,

1235: original_varchar2_value,
1236: original_number_value,
1237: original_date_value)
1238: Values
1239: ( hr_api_transaction_values_s.nextval,
1240: l_transaction_step_id,
1241: l_tx_type(i),
1242: l_tx_name(i),
1243: l_tx_char(i),

Line 1252: update hr_api_transaction_values

1248: l_tx_date(i));
1249:
1250: -- Update change in pay basis value
1251:
1252: update hr_api_transaction_values
1253: set
1254: number_value = p_pay_basis_id
1255: where transaction_step_id = l_transaction_step_id
1256: and name = 'P_PAY_BASIS_ID';

Line 1274: from hr_api_transaction_values hatv,

1270: is
1271:
1272: Cursor csr_txn_basis_change_date Is
1273: select hatv1.date_value date_value
1274: from hr_api_transaction_values hatv,
1275: hr_api_transaction_steps hats,
1276: hr_api_transactions hat,
1277: hr_api_transaction_values hatv1
1278: where hatv.NAME = 'P_PAY_BASIS_ID'

Line 1277: hr_api_transaction_values hatv1

1273: select hatv1.date_value date_value
1274: from hr_api_transaction_values hatv,
1275: hr_api_transaction_steps hats,
1276: hr_api_transactions hat,
1277: hr_api_transaction_values hatv1
1278: where hatv.NAME = 'P_PAY_BASIS_ID'
1279: and hatv1.NAME = 'P_EFFECTIVE_DATE'
1280: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID
1281: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

Line 2846: hr_api_transaction_values tr_values,

2842: select trans.pay_basis_id,
2843: trans.pay_transaction_id
2844: from per_pay_transactions trans,
2845: hr_api_transaction_steps tr_steps,
2846: hr_api_transaction_values tr_values,
2847: hr_api_transaction_values tr_values2
2848: where trans.assignment_id = c_assgn_id
2849: and trans.item_type = c_item_type
2850: and trans.item_key = c_item_key

Line 2847: hr_api_transaction_values tr_values2

2843: trans.pay_transaction_id
2844: from per_pay_transactions trans,
2845: hr_api_transaction_steps tr_steps,
2846: hr_api_transaction_values tr_values,
2847: hr_api_transaction_values tr_values2
2848: where trans.assignment_id = c_assgn_id
2849: and trans.item_type = c_item_type
2850: and trans.item_key = c_item_key
2851: and tr_steps.item_type = c_item_type

Line 3075: insert into hr_api_transaction_values

3071: l_tx_date(2) := null;
3072: l_tx_type(2) := 'VARCHAR2';
3073: --
3074: forall i in 1..2
3075: insert into hr_api_transaction_values
3076: ( transaction_value_id,
3077: transaction_step_id,
3078: datatype,
3079: name,

Line 3087: ( hr_api_transaction_values_s.nextval,

3083: original_varchar2_value,
3084: original_number_value,
3085: original_date_value)
3086: Values
3087: ( hr_api_transaction_values_s.nextval,
3088: l_transaction_step_id,
3089: l_tx_type(i),
3090: l_tx_name(i),
3091: l_tx_char(i),

Line 3726: delete from hr_api_transaction_values

3722: where transaction_step_id=p_transaction_step_id;
3723:
3724: if(l_count = 0 ) then
3725:
3726: delete from hr_api_transaction_values
3727: where transaction_step_id=p_transaction_step_id;
3728:
3729: delete from hr_api_transaction_steps
3730: where transaction_step_id=p_transaction_step_id;

Line 3862: from hr_api_transaction_values hatv,

3858: order by change_date desc;
3859: --
3860: Cursor csr_txn_basis_change_date Is
3861: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
3862: from hr_api_transaction_values hatv,
3863: hr_api_transaction_steps hats,
3864: hr_api_transactions hat,
3865: hr_api_transaction_values hatv1
3866: where hatv.NAME = 'P_PAY_BASIS_ID'

Line 3865: hr_api_transaction_values hatv1

3861: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
3862: from hr_api_transaction_values hatv,
3863: hr_api_transaction_steps hats,
3864: hr_api_transactions hat,
3865: hr_api_transaction_values hatv1
3866: where hatv.NAME = 'P_PAY_BASIS_ID'
3867: and hatv1.NAME = 'P_EFFECTIVE_DATE'
3868: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID
3869: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

Line 3881: hr_api_transaction_values hatv

3877: Cursor csr_txn_asst_change_date Is
3878: select hatv.date_value
3879: from hr_api_transaction_steps hats,
3880: hr_api_transactions hat,
3881: hr_api_transaction_values hatv
3882: where hats.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
3883: and hatv.transaction_step_id = hats.transaction_step_id
3884: and hatv.name = 'P_EFFECTIVE_DATE'
3885: and hats.TRANSACTION_ID = hat.TRANSACTION_ID

Line 3943: from hr_api_transaction_values hatv,

3939: --
3940: Cursor csr_txn_basis_id Is
3941: select hatv.number_value,
3942: hatv.original_number_value
3943: from hr_api_transaction_values hatv,
3944: hr_api_transaction_steps hats,
3945: hr_api_transactions hat
3946: where hatv.NAME = 'P_PAY_BASIS_ID'
3947: and hatv.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID

Line 4464: from hr_api_transaction_values hatv,

4460: --
4461: --
4462: Cursor csr_txn_basis_change_date Is
4463: select hatv1.date_value ,hatv.number_value
4464: from hr_api_transaction_values hatv,
4465: hr_api_transaction_steps hats,
4466: hr_api_transactions hat,
4467: hr_api_transaction_values hatv1
4468: where hatv.NAME = 'P_PAY_BASIS_ID'

Line 4467: hr_api_transaction_values hatv1

4463: select hatv1.date_value ,hatv.number_value
4464: from hr_api_transaction_values hatv,
4465: hr_api_transaction_steps hats,
4466: hr_api_transactions hat,
4467: hr_api_transaction_values hatv1
4468: where hatv.NAME = 'P_PAY_BASIS_ID'
4469: and hatv1.NAME = 'P_EFFECTIVE_DATE'
4470: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID
4471: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

Line 4999: from hr_api_transaction_values hatv,

4995: --
4996: --
4997: Cursor csr_txn_basis_change_date Is
4998: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
4999: from hr_api_transaction_values hatv,
5000: hr_api_transaction_steps hats,
5001: hr_api_transactions hat,
5002: hr_api_transaction_values hatv1
5003: where hatv.NAME = 'P_PAY_BASIS_ID'

Line 5002: hr_api_transaction_values hatv1

4998: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
4999: from hr_api_transaction_values hatv,
5000: hr_api_transaction_steps hats,
5001: hr_api_transactions hat,
5002: hr_api_transaction_values hatv1
5003: where hatv.NAME = 'P_PAY_BASIS_ID'
5004: and hatv1.NAME = 'P_EFFECTIVE_DATE'
5005: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID
5006: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

Line 5018: hr_api_transaction_values hatv

5014: Cursor csr_txn_asst_change_date Is
5015: select hatv.date_value
5016: from hr_api_transaction_steps hats,
5017: hr_api_transactions hat,
5018: hr_api_transaction_values hatv
5019: where hats.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
5020: and hatv.transaction_step_id = hats.transaction_step_id
5021: and hatv.name = 'P_EFFECTIVE_DATE'
5022: and hats.TRANSACTION_ID = hat.TRANSACTION_ID

Line 5349: from hr_api_transaction_values

5345: from(
5346: select decode(NAME, 'P_FREQUENCY', VARCHAR2_VALUE) frequencyCol,
5347: decode(NAME, 'P_NORMAL_HOURS', NUMBER_VALUE) astHoursCol,
5348: decode(NAME, 'P_EFFECTIVE_DATE',DATE_VALUE) effDateCol
5349: from hr_api_transaction_values
5350: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps
5351: where API_NAME = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
5352: and TRANSACTION_ID = p_transaction_id)
5353: ) ;

Line 5366: from hr_api_transaction_values

5362: Select max(position_id) position_id , max(org_id) org_id, max(bg_id) bg_id from (
5363: select decode (NAME, 'P_POSITION_ID', NUMBER_VALUE) position_id,
5364: decode (NAME, 'P_ORGANIZATION_ID', NUMBER_VALUE) org_id,
5365: decode (NAME, 'P_BUSINESS_GROUP_ID', NUMBER_VALUE) bg_id
5366: from hr_api_transaction_values
5367: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps
5368: where API_NAME = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
5369: and TRANSACTION_ID = p_transaction_id));
5370: