[Home] [Help]
385: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
386: then
387:
388: SELECT count(*) INTO l_count
389: FROM OE_LINE_ACKS
390: WHERE header_id = l_line_rec.header_id
391: AND line_id = l_line_rec.line_id
392: AND acknowledgment_flag Is Null
393: -- Change this condition once ack type is ins for POAO/POCAO
402:
403:
404: else
405: SELECT count(*) INTO l_count
406: FROM OE_LINE_ACKS
407: WHERE header_id = l_line_rec.header_id
408: AND line_id = l_line_rec.line_id
409: AND acknowledgment_flag Is Null
410: -- Change this condition once ack type is ins for POAO/POCAO
491: oe_debug_pub.add('bsadri failed to get the refernce for split line');
492: END;
493: END IF;
494: --added end customer fields for bug 4034441
495: INSERT INTO OE_LINE_ACKS
496: (
497: ACCOUNTING_RULE
498: ,ACCOUNTING_RULE_ID
499: ,ACCOUNTING_RULE_DURATION
2113:
2114: If l_count > 0 Then
2115: --Added for bug4730258 start
2116: FORALL y in l_line_acks_rec.line_id.First..l_line_acks_rec.line_id.Last
2117: DELETE FROM OE_LINE_ACKS
2118: WHERE HEADER_ID = l_line_acks_rec.header_id(y)
2119: AND LINE_ID = l_line_acks_rec.line_id(y)
2120: AND ACKNOWLEDGMENT_FLAG is null
2121: -- Change this condition once a type is inserted for POAO/POCAO
2123: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2124: = nvl(l_line_acks_rec.CHANGE_SEQUENCE(y), FND_API.G_MISS_CHAR) ;
2125: --Added for bug4730258 end
2126: FORALL j in l_line_acks_rec.line_id.First..l_line_acks_rec.line_id.Last
2127: Insert Into Oe_Line_Acks
2128: (
2129: ACCOUNTING_RULE_ID
2130: ,ACCOUNTING_RULE_DURATION
2131: ,ACKNOWLEDGMENT_FLAG
2757:
2758: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2759: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2760: then
2761: DELETE FROM OE_LINE_ACKS
2762: WHERE HEADER_ID = p_header_id
2763: AND LINE_ID = p_line_id
2764: AND ACKNOWLEDGMENT_FLAG is null
2765: -- Change this condition once a type is inserted for POAO/POCAO
2772: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2773: AND request_id = p_request_id;
2774:
2775: else
2776: DELETE FROM OE_LINE_ACKS
2777: WHERE HEADER_ID = p_header_id
2778: AND LINE_ID = p_line_id
2779: AND ACKNOWLEDGMENT_FLAG is null
2780: -- Change this condition once a type is inserted for POAO/POCAO
2786: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2787: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2788: end if;
2789: if sql%rowcount > 0 then
2790: oe_debug_pub.add('Row Deleted from the oe_line_Acks table');
2791: end If;
2792: Elsif (p_orig_sys_document_ref is not null) Then
2793: oe_debug_pub.add('before deleting line acknowledgment by orig_sys_document_Ref, line_ref and shipment_ref ',3);
2794:
2795: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2796: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2797: then
2798:
2799: DELETE FROM OE_LINE_ACKS
2800: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
2801: AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
2802: AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2803: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2810: AND REQUEST_ID = p_request_id;
2811:
2812: else
2813:
2814: DELETE FROM OE_LINE_ACKS
2815: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
2816: AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
2817: AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2818: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2826:
2827: end if;
2828:
2829: if sql%rowcount > 0 then
2830: oe_debug_pub.add('Row(s) Deleted from the oe_line_acks table');
2831: end If;
2832: Else
2833: oe_debug_pub.add('not deleting any rows from oe_line_acks ',3);
2834:
2829: if sql%rowcount > 0 then
2830: oe_debug_pub.add('Row(s) Deleted from the oe_line_acks table');
2831: end If;
2832: Else
2833: oe_debug_pub.add('not deleting any rows from oe_line_acks ',3);
2834:
2835: End If;
2836:
2837: