27: AND w.activity_result_code = l_wf_activity_result_code
28: AND w.item_key IN
29: ( SELECT b.LINE_ID || ''
30: FROM OE_AK_ORDER_LINES_V b
31: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
32: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
33: );
34:
35: CURSOR C_RSC IS
28: AND w.item_key IN
29: ( SELECT b.LINE_ID || ''
30: FROM OE_AK_ORDER_LINES_V b
31: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
32: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
33: );
34:
35: CURSOR C_RSC IS
36: SELECT count(*)
34:
35: CURSOR C_RSC IS
36: SELECT count(*)
37: FROM OE_AK_ORDER_LINES_V b
38: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
39: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
40: ;
41:
42: BEGIN
35: CURSOR C_RSC IS
36: SELECT count(*)
37: FROM OE_AK_ORDER_LINES_V b
38: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
39: AND b.SHIP_SET_ID = OE_LINE_SECURITY.g_record.SHIP_SET_ID
40: ;
41:
42: BEGIN
43: x_result := 0;