[Home] [Help]
400: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
401: then
402:
403: SELECT count(*) INTO l_count
404: FROM OE_LINE_ACKS
405: WHERE header_id = l_line_rec.header_id
406: AND line_id = l_line_rec.line_id
407: AND acknowledgment_flag Is Null
408: -- Change this condition once ack type is ins for POAO/POCAO
417:
418:
419: else
420: SELECT count(*) INTO l_count
421: FROM OE_LINE_ACKS
422: WHERE header_id = l_line_rec.header_id
423: AND line_id = l_line_rec.line_id
424: AND acknowledgment_flag Is Null
425: -- Change this condition once ack type is ins for POAO/POCAO
506: oe_debug_pub.add('bsadri failed to get the refernce for split line');
507: END;
508: END IF;
509: --added end customer fields for bug 4034441
510: INSERT INTO OE_LINE_ACKS
511: (
512: ACCOUNTING_RULE
513: ,ACCOUNTING_RULE_ID
514: ,ACCOUNTING_RULE_DURATION
2173:
2174: If l_count > 0 Then
2175: --Added for bug4730258 start
2176: FORALL y in l_line_acks_rec.line_id.First..l_line_acks_rec.line_id.Last
2177: DELETE FROM OE_LINE_ACKS
2178: WHERE HEADER_ID = l_line_acks_rec.header_id(y)
2179: AND LINE_ID = l_line_acks_rec.line_id(y)
2180: AND ACKNOWLEDGMENT_FLAG is null
2181: -- Change this condition once a type is inserted for POAO/POCAO
2183: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2184: = nvl(l_line_acks_rec.CHANGE_SEQUENCE(y), FND_API.G_MISS_CHAR) ;
2185: --Added for bug4730258 end
2186: FORALL j in l_line_acks_rec.line_id.First..l_line_acks_rec.line_id.Last
2187: Insert Into Oe_Line_Acks
2188: (
2189: ACCOUNTING_RULE_ID
2190: ,ACCOUNTING_RULE_DURATION
2191: ,ACKNOWLEDGMENT_FLAG
2835:
2836: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2837: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2838: then
2839: DELETE FROM OE_LINE_ACKS
2840: WHERE HEADER_ID = p_header_id
2841: AND LINE_ID = p_line_id
2842: AND ACKNOWLEDGMENT_FLAG is null
2843: -- Change this condition once a type is inserted for POAO/POCAO
2850: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2851: AND request_id = p_request_id;
2852:
2853: else
2854: DELETE FROM OE_LINE_ACKS
2855: WHERE HEADER_ID = p_header_id
2856: AND LINE_ID = p_line_id
2857: AND ACKNOWLEDGMENT_FLAG is null
2858: -- Change this condition once a type is inserted for POAO/POCAO
2864: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2865: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2866: end if;
2867: if sql%rowcount > 0 then
2868: oe_debug_pub.add('Row Deleted from the oe_line_Acks table');
2869: end If;
2870: Elsif (p_orig_sys_document_ref is not null) Then
2871: oe_debug_pub.add('before deleting line acknowledgment by orig_sys_document_Ref, line_ref and shipment_ref ',3);
2872:
2873: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2874: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2875: then
2876:
2877: DELETE FROM OE_LINE_ACKS
2878: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
2879: AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
2880: AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2881: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2888: AND REQUEST_ID = p_request_id;
2889:
2890: else
2891:
2892: DELETE FROM OE_LINE_ACKS
2893: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
2894: AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
2895: AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2896: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2904:
2905: end if;
2906:
2907: if sql%rowcount > 0 then
2908: oe_debug_pub.add('Row(s) Deleted from the oe_line_acks table');
2909: end If;
2910: Else
2911: oe_debug_pub.add('not deleting any rows from oe_line_acks ',3);
2912:
2907: if sql%rowcount > 0 then
2908: oe_debug_pub.add('Row(s) Deleted from the oe_line_acks table');
2909: end If;
2910: Else
2911: oe_debug_pub.add('not deleting any rows from oe_line_acks ',3);
2912:
2913: End If;
2914:
2915: