APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_LINE_SECURITY

Line 59: AND SOURCE_LINE_ID = OE_LINE_SECURITY.g_record.line_id

55: SELECT PICK_STATUS
56: INTO l_release_status
57: FROM WSH_DELIVERY_LINE_STATUS_V
58: WHERE SOURCE_CODE = 'OE'
59: AND SOURCE_LINE_ID = OE_LINE_SECURITY.g_record.line_id
60: AND PICK_STATUS = 'S';
61: IF l_release_status = 'S' THEN
62: x_result_out := 1;
63: ELSE

Line 118: AND SOURCE_LINE_ID = OE_LINE_SECURITY.g_record.line_id

114: SELECT PICK_STATUS
115: INTO l_pick_status
116: FROM WSH_DELIVERY_LINE_STATUS_V
117: WHERE SOURCE_CODE = 'OE'
118: AND SOURCE_LINE_ID = OE_LINE_SECURITY.g_record.line_id
119: AND PICK_STATUS = 'Y';
120:
121: IF l_pick_status = 'Y' THEN
122: x_result_out := 1;

Line 6254: and item_key = to_char(OE_LINE_SECURITY.g_record.line_id)

6250: into l_ship_confirm_status
6251: from wf_process_activities p, wf_item_activity_statuses s
6252: where p.instance_id = s.process_activity
6253: and item_type = 'OEOL'
6254: and item_key = to_char(OE_LINE_SECURITY.g_record.line_id)
6255: and p.activity_name = 'SHIP_LINE'
6256: and s.activity_status = 'COMPLETE';
6257:
6258: IF l_ship_confirm_status = 'UNRESERVE' THEN

Line 6275: and item_key = to_char(OE_LINE_SECURITY.g_record.line_id)

6271: into l_count_reserve
6272: from wf_process_activities p, wf_item_activity_statuses s
6273: where p.instance_id = s.process_activity
6274: and item_type = 'OEOL'
6275: and item_key = to_char(OE_LINE_SECURITY.g_record.line_id)
6276: and p.activity_name = 'SHIP_LINE'
6277: and s.activity_status = 'COMPLETE'
6278: and (activity_result_code IS NULL OR activity_result_code <> 'UNRESERVE');
6279: