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.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_BUDGET_REVISION_POSITIONS

Line 734: from PSB_BUDGET_REVISION_POSITIONS a, PSB_BUDGET_REVISION_POS_LINES b

730: and b.budget_revision_acct_line_id = a.budget_revision_acct_line_id);
731:
732: cursor c_position_dates_br is
733: select min(effective_start_date) start_date, max(effective_end_date) end_date
734: from PSB_BUDGET_REVISION_POSITIONS a, PSB_BUDGET_REVISION_POS_LINES b
735: where b.budget_revision_id = p_budget_revision_id
736: and a.budget_revision_pos_line_id = b.budget_revision_pos_line_id;
737:
738: cursor c_position_exists is

Line 3213: from PSB_BUDGET_REVISION_POS_LINES pbrpl, PSB_BUDGET_REVISION_POSITIONS pbrp

3209: select pbrp.position_id, pbrp.effective_start_date, pbrp.effective_end_date,
3210: /* Bug No 1808330 Start */
3211: pbrp.budget_revision_pos_line_id
3212: /* Bug No 1808330 End */
3213: from PSB_BUDGET_REVISION_POS_LINES pbrpl, PSB_BUDGET_REVISION_POSITIONS pbrp
3214: where pbrpl.budget_revision_id = p_budget_revision_id
3215: and pbrp.budget_revision_pos_line_id = pbrpl.budget_revision_pos_line_id;
3216:
3217: cursor c_period_list is

Line 3735: INSERT INTO PSB_BUDGET_REVISION_POSITIONS

3731: for c_seq_rec in c_seq loop
3732: l_budget_revision_pos_line_id := c_seq_rec.seq;
3733: end loop;
3734:
3735: INSERT INTO PSB_BUDGET_REVISION_POSITIONS
3736: (budget_revision_pos_line_id, position_id, budget_group_id, effective_start_date,
3737: effective_end_date, revision_type, revision_value_type, revision_value, note_id,
3738: last_update_date, last_updated_by, last_update_login, created_by, creation_date)
3739: VALUES (l_budget_revision_pos_line_id, p_position_id, p_budget_group_id, p_effective_start_date,

Line 3795: update PSB_BUDGET_REVISION_POSITIONS

3791: ) IS
3792:
3793: BEGIN
3794:
3795: update PSB_BUDGET_REVISION_POSITIONS
3796: set budget_group_id = p_budget_group_id,
3797: effective_start_date = decode(p_effective_start_date, FND_API.G_MISS_DATE, effective_start_date, p_effective_start_date),
3798: effective_end_date = decode(p_effective_end_date, FND_API.G_MISS_DATE, effective_end_date, p_effective_end_date),
3799: revision_type = p_revision_type,

Line 3834: delete from PSB_BUDGET_REVISION_POSITIONS

3830: ) IS
3831:
3832: BEGIN
3833:
3834: delete from PSB_BUDGET_REVISION_POSITIONS
3835: where budget_revision_pos_line_id = p_budget_revision_pos_line_id;
3836:
3837: -- Initialize API return status to success
3838:

Line 3889: from psb_budget_revision_positions pbrp,

3885: l_return_status VARCHAR2(1);
3886:
3887: cursor c_Overlap is
3888: select pbrp.*
3889: from psb_budget_revision_positions pbrp,
3890: psb_budget_revision_pos_lines pbrl
3891: where pbrp.position_id = p_position_id
3892: and ((((p_effective_end_date is not null)
3893: and ((pbrp.effective_start_date <= p_effective_end_date)

Line 3924: update PSB_BUDGET_REVISION_POSITIONS brp

3920: IF FND_API.to_Boolean (p_init_msg_list) THEN
3921: FND_MSG_PUB.initialize;
3922: END IF;
3923:
3924: update PSB_BUDGET_REVISION_POSITIONS brp
3925: set budget_group_id = p_budget_group_id,
3926: revision_type = p_revision_type,
3927: revision_value_type = p_revision_value_type,
3928: revision_value = p_revision_value,

Line 7004: from PSB_BUDGET_REVISION_POSITIONS brp, PSB_BUDGET_REVISION_POS_LINES brpl

7000: FND_NUMBER.canonical_to_number(attribute_value) desc; -- Fixed bug # 3683644
7001:
7002: cursor c_fte is
7003: select brp.revision_type, brp.revision_value_type, brp.revision_value, brp.effective_start_date, brp.effective_end_date
7004: from PSB_BUDGET_REVISION_POSITIONS brp, PSB_BUDGET_REVISION_POS_LINES brpl
7005: where brp.position_id = p_position_id
7006: and ((effective_start_date between p_revision_start_date and p_revision_end_date)
7007: or (effective_end_date between p_revision_start_date and p_revision_end_date)
7008: or ((effective_start_date < p_revision_start_date)

Line 8353: from PSB_BUDGET_REVISION_POSITIONS c,

8349: select sum(nvl(a.element_cost, 0)) Sum_Elem
8350: from PSB_POSITION_COSTS a
8351: where exists
8352: (select 1
8353: from PSB_BUDGET_REVISION_POSITIONS c,
8354: PSB_BUDGET_REVISION_POS_LINES d,
8355: PSB_BUDGET_POSITIONS e,
8356: PSB_SET_RELATIONS f
8357: where d.budget_revision_id = a.budget_revision_id

Line 8374: from PSB_BUDGET_REVISION_POSITIONS d,

8370: from PSB_POSITION_COSTS a,
8371: PSB_PAY_ELEMENTS c
8372: where exists
8373: (select 1
8374: from PSB_BUDGET_REVISION_POSITIONS d,
8375: PSB_BUDGET_REVISION_POS_LINES e,
8376: PSB_BUDGET_POSITIONS f,
8377: PSB_SET_RELATIONS g
8378: where e.budget_revision_id = a.budget_revision_id

Line 8834: from PSB_BUDGET_REVISION_POSITIONS c,

8830: select sum(nvl(a.fte, 0)) Sum_FTE
8831: from PSB_POSITION_FTE a
8832: where exists
8833: (select 1
8834: from PSB_BUDGET_REVISION_POSITIONS c,
8835: PSB_BUDGET_REVISION_POS_LINES d,
8836: PSB_BUDGET_POSITIONS e,
8837: PSB_SET_RELATIONS f
8838: where c.budget_revision_pos_line_id = d.budget_revision_pos_line_id

Line 9013: from PSB_BUDGET_REVISION_POSITIONS a,

9009:
9010: cursor c_Positions is
9011: select d.position_id,
9012: c.name
9013: from PSB_BUDGET_REVISION_POSITIONS a,
9014: PSB_BUDGET_REVISION_POS_LINES b,
9015: PSB_POSITIONS c,
9016: PSB_BUDGET_POSITIONS d,
9017: PSB_SET_RELATIONS e

Line 9404: from psb_budget_revision_positions

9400: where pbr.budget_revision_id = p_budget_revision_id;
9401:
9402: cursor c_Position_Revision is
9403: select position_id, effective_start_date, effective_end_date
9404: from psb_budget_revision_positions
9405: where budget_revision_pos_line_id = p_budget_revision_pos_line_id;
9406:
9407: BEGIN
9408:

Line 9453: DELETE PSB_BUDGET_REVISION_POSITIONS

9449: /* Bug No 2482305 End */
9450:
9451: If l_global_revision = 'Y' Then
9452:
9453: DELETE PSB_BUDGET_REVISION_POSITIONS
9454: WHERE budget_revision_pos_line_id = p_budget_revision_pos_line_id;
9455:
9456: DELETE PSB_BUDGET_REVISION_POS_LINES
9457: WHERE budget_revision_pos_line_id = p_budget_revision_pos_line_id;

Line 9696: FROM psb_budget_revision_positions brp,

9692: FROM psb_positions pp
9693: WHERE pp.data_extract_id = l_data_extract_id
9694: AND nvl(pp.new_position_flag, 'N') = 'Y'
9695: AND EXISTS (SELECT 1
9696: FROM psb_budget_revision_positions brp,
9697: psb_budget_revision_pos_lines brpl,
9698: psb_budget_revisions br
9699: WHERE br.budget_revision_id = p_budget_revision_id
9700: AND br.budget_revision_id = brpl.budget_revision_id

Line 11737: FROM PSB_BUDGET_REVISION_POSITIONS pbrp, PSB_BUDGET_REVISION_ACCOUNTS pbra

11733: CURSOR c_pos_note_id
11734: IS
11735: SELECT pbrp.note_id,
11736: pbra.code_combination_id
11737: FROM PSB_BUDGET_REVISION_POSITIONS pbrp, PSB_BUDGET_REVISION_ACCOUNTS pbra
11738: WHERE pbrp.budget_revision_pos_line_id = p_position_line_id
11739: AND pbrp.position_id = pbra.position_id;
11740:
11741: BEGIN

Line 11775: update PSB_BUDGET_REVISION_POSITIONS

11771: update PSB_BUDGET_REVISION_ACCOUNTS
11772: set note_id = l_note_id
11773: where budget_revision_acct_line_id = p_account_line_id;
11774: elsif p_position_line_id is not null then
11775: update PSB_BUDGET_REVISION_POSITIONS
11776: set note_id = l_note_id
11777: where budget_revision_pos_line_id = p_position_line_id;
11778: end if;
11779: