APPS.PSB_POSITION_ASSIGNMENTS_PVT dependencies on PSB_POSITION_ASSIGNMENTS

Line 1: PACKAGE BODY PSB_POSITION_ASSIGNMENTS_PVT AS

1: PACKAGE BODY PSB_POSITION_ASSIGNMENTS_PVT AS
2: /* $Header: PSBVPOAB.pls 120.2 2005/06/08 05:06:27 masethur ship $ */
3: --
4: -- Global Variables
5: --

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

3: --
4: -- Global Variables
5: --
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_POSITION_ASSIGNMENTS_PVT';
8: G_DBUG VARCHAR2(2000);
9:
10: /* ----------------------------------------------------------------------- */
11: --

Line 91: update PSB_POSITION_ASSIGNMENTS set

87:
88: -- do the update of the record
89: --
90: -- truncated the p_effective_start_date and p_effective_end_date for bug 4377166
91: update PSB_POSITION_ASSIGNMENTS set
92: pay_element_id = decode(p_pay_element_id, FND_API.G_MISS_NUM, pay_element_id, p_pay_element_id),
93: pay_element_option_id = decode(p_pay_element_option_id, FND_API.G_MISS_NUM, pay_element_option_id, p_pay_element_option_id),
94: attribute_value_id = decode(p_attribute_value_id, FND_API.G_MISS_NUM, attribute_value_id, p_attribute_value_id),
95: attribute_value = decode(p_attribute_value, FND_API.G_MISS_CHAR, attribute_value, p_attribute_value),

Line 197: cursor C is select ROWID from PSB_POSITION_ASSIGNMENTS

193: p_assignment_default_rule_id in number,
194: p_modify_flag in varchar2,
195: p_mode in varchar2
196: ) is
197: cursor C is select ROWID from PSB_POSITION_ASSIGNMENTS
198: where position_assignment_id = p_position_assignment_id;
199: P_LAST_UPDATE_DATE DATE;
200: P_LAST_UPDATED_BY NUMBER;
201: P_LAST_UPDATE_LOGIN NUMBER;

Line 239: SELECT psb_position_assignments_s.NEXTVAL

235: end if;
236: --
237:
238: -- assign pos assignment id
239: SELECT psb_position_assignments_s.NEXTVAL
240: INTO p_position_assignment_id
241: FROM dual;
242:
243: --

Line 244: insert into PSB_POSITION_ASSIGNMENTS (

240: INTO p_position_assignment_id
241: FROM dual;
242:
243: --
244: insert into PSB_POSITION_ASSIGNMENTS (
245: position_assignment_id ,
246: data_extract_id ,
247: worksheet_id ,
248: position_id ,

Line 403: from PSB_POSITION_ASSIGNMENTS

399: primary_employee_flag ,
400: global_default_flag ,
401: assignment_default_rule_id ,
402: modify_flag
403: from PSB_POSITION_ASSIGNMENTS
404: where position_assignment_id = P_position_assignment_id
405: for update of position_assignment_id nowait;
406: tlinfo c1%rowtype;
407: --

Line 563: delete from PSB_POSITION_ASSIGNMENTS

559: --
560: p_return_status := FND_API.G_RET_STS_SUCCESS ;
561:
562: --
563: delete from PSB_POSITION_ASSIGNMENTS
564: where position_assignment_id = p_position_assignment_id;
565: if (sql%notfound) THEN
566: null;
567: end if;

Line 631: END PSB_POSITION_ASSIGNMENTS_PVT ;

627: END get_debug;
628:
629: /* ----------------------------------------------------------------------- */
630:
631: END PSB_POSITION_ASSIGNMENTS_PVT ;