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.PQH_PTX_UTL dependencies on PQH_POSITION_TRANSACTIONS

Line 129: p_position_transaction_id out nocopy pqh_position_transactions.position_transaction_id%TYPE,

125: -- ----------------------------------------------------------------------------
126:
127: procedure fetch_position
128: (
129: p_position_transaction_id out nocopy pqh_position_transactions.position_transaction_id%TYPE,
130: p_position_id in pqh_position_transactions.position_id%TYPE,
131: p_action_date in date,
132: p_review_flag in pqh_position_transactions.review_flag%type
133: ) is

Line 130: p_position_id in pqh_position_transactions.position_id%TYPE,

126:
127: procedure fetch_position
128: (
129: p_position_transaction_id out nocopy pqh_position_transactions.position_transaction_id%TYPE,
130: p_position_id in pqh_position_transactions.position_id%TYPE,
131: p_action_date in date,
132: p_review_flag in pqh_position_transactions.review_flag%type
133: ) is
134: l_object_version_number number := 1;

Line 132: p_review_flag in pqh_position_transactions.review_flag%type

128: (
129: p_position_transaction_id out nocopy pqh_position_transactions.position_transaction_id%TYPE,
130: p_position_id in pqh_position_transactions.position_id%TYPE,
131: p_action_date in date,
132: p_review_flag in pqh_position_transactions.review_flag%type
133: ) is
134: l_object_version_number number := 1;
135: v_posn_rec HR_POSITIONS%ROWTYPE;
136: l_pei_populated varchar2(5000);

Line 178: pqh_position_transactions_api.create_position_transaction

174: fnd_message.set_name('PQH','PQH_POSITION_UNDER_REVIEW');
175: fnd_message.raise_error;
176: end if;
177: --
178: pqh_position_transactions_api.create_position_transaction
179: (
180: p_validate => false
181: ,p_position_transaction_id => p_position_transaction_id
182: ,p_action_date => p_action_date

Line 734: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,

730: -- ----------------------------------------------------------------------------
731:
732: procedure populate_pei
733: (
734: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,
735: p_position_id in pqh_position_transactions.position_id%TYPE,
736: p_populated in out nocopy varchar2
737: ) is
738:

Line 735: p_position_id in pqh_position_transactions.position_id%TYPE,

731:
732: procedure populate_pei
733: (
734: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,
735: p_position_id in pqh_position_transactions.position_id%TYPE,
736: p_populated in out nocopy varchar2
737: ) is
738:
739: /*

Line 909: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,

905: -- ----------------------------------------------------------------------------
906:
907: procedure populate_job_requirements
908: (
909: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,
910: p_position_id in pqh_position_transactions.position_id%TYPE,
911: p_populated in out nocopy varchar2
912: ) is
913:

Line 910: p_position_id in pqh_position_transactions.position_id%TYPE,

906:
907: procedure populate_job_requirements
908: (
909: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,
910: p_position_id in pqh_position_transactions.position_id%TYPE,
911: p_populated in out nocopy varchar2
912: ) is
913:
914: /*

Line 1037: When we query the pqh_position_transactions_v the session hangs. So as a

1033: procedure alter_session_push is
1034:
1035: /*
1036: This is called thru the Position Txn Form as a work around for bug 934616.
1037: When we query the pqh_position_transactions_v the session hangs. So as a
1038: work around we have to alter session set "_push_join_predicate"=FALSE
1039: */
1040: --
1041: -- local variables

Line 1067: ( p_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,

1063: -- |------------------------< apply_transaction >------------------------|
1064: -- ----------------------------------------------------------------------------
1065:
1066: function apply_transaction
1067: ( p_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,
1068: p_validate_only in varchar2 default 'NO'
1069: ) return varchar2 is
1070: /*
1071:

Line 1094: l_ptx_rec pqh_position_transactions%ROWTYPE;

1090: l_dpf_type varchar2(1);
1091: l_pei_type varchar2(1);
1092: l_update_mode varchar2(20);
1093: l_dummy varchar2(10);
1094: l_ptx_rec pqh_position_transactions%ROWTYPE;
1095: l_pte_rec pqh_ptx_extra_info%ROWTYPE;
1096: l_position_id hr_all_positions_f.position_id%TYPE;
1097: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
1098: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;

Line 1128: from pqh_position_transactions

1124: l_res_validation_end_date date;
1125:
1126: CURSOR c1 IS
1127: select *
1128: from pqh_position_transactions
1129: where position_transaction_id = p_transaction_id;
1130:
1131: CURSOR c2(p_position_id IN hr_all_positions_f.position_id%TYPE,
1132: p_effective_date IN hr_all_positions_f.effective_start_date%TYPE) IS

Line 1467: AND ENTITY_NAME = 'PQH_POSITION_TRANSACTIONS_V';

1463: UPDATE FND_ATTACHED_DOCUMENTS
1464: SET PK1_VALUE = l_position_id,
1465: ENTITY_NAME = 'PER_POSITIONS'
1466: WHERE PK1_VALUE = p_transaction_id
1467: AND ENTITY_NAME = 'PQH_POSITION_TRANSACTIONS_V';
1468:
1469:
1470:
1471: --rpullare

Line 1776: AND ENTITY_NAME = 'PQH_POSITION_TRANSACTIONS_V';

1772: UPDATE FND_ATTACHED_DOCUMENTS
1773: SET PK1_VALUE = l_ptx_rec.position_id,
1774: ENTITY_NAME = 'PER_POSITIONS'
1775: WHERE PK1_VALUE = p_transaction_id
1776: AND ENTITY_NAME = 'PQH_POSITION_TRANSACTIONS_V';
1777:
1778:
1779: --rpullare
1780: --

Line 2238: pqh_position_transactions_api.update_position_transaction

2234: pqh_ptx_utl.apply_sit(p_transaction_id, l_position_id, l_txn_type);
2235: --
2236: pqh_ptx_utl.apply_ptx_budgets(l_ptx_rec.position_transaction_id);
2237: --
2238: pqh_position_transactions_api.update_position_transaction
2239: (
2240: p_validate => false
2241: ,p_position_transaction_id => l_ptx_rec.position_transaction_id
2242: ,p_action_date => l_ptx_rec.action_date

Line 2418: pqh_position_transactions_api.update_position_transaction

2414: p_transaction_category_id => l_transaction_category_id,
2415: p_action_date => l_ptx_rec.action_date
2416: ) = 'D'
2417: then
2418: pqh_position_transactions_api.update_position_transaction
2419: (
2420: p_validate => false
2421: ,p_position_transaction_id => l_ptx_rec.position_transaction_id
2422: ,p_action_date => l_ptx_rec.action_date

Line 2596: from pqh_position_transactions

2592: cursor c0 is select name, action_date,
2593: hr_general.decode_organization(organization_id),
2594: hr_general.decode_job(job_id),
2595: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2596: from pqh_position_transactions
2597: where position_transaction_id = p_transaction_id;
2598: BEGIN
2599: hr_utility.set_location('inside fyi notification'||l_proc,10);
2600: open c0;

Line 2637: from pqh_position_transactions

2633: cursor c0 is select name, action_date,
2634: hr_general.decode_organization(organization_id),
2635: hr_general.decode_job(job_id),
2636: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2637: from pqh_position_transactions
2638: where position_transaction_id = p_transaction_id;
2639: BEGIN
2640: hr_utility.set_location('inside back notification'||l_proc,10);
2641: open c0;

Line 2678: from pqh_position_transactions

2674: cursor c0 is select name, action_date,
2675: hr_general.decode_organization(organization_id),
2676: hr_general.decode_job(job_id),
2677: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2678: from pqh_position_transactions
2679: where position_transaction_id = p_transaction_id;
2680: BEGIN
2681: hr_utility.set_location('inside override notification'||l_proc,10);
2682: open c0;

Line 2719: from pqh_position_transactions

2715: cursor c0 is select name, action_date,
2716: hr_general.decode_organization(organization_id),
2717: hr_general.decode_job(job_id),
2718: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2719: from pqh_position_transactions
2720: where position_transaction_id = p_transaction_id;
2721: BEGIN
2722: hr_utility.set_location('inside apply notification'||l_proc,10);
2723: open c0;

Line 2760: from pqh_position_transactions

2756: cursor c0 is select name, action_date,
2757: hr_general.decode_organization(organization_id),
2758: hr_general.decode_job(job_id),
2759: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2760: from pqh_position_transactions
2761: where position_transaction_id = p_transaction_id;
2762: BEGIN
2763: hr_utility.set_location('inside reject notification'||l_proc,10);
2764: open c0;

Line 2801: from pqh_position_transactions

2797: cursor c0 is select name, action_date,
2798: hr_general.decode_organization(organization_id),
2799: hr_general.decode_job(job_id),
2800: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2801: from pqh_position_transactions
2802: where position_transaction_id = p_transaction_id;
2803: BEGIN
2804: hr_utility.set_location('inside warning notification'||l_proc,10);
2805: open c0;

Line 2842: from pqh_position_transactions

2838: cursor c0 is select name, action_date,
2839: hr_general.decode_organization(organization_id),
2840: hr_general.decode_job(job_id),
2841: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2842: from pqh_position_transactions
2843: where position_transaction_id = p_transaction_id;
2844: BEGIN
2845: hr_utility.set_location('inside respond notification'||l_proc,10);
2846: open c0;

Line 2885: FROM pqh_position_transactions ptx

2881:
2882:
2883: CURSOR csr_ptx IS
2884: SELECT ptx.*
2885: FROM pqh_position_transactions ptx
2886: WHERE ptx.position_transaction_id = p_transaction_id;
2887:
2888: l_ptx_rec pqh_position_transactions%ROWTYPE;
2889: l_object_version_number pqh_position_transactions.object_version_number%TYPE;

Line 2888: l_ptx_rec pqh_position_transactions%ROWTYPE;

2884: SELECT ptx.*
2885: FROM pqh_position_transactions ptx
2886: WHERE ptx.position_transaction_id = p_transaction_id;
2887:
2888: l_ptx_rec pqh_position_transactions%ROWTYPE;
2889: l_object_version_number pqh_position_transactions.object_version_number%TYPE;
2890: l_review_flag pqh_position_transactions.review_flag%TYPE;
2891:
2892: BEGIN

Line 2889: l_object_version_number pqh_position_transactions.object_version_number%TYPE;

2885: FROM pqh_position_transactions ptx
2886: WHERE ptx.position_transaction_id = p_transaction_id;
2887:
2888: l_ptx_rec pqh_position_transactions%ROWTYPE;
2889: l_object_version_number pqh_position_transactions.object_version_number%TYPE;
2890: l_review_flag pqh_position_transactions.review_flag%TYPE;
2891:
2892: BEGIN
2893: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2890: l_review_flag pqh_position_transactions.review_flag%TYPE;

2886: WHERE ptx.position_transaction_id = p_transaction_id;
2887:
2888: l_ptx_rec pqh_position_transactions%ROWTYPE;
2889: l_object_version_number pqh_position_transactions.object_version_number%TYPE;
2890: l_review_flag pqh_position_transactions.review_flag%TYPE;
2891:
2892: BEGIN
2893: hr_utility.set_location('Entering:'||l_proc, 5);
2894:

Line 2926: pqh_position_transactions_api.update_position_transaction

2922: l_review_flag := 'N';
2923: end if;
2924:
2925:
2926: pqh_position_transactions_api.update_position_transaction
2927: (
2928: p_validate => false
2929: ,p_position_transaction_id => p_transaction_id
2930: ,p_object_version_number => l_object_version_number

Line 2957: from pqh_position_transactions

2953: --------------------------------------------------------------------------------
2954: procedure create_ptx_shadow(p_position_transaction_id number) is
2955: cursor c1 is
2956: select *
2957: from pqh_position_transactions
2958: where position_transaction_id = p_position_transaction_id
2959: and position_transaction_id not in
2960: (select position_transaction_id
2961: from pqh_ptx_shadow

Line 3137: from pqh_position_transactions

3133: p_ptx_deployment_factor_id number;
3134:
3135: cursor c_ptx(p_position_transaction_id number) is
3136: select position_id
3137: from pqh_position_transactions
3138: where position_transaction_id = p_position_transaction_id;
3139: --
3140: cursor c_dpf_df(p_position_transaction_id number) is
3141: select ptx_deployment_factor_id