APPS.PSB_PAY_ELEMENT_OPTIONS_PVT dependencies on PSB_PAY_ELEMENT_OPTIONS

Line 1: PACKAGE BODY PSB_PAY_ELEMENT_OPTIONS_PVT AS

1: PACKAGE BODY PSB_PAY_ELEMENT_OPTIONS_PVT AS
2: /* $Header: PSBVOPTB.pls 120.2 2005/07/13 11:27:27 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_PAY_ELEMENT_OPTIONS_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_PAY_ELEMENT_OPTIONS_PVT';

1: PACKAGE BODY PSB_PAY_ELEMENT_OPTIONS_PVT AS
2: /* $Header: PSBVOPTB.pls 120.2 2005/07/13 11:27:27 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_PAY_ELEMENT_OPTIONS_PVT';
5:
6: /* ----------------------------------------------------------------------- */
7:
8: PROCEDURE INSERT_ROW

Line 34: select ROWID from psb_pay_element_options

30: l_api_version CONSTANT NUMBER := 1.0;
31: l_row_id varchar2(40);
32: --
33: cursor c1 is
34: select ROWID from psb_pay_element_options
35: where pay_element_option_id = p_pay_element_option_id
36: and pay_element_id = p_pay_element_id;
37:
38: BEGIN

Line 66: INSERT INTO psb_pay_element_options

62: p_return_status := FND_API.G_RET_STS_SUCCESS;
63:
64:
65: -- API body
66: INSERT INTO psb_pay_element_options
67: (
68: PAY_ELEMENT_OPTION_ID ,
69: PAY_ELEMENT_ID ,
70: NAME ,

Line 200: UPDATE psb_pay_element_options SET

196:
197: p_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: -- API body
200: UPDATE psb_pay_element_options SET
201: NAME = P_NAME ,
202: GRADE_STEP = P_GRADE_STEP ,
203: SEQUENCE_NUMBER = P_SEQUENCE_NUMBER ,
204: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE ,

Line 305: --Deleting detail record from psb_pay_element_options and

301: if FND_API.to_Boolean (p_init_msg_list) then
302: FND_MSG_PUB.initialize;
303: end if;
304:
305: --Deleting detail record from psb_pay_element_options and
306: --from psb_pay_element_rates to maintain the isolated delete
307: --relation between the master and detail
308:
309: DELETE FROM psb_pay_element_rates

Line 314: DELETE FROM psb_pay_element_options

310: WHERE pay_element_option_id = p_pay_element_option_id
311: AND pay_element_id = p_pay_element_id;
312:
313: --Delete the record in the master table
314: DELETE FROM psb_pay_element_options
315: WHERE pay_element_option_id = p_pay_element_option_id
316: AND pay_element_id = p_pay_element_id;
317:
318:

Line 397: CURSOR C IS SELECT * FROM PSB_PAY_ELEMENT_OPTIONS

393: l_api_version CONSTANT NUMBER := 1.0;
394: --
395: counter number;
396:
397: CURSOR C IS SELECT * FROM PSB_PAY_ELEMENT_OPTIONS
398: WHERE pay_element_option_id = p_pay_element_option_id
399: AND pay_element_id = p_pay_element_id
400: FOR UPDATE of PAY_ELEMENT_OPTION_Id NOWAIT;
401: Recinfo C%ROWTYPE;

Line 531: FROM psb_pay_element_options

527: l_tmp VARCHAR2(1);
528:
529: CURSOR c IS
530: SELECT '1'
531: FROM psb_pay_element_options
532: WHERE name = p_name
533: AND ( (p_pay_element_option_id IS NULL)
534: OR ( pay_element_option_id <> p_pay_element_option_id) )
535: AND ( (pay_element_id = p_pay_element_id) );

Line 539: FROM psb_pay_element_options

535: AND ( (pay_element_id = p_pay_element_id) );
536:
537: CURSOR c1 IS
538: SELECT '1'
539: FROM psb_pay_element_options
540: WHERE name = p_name
541: AND grade_step = p_grade_step
542: AND ( (p_pay_element_option_id IS NULL)
543: OR ( pay_element_option_id <> p_pay_element_option_id) )

Line 735: END PSB_PAY_ELEMENT_OPTIONS_PVT;

731:
732:
733:
734:
735: END PSB_PAY_ELEMENT_OPTIONS_PVT;