APPS.QP_SEG_UTIL dependencies on QP_SEGMENTS_TL

Line 1130: UPDATE qp_segments_tl

1126: , REQUIRED_FLAG = p_SEG_rec.required_flag
1127: , PARTY_HIERARCHY_ENABLED_FLAG = p_SEG_rec.party_hierarchy_enabled_flag -- Added for TCA
1128: WHERE SEGMENT_ID = p_SEG_rec.segment_id ;
1129:
1130: UPDATE qp_segments_tl
1131: SET CREATED_BY = p_SEG_rec.created_by
1132: , CREATION_DATE = p_SEG_rec.creation_date
1133: , LAST_UPDATED_BY = p_SEG_rec.last_updated_by
1134: , LAST_UPDATE_DATE = p_SEG_rec.last_update_date

Line 1334: INSERT INTO QP_segments_tl

1330: , p_SEG_rec.required_flag
1331: , p_SEG_rec.party_hierarchy_enabled_flag --Added for TCA
1332: );
1333:
1334: INSERT INTO QP_segments_tl
1335: ( CREATED_BY
1336: , CREATION_DATE
1337: , LAST_UPDATED_BY
1338: , LAST_UPDATE_DATE

Line 1364: from qp_segments_tl T

1360: from FND_LANGUAGES L
1361: where L.INSTALLED_FLAG in ('I', 'B')
1362: and not exists
1363: ( select NULL
1364: from qp_segments_tl T
1365: where T.segment_id = p_SEG_rec.segment_id
1366: and T.LANGUAGE = L.LANGUAGE_CODE );
1367: ---
1368: /*

Line 1456: DELETE FROM QP_SEGMENTS_tl

1452: b.segment_id = p_segment_id;
1453: --
1454: DELETE FROM QP_SEGMENTS_b
1455: WHERE SEGMENT_ID = p_segment_id ;
1456: DELETE FROM QP_SEGMENTS_tl
1457: WHERE SEGMENT_ID = p_segment_id ;
1458: ---
1459: ---
1460: if l_prc_context_type = 'PRICING_ATTRIBUTE' and l_seeded_flag = 'N' then