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.

[Home] [Help]

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 131: from hr_api_transaction_values

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

Line 405: update hr_api_transaction_values

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

Line 1219: insert into hr_api_transaction_values

1215:
1216: -- Insert all other assignment values as unchanged.
1217:
1218: forall i in 1..l_count
1219: insert into hr_api_transaction_values
1220: ( transaction_value_id,
1221: transaction_step_id,
1222: datatype,
1223: name,

Line 1231: ( hr_api_transaction_values_s.nextval,

1227: original_varchar2_value,
1228: original_number_value,
1229: original_date_value)
1230: Values
1231: ( hr_api_transaction_values_s.nextval,
1232: l_transaction_step_id,
1233: l_tx_type(i),
1234: l_tx_name(i),
1235: l_tx_char(i),

Line 1244: update hr_api_transaction_values

1240: l_tx_date(i));
1241:
1242: -- Update change in pay basis value
1243:
1244: update hr_api_transaction_values
1245: set
1246: number_value = p_pay_basis_id
1247: where transaction_step_id = l_transaction_step_id
1248: and name = 'P_PAY_BASIS_ID';

Line 1266: from hr_api_transaction_values hatv,

1262: is
1263:
1264: Cursor csr_txn_basis_change_date Is
1265: select hatv1.date_value date_value
1266: from hr_api_transaction_values hatv,
1267: hr_api_transaction_steps hats,
1268: hr_api_transactions hat,
1269: hr_api_transaction_values hatv1
1270: where hatv.NAME = 'P_PAY_BASIS_ID'

Line 1269: hr_api_transaction_values hatv1

1265: select hatv1.date_value date_value
1266: from hr_api_transaction_values hatv,
1267: hr_api_transaction_steps hats,
1268: hr_api_transactions hat,
1269: hr_api_transaction_values hatv1
1270: where hatv.NAME = 'P_PAY_BASIS_ID'
1271: and hatv1.NAME = 'P_EFFECTIVE_DATE'
1272: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID
1273: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

Line 2815: hr_api_transaction_values tr_values,

2811: select trans.pay_basis_id,
2812: trans.pay_transaction_id
2813: from per_pay_transactions trans,
2814: hr_api_transaction_steps tr_steps,
2815: hr_api_transaction_values tr_values,
2816: hr_api_transaction_values tr_values2
2817: where trans.assignment_id = c_assgn_id
2818: and trans.item_type = c_item_type
2819: and trans.item_key = c_item_key

Line 2816: hr_api_transaction_values tr_values2

2812: trans.pay_transaction_id
2813: from per_pay_transactions trans,
2814: hr_api_transaction_steps tr_steps,
2815: hr_api_transaction_values tr_values,
2816: hr_api_transaction_values tr_values2
2817: where trans.assignment_id = c_assgn_id
2818: and trans.item_type = c_item_type
2819: and trans.item_key = c_item_key
2820: and tr_steps.item_type = c_item_type

Line 3044: insert into hr_api_transaction_values

3040: l_tx_date(2) := null;
3041: l_tx_type(2) := 'VARCHAR2';
3042: --
3043: forall i in 1..2
3044: insert into hr_api_transaction_values
3045: ( transaction_value_id,
3046: transaction_step_id,
3047: datatype,
3048: name,

Line 3056: ( hr_api_transaction_values_s.nextval,

3052: original_varchar2_value,
3053: original_number_value,
3054: original_date_value)
3055: Values
3056: ( hr_api_transaction_values_s.nextval,
3057: l_transaction_step_id,
3058: l_tx_type(i),
3059: l_tx_name(i),
3060: l_tx_char(i),

Line 3733: from hr_api_transaction_values hatv,

3729: order by change_date desc;
3730: --
3731: Cursor csr_txn_basis_change_date Is
3732: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
3733: from hr_api_transaction_values hatv,
3734: hr_api_transaction_steps hats,
3735: hr_api_transactions hat,
3736: hr_api_transaction_values hatv1
3737: where hatv.NAME = 'P_PAY_BASIS_ID'

Line 3736: hr_api_transaction_values hatv1

3732: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
3733: from hr_api_transaction_values hatv,
3734: hr_api_transaction_steps hats,
3735: hr_api_transactions hat,
3736: hr_api_transaction_values hatv1
3737: where hatv.NAME = 'P_PAY_BASIS_ID'
3738: and hatv1.NAME = 'P_EFFECTIVE_DATE'
3739: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID
3740: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

Line 3751: hr_api_transaction_values hatv

3747: Cursor csr_txn_asst_change_date Is
3748: select hatv.date_value
3749: from hr_api_transaction_steps hats,
3750: hr_api_transactions hat,
3751: hr_api_transaction_values hatv
3752: where hats.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
3753: and hatv.transaction_step_id = hats.transaction_step_id
3754: and hatv.name = 'P_EFFECTIVE_DATE'
3755: and hats.TRANSACTION_ID = hat.TRANSACTION_ID

Line 3812: from hr_api_transaction_values hatv,

3808: --
3809: Cursor csr_txn_basis_id Is
3810: select hatv.number_value,
3811: hatv.original_number_value
3812: from hr_api_transaction_values hatv,
3813: hr_api_transaction_steps hats,
3814: hr_api_transactions hat
3815: where hatv.NAME = 'P_PAY_BASIS_ID'
3816: and hatv.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID

Line 4329: from hr_api_transaction_values hatv,

4325: --
4326: --
4327: Cursor csr_txn_basis_change_date Is
4328: select hatv1.date_value ,hatv.number_value
4329: from hr_api_transaction_values hatv,
4330: hr_api_transaction_steps hats,
4331: hr_api_transactions hat,
4332: hr_api_transaction_values hatv1
4333: where hatv.NAME = 'P_PAY_BASIS_ID'

Line 4332: hr_api_transaction_values hatv1

4328: select hatv1.date_value ,hatv.number_value
4329: from hr_api_transaction_values hatv,
4330: hr_api_transaction_steps hats,
4331: hr_api_transactions hat,
4332: hr_api_transaction_values hatv1
4333: where hatv.NAME = 'P_PAY_BASIS_ID'
4334: and hatv1.NAME = 'P_EFFECTIVE_DATE'
4335: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID
4336: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

Line 4863: from hr_api_transaction_values hatv,

4859: --
4860: --
4861: Cursor csr_txn_basis_change_date Is
4862: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
4863: from hr_api_transaction_values hatv,
4864: hr_api_transaction_steps hats,
4865: hr_api_transactions hat,
4866: hr_api_transaction_values hatv1
4867: where hatv.NAME = 'P_PAY_BASIS_ID'

Line 4866: hr_api_transaction_values hatv1

4862: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
4863: from hr_api_transaction_values hatv,
4864: hr_api_transaction_steps hats,
4865: hr_api_transactions hat,
4866: hr_api_transaction_values hatv1
4867: where hatv.NAME = 'P_PAY_BASIS_ID'
4868: and hatv1.NAME = 'P_EFFECTIVE_DATE'
4869: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID
4870: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

Line 4881: hr_api_transaction_values hatv

4877: Cursor csr_txn_asst_change_date Is
4878: select hatv.date_value
4879: from hr_api_transaction_steps hats,
4880: hr_api_transactions hat,
4881: hr_api_transaction_values hatv
4882: where hats.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
4883: and hatv.transaction_step_id = hats.transaction_step_id
4884: and hatv.name = 'P_EFFECTIVE_DATE'
4885: and hats.TRANSACTION_ID = hat.TRANSACTION_ID

Line 5208: from hr_api_transaction_values

5204: ,1) as frequency
5205: from(
5206: select decode(NAME, 'P_FREQUENCY', VARCHAR2_VALUE) frequencyCol,
5207: decode(NAME, 'P_NORMAL_HOURS', NUMBER_VALUE) astHoursCol
5208: from hr_api_transaction_values
5209: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps
5210: where API_NAME = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
5211: and TRANSACTION_ID = p_transaction_id)
5212: ) ;

Line 5225: from hr_api_transaction_values

5221: Select max(position_id) position_id , max(org_id) org_id, max(bg_id) bg_id from (
5222: select decode (NAME, 'P_POSITION_ID', NUMBER_VALUE) position_id,
5223: decode (NAME, 'P_ORGANIZATION_ID', NUMBER_VALUE) org_id,
5224: decode (NAME, 'P_BUSINESS_GROUP_ID', NUMBER_VALUE) bg_id
5225: from hr_api_transaction_values
5226: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps
5227: where API_NAME = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
5228: and TRANSACTION_ID = p_transaction_id));
5229: