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_COMMITMENT_PKG dependencies on PQH_ELEMENT_COMMITMENTS

Line 1597: l_adjusted_start_dt pqh_element_commitments.commitment_start_date%type;

1593: l_element_frequency pay_element_entry_values.screen_entry_value%type;
1594: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1595: l_element_creator_type pay_element_entries_f.creator_type%type;
1596: --
1597: l_adjusted_start_dt pqh_element_commitments.commitment_start_date%type;
1598: l_adjusted_end_dt pqh_element_commitments.commitment_end_date%type;
1599: --
1600: l_entry_commitment number;
1601: l_converted_amt number;

Line 1598: l_adjusted_end_dt pqh_element_commitments.commitment_end_date%type;

1594: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1595: l_element_creator_type pay_element_entries_f.creator_type%type;
1596: --
1597: l_adjusted_start_dt pqh_element_commitments.commitment_start_date%type;
1598: l_adjusted_end_dt pqh_element_commitments.commitment_end_date%type;
1599: --
1600: l_entry_commitment number;
1601: l_converted_amt number;
1602: --

Line 1769: l_adjusted_start_dt pqh_element_commitments.commitment_start_date%type;

1765: -- DECLARE all local variables.
1766: --
1767: l_entry_value number;
1768: l_pay_basis per_pay_bases.pay_basis%type;
1769: l_adjusted_start_dt pqh_element_commitments.commitment_start_date%type;
1770: l_adjusted_end_dt pqh_element_commitments.commitment_end_date%type;
1771: --
1772: --
1773: l_converted_amt number;

Line 1770: l_adjusted_end_dt pqh_element_commitments.commitment_end_date%type;

1766: --
1767: l_entry_value number;
1768: l_pay_basis per_pay_bases.pay_basis%type;
1769: l_adjusted_start_dt pqh_element_commitments.commitment_start_date%type;
1770: l_adjusted_end_dt pqh_element_commitments.commitment_end_date%type;
1771: --
1772: --
1773: l_converted_amt number;
1774: --

Line 2055: Delete from pqh_element_commitments

2051: Open csr_bdgt_version;
2052: Loop
2053: Fetch csr_bdgt_version into l_budget_version_id;
2054: --
2055: Delete from pqh_element_commitments
2056: where budget_version_id = l_budget_version_id;
2057: commit;
2058: --
2059: If csr_bdgt_version%notfound then

Line 2693: FROM pqh_element_commitments

2689: --
2690: hr_utility.set_location('Delete LD encumbered commitments'||to_char(t_entity_assignments(assign_cnt).assignment_id),55);
2691: --
2692: DELETE
2693: FROM pqh_element_commitments
2694: WHERE budget_version_id = p_budget_version_id
2695: AND ASSIGNMENT_ID = t_entity_assignments(assign_cnt).assignment_id
2696: AND (COMMITMENT_START_DATE BETWEEN p_actual_cmmtmnt_start_dt AND p_actual_cmmtmnt_end_dt
2697: OR p_actual_cmmtmnt_start_dt BETWEEN COMMITMENT_START_DATE AND COMMITMENT_END_DATE);

Line 2715: INTO pqh_element_commitments

2711: hr_utility.set_location('ELEMENT_TYPE_ID: '|| t_element_commitment(cnt).element_type_id||'ASSIGNMENT_ID: '||t_element_commitment(cnt).assignment_id,48);
2712: hr_utility.set_location('BUDGET_VERSION_ID: '||p_BUDGET_VERSION_ID,48);
2713: --
2714: INSERT
2715: INTO pqh_element_commitments
2716: (
2717: ELEMENT_COMMITMENT_ID ,
2718: BUDGET_VERSION_ID,
2719: ASSIGNMENT_ID,

Line 2730: pqh_element_commitments_s.nextval ,

2726: CREATED_BY
2727: )
2728: VALUES
2729: (
2730: pqh_element_commitments_s.nextval ,
2731: p_budget_version_id,
2732: t_element_commitment(cnt).assignment_id,
2733: t_element_commitment(cnt).element_type_id,
2734: p_actual_cmmtmnt_start_dt,

Line 2818: delete from pqh_element_commitments where budget_version_id = p_budget_version_id ;

2814: --
2815: --
2816: --Since the commitments were recalculated for all the calendar periods for this budget.
2817: --we are deleting the old records
2818: delete from pqh_element_commitments where budget_version_id = p_budget_version_id ;
2819:
2820: Calculate_money_cmmtmnts
2821: (p_budgeted_entity_cd => p_budgeted_entity_cd,
2822: p_budget_version_id => p_budget_version_id,

Line 2931: -- pqh_element_commitments table.Commitment is calculated for the period

2927: p_bdgt_cmmtmnt_elmnts => g_bdgt_cmmtmnt_elmnts);
2928: --
2929: -- Calculate commitment for each position under the input budget version ,
2930: -- then each assignment under the position and populate commitment into
2931: -- pqh_element_commitments table.Commitment is calculated for the period
2932: -- generated using the supplied frequency.
2933: -- From this point onwards we will start logging errors into the Process log.
2934: -- Start the Log Process
2935: --

Line 4023: Delete from pqh_element_commitments

4019: End if;
4020:
4021: hr_utility.set_location('Delete commitment',46);
4022: --
4023: Delete from pqh_element_commitments
4024: Where budget_version_id = l_budget_version_id
4025: AND ASSIGNMENT_ID = p_assignment_id
4026: AND ELEMENT_TYPE_ID = p_element_type_id
4027: AND (COMMITMENT_START_DATE between g_cmmtmnt_calc_dates(cnt).actual_cmmtmnt_start_dt

Line 4036: Insert into pqh_element_commitments(

4032: --
4033: hr_utility.set_location('Insert commitment',48);
4034: hr_utility.set_location('l_entry_commitment:'||l_entry_commitment,48);
4035: --
4036: Insert into pqh_element_commitments(
4037: ELEMENT_COMMITMENT_ID ,
4038: BUDGET_VERSION_ID,
4039: ASSIGNMENT_ID,
4040: ELEMENT_TYPE_ID,

Line 4048: pqh_element_commitments_s.nextval ,

4044: COMMITMENT_AMOUNT,
4045: CREATION_DATE,
4046: CREATED_BY)
4047: Values(
4048: pqh_element_commitments_s.nextval ,
4049: l_budget_version_id,
4050: p_assignment_id,
4051: p_element_type_id,
4052: g_cmmtmnt_calc_dates(cnt).actual_cmmtmnt_start_dt,