126: Begin
127:
128: SELECT 1
129: INTO l_exists_reject_line
130: FROM oe_lines_interface
131: WHERE order_source_id = p_order_source_id
132: AND orig_sys_document_ref = p_orig_sys_document_ref
133: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
134: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
140: = nvl(p_request_id, FND_API.G_MISS_NUM)
141: AND nvl(rejected_flag,'N')= 'Y'
142: AND rownum = 1;
143:
144: DELETE FROM oe_lines_interface
145: WHERE order_source_id = p_order_source_id
146: AND orig_sys_document_ref = p_orig_sys_document_ref
147: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
148: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
160: -- developer know this is executed..
161:
162: oe_debug_pub.add('Delete_Order - No_DATA - Old Path of execution');
163:
164: DELETE FROM oe_lines_interface
165: WHERE order_source_id = p_order_source_id
166: AND orig_sys_document_ref = p_orig_sys_document_ref
167: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
168: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)