[Home] [Help]
175: OR p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
176: then
177:
178: SELECT count(*) INTO l_count
179: FROM OE_HEADER_ACKS
180: WHERE header_id = l_header_rec.header_id
181: AND acknowledgment_flag Is Null
182: -- Change this condition once a type is inserted for POAO/POCAO
183: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
189: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR)
190: AND request_id = l_header_rec.request_id;
191: else
192: SELECT count(*) INTO l_count
193: FROM OE_HEADER_ACKS
194: WHERE header_id = l_header_rec.header_id
195: AND acknowledgment_flag Is Null
196: -- Change this condition once a type is inserted for POAO/POCAO
197: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
250:
251: /* Added substr for some of the values being inserted in the table. This is done to fix the bug 2237470 */
252: /*Bug2403389 : Reverted the changes made for Bug2237470 */
253: --Added end customer fields for bug 4034441
254: INSERT INTO OE_HEADER_ACKS
255: (ACCOUNTING_RULE
256: ,ACCOUNTING_RULE_ID
257: ,ACCOUNTING_RULE_DURATION
258: ,ACKNOWLEDGMENT_FLAG
878:
879: Begin
880: Select count(*)
881: Into l_count
882: From Oe_Header_Acks
883: Where header_id = l_header_rec.header_id
884: And nvl(change_sequence,'ALL') = nvl(l_header_rec.change_sequence,'ALL')
885: And nvl(acknowledgment_type,'ALL') = nvl(l_ack_type,'ALL')
886: And acknowledgment_flag Is Null;
887:
888: If l_count > 0 Then
889: oe_debug_pub.add('unacknowledged ack present, call delete');
890: --Commented code to delete records from oe_line_acks for bug 4730258
891: Delete From Oe_Header_Acks
892: Where header_id = l_header_rec.header_id
893: And nvl(change_sequence,'ALL') = nvl(l_header_rec.change_sequence,'ALL')
894: And nvl(acknowledgment_type,'ALL') = nvl(l_ack_type,'ALL')
895: And acknowledgment_flag Is Null;
908: AND nvl(l_header_rec.header_id,0) <> 0) Then
909:
910: -- Insert data
911: Insert
912: Into Oe_Header_Acks
913: (ACCOUNTING_RULE_ID
914: ,ACCOUNTING_RULE_DURATION
915: ,ACKNOWLEDGMENT_FLAG
916: ,AGREEMENT_ID
1263: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
1264: OR p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
1265: then
1266:
1267: DELETE FROM OE_HEADER_ACKS
1268: WHERE HEADER_ID = p_header_id
1269: AND ACKNOWLEDGMENT_FLAG Is Null
1270: -- Change this condition once a type is inserted for POAO/POCAO
1271: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
1277: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
1278: AND request_id = p_request_id;
1279: else
1280:
1281: DELETE FROM OE_HEADER_ACKS
1282: WHERE HEADER_ID = p_header_id
1283: AND ACKNOWLEDGMENT_FLAG Is Null
1284: -- Change this condition once a type is inserted for POAO/POCAO
1285: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
1296:
1297: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
1298: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
1299: then
1300: DELETE FROM OE_HEADER_ACKS
1301: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
1302: AND ACKNOWLEDGMENT_TYPE = p_ack_type -- POI, CPO, etc
1303: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1304: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1309: AND REQUEST_ID = p_request_id;
1310:
1311:
1312: else
1313: DELETE FROM OE_HEADER_ACKS
1314: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
1315: AND ACKNOWLEDGMENT_TYPE = p_ack_type -- POI, CPO, etc
1316: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1317: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
1323:
1324: end if;
1325:
1326: Else
1327: oe_debug_pub.add('not deleting any rows from oe_header_acks ',3);
1328:
1329: End If;
1330:
1331: EXCEPTION