APPS.QP_LIMIT_ATTRS_UTIL dependencies on QP_LIMIT_ATTRIBUTES

Line 824: UPDATE QP_LIMIT_ATTRIBUTES

820: WHERE a.limit_id=p_LIMIT_ATTRS_rec.limit_id
821: AND b.list_header_id=a.list_header_id;
822:
823:
824: UPDATE QP_LIMIT_ATTRIBUTES
825: SET ATTRIBUTE1 = p_LIMIT_ATTRS_rec.attribute1
826: , ATTRIBUTE10 = p_LIMIT_ATTRS_rec.attribute10
827: , ATTRIBUTE11 = p_LIMIT_ATTRS_rec.attribute11
828: , ATTRIBUTE12 = p_LIMIT_ATTRS_rec.attribute12

Line 910: INSERT INTO QP_LIMIT_ATTRIBUTES

906: FROM QP_LIMITS a,QP_LIST_HEADERS_B b
907: WHERE a.limit_id=p_LIMIT_ATTRS_rec.limit_id
908: AND b.list_header_id=a.list_header_id;
909:
910: INSERT INTO QP_LIMIT_ATTRIBUTES
911: ( ATTRIBUTE1
912: , ATTRIBUTE10
913: , ATTRIBUTE11
914: , ATTRIBUTE12

Line 1022: DELETE FROM QP_LIMIT_ATTRIBUTES

1018: )
1019: IS
1020: BEGIN
1021:
1022: DELETE FROM QP_LIMIT_ATTRIBUTES
1023: WHERE LIMIT_ATTRIBUTE_ID = p_limit_attribute_id
1024: ;
1025:
1026:

Line 1105: FROM QP_LIMIT_ATTRIBUTES

1101: , PROGRAM_APPLICATION_ID
1102: , PROGRAM_ID
1103: , PROGRAM_UPDATE_DATE
1104: , REQUEST_ID
1105: FROM QP_LIMIT_ATTRIBUTES
1106: WHERE ( LIMIT_ATTRIBUTE_ID = p_limit_attribute_id
1107: )
1108: OR ( LIMIT_ID = p_limit_id
1109: );

Line 1294: FROM QP_LIMIT_ATTRIBUTES

1290: , l_LIMIT_ATTRS_rec.program_application_id
1291: , l_LIMIT_ATTRS_rec.program_id
1292: , l_LIMIT_ATTRS_rec.program_update_date
1293: , l_LIMIT_ATTRS_rec.request_id
1294: FROM QP_LIMIT_ATTRIBUTES
1295: WHERE LIMIT_ATTRIBUTE_ID = p_LIMIT_ATTRS_rec.limit_attribute_id
1296: FOR UPDATE NOWAIT;
1297:
1298: -- Row locked. Compare IN attributes to DB attributes.