APPS.QP_PSG_UTIL dependencies on QP_PTE_SEGMENTS

Line 836: UPDATE QP_PTE_SEGMENTS

832: )
833: IS
834: BEGIN
835:
836: UPDATE QP_PTE_SEGMENTS
837: SET ATTRIBUTE1 = p_PSG_rec.attribute1
838: , ATTRIBUTE10 = p_PSG_rec.attribute10
839: , ATTRIBUTE11 = p_PSG_rec.attribute11
840: , ATTRIBUTE12 = p_PSG_rec.attribute12

Line 899: INSERT INTO QP_PTE_SEGMENTS

895: IS
896: BEGIN
897: oe_debug_pub.add('inserting data in psg ..............................');
898:
899: INSERT INTO QP_PTE_SEGMENTS
900: ( ATTRIBUTE1
901: , ATTRIBUTE10
902: , ATTRIBUTE11
903: , ATTRIBUTE12

Line 996: DELETE FROM QP_PTE_SEGMENTS

992: )
993: IS
994: BEGIN
995:
996: DELETE FROM QP_PTE_SEGMENTS
997: WHERE SEGMENT_PTE_ID = p_segment_pte_id
998: ;
999:
1000: EXCEPTION

Line 1079: FROM QP_PTE_SEGMENTS

1075: , SEGMENT_PTE_ID
1076: , SOURCING_ENABLED
1077: , SOURCING_STATUS
1078: , USER_SOURCING_METHOD
1079: FROM QP_PTE_SEGMENTS
1080: WHERE ( SEGMENT_PTE_ID = p_segment_pte_id
1081: )
1082: --**OR ( LOOKUP_CODE = p_lookup_code
1083: OR ( PTE_CODE = p_lookup_code

Line 1272: FROM QP_PTE_SEGMENTS

1268: , l_PSG_rec.segment_pte_id
1269: , l_PSG_rec.sourcing_enabled
1270: , l_PSG_rec.sourcing_status
1271: , l_PSG_rec.user_sourcing_method
1272: FROM QP_PTE_SEGMENTS
1273: WHERE SEGMENT_PTE_ID = p_PSG_rec.segment_pte_id
1274: FOR UPDATE NOWAIT;
1275:
1276: -- Row locked. Compare IN attributes to DB attributes.