APPS.QP_SOU_UTIL dependencies on QP_ATTRIBUTE_SOURCING

Line 859: UPDATE QP_ATTRIBUTE_SOURCING

855: )
856: IS
857: BEGIN
858:
859: UPDATE QP_ATTRIBUTE_SOURCING
860: SET ATTRIBUTE1 = p_SOU_rec.attribute1
861: , ATTRIBUTE10 = p_SOU_rec.attribute10
862: , ATTRIBUTE11 = p_SOU_rec.attribute11
863: , ATTRIBUTE12 = p_SOU_rec.attribute12

Line 922: INSERT INTO QP_ATTRIBUTE_SOURCING

918: )
919: IS
920: BEGIN
921:
922: INSERT INTO QP_ATTRIBUTE_SOURCING
923: ( ATTRIBUTE1
924: , ATTRIBUTE10
925: , ATTRIBUTE11
926: , ATTRIBUTE12

Line 1021: DELETE FROM QP_ATTRIBUTE_SOURCING

1017: )
1018: IS
1019: BEGIN
1020:
1021: DELETE FROM QP_ATTRIBUTE_SOURCING
1022: WHERE ATTRIBUTE_SOURCING_ID = p_attribute_sourcing_id
1023: ;
1024:
1025: EXCEPTION

Line 1105: FROM QP_ATTRIBUTE_SOURCING

1101: , SEEDED_VALUE_STRING
1102: , SEGMENT_ID
1103: , USER_SOURCING_TYPE
1104: , USER_VALUE_STRING
1105: FROM QP_ATTRIBUTE_SOURCING
1106: WHERE ( ATTRIBUTE_SOURCING_ID = p_attribute_sourcing_id
1107: );
1108: --**OR ( SEGMENT_PTE_ID = p_segment_pte_id
1109: --**);

Line 1300: FROM QP_ATTRIBUTE_SOURCING

1296: , l_SOU_rec.seeded_value_string
1297: , l_SOU_rec.segment_id
1298: , l_SOU_rec.user_sourcing_type
1299: , l_SOU_rec.user_value_string
1300: FROM QP_ATTRIBUTE_SOURCING
1301: WHERE ATTRIBUTE_SOURCING_ID = p_SOU_rec.attribute_sourcing_id
1302: FOR UPDATE NOWAIT;
1303:
1304: -- Row locked. Compare IN attributes to DB attributes.