APPS.PSB_FLEX_MAPPING_PVT dependencies on PSB_FLEX_MAPPING_SETS

Line 583: FROM psb_flex_mapping_sets

579: IS
580:
581: CURSOR C IS
582: SELECT rowid
583: FROM psb_flex_mapping_sets
584: WHERE Flex_Mapping_Set_ID = p_Flex_Mapping_Set_ID ;
585:
586: --
587: P_LAST_UPDATE_DATE DATE;

Line 635: INSERT INTO psb_flex_mapping_sets

631: raise FND_API.G_EXC_ERROR;
632: end if;
633: --
634:
635: INSERT INTO psb_flex_mapping_sets
636: ( Flex_Mapping_Set_ID ,
637: Name,
638: Description,
639: set_of_books_id,

Line 749: DELETE psb_flex_mapping_sets

745: --
746: DELETE psb_flex_mapping_set_values
747: WHERE flex_mapping_set_id = p_flex_mapping_set_id ;
748:
749: DELETE psb_flex_mapping_sets
750: WHERE flex_mapping_set_id = p_flex_mapping_set_id;
751:
752: IF (SQL%NOTFOUND) THEN
753: RAISE NO_DATA_FOUND ;

Line 829: FROM psb_flex_mapping_sets

825: SELECT Flex_Mapping_Set_ID,
826: Name,
827: description ,
828: set_of_books_id
829: FROM psb_flex_mapping_sets
830: WHERE Flex_Mapping_Set_Id = p_Flex_Mapping_Set_Id
831: FOR UPDATE of Flex_Mapping_Set_Id NOWAIT;
832: Recinfo C%ROWTYPE;
833:

Line 997: UPDATE psb_flex_mapping_sets

993: FND_MSG_PUB.Add ;
994: raise FND_API.G_EXC_ERROR ;
995: end if;
996: --
997: UPDATE psb_flex_mapping_sets
998: SET
999: Flex_Mapping_Set_ID = p_Flex_Mapping_Set_ID,
1000: Name = p_Name ,
1001: Description = p_Description ,

Line 1093: FROM psb_flex_mapping_sets f,

1089: l_seg_value VARCHAR2(150);
1090:
1091: CURSOR c_flex IS
1092: SELECT s.chart_of_accounts_id
1093: FROM psb_flex_mapping_sets f,
1094: gl_sets_of_books s
1095: WHERE flex_mapping_set_id = p_flexfield_mapping_set_id AND
1096: f.set_of_books_id = s.set_of_books_id ;
1097:

Line 1430: FROM psb_flex_mapping_sets f,

1426: l_py_exists VARCHAR2(1) := FND_API.G_FALSE;
1427:
1428: CURSOR c_flex IS
1429: SELECT s.chart_of_accounts_id,fnd.concatenated_segment_delimiter
1430: FROM psb_flex_mapping_sets f,
1431: gl_sets_of_books s,
1432: fnd_id_flex_structures_vl fnd
1433: WHERE flex_mapping_set_id = p_flexfield_mapping_set_id AND
1434: f.set_of_books_id = s.set_of_books_id AND