129: SET(CREATED_FROM_RULE_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
130: (SELECT b.QUALIFIER_RULE_ID,
131: DECODE(b.QUALIFIER_RULE_ID, NULL, null, 'P'),
132: DECODE(b.QUALIFIER_RULE_ID,NULL, a.ATTRIBUTE_STATUS||'001', a.ATTRIBUTE_STATUS)
133: FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c
134: WHERE c.CREATED_FROM_RULE = b.NAME(+)
135: AND a.rowid = c.rowid
136: )
137: WHERE a.REQUEST_ID = P_REQUEST_ID
149: SET(QUALIFIER_RULE_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
150: (SELECT b.QUALIFIER_RULE_ID,
151: DECODE(b.QUALIFIER_RULE_ID, NULL, null, 'P'),
152: DECODE(b.QUALIFIER_RULE_ID,NULL, a.ATTRIBUTE_STATUS||'002', a.ATTRIBUTE_STATUS)
153: FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c
154: WHERE c.QUALIFIER_RULE = b.NAME(+)
155: AND a.rowid = c.rowid
156: )
157: WHERE a.REQUEST_ID = P_REQUEST_ID