[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE autoaccept_deleted_records
( p_draft_id IN NUMBER
);
SELECT NVL(revision_num, 0), segment1, org_id, agent_id
INTO l_revision_num, l_agreement_num, l_org_id, l_agent_id
FROM po_headers_all
WHERE po_header_id = p_po_header_id;
SELECT owner_user_id
INTO l_draft_owner_user_id
FROM po_drafts DFT
WHERE draft_id = l_draft_id;
PROCEDURE selector
( item_type IN VARCHAR2,
item_key IN VARCHAR2,
activity_id IN NUMBER,
command IN VARCHAR2,
resultout IN OUT NOCOPY VARCHAR2
) IS
d_api_name CONSTANT VARCHAR2(30) := 'selector';
END selector;
SELECT DECODE (l_draft_owner_role,
PO_GLOBAL.g_ROLE_CAT_ADMIN,
NVL(PSP.cat_admin_authoring_acceptance, 'NOT_REQUIRED'),
PO_GLOBAL.g_ROLE_SUPPLIER,
NVL(PSP.supplier_authoring_acceptance, 'REQUIRED'))
INTO l_acceptance_level
FROM po_system_parameters_all PSP
WHERE PSP.org_id = l_org_id;
autoaccept_deleted_records
( p_draft_id => l_draft_id
);
PO_DRAFTS_PVT.update_draft_status
( p_draft_id => l_draft_id,
p_new_status => PO_DRAFTS_PVT.g_status_IN_PROCESS
);
SELECT supervisor_id
INTO l_manager_id
FROM hr_employees_current_v HREMP
WHERE employee_id = l_agent_id;
SELECT created_language
INTO l_created_language
FROM po_headers_all
WHERE po_header_id = l_po_header_id;
SELECT *
BULK COLLECT
INTO l_reject_list
FROM
(
SELECT po_line_id
FROM po_lines_draft_all
WHERE draft_id = l_draft_id
AND change_accepted_flag IS NULL
UNION
SELECT po_line_id
FROM po_line_locations_draft_all
WHERE draft_id = l_draft_id
AND change_accepted_flag IS NULL
UNION
SELECT entity_id
FROM po_price_diff_draft
WHERE draft_id = l_draft_id
AND entity_type = 'BLANKET LINE'
AND change_accepted_flag IS NULL
UNION
SELECT NVL(LLD.po_line_id, LL.po_line_id)
FROM po_line_locations_draft_all LLD,
po_line_locations_all LL,
po_price_diff_draft PDD
WHERE PDD.draft_id = l_draft_id
AND entity_type = 'PRICE BREAK'
AND PDD.change_accepted_flag IS NULL
AND PDD.entity_id = LLD.line_location_id(+)
AND PDD.draft_id = LLD.draft_id(+)
AND PDD.entity_id = LL.line_location_id(+)
UNION
SELECT po_line_id
FROM po_attribute_values_draft
WHERE draft_id = l_draft_id
AND change_accepted_flag IS NULL
UNION
SELECT po_line_id
FROM po_attribute_values_tlp_draft
WHERE draft_id = l_draft_id
AND language = l_created_language
AND change_accepted_flag IS NULL
);
SELECT 'Y'
INTO l_any_lines_get_rejected
FROM DUAL
WHERE EXISTS
(SELECT 1
FROM po_lines_draft_all
WHERE draft_id = l_draft_id
AND change_accepted_flag = 'N')
OR EXISTS
(SELECT 1
FROM po_line_locations_draft_all
WHERE draft_id = l_draft_id
AND change_accepted_flag = 'N')
OR EXISTS
(SELECT 1
FROM po_price_diff_draft
WHERE draft_id = l_draft_id
AND change_accepted_flag = 'N')
OR EXISTS
(SELECT 1
FROM po_attribute_values_draft
WHERE draft_id = l_draft_id
AND change_accepted_flag = 'N');
p_delete_processed_draft => FND_API.G_FALSE,
p_acceptance_action => l_acceptance_action,
x_return_status => l_return_status
);
l_update_sourcing_rule VARCHAR2(10);
SELECT AUTO_SOURCING_FLAG,UPDATE_SOURCING_RULES_FLAG
INTO
l_create_sourcing_rule,l_update_sourcing_rule
FROM
PO_HEADERS_ALL
WHERE
PO_HEADER_ID=l_po_header_id;
UpdateSourcingRule=>l_update_sourcing_rule
);
SELECT PO_WF_ITEMKEY_S.NEXTVAL
INTO l_new_itemkey
FROM DUAL;
SELECT MAX(item_key)
INTO l_itemkey
FROM WF_ITEMS
WHERE item_type = g_ITEMTYPE
AND item_key LIKE l_itemkey_like
AND end_date IS NULL;
l_price_update_tolerance_tbl PO_TBL_NUMBER;
SELECT PH.vendor_id,
PLD.po_line_id,
PLD.po_header_id,
PLD.item_id,
PLD.category_id,
PLD.unit_price,
PL.unit_price,
NVL2(PL.po_line_id, 'N', 'Y')
BULK COLLECT
INTO l_vendor_id_tbl,
l_po_line_id_tbl,
l_po_header_id_tbl,
l_item_id_tbl,
l_category_id_tbl,
l_new_price_tbl,
l_old_price_tbl,
l_new_line_flag_tbl
FROM po_headers_all PH,
po_lines_draft_all PLD,
po_lines_all PL
WHERE PLD.draft_id = p_draft_id
AND NVL(PLD.delete_flag, 'N') = 'N'
AND PLD.change_accepted_flag IS NULL
AND PLD.po_line_id = PL.po_line_id(+)
AND PLD.po_header_id = PH.po_header_id;
x_price_update_tolerance_tbl => l_price_update_tolerance_tbl
);
( p_price_tolerance => l_price_update_tolerance_tbl(l_index),
p_old_price => l_old_price_tbl(l_index),
p_new_price => l_new_price_tbl(l_index)
);
SELECT PH.created_language
INTO l_created_language
FROM po_drafts DFT,
po_headers_all PH
WHERE DFT.draft_id = p_draft_id
AND PH.po_header_id = DFT.document_id;
UPDATE po_attribute_values_tlp_draft PAVTD
SET change_accepted_flag = 'Y'
WHERE change_accepted_flag IS NULL
AND PAVTD.draft_id = p_draft_id
AND PAVTD.language <> l_created_language;
PO_LOG.proc_end (d_module, '# of records updated: ', SQL%ROWCOUNT);
PROCEDURE autoaccept_deleted_records
( p_draft_id IN NUMBER
) IS
d_api_name CONSTANT VARCHAR2(30) := 'autoaccept_deleted_records';
UPDATE po_lines_draft_all PLD
SET PLD.change_accepted_flag = 'Y'
WHERE PLD.draft_id = p_draft_id
AND PLD.change_accepted_flag IS NULL
AND PLD.delete_flag = 'Y'
AND NOT EXISTS
( SELECT 1
FROM po_lines_all PL
WHERE PLD.po_line_id = PL.po_line_id);
UPDATE po_line_locations_draft_all PLLD
SET PLLD.change_accepted_flag = 'Y'
WHERE PLLD.draft_id = p_draft_id
AND PLLD.change_accepted_flag IS NULL
AND PLLD.delete_flag = 'Y'
AND NOT EXISTS
( SELECT 1
FROM po_line_locations_all PLL
WHERE PLLD.line_location_id = PLL.line_location_id);
UPDATE po_price_diff_draft PPDD
SET PPDD.change_accepted_flag = 'Y'
WHERE PPDD.draft_id = p_draft_id
AND PPDD.change_accepted_flag IS NULL
AND PPDD.delete_flag = 'Y'
AND NOT EXISTS
( SELECT 1
FROM po_price_differentials PPD
WHERE PPDD.price_differential_id = PPD.price_differential_id);
UPDATE po_attribute_values_draft PAVD
SET PAVD.change_accepted_flag = 'Y'
WHERE PAVD.draft_id = p_draft_id
AND PAVD.change_accepted_flag IS NULL
AND PAVD.delete_flag = 'Y'
AND NOT EXISTS
( SELECT 1
FROM po_attribute_values PAV
WHERE PAVD.attribute_values_id = PAV.attribute_values_id);
UPDATE po_attribute_values_tlp_draft PAVTD
SET PAVTD.change_accepted_flag = 'Y'
WHERE PAVTD.draft_id = p_draft_id
AND PAVTD.change_accepted_flag IS NULL
AND PAVTD.delete_flag = 'Y'
AND NOT EXISTS
( SELECT 1
FROM po_attribute_values_tlp PAVT
WHERE PAVTD.attribute_values_tlp_id = PAVT.attribute_values_tlp_id);
END autoaccept_deleted_records;
UPDATE po_lines_draft_all PLD
SET PLD.change_accepted_flag = 'Y'
WHERE PLD.draft_id = p_draft_id
AND PLD.change_accepted_flag IS NULL
AND NVL(PLD.delete_flag, 'N') <> 'Y'
AND EXISTS
( SELECT 1
FROM po_lines_all PL
WHERE PLD.po_line_id = PL.po_line_id
AND DECODE (PLD.line_num,
PL.line_num, 'Y', 'N') = 'Y'
AND DECODE (PLD.line_type_id,
PL.line_type_id, 'Y', 'N') = 'Y'
AND DECODE (PLD.item_id,
PL.item_id, 'Y', 'N') = 'Y'
AND DECODE (PLD.job_id,
PL.job_id, 'Y', 'N') = 'Y'
AND DECODE (PLD.item_description,
PL.item_description, 'Y', 'N') = 'Y'
AND DECODE (PLD.category_id,
PL.category_id, 'Y', 'N') = 'Y'
AND DECODE (PLD.unit_meas_lookup_code,
PL.unit_meas_lookup_code, 'Y', 'N') = 'Y'
AND DECODE (PLD.unit_price,
PL.unit_price, 'Y', 'N') = 'Y'
AND DECODE (PLD.amount,
PL.amount, 'Y', 'N') = 'Y'
AND DECODE (PLD.expiration_date,
PL.expiration_date, 'Y', 'N') = 'Y'
AND DECODE (PLD.item_revision,
PL.item_revision, 'Y', 'N') = 'Y'
AND DECODE (PLD.vendor_product_num,
PL.vendor_product_num, 'Y', 'N') = 'Y'
AND DECODE (PLD.supplier_ref_number,
PL.supplier_ref_number, 'Y', 'N') = 'Y'
AND DECODE (PLD.ip_category_id,
PL.ip_category_id, 'Y', 'N') = 'Y'
AND DECODE (NVL(PLD.capital_expense_flag, 'N'),
NVL(PL.capital_expense_flag, 'N'), 'Y', 'N') = 'Y'
AND DECODE (NVL(PLD.allow_price_override_flag, 'N'),
NVL(PL.allow_price_override_flag, 'N'), 'Y', 'N') = 'Y'
AND DECODE (PLD.not_to_exceed_price,
PL.not_to_exceed_price, 'Y', 'N') = 'Y'
AND DECODE (PLD.list_price_per_unit,
PL.list_price_per_unit, 'Y', 'N') = 'Y'
AND DECODE (PLD.market_price,
PL.market_price, 'Y', 'N') = 'Y'
AND DECODE (PLD.price_type_lookup_code,
PL.price_type_lookup_code, 'Y', 'N') = 'Y'
AND DECODE (NVL(PLD.negotiated_by_preparer_flag, 'N'),
NVL(PL.negotiated_by_preparer_flag, 'N'), 'Y', 'N') = 'Y'
AND DECODE (PLD.min_release_amount,
PL.min_release_amount, 'Y', 'N') = 'Y'
AND DECODE (PLD.committed_amount,
PL.committed_amount, 'Y', 'N') = 'Y'
AND DECODE (PLD.quantity_committed,
PL.quantity_committed, 'Y', 'N') = 'Y'
AND DECODE (PLD.supplier_part_auxid,
PL.supplier_part_auxid, 'Y', 'N') = 'Y'
AND DECODE (PLD.un_number_id,
PL.un_number_id, 'Y', 'N') = 'Y'
AND DECODE (PLD.hazard_class_id,
PL.hazard_class_id, 'Y', 'N') = 'Y'
AND DECODE (PLD.note_to_vendor,
PL.note_to_vendor, 'Y', 'N') = 'Y');
UPDATE po_line_locations_draft_all PLLD
SET PLLD.change_accepted_flag = 'Y'
WHERE PLLD.draft_id = p_draft_id
AND PLLD.change_accepted_flag IS NULL
AND NVL(PLLD.delete_flag, 'N') <> 'Y'
AND EXISTS
( SELECT 1
FROM po_line_locations_all PLL
WHERE PLLD.line_location_id = PLL.line_location_id
AND DECODE (PLLD.ship_to_organization_id,
PLL.ship_to_organization_id, 'Y', 'N') = 'Y'
AND DECODE (PLLD.ship_to_location_id,
PLL.ship_to_location_id, 'Y', 'N') = 'Y'
AND DECODE (PLLD.quantity,
PLL.quantity, 'Y', 'N') = 'Y'
AND DECODE (PLLD.price_override,
PLL.price_override, 'Y', 'N') = 'Y'
AND DECODE (PLLD.price_discount,
PLL.price_discount, 'Y', 'N') = 'Y'
AND DECODE (PLLD.start_date,
PLL.start_date, 'Y', 'N') = 'Y'
AND DECODE (PLLD.end_date,
PLL.end_date, 'Y', 'N') = 'Y');
UPDATE po_price_diff_draft PPDD
SET PPDD.change_accepted_flag = 'Y'
WHERE PPDD.draft_id = p_draft_id
AND PPDD.change_accepted_flag IS NULL
AND NVL(PPDD.delete_flag, 'N') <> 'Y'
AND EXISTS
( SELECT 1
FROM po_price_differentials PPD
WHERE PPDD.price_differential_id = PPD.price_differential_id
AND DECODE (PPDD.price_differential_num,
PPD.price_differential_num, 'Y', 'N') = 'Y'
AND DECODE (PPDD.price_type,
PPD.price_type, 'Y', 'N') = 'Y'
AND DECODE (PPDD.min_multiplier,
PPD.min_multiplier, 'Y', 'N') = 'Y'
AND DECODE (PPDD.max_multiplier,
PPD.max_multiplier, 'Y', 'N') = 'Y');
UPDATE po_attribute_values_draft PAVD
SET PAVD.change_accepted_flag = 'Y'
WHERE PAVD.draft_id = p_draft_id
AND PAVD.change_accepted_flag IS NULL
AND NVL(PAVD.delete_flag, 'N') <> 'Y'
AND EXISTS
( SELECT 1
FROM po_attribute_values PAV
WHERE PAVD.attribute_values_id = PAV.attribute_values_id
AND DECODE (PAVD.manufacturer_part_num ,
PAV.manufacturer_part_num , 'Y', 'N') = 'Y'
AND DECODE (PAVD.picture,
PAV.picture, 'Y', 'N') = 'Y'
AND DECODE (PAVD.thumbnail_image,
PAV.thumbnail_image, 'Y', 'N') = 'Y'
AND DECODE (PAVD.supplier_url,
PAV.supplier_url, 'Y', 'N') = 'Y'
AND DECODE (PAVD.manufacturer_url,
PAV.manufacturer_url, 'Y', 'N') = 'Y'
AND DECODE (PAVD.attachment_url,
PAV.attachment_url, 'Y', 'N') = 'Y'
AND DECODE (PAVD.unspsc,
PAV.unspsc, 'Y', 'N') = 'Y'
AND DECODE (PAVD.availability,
PAV.availability, 'Y', 'N') = 'Y'
AND DECODE (PAVD.lead_time,
PAV.lead_time, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute1,
PAV.text_base_attribute1, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute2,
PAV.text_base_attribute2, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute3,
PAV.text_base_attribute3, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute4,
PAV.text_base_attribute4, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute5,
PAV.text_base_attribute5, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute6,
PAV.text_base_attribute6, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute7,
PAV.text_base_attribute7, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute8,
PAV.text_base_attribute8, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute9,
PAV.text_base_attribute9, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute10,
PAV.text_base_attribute10, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute11,
PAV.text_base_attribute11, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute12,
PAV.text_base_attribute12, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute13,
PAV.text_base_attribute13, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute14,
PAV.text_base_attribute14, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute15,
PAV.text_base_attribute15, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute16,
PAV.text_base_attribute16, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute17,
PAV.text_base_attribute17, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute18,
PAV.text_base_attribute18, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute19,
PAV.text_base_attribute19, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute20,
PAV.text_base_attribute20, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute21,
PAV.text_base_attribute21, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute22,
PAV.text_base_attribute22, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute23,
PAV.text_base_attribute23, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute24,
PAV.text_base_attribute24, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute25,
PAV.text_base_attribute25, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute26,
PAV.text_base_attribute26, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute27,
PAV.text_base_attribute27, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute28,
PAV.text_base_attribute28, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute29,
PAV.text_base_attribute29, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute30,
PAV.text_base_attribute30, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute31,
PAV.text_base_attribute31, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute32,
PAV.text_base_attribute32, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute33,
PAV.text_base_attribute33, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute34,
PAV.text_base_attribute34, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute35,
PAV.text_base_attribute35, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute36,
PAV.text_base_attribute36, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute37,
PAV.text_base_attribute37, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute38,
PAV.text_base_attribute38, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute39,
PAV.text_base_attribute39, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute40,
PAV.text_base_attribute40, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute41,
PAV.text_base_attribute41, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute42,
PAV.text_base_attribute42, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute43,
PAV.text_base_attribute43, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute44,
PAV.text_base_attribute44, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute45,
PAV.text_base_attribute45, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute46,
PAV.text_base_attribute46, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute47,
PAV.text_base_attribute47, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute48,
PAV.text_base_attribute48, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute49,
PAV.text_base_attribute49, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute50,
PAV.text_base_attribute50, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute51,
PAV.text_base_attribute51, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute52,
PAV.text_base_attribute52, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute53,
PAV.text_base_attribute53, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute54,
PAV.text_base_attribute54, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute55,
PAV.text_base_attribute55, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute56,
PAV.text_base_attribute56, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute57,
PAV.text_base_attribute57, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute58,
PAV.text_base_attribute58, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute59,
PAV.text_base_attribute59, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute60,
PAV.text_base_attribute60, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute61,
PAV.text_base_attribute61, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute62,
PAV.text_base_attribute62, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute63,
PAV.text_base_attribute63, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute64,
PAV.text_base_attribute64, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute65,
PAV.text_base_attribute65, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute66,
PAV.text_base_attribute66, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute67,
PAV.text_base_attribute67, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute68,
PAV.text_base_attribute68, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute69,
PAV.text_base_attribute69, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute70,
PAV.text_base_attribute70, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute71,
PAV.text_base_attribute71, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute72,
PAV.text_base_attribute72, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute73,
PAV.text_base_attribute73, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute74,
PAV.text_base_attribute74, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute75,
PAV.text_base_attribute75, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute76,
PAV.text_base_attribute76, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute77,
PAV.text_base_attribute77, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute78,
PAV.text_base_attribute78, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute79,
PAV.text_base_attribute79, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute80,
PAV.text_base_attribute80, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute81,
PAV.text_base_attribute81, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute82,
PAV.text_base_attribute82, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute83,
PAV.text_base_attribute83, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute84,
PAV.text_base_attribute84, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute85,
PAV.text_base_attribute85, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute86,
PAV.text_base_attribute86, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute87,
PAV.text_base_attribute87, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute88,
PAV.text_base_attribute88, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute89,
PAV.text_base_attribute89, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute90,
PAV.text_base_attribute90, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute91,
PAV.text_base_attribute91, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute92,
PAV.text_base_attribute92, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute93,
PAV.text_base_attribute93, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute94,
PAV.text_base_attribute94, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute95,
PAV.text_base_attribute95, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute96,
PAV.text_base_attribute96, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute97,
PAV.text_base_attribute97, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute98,
PAV.text_base_attribute98, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute99,
PAV.text_base_attribute99, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_base_attribute100,
PAV.text_base_attribute100, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute1,
PAV.num_base_attribute1, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute2,
PAV.num_base_attribute2, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute3,
PAV.num_base_attribute3, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute4,
PAV.num_base_attribute4, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute5,
PAV.num_base_attribute5, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute6,
PAV.num_base_attribute6, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute7,
PAV.num_base_attribute7, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute8,
PAV.num_base_attribute8, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute9,
PAV.num_base_attribute9, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute10,
PAV.num_base_attribute10, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute11,
PAV.num_base_attribute11, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute12,
PAV.num_base_attribute12, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute13,
PAV.num_base_attribute13, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute14,
PAV.num_base_attribute14, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute15,
PAV.num_base_attribute15, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute16,
PAV.num_base_attribute16, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute17,
PAV.num_base_attribute17, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute18,
PAV.num_base_attribute18, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute19,
PAV.num_base_attribute19, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute20,
PAV.num_base_attribute20, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute21,
PAV.num_base_attribute21, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute22,
PAV.num_base_attribute22, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute23,
PAV.num_base_attribute23, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute24,
PAV.num_base_attribute24, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute25,
PAV.num_base_attribute25, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute26,
PAV.num_base_attribute26, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute27,
PAV.num_base_attribute27, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute28,
PAV.num_base_attribute28, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute29,
PAV.num_base_attribute29, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute30,
PAV.num_base_attribute30, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute31,
PAV.num_base_attribute31, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute32,
PAV.num_base_attribute32, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute33,
PAV.num_base_attribute33, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute34,
PAV.num_base_attribute34, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute35,
PAV.num_base_attribute35, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute36,
PAV.num_base_attribute36, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute37,
PAV.num_base_attribute37, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute38,
PAV.num_base_attribute38, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute39,
PAV.num_base_attribute39, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute40,
PAV.num_base_attribute40, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute41,
PAV.num_base_attribute41, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute42,
PAV.num_base_attribute42, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute43,
PAV.num_base_attribute43, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute44,
PAV.num_base_attribute44, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute45,
PAV.num_base_attribute45, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute46,
PAV.num_base_attribute46, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute47,
PAV.num_base_attribute47, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute48,
PAV.num_base_attribute48, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute49,
PAV.num_base_attribute49, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute50,
PAV.num_base_attribute50, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute51,
PAV.num_base_attribute51, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute52,
PAV.num_base_attribute52, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute53,
PAV.num_base_attribute53, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute54,
PAV.num_base_attribute54, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute55,
PAV.num_base_attribute55, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute56,
PAV.num_base_attribute56, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute57,
PAV.num_base_attribute57, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute58,
PAV.num_base_attribute58, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute59,
PAV.num_base_attribute59, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute60,
PAV.num_base_attribute60, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute61,
PAV.num_base_attribute61, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute62,
PAV.num_base_attribute62, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute63,
PAV.num_base_attribute63, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute64,
PAV.num_base_attribute64, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute65,
PAV.num_base_attribute65, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute66,
PAV.num_base_attribute66, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute67,
PAV.num_base_attribute67, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute68,
PAV.num_base_attribute68, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute69,
PAV.num_base_attribute69, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute70,
PAV.num_base_attribute70, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute71,
PAV.num_base_attribute71, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute72,
PAV.num_base_attribute72, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute73,
PAV.num_base_attribute73, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute74,
PAV.num_base_attribute74, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute75,
PAV.num_base_attribute75, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute76,
PAV.num_base_attribute76, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute77,
PAV.num_base_attribute77, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute78,
PAV.num_base_attribute78, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute79,
PAV.num_base_attribute79, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute80,
PAV.num_base_attribute80, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute81,
PAV.num_base_attribute81, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute82,
PAV.num_base_attribute82, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute83,
PAV.num_base_attribute83, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute84,
PAV.num_base_attribute84, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute85,
PAV.num_base_attribute85, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute86,
PAV.num_base_attribute86, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute87,
PAV.num_base_attribute87, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute88,
PAV.num_base_attribute88, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute89,
PAV.num_base_attribute89, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute90,
PAV.num_base_attribute90, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute91,
PAV.num_base_attribute91, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute92,
PAV.num_base_attribute92, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute93,
PAV.num_base_attribute93, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute94,
PAV.num_base_attribute94, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute95,
PAV.num_base_attribute95, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute96,
PAV.num_base_attribute96, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute97,
PAV.num_base_attribute97, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute98,
PAV.num_base_attribute98, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute99,
PAV.num_base_attribute99, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_base_attribute100,
PAV.num_base_attribute100, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute1,
PAV.text_cat_attribute1, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute2,
PAV.text_cat_attribute2, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute3,
PAV.text_cat_attribute3, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute4,
PAV.text_cat_attribute4, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute5,
PAV.text_cat_attribute5, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute6,
PAV.text_cat_attribute6, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute7,
PAV.text_cat_attribute7, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute8,
PAV.text_cat_attribute8, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute9,
PAV.text_cat_attribute9, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute10,
PAV.text_cat_attribute10, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute11,
PAV.text_cat_attribute11, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute12,
PAV.text_cat_attribute12, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute13,
PAV.text_cat_attribute13, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute14,
PAV.text_cat_attribute14, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute15,
PAV.text_cat_attribute15, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute16,
PAV.text_cat_attribute16, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute17,
PAV.text_cat_attribute17, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute18,
PAV.text_cat_attribute18, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute19,
PAV.text_cat_attribute19, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute20,
PAV.text_cat_attribute20, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute21,
PAV.text_cat_attribute21, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute22,
PAV.text_cat_attribute22, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute23,
PAV.text_cat_attribute23, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute24,
PAV.text_cat_attribute24, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute25,
PAV.text_cat_attribute25, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute26,
PAV.text_cat_attribute26, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute27,
PAV.text_cat_attribute27, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute28,
PAV.text_cat_attribute28, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute29,
PAV.text_cat_attribute29, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute30,
PAV.text_cat_attribute30, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute31,
PAV.text_cat_attribute31, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute32,
PAV.text_cat_attribute32, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute33,
PAV.text_cat_attribute33, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute34,
PAV.text_cat_attribute34, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute35,
PAV.text_cat_attribute35, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute36,
PAV.text_cat_attribute36, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute37,
PAV.text_cat_attribute37, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute38,
PAV.text_cat_attribute38, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute39,
PAV.text_cat_attribute39, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute40,
PAV.text_cat_attribute40, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute41,
PAV.text_cat_attribute41, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute42,
PAV.text_cat_attribute42, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute43,
PAV.text_cat_attribute43, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute44,
PAV.text_cat_attribute44, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute45,
PAV.text_cat_attribute45, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute46,
PAV.text_cat_attribute46, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute47,
PAV.text_cat_attribute47, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute48,
PAV.text_cat_attribute48, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute49,
PAV.text_cat_attribute49, 'Y', 'N') = 'Y'
AND DECODE (PAVD.text_cat_attribute50,
PAV.text_cat_attribute50, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute1,
PAV.num_cat_attribute1, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute2,
PAV.num_cat_attribute2, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute3,
PAV.num_cat_attribute3, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute4,
PAV.num_cat_attribute4, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute5,
PAV.num_cat_attribute5, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute6,
PAV.num_cat_attribute6, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute7,
PAV.num_cat_attribute7, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute8,
PAV.num_cat_attribute8, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute9,
PAV.num_cat_attribute9, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute10,
PAV.num_cat_attribute10, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute11,
PAV.num_cat_attribute11, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute12,
PAV.num_cat_attribute12, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute13,
PAV.num_cat_attribute13, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute14,
PAV.num_cat_attribute14, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute15,
PAV.num_cat_attribute15, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute16,
PAV.num_cat_attribute16, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute17,
PAV.num_cat_attribute17, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute18,
PAV.num_cat_attribute18, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute19,
PAV.num_cat_attribute19, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute20,
PAV.num_cat_attribute20, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute21,
PAV.num_cat_attribute21, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute22,
PAV.num_cat_attribute22, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute23,
PAV.num_cat_attribute23, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute24,
PAV.num_cat_attribute24, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute25,
PAV.num_cat_attribute25, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute26,
PAV.num_cat_attribute26, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute27,
PAV.num_cat_attribute27, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute28,
PAV.num_cat_attribute28, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute29,
PAV.num_cat_attribute29, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute30,
PAV.num_cat_attribute30, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute31,
PAV.num_cat_attribute31, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute32,
PAV.num_cat_attribute32, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute33,
PAV.num_cat_attribute33, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute34,
PAV.num_cat_attribute34, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute35,
PAV.num_cat_attribute35, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute36,
PAV.num_cat_attribute36, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute37,
PAV.num_cat_attribute37, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute38,
PAV.num_cat_attribute38, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute39,
PAV.num_cat_attribute39, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute40,
PAV.num_cat_attribute40, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute41,
PAV.num_cat_attribute41, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute42,
PAV.num_cat_attribute42, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute43,
PAV.num_cat_attribute43, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute44,
PAV.num_cat_attribute44, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute45,
PAV.num_cat_attribute45, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute46,
PAV.num_cat_attribute46, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute47,
PAV.num_cat_attribute47, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute48,
PAV.num_cat_attribute48, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute49,
PAV.num_cat_attribute49, 'Y', 'N') = 'Y'
AND DECODE (PAVD.num_cat_attribute50,
PAV.num_cat_attribute50, 'Y', 'N') = 'Y');
UPDATE po_attribute_values_tlp_draft PAVTD
SET PAVTD.change_accepted_flag = 'Y'
WHERE PAVTD.draft_id = p_draft_id
AND PAVTD.change_accepted_flag IS NULL
AND NVL(PAVTD.delete_flag, 'N') <> 'Y'
AND EXISTS
( SELECT 1
FROM po_attribute_values_tlp PAVT
WHERE PAVTD.attribute_values_tlp_id = PAVT.attribute_values_tlp_id
AND DECODE (PAVTD.description,
PAVT.description, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.manufacturer,
PAVT.manufacturer, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.comments,
PAVT.comments, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.alias,
PAVT.alias, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.long_description,
PAVT.long_description, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute1,
PAVT.tl_text_base_attribute1, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute2,
PAVT.tl_text_base_attribute2, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute3,
PAVT.tl_text_base_attribute3, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute4,
PAVT.tl_text_base_attribute4, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute5,
PAVT.tl_text_base_attribute5, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute6,
PAVT.tl_text_base_attribute6, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute7,
PAVT.tl_text_base_attribute7, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute8,
PAVT.tl_text_base_attribute8, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute9,
PAVT.tl_text_base_attribute9, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute10,
PAVT.tl_text_base_attribute10, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute11,
PAVT.tl_text_base_attribute11, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute12,
PAVT.tl_text_base_attribute12, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute13,
PAVT.tl_text_base_attribute13, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute14,
PAVT.tl_text_base_attribute14, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute15,
PAVT.tl_text_base_attribute15, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute16,
PAVT.tl_text_base_attribute16, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute17,
PAVT.tl_text_base_attribute17, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute18,
PAVT.tl_text_base_attribute18, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute19,
PAVT.tl_text_base_attribute19, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute20,
PAVT.tl_text_base_attribute20, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute21,
PAVT.tl_text_base_attribute21, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute22,
PAVT.tl_text_base_attribute22, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute23,
PAVT.tl_text_base_attribute23, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute24,
PAVT.tl_text_base_attribute24, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute25,
PAVT.tl_text_base_attribute25, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute26,
PAVT.tl_text_base_attribute26, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute27,
PAVT.tl_text_base_attribute27, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute28,
PAVT.tl_text_base_attribute28, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute29,
PAVT.tl_text_base_attribute29, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute30,
PAVT.tl_text_base_attribute30, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute31,
PAVT.tl_text_base_attribute31, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute32,
PAVT.tl_text_base_attribute32, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute33,
PAVT.tl_text_base_attribute33, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute34,
PAVT.tl_text_base_attribute34, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute35,
PAVT.tl_text_base_attribute35, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute36,
PAVT.tl_text_base_attribute36, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute37,
PAVT.tl_text_base_attribute37, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute38,
PAVT.tl_text_base_attribute38, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute39,
PAVT.tl_text_base_attribute39, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute40,
PAVT.tl_text_base_attribute40, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute41,
PAVT.tl_text_base_attribute41, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute42,
PAVT.tl_text_base_attribute42, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute43,
PAVT.tl_text_base_attribute43, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute44,
PAVT.tl_text_base_attribute44, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute45,
PAVT.tl_text_base_attribute45, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute46,
PAVT.tl_text_base_attribute46, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute47,
PAVT.tl_text_base_attribute47, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute48,
PAVT.tl_text_base_attribute48, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute49,
PAVT.tl_text_base_attribute49, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute50,
PAVT.tl_text_base_attribute50, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute51,
PAVT.tl_text_base_attribute51, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute52,
PAVT.tl_text_base_attribute52, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute53,
PAVT.tl_text_base_attribute53, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute54,
PAVT.tl_text_base_attribute54, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute55,
PAVT.tl_text_base_attribute55, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute56,
PAVT.tl_text_base_attribute56, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute57,
PAVT.tl_text_base_attribute57, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute58,
PAVT.tl_text_base_attribute58, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute59,
PAVT.tl_text_base_attribute59, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute60,
PAVT.tl_text_base_attribute60, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute61,
PAVT.tl_text_base_attribute61, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute62,
PAVT.tl_text_base_attribute62, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute63,
PAVT.tl_text_base_attribute63, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute64,
PAVT.tl_text_base_attribute64, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute65,
PAVT.tl_text_base_attribute65, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute66,
PAVT.tl_text_base_attribute66, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute67,
PAVT.tl_text_base_attribute67, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute68,
PAVT.tl_text_base_attribute68, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute69,
PAVT.tl_text_base_attribute69, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute70,
PAVT.tl_text_base_attribute70, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute71,
PAVT.tl_text_base_attribute71, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute72,
PAVT.tl_text_base_attribute72, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute73,
PAVT.tl_text_base_attribute73, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute74,
PAVT.tl_text_base_attribute74, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute75,
PAVT.tl_text_base_attribute75, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute76,
PAVT.tl_text_base_attribute76, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute77,
PAVT.tl_text_base_attribute77, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute78,
PAVT.tl_text_base_attribute78, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute79,
PAVT.tl_text_base_attribute79, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute80,
PAVT.tl_text_base_attribute80, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute81,
PAVT.tl_text_base_attribute81, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute82,
PAVT.tl_text_base_attribute82, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute83,
PAVT.tl_text_base_attribute83, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute84,
PAVT.tl_text_base_attribute84, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute85,
PAVT.tl_text_base_attribute85, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute86,
PAVT.tl_text_base_attribute86, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute87,
PAVT.tl_text_base_attribute87, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute88,
PAVT.tl_text_base_attribute88, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute89,
PAVT.tl_text_base_attribute89, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute90,
PAVT.tl_text_base_attribute90, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute91,
PAVT.tl_text_base_attribute91, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute92,
PAVT.tl_text_base_attribute92, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute93,
PAVT.tl_text_base_attribute93, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute94,
PAVT.tl_text_base_attribute94, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute95,
PAVT.tl_text_base_attribute95, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute96,
PAVT.tl_text_base_attribute96, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute97,
PAVT.tl_text_base_attribute97, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute98,
PAVT.tl_text_base_attribute98, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute99,
PAVT.tl_text_base_attribute99, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_base_attribute100,
PAVT.tl_text_base_attribute100, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute1,
PAVT.tl_text_cat_attribute1, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute2,
PAVT.tl_text_cat_attribute2, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute3,
PAVT.tl_text_cat_attribute3, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute4,
PAVT.tl_text_cat_attribute4, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute5,
PAVT.tl_text_cat_attribute5, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute6,
PAVT.tl_text_cat_attribute6, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute7,
PAVT.tl_text_cat_attribute7, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute8,
PAVT.tl_text_cat_attribute8, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute9,
PAVT.tl_text_cat_attribute9, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute10,
PAVT.tl_text_cat_attribute10, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute11,
PAVT.tl_text_cat_attribute11, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute12,
PAVT.tl_text_cat_attribute12, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute13,
PAVT.tl_text_cat_attribute13, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute14,
PAVT.tl_text_cat_attribute14, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute15,
PAVT.tl_text_cat_attribute15, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute16,
PAVT.tl_text_cat_attribute16, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute17,
PAVT.tl_text_cat_attribute17, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute18,
PAVT.tl_text_cat_attribute18, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute19,
PAVT.tl_text_cat_attribute19, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute20,
PAVT.tl_text_cat_attribute20, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute21,
PAVT.tl_text_cat_attribute21, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute22,
PAVT.tl_text_cat_attribute22, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute23,
PAVT.tl_text_cat_attribute23, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute24,
PAVT.tl_text_cat_attribute24, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute25,
PAVT.tl_text_cat_attribute25, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute26,
PAVT.tl_text_cat_attribute26, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute27,
PAVT.tl_text_cat_attribute27, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute28,
PAVT.tl_text_cat_attribute28, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute29,
PAVT.tl_text_cat_attribute29, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute30,
PAVT.tl_text_cat_attribute30, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute31,
PAVT.tl_text_cat_attribute31, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute32,
PAVT.tl_text_cat_attribute32, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute33,
PAVT.tl_text_cat_attribute33, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute34,
PAVT.tl_text_cat_attribute34, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute35,
PAVT.tl_text_cat_attribute35, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute36,
PAVT.tl_text_cat_attribute36, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute37,
PAVT.tl_text_cat_attribute37, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute38,
PAVT.tl_text_cat_attribute38, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute39,
PAVT.tl_text_cat_attribute39, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute40,
PAVT.tl_text_cat_attribute40, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute41,
PAVT.tl_text_cat_attribute41, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute42,
PAVT.tl_text_cat_attribute42, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute43,
PAVT.tl_text_cat_attribute43, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute44,
PAVT.tl_text_cat_attribute44, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute45,
PAVT.tl_text_cat_attribute45, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute46,
PAVT.tl_text_cat_attribute46, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute47,
PAVT.tl_text_cat_attribute47, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute48,
PAVT.tl_text_cat_attribute48, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute49,
PAVT.tl_text_cat_attribute49, 'Y', 'N') = 'Y'
AND DECODE (PAVTD.tl_text_cat_attribute50,
PAVT.tl_text_cat_attribute50, 'Y', 'N') = 'Y');
SELECT NVL(MAX(FND_API.G_TRUE), FND_API.G_FALSE)
INTO l_has_record_to_accept
FROM DUAL
WHERE EXISTS
( SELECT 1
FROM po_lines_draft_all
WHERE draft_id = p_draft_id
AND change_accepted_flag IS NULL)
OR EXISTS
( SELECT 1
FROM po_line_locations_draft_all
WHERE draft_id = p_draft_id
AND change_accepted_flag IS NULL)
OR EXISTS
( SELECT 1
FROM po_price_diff_draft
WHERE draft_id = p_draft_id
AND change_accepted_flag IS NULL)
OR EXISTS
( SELECT 1
FROM po_attribute_values_draft
WHERE draft_id = p_draft_id
AND change_accepted_flag IS NULL)
OR EXISTS
( SELECT 1
FROM po_attribute_values_tlp_draft
WHERE draft_id = p_draft_id
AND change_accepted_flag IS NULL);
UPDATE po_line_locations_draft_all PLLDA
SET PLLDA.change_accepted_flag = 'Y'
WHERE PLLDA.draft_id = p_draft_id
AND NVL(PLLDA.change_accepted_flag, 'N') <> 'Y'
AND NOT EXISTS
( SELECT NULL
FROM po_lines_draft_all PLDA
WHERE PLDA.po_line_id = PLLDA.po_line_id
AND PLDA.draft_id = PLLDA.draft_id );
UPDATE po_attribute_values_draft PLVD
SET PLVD.change_accepted_flag = 'Y'
WHERE PLVD.draft_id = p_draft_id
AND NVL(PLVD.change_accepted_flag, 'N') <> 'Y'
AND NOT EXISTS
( SELECT NULL
FROM po_lines_draft_all PLDA
WHERE PLDA.po_line_id = PLVD.po_line_id
AND PLDA.draft_id = PLVD.draft_id );
UPDATE po_attribute_values_tlp_draft PLVTD
SET PLVTD.change_accepted_flag = 'Y'
WHERE PLVTD.draft_id = p_draft_id
AND NVL(PLVTD.change_accepted_flag, 'N') <> 'Y'
AND NOT EXISTS
( SELECT NULL
FROM po_lines_draft_all PLDA
WHERE PLDA.po_line_id = PLVTD.po_line_id
AND PLDA.draft_id = PLVTD.draft_id );
UPDATE po_price_diff_draft PPDD
SET PPDD.change_accepted_flag = 'Y'
WHERE PPDD.draft_id = p_draft_id
AND NVL(PPDD.change_accepted_flag, 'N') <> 'Y'
AND (( PPDD.entity_type = 'BLANKET LINE'
AND NOT EXISTS
( SELECT NULL
FROM po_lines_draft_all PLDA
WHERE PLDA.po_line_id = PPDD.entity_id
AND PLDA.draft_id = PPDD.draft_id
)
)
OR
( PPDD.entity_type = 'PRICE BREAK'
AND NOT EXISTS
( SELECT NULL
FROM po_line_locations_draft_all PLLDA,
po_lines_draft_all PLDA
WHERE PLLDA.line_location_id = PPDD.entity_id
AND PLLDA.draft_id = PPDD.draft_id
AND PLDA.po_line_id = PLLDA.po_line_id
AND PLDA.draft_id = PLLDA.draft_id )
AND NOT EXISTS
( SELECT NULL
FROM po_line_locations_all PLLA,
po_lines_draft_all PLDA
WHERE PLLA.line_location_id = PPDD.entity_id
AND PLDA.po_line_id = PLLA.po_line_id
AND PLDA.draft_id = PPDD.draft_id)));
UPDATE po_lines_draft_all
SET change_accepted_flag = p_change_accepted_value
WHERE draft_id = p_draft_id
AND po_line_id = p_line_id_list(i);
UPDATE po_line_locations_draft_all
SET change_accepted_flag = p_change_accepted_value
WHERE draft_id = p_draft_id
AND po_line_id = p_line_id_list(i);
UPDATE po_attribute_values_draft
SET change_accepted_flag = p_change_accepted_value
WHERE draft_id = p_draft_id
AND po_line_id = p_line_id_list(i);
UPDATE po_attribute_values_tlp_draft
SET change_accepted_flag = p_change_accepted_value
WHERE draft_id = p_draft_id
AND po_line_id = p_line_id_list(i);
UPDATE po_price_diff_draft
SET change_accepted_flag = p_change_accepted_value
WHERE draft_id = p_draft_id
AND entity_id = p_line_id_list(i)
AND entity_type = 'BLANKET LINE';
UPDATE po_price_diff_draft PPDD
SET change_accepted_flag = p_change_accepted_value
WHERE draft_id = p_draft_id
AND entity_type = 'PRICE BREAK'
AND EXISTS (SELECT 1
FROM po_line_locations_draft_all PLLD
WHERE PLLD.draft_id = p_draft_id
AND PLLD.po_line_id = p_line_id_list(i)
AND PLLD.line_location_id = PPDD.entity_id
UNION ALL
SELECT 1
FROM po_line_locations_all PLLD
WHERE PLLD.po_line_id = p_line_id_list(i)
AND PLLD.line_location_id = PPDD.entity_id);
INSERT INTO po_session_gt
( key,
index_num1, -- po_line_id
num2, -- line_num
char2 -- delete_flag
)
SELECT l_key,
p_reject_line_id_list(i),
pld.line_num,
pld.delete_flag
FROM po_lines_draft_all pld
WHERE pld.draft_id = p_draft_id
AND pld.po_line_id = p_reject_line_id_list(i);
SELECT PSG.index_num1,
num2
BULK COLLECT
INTO x_invalid_line_id_list,
x_invalid_line_num_list
FROM po_session_gt PSG
WHERE PSG.key = l_key
AND PSG.char2 = 'Y' -- delete_flag
AND EXISTS
(SELECT NULL
FROM po_lines_draft_all PLD
WHERE PLD.draft_id = p_draft_id
AND NVL(PLD.delete_flag, 'N') <> 'Y'
AND PLD.line_num = PSG.num2 -- line_num
AND NOT EXISTS
(SELECT NULL
FROM po_session_gt PSG1
WHERE PSG1.key = l_key
AND PSG1.index_num1 = PLD.po_line_id));
DELETE FROM po_session_gt
WHERE key = l_key;
SELECT fu.USER_ID, fu.user_name
INTO l_responder_id, l_responder_name
FROM fnd_user fu,
wf_notifications wfn
WHERE wfn.notification_id = l_nid
AND wfn.original_recipient = fu.user_name;
SELECT 'Y'
INTO l_any_line_accepted
FROM dual
WHERE EXISTS (SELECT 1
FROM po_lines_draft_all
WHERE draft_id = l_draft_id
AND nvl(change_accepted_flag,'Y') = 'Y')
OR EXISTS (SELECT 1
FROM po_line_locations_draft_all
WHERE draft_id = l_draft_id
AND nvl(change_accepted_flag,'Y') = 'Y')
OR EXISTS (SELECT 1
FROM po_price_diff_draft
WHERE draft_id = l_draft_id
AND nvl(change_accepted_flag,'Y') = 'Y')
OR EXISTS (SELECT 1
FROM po_attribute_values_draft
WHERE draft_id = l_draft_id
AND nvl(change_accepted_flag,'Y') = 'Y');