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.PSB_POSITIONS_PVT dependencies on PSB_POSITIONS

Line 1: PACKAGE BODY PSB_POSITIONS_PVT AS

1: PACKAGE BODY PSB_POSITIONS_PVT AS
2: /* $Header: PSBVPOSB.pls 120.26 2006/02/17 12:40:34 matthoma ship $ */
3: --
4: -- Global Variables
5: --

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_POSITIONS_PVT';

3: --
4: -- Global Variables
5: --
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_POSITIONS_PVT';
8: G_DBUG VARCHAR2(2000);
9:
10: TYPE g_assign_rec_type IS RECORD
11: ( position_assignment_id NUMBER,

Line 271: cursor C is select ROWID from PSB_POSITIONS

267: p_name in varchar2,
268: p_mode in varchar2 := 'R'
269:
270: ) is
271: cursor C is select ROWID from PSB_POSITIONS
272: where POSITION_ID = P_POSITION_ID;
273: P_LAST_UPDATE_DATE DATE;
274: P_LAST_UPDATED_BY NUMBER;
275: P_LAST_UPDATE_LOGIN NUMBER;

Line 281: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;

277: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row' ;
278: l_api_version CONSTANT NUMBER := 1.0 ;
279: l_return_status VARCHAR2(1);
280: --
281: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;
282: l_budget_group_id psb_positions.budget_group_id%TYPE;
283: l_availability_status psb_positions.availability_status%TYPE;
284: l_transaction_id psb_positions.transaction_id%TYPE;
285: l_transaction_status psb_positions.transaction_status%TYPE;

Line 282: l_budget_group_id psb_positions.budget_group_id%TYPE;

278: l_api_version CONSTANT NUMBER := 1.0 ;
279: l_return_status VARCHAR2(1);
280: --
281: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;
282: l_budget_group_id psb_positions.budget_group_id%TYPE;
283: l_availability_status psb_positions.availability_status%TYPE;
284: l_transaction_id psb_positions.transaction_id%TYPE;
285: l_transaction_status psb_positions.transaction_status%TYPE;
286: l_new_position_flag psb_positions.new_position_flag%TYPE;

Line 283: l_availability_status psb_positions.availability_status%TYPE;

279: l_return_status VARCHAR2(1);
280: --
281: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;
282: l_budget_group_id psb_positions.budget_group_id%TYPE;
283: l_availability_status psb_positions.availability_status%TYPE;
284: l_transaction_id psb_positions.transaction_id%TYPE;
285: l_transaction_status psb_positions.transaction_status%TYPE;
286: l_new_position_flag psb_positions.new_position_flag%TYPE;
287: --

Line 284: l_transaction_id psb_positions.transaction_id%TYPE;

280: --
281: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;
282: l_budget_group_id psb_positions.budget_group_id%TYPE;
283: l_availability_status psb_positions.availability_status%TYPE;
284: l_transaction_id psb_positions.transaction_id%TYPE;
285: l_transaction_status psb_positions.transaction_status%TYPE;
286: l_new_position_flag psb_positions.new_position_flag%TYPE;
287: --
288: BEGIN

Line 285: l_transaction_status psb_positions.transaction_status%TYPE;

281: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;
282: l_budget_group_id psb_positions.budget_group_id%TYPE;
283: l_availability_status psb_positions.availability_status%TYPE;
284: l_transaction_id psb_positions.transaction_id%TYPE;
285: l_transaction_status psb_positions.transaction_status%TYPE;
286: l_new_position_flag psb_positions.new_position_flag%TYPE;
287: --
288: BEGIN
289: --

Line 286: l_new_position_flag psb_positions.new_position_flag%TYPE;

282: l_budget_group_id psb_positions.budget_group_id%TYPE;
283: l_availability_status psb_positions.availability_status%TYPE;
284: l_transaction_id psb_positions.transaction_id%TYPE;
285: l_transaction_status psb_positions.transaction_status%TYPE;
286: l_new_position_flag psb_positions.new_position_flag%TYPE;
287: --
288: BEGIN
289: --
290: SAVEPOINT Insert_Row ;

Line 360: insert into PSB_POSITIONS (

356: ELSE
357: l_new_position_flag := p_new_position_flag ;
358: END IF;
359:
360: insert into PSB_POSITIONS (
361: position_id ,
362: organization_id ,
363: data_extract_id ,
364: position_definition_id,

Line 574: from PSB_POSITIONS

570: attribute19 ,
571: attribute20 ,
572: attribute_category ,
573: name
574: from PSB_POSITIONS
575: where position_id = P_position_id
576: for update of position_id nowait;
577: tlinfo c1%rowtype;
578: --

Line 806: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;

802: l_api_name CONSTANT VARCHAR2(30) := 'Update Row';
803: l_api_version CONSTANT NUMBER := 1.0 ;
804: l_return_status VARCHAR2(1);
805: --
806: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;
807: l_budget_group_id psb_positions.budget_group_id%TYPE ;
808: l_availability_status psb_positions.availability_status%TYPE;
809: l_transaction_id psb_positions.transaction_id%TYPE;
810: l_transaction_status psb_positions.transaction_status%TYPE;

Line 807: l_budget_group_id psb_positions.budget_group_id%TYPE ;

803: l_api_version CONSTANT NUMBER := 1.0 ;
804: l_return_status VARCHAR2(1);
805: --
806: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;
807: l_budget_group_id psb_positions.budget_group_id%TYPE ;
808: l_availability_status psb_positions.availability_status%TYPE;
809: l_transaction_id psb_positions.transaction_id%TYPE;
810: l_transaction_status psb_positions.transaction_status%TYPE;
811: l_new_position_flag psb_positions.new_position_flag%TYPE;

Line 808: l_availability_status psb_positions.availability_status%TYPE;

804: l_return_status VARCHAR2(1);
805: --
806: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;
807: l_budget_group_id psb_positions.budget_group_id%TYPE ;
808: l_availability_status psb_positions.availability_status%TYPE;
809: l_transaction_id psb_positions.transaction_id%TYPE;
810: l_transaction_status psb_positions.transaction_status%TYPE;
811: l_new_position_flag psb_positions.new_position_flag%TYPE;
812: --

Line 809: l_transaction_id psb_positions.transaction_id%TYPE;

805: --
806: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;
807: l_budget_group_id psb_positions.budget_group_id%TYPE ;
808: l_availability_status psb_positions.availability_status%TYPE;
809: l_transaction_id psb_positions.transaction_id%TYPE;
810: l_transaction_status psb_positions.transaction_status%TYPE;
811: l_new_position_flag psb_positions.new_position_flag%TYPE;
812: --
813:

Line 810: l_transaction_status psb_positions.transaction_status%TYPE;

806: l_hr_employee_id psb_positions.hr_employee_id%TYPE ;
807: l_budget_group_id psb_positions.budget_group_id%TYPE ;
808: l_availability_status psb_positions.availability_status%TYPE;
809: l_transaction_id psb_positions.transaction_id%TYPE;
810: l_transaction_status psb_positions.transaction_status%TYPE;
811: l_new_position_flag psb_positions.new_position_flag%TYPE;
812: --
813:
814: BEGIN

Line 811: l_new_position_flag psb_positions.new_position_flag%TYPE;

807: l_budget_group_id psb_positions.budget_group_id%TYPE ;
808: l_availability_status psb_positions.availability_status%TYPE;
809: l_transaction_id psb_positions.transaction_id%TYPE;
810: l_transaction_status psb_positions.transaction_status%TYPE;
811: l_new_position_flag psb_positions.new_position_flag%TYPE;
812: --
813:
814: BEGIN
815: --

Line 892: update PSB_POSITIONS set

888:
889: --
890: -- do the update of the record
891: --
892: update PSB_POSITIONS set
893: position_id = p_position_id ,
894: -- de by org
895: organization_id = nvl(p_organization_id,organization_id),
896: data_extract_id = p_data_extract_id ,

Line 1030: cursor c1 is select rowid from PSB_POSITIONS

1026: p_mode in varchar2 := 'R'
1027:
1028:
1029: ) is
1030: cursor c1 is select rowid from PSB_POSITIONS
1031: where position_id = p_position_id
1032: ;
1033: dummy c1%rowtype;
1034: --

Line 1209: delete from PSB_POSITIONS

1205: raise fnd_api.g_exc_error ;
1206: END IF;
1207: --
1208:
1209: delete from PSB_POSITIONS
1210: where position_id = p_position_id;
1211: if (sql%notfound) THEN
1212: null;
1213: end if;

Line 1533: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

1529: and c.pay_element_id = pe2.pay_element_id
1530: and pe2.salary_flag = 'Y'
1531: and c.worksheet_id = p_worksheet_id
1532: and ( (
1533: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

Line 1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

1530: and pe2.salary_flag = 'Y'
1531: and c.worksheet_id = p_worksheet_id
1532: and ( (
1533: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

Line 1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

1531: and c.worksheet_id = p_worksheet_id
1532: and ( (
1533: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1539: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

Line 1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

1533: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1539: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1540: a.effective_start_date ))) )
1541: )

Line 1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1539: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1540: a.effective_start_date ))) )
1541: )
1542: )

Line 1539: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1539: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1540: a.effective_start_date ))) )
1541: )
1542: )
1543: )

Line 2858: FROM psb_positions

2854: SELECT position_id,
2855: vacant_position_flag,
2856: effective_start_date,
2857: effective_end_date
2858: FROM psb_positions
2859: WHERE data_extract_id = p_data_extract_id ;
2860: --
2861: CURSOR c_Position IS
2862: SELECT effective_start_date,

Line 2864: FROM psb_positions

2860: --
2861: CURSOR c_Position IS
2862: SELECT effective_start_date,
2863: effective_end_date
2864: FROM psb_positions
2865: WHERE position_id = p_position_id ;
2866: --
2867: BEGIN
2868:

Line 4071: FROM psb_positions

4067: --
4068: cursor position_csr IS
4069: SELECT effective_start_date ,
4070: effective_end_date
4071: FROM psb_positions
4072: WHERE position_id = p_position_id ;
4073: cursor worksheet_csr IS
4074: SELECT worksheet_id,local_copy_flag,global_worksheet_id,
4075: budget_calendar_id

Line 4337: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

4333: and c.pay_element_id = pe2.pay_element_id
4334: and pe2.salary_flag = 'Y'
4335: and c.worksheet_id = p_worksheet_id
4336: and ( (
4337: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

Line 4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

4334: and pe2.salary_flag = 'Y'
4335: and c.worksheet_id = p_worksheet_id
4336: and ( (
4337: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

Line 4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

4335: and c.worksheet_id = p_worksheet_id
4336: and ( (
4337: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4343: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

Line 4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

4337: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4343: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4344: a.effective_start_date ))) )
4345: )

Line 4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4343: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4344: a.effective_start_date ))) )
4345: )
4346: )

Line 4343: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4343: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4344: a.effective_start_date ))) )
4345: )
4346: )
4347: )

Line 4541: FROM psb_positions pos,

4537: pos.effective_start_date,
4538: pos.effective_end_date,
4539: pos.name ,
4540: emp.employee_number
4541: FROM psb_positions pos,
4542: psb_employees emp
4543: WHERE pos.data_extract_id = l_data_extract_id
4544: AND pos.hr_employee_id = emp.hr_employee_id(+)
4545: AND emp.data_extract_id(+) = l_data_extract_id

Line 5507: l_check_allowed_ret_status:= PSB_POSITIONS_I_PVT.Check_Allowed

5503: -- ... budget group's hierarchy
5504: -- ... call wrapper
5505:
5506:
5507: l_check_allowed_ret_status:= PSB_POSITIONS_I_PVT.Check_Allowed
5508: (
5509: p_api_version => 1.0,
5510: p_init_msg_list => FND_API.G_FALSE,
5511: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 6403: END PSB_POSITIONS_PVT ;

6399:
6400: End Apply_Position_Default_Rules;
6401: /* Bug 1308558 End */
6402:
6403: END PSB_POSITIONS_PVT ;