APPS.PSB_ENTITY_SET_PVT dependencies on PSB_ENTITY_SET

Line 1: PACKAGE BODY PSB_ENTITY_SET_PVT AS

1: PACKAGE BODY PSB_ENTITY_SET_PVT AS
2: /* $Header: PSBVESPB.pls 120.4 2005/03/16 05:33:01 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_ENTITY_SET_PVT';
5: -- The flag determines whether to print debug information or not.

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

1: PACKAGE BODY PSB_ENTITY_SET_PVT AS
2: /* $Header: PSBVESPB.pls 120.4 2005/03/16 05:33:01 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_ENTITY_SET_PVT';
5: -- The flag determines whether to print debug information or not.
6: g_debug_flag VARCHAR2(1) := 'N' ;
7:
8: /* ---------------------- Private Procedures -----------------------*/

Line 78: cursor C is select ROWID from PSB_ENTITY_SET

74: --
75: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
76: l_api_version CONSTANT NUMBER := 1.0;
77: --
78: cursor C is select ROWID from PSB_ENTITY_SET
79: where ENTITY_SET_ID = P_ENTITY_SET_ID;
80: BEGIN
81: --
82: SAVEPOINT Insert_Row_Pvt ;

Line 99: insert into PSB_ENTITY_SET (

95: END IF;
96: --
97: p_return_status := FND_API.G_RET_STS_SUCCESS ;
98: --
99: insert into PSB_ENTITY_SET (
100: ENTITY_SET_ID,
101: ENTITY_TYPE,
102: NAME,
103: DESCRIPTION,

Line 276: from PSB_ENTITY_SET

272: ATTRIBUTE8,
273: ATTRIBUTE9,
274: ATTRIBUTE10,
275: CONTEXT
276: from PSB_ENTITY_SET
277: where ENTITY_SET_ID = P_ENTITY_SET_ID
278: for update of ENTITY_SET_ID nowait;
279: tlinfo c1%rowtype;
280: BEGIN

Line 487: update PSB_ENTITY_SET set

483: END IF;
484: --
485: p_return_status := FND_API.G_RET_STS_SUCCESS ;
486: --
487: update PSB_ENTITY_SET set
488: ENTITY_TYPE = P_ENTITY_TYPE,
489: NAME = P_NAME,
490: DESCRIPTION = P_DESCRIPTION,
491: BUDGET_GROUP_ID = P_BUDGET_GROUP_ID,

Line 595: delete from PSB_ENTITY_SET

591: END IF;
592: --
593: p_return_status := FND_API.G_RET_STS_SUCCESS ;
594: --
595: delete from PSB_ENTITY_SET
596: where ENTITY_SET_ID = P_ENTITY_SET_ID;
597:
598: IF (SQL%NOTFOUND) THEN
599: RAISE NO_DATA_FOUND ;

Line 707: FROM psb_entity_set

703:
704:
705: CURSOR l_entity_set_csr IS
706: SELECT *
707: FROM psb_entity_set
708: WHERE entity_set_id = p_source_entity_set_id ;
709: --
710: CURSOR l_find_position_set_id_csr IS
711: SELECT account_position_set_id

Line 762: FROM psb_entity_set

758: and pay_element_option_id = l_source_pay_element_option_id);
759: --
760: CURSOR l_source_data_extract_csr IS
761: SELECT data_extract_id
762: FROM psb_entity_set
763: WHERE entity_set_id = p_source_entity_set_id ;
764: --
765:
766: CURSOR l_parameter_formula_csr IS

Line 845: PSB_ENTITY_SET_PVT.Copy_Attributes

841: OPEN l_source_data_extract_csr ;
842: FETCH l_source_data_extract_csr INTO l_source_data_extract_rec ;
843: CLOSE l_source_data_extract_csr ;
844:
845: PSB_ENTITY_SET_PVT.Copy_Attributes
846: ( p_api_version => 1.0,
847: p_init_msg_list => null,
848: p_commit => null,
849: p_validation_level => null,

Line 2161: end PSB_ENTITY_SET_PVT;

2157:
2158: END debug ;
2159:
2160:
2161: end PSB_ENTITY_SET_PVT;