APPS.PSB_SET_RELATION_PVT dependencies on PSB_SET_RELATIONS

Line 50: FROM psb_set_relations

46: l_api_version CONSTANT NUMBER := 1.0;
47: --
48: CURSOR C IS
49: SELECT rowid
50: FROM psb_set_relations
51: WHERE set_relation_id = p_set_relation_id;
52:
53: CURSOR C2 IS
54: SELECT psb_set_relations_s.nextval

Line 54: SELECT psb_set_relations_s.nextval

50: FROM psb_set_relations
51: WHERE set_relation_id = p_set_relation_id;
52:
53: CURSOR C2 IS
54: SELECT psb_set_relations_s.nextval
55: FROM dual;
56: --
57: l_last_update_date DATE ;
58: l_last_Updated_by NUMBER ;

Line 117: INSERT INTO psb_set_relations(

113: l_created_by := l_last_Updated_by ;
114: l_creation_date := l_last_update_date ;
115: --
116:
117: INSERT INTO psb_set_relations(
118: set_relation_id,
119: account_position_set_id,
120: allocation_rule_id,
121: budget_group_id,

Line 254: FROM psb_set_relations

250: l_api_version CONSTANT NUMBER := 1.0;
251: --
252: CURSOR C IS
253: SELECT *
254: FROM psb_set_relations
255: WHERE rowid = p_row_id
256: FOR UPDATE of set_relation_id NOWAIT;
257: Recinfo C%ROWTYPE;
258: --

Line 502: UPDATE psb_set_relations

498: l_last_update_login := -1;
499: END IF;
500: --
501:
502: UPDATE psb_set_relations
503: SET
504: set_relation_id = p_set_relation_id,
505: account_position_set_id = p_account_position_set_id,
506: allocation_rule_id = p_allocation_Rule_id,

Line 609: DELETE psb_set_relations

605: --
606: p_return_status := FND_API.G_RET_STS_SUCCESS ;
607: --
608:
609: DELETE psb_set_relations
610: WHERE rowid = p_row_id;
611:
612: IF (SQL%NOTFOUND) THEN
613: RAISE NO_DATA_FOUND ;

Line 708: FROM psb_set_relations_v

704: SELECT account_position_set_id ,
705: account_or_position_type ,
706: global_or_local_type ,
707: set_relation_id
708: FROM psb_set_relations_v
709: WHERE DECODE( p_entity_type,
710: 'AR', allocation_rule_id,
711: 'BG', budget_group_id,
712: 'BWR', budget_workflow_rule_id,

Line 761: DELETE psb_set_relations

757:
758: --
759: -- Delete the relation.
760: --
761: DELETE psb_set_relations
762: WHERE set_relation_id = l_relations_rec.set_relation_id;
763:
764: END LOOP;
765:

Line 856: FROM psb_set_relations_v

852: l_tmp VARCHAR2(1);
853:
854: CURSOR c IS
855: SELECT '1'
856: FROM psb_set_relations_v
857: WHERE account_or_position_type = p_account_or_position_type
858: AND DECODE( p_entity_type,
859: 'AR', allocation_rule_id,
860: 'BG', budget_group_id,

Line 879: FROM psb_set_relations_v

875:
876: /* Bug No 2131841 Start */
877: CURSOR c1 IS
878: SELECT '1'
879: FROM psb_set_relations_v
880: WHERE account_or_position_type = p_account_or_position_type
881: AND DECODE( p_entity_type,
882: 'AR', allocation_rule_id,
883: 'BG', budget_group_id,

Line 920: -- Checking the Psb_set_relations table for references.

916: p_return_status := FND_API.G_RET_STS_SUCCESS ;
917: --
918:
919:
920: -- Checking the Psb_set_relations table for references.
921: /* Bug No 2131841 Start */
922: IF p_entity_type = 'BRR' THEN
923: OPEN c1;
924: FETCH c1 INTO l_tmp;