[Home] [Help]
1361:
1362: l_progress := '020';
1363:
1364: DELETE
1365: FROM po_history_pos
1366: WHERE purge_name = p_purge_name;
1367:
1368: l_progress := '030';
1369:
3908: -----------------------------------------------------------------------
3909: --Start of Comments
3910: --Name: summarize_pos
3911: --Pre-reqs:
3912: --Modifies: po_history_pos
3913: --Locks:
3914: -- None
3915: --Function:
3916: -- Record necessary information for pos that are about to be purged
4002: FROM dual
4003: WHERE EXISTS (
4004: SELECT NULL
4005: FROM po_headers PH,
4006: po_history_pos PHP
4007: WHERE PH.segment1 = PHP.segment1
4008: AND PH.type_lookup_code = PHP.type_lookup_code
4009: AND PHP.purge_name = p_purge_name
4010: AND PH.po_header_id BETWEEN l_range_low
4035: -- Local Blanket PA
4036: -- SQL Why: Need to record data in history table before actual
4037: -- purge happens
4038:
4039: INSERT INTO po_history_pos
4040: ( segment1,
4041: type_lookup_code,
4042: vendor_id,
4043: vendor_site_code,
4111: -- purge list that are Global Blanket PA
4112: -- SQL Why: Need to record data in history table before actual
4113: -- purge happens
4114:
4115: INSERT INTO po_history_pos
4116: ( segment1,
4117: type_lookup_code,
4118: vendor_id,
4119: vendor_site_code,
4184: -- purge list that are contracts
4185: -- SQL Why: Need to record data in history table before actual
4186: -- purge happens
4187:
4188: INSERT INTO po_history_pos
4189: ( segment1,
4190: type_lookup_code,
4191: vendor_id,
4192: vendor_site_code,
4258: -- its related information into purge history table
4259: -- SQl Why: Need to record data in history table before actual
4260: -- purge happens
4261:
4262: INSERT INTO po_history_pos
4263: ( segment1,
4264: type_lookup_code,
4265: vendor_id,
4266: vendor_site_code,