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_ENTITY_SET_PVT dependencies on PSB_ENTITY

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 897: FROM psb_entity pe, psb_entity_assignment pea

893: pe.effective_start_date start_date, pe.effective_end_date end_date,
894: pea.priority,
895: pea.severity_level, pea.effective_start_date,
896: pea.effective_end_date
897: FROM psb_entity pe, psb_entity_assignment pea
898: WHERE pea.entity_set_id = p_source_entity_set_id
899: and pea.entity_id = pe.entity_id
900: )
901: LOOP

Line 909: SELECT psb_entity_s.nextval INTO l_entity_id

905:
906: --use this assignment for formula rec
907: l_source_entity_id := l_entity_rec.entity_id;
908:
909: SELECT psb_entity_s.nextval INTO l_entity_id
910: FROM dual;
911:
912: -- Call Create parameter API.
913:

Line 924: PSB_ENTITY_PVT.INSERT_ROW

920:
921: l_entity_name := substr(l_entity_rec.name,1,l_count)||'_'||
922: to_char(l_entity_id);
923:
924: PSB_ENTITY_PVT.INSERT_ROW
925: (
926: p_api_version => 1.0,
927: p_init_msg_list => null,
928: p_commit => null,

Line 991: PSB_ENTITY_ASSIGNMENT_PVT.INSERT_ROW

987:
988: -- creating assignment between the copied parameter set and the
989: -- copied parameters
990:
991: PSB_ENTITY_ASSIGNMENT_PVT.INSERT_ROW
992: (
993: p_api_version => 1.0,
994: p_init_msg_list => null,
995: p_commit => null,

Line 1784: FROM psb_entity_assignment assgn,

1780:
1781: CURSOR l_attr_value_csr IS
1782: (
1783: SELECT DISTINCT lines.attribute_id, attr_values.attribute_value
1784: FROM psb_entity_assignment assgn,
1785: psb_entity entity,
1786: psb_set_relations rels,
1787: psb_account_position_sets sets,
1788: psb_account_position_set_lines lines,

Line 1785: psb_entity entity,

1781: CURSOR l_attr_value_csr IS
1782: (
1783: SELECT DISTINCT lines.attribute_id, attr_values.attribute_value
1784: FROM psb_entity_assignment assgn,
1785: psb_entity entity,
1786: psb_set_relations rels,
1787: psb_account_position_sets sets,
1788: psb_account_position_set_lines lines,
1789: psb_position_set_line_values pos_val,

Line 1810: FROM psb_entity_assignment assgn,

1806: )
1807: UNION
1808: (
1809: SELECT DISTINCT formulas.attribute_id, attr_values.attribute_value
1810: FROM psb_entity_assignment assgn,
1811: psb_entity entity,
1812: psb_parameter_formulas formulas,
1813: psb_attributes attrs,
1814: psb_attribute_values attr_values

Line 1811: psb_entity entity,

1807: UNION
1808: (
1809: SELECT DISTINCT formulas.attribute_id, attr_values.attribute_value
1810: FROM psb_entity_assignment assgn,
1811: psb_entity entity,
1812: psb_parameter_formulas formulas,
1813: psb_attributes attrs,
1814: psb_attribute_values attr_values
1815: WHERE assgn.entity_set_id = p_source_entity_set_id

Line 2161: end PSB_ENTITY_SET_PVT;

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