[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_uda_template_id;
update_uda_template_id;
UPDATE po_headers_all_ext_b
SET c_ext_attr40 = 'PO_UDA_ADDRESS_TYPES'
WHERE po_header_id = po_autocreate_params.g_po_header_id
AND draft_id = -1
AND c_ext_attr39 NOT IN ('MOD_ADMIN_OFFICE', 'MOD_ISSUING_OFFICE')
AND attr_group_id = (SELECT attr_group_id
FROM ego_attr_groups_v
WHERE ATTR_GROUP_NAME = 'addresses'
AND ATTR_GROUP_TYPE = 'PO_HEADER_EXT_ATTRS' );
SELECT PEI_INFORMATION2
INTO x_dodaac
FROM per_people_extra_info pei, fnd_user fu
WHERE pei.information_type = 'CLM_CONTACT_TITLE'
AND pei.person_id= fu.employee_id
AND fu.user_id = fnd_global.user_id;
SELECT umbrella_program_id,
clm_contract_finance_code
INTO l_umbrella_program_id,
l_clm_contract_fin_code
FROM po_headers_all
WHERE po_header_id =po_autocreate_params.g_clm_source_document_id;
UPDATE po_headers_draft_all
SET clm_source_document_id = po_autocreate_params.g_clm_source_document_id,
/*umbrella program changes*/
umbrella_program_id = nvl(umbrella_program_id,l_umbrella_program_id),
/*umbrella program changes*/
--Bug 16399373 - contract financing value to be carried forwarded from idv to the award
clm_contract_finance_code = l_clm_contract_fin_code
WHERE po_header_id = l_doc_row.po_header_id;
SELECT phda.clm_source_document_id
INTO x_clm_source_document_id
FROM po_headers_draft_all phda,
po_headers_all pha
WHERE phda.po_header_id = l_doc_row.po_header_id
AND pha.po_header_id = phda.clm_source_document_id
AND pha.clm_award_type IS NOT NULL
AND PO_AUTOCREATE_PARAMS.g_document_type <> 'PA'; --Bug 13787095
UPDATE po_headers_draft_all
SET segment1 = x_document_num,
clm_document_number = x_doc_number
WHERE po_header_id = l_doc_row.po_header_id;
select authorization_status
INTO l_authorization_status
FROM po_headers_all
WHERE po_header_id = PO_AUTOCREATE_PARAMS.g_po_header_id;
SELECT Decode(Nvl(clm_award_type,'*'),
'DELIVERY_ORD', 'Y',
'BPA_CALL', 'Y',
'N')
INTO l_is_ord_off_idv
FROM po_headers_draft_all
WHERE po_header_id = l_doc_row.po_header_id
AND draft_id = l_doc_row.draft_id;
SELECT standard_form,
document_format
INTO l_standard_form,
l_document_format
FROM po_print_form_formats
WHERE NVL(inactive_date, SYSDATE+1) > SYSDATE
AND standard_form = x_headers.clm_standard_form
AND document_format = x_headers.clm_document_format;
SELECT standard_form,
document_format
INTO l_standard_form,
l_document_format
FROM po_print_form_formats
WHERE NVL(inactive_date, SYSDATE+1) > SYSDATE
AND default_flag = 'Y'
AND style_id = l_doc_row.po_style_id
AND document_type = l_print_doc_type;
UPDATE po_headers_draft_all
SET clm_standard_form = l_standard_form,
clm_document_format = l_document_format,
clm_default_dist_flag = l_clm_default_dist
WHERE po_header_id = l_doc_row.po_header_id;
UPDATE po_drafts
SET draft_type = 'MOD'
,modification_number = x_doc_number
,mod_effective_date = sysdate
,clm_standard_form = l_standard_form
,clm_document_format = l_document_format
WHERE draft_id = po_autocreate_params.g_draft_id;
SELECT po_ame_approvals_s.nextval
INTO l_ame_approval_id
FROM dual;
SELECT mod_ame_transaction_type
INTO l_ame_transaction_type
FROM po_doc_style_headers pdsh, po_headers_all pha
WHERE pha.po_header_id = l_doc_row.po_header_id
AND pha.style_id = pdsh.style_id;
UPDATE po_headers_draft_all
SET ame_approval_id = l_ame_approval_id,
ame_transaction_type = l_ame_transaction_type,
clm_default_dist_flag = l_clm_default_dist
WHERE po_header_id = l_doc_row.po_header_id
AND draft_id = l_doc_row.draft_id;
SELECT MAX (pli.bid_number)
INTO x_bid_number
FROM po_lines_interface pli
WHERE pli.interface_header_id =
po_autocreate_params.x_interface_header_id;
p_delete_processed_draft => fnd_api.g_true,
p_acceptance_action => NULL,
x_return_status => l_return_status
);
UPDATE po_headers_all
SET CLM_SPECIAL_CONTRACT_TYPE = 'OBLIGATION_DOC'
WHERE po_header_id = po_autocreate_params.g_po_header_id;
SELECT MAX (pli.bid_number)
INTO x_bid_number
FROM po_lines_interface pli
WHERE pli.interface_header_id =
po_autocreate_params.x_interface_header_id;
/* Update the terms after the successful completion of PO */
l_progress := '140';
po_interface_s2.update_terms (l_doc_row.po_header_id);
SELECT po_ame_approvals_s.nextval
INTO l_ame_approval_id
FROM dual;
SELECT pdsh.ame_transaction_type
INTO l_ame_transaction_type
FROM po_doc_style_headers pdsh, po_headers_all pha
WHERE pha.po_header_id = l_doc_row.po_header_id
AND pha.style_id = pdsh.style_id;
UPDATE po_headers_draft_all
SET ame_approval_id = l_ame_approval_id,
ame_transaction_type = l_ame_transaction_type
WHERE po_header_id = l_doc_row.po_header_id
AND draft_id = l_doc_row.draft_id;
SELECT plt.purchase_basis, pla.po_line_id, pla.line_num
FROM po_lines_merge_v pla, po_line_types plt
WHERE pla.po_header_id = po_autocreate_params.g_po_header_id
AND pla.draft_id = l_draft_id
AND plt.line_type_id(+) = pla.line_type_id
AND EXISTS (
SELECT 'Y'
FROM po_lines_interface pli
WHERE pli.line_num = pla.line_num
AND pli.interface_header_id =
po_autocreate_params.x_interface_header_id);
SELECT pli.requisition_line_id, pli.created_by, pli.creation_date,
pli.last_update_login, pli.last_updated_by,
pli.last_update_date, pli.clm_info_flag,
pli.auction_header_id, pli.auction_line_number,
pli.bid_number, pli.bid_line_number, pli.interface_line_id
FROM po_lines_interface pli
WHERE pli.interface_header_id =
po_autocreate_params.x_interface_header_id
AND Nvl(pli.shipment_type, 'NONE') <> 'PRICE BREAK';
SELECT pli.requisition_line_id, pli.created_by, pli.creation_date,
pli.last_update_login, pli.last_updated_by,
pli.last_update_date, pli.clm_info_flag,
pli.auction_header_id, pli.auction_line_number,
pli.bid_number, pli.bid_line_number, pli.interface_line_id,
pli.shipment_type
FROM po_lines_interface pli
WHERE pli.interface_header_id =
po_autocreate_params.x_interface_header_id
AND pli.line_num = p_line_num;
SELECT pll.line_location_id
FROM po_line_locations_merge_v pll,
po_lines_interface pli,
po_lines_all pla
WHERE pll.po_line_id = p_po_line_id
AND pll.draft_id = l_draft_id
AND pli.interface_header_id =
po_autocreate_params.g_po_header_id
AND pli.shipment_num = pll.shipment_num
AND pla.line_num = pli.line_num
ORDER BY pll.line_location_id;
SELECT line_location_id
FROM po_line_locations_interface plli
WHERE plli.line_location_id <> p_line_location_id
AND plli.interface_line_id = p_intf_line_id;
SELECT MAX (pli.auction_header_id)
INTO x_auction_header_id
FROM po_lines_interface pli
WHERE pli.interface_header_id =
po_autocreate_params.x_interface_header_id;
p_doc_rec.last_update_login,
NULL,
NULL,
NULL,
'NEG'
);
p_doc_rec.last_update_login,
NULL,
NULL,
NULL
);
p_doc_rec.last_update_login,
NULL,
NULL,
NULL
);
l_who_rec.last_update_login := intf_rec.last_update_login;
l_who_rec.last_updated_by := intf_rec.last_updated_by;
l_who_rec.last_update_date := intf_rec.last_update_date;
intf_rec.last_update_login,
'',
'',
''
);
SELECT requisition_header_id
INTO x_requisition_header_id
FROM po_requisition_lines_all --
WHERE requisition_line_id = intf_rec.requisition_line_id;
intf_rec.last_update_login,
'',
'',
''
);
SELECT requisition_header_id
INTO x_requisition_header_id
FROM po_requisition_lines_all --
WHERE requisition_line_id = intf_rec.requisition_line_id;
intf_rec.last_update_login
);
p_message => 'Before selecting one-time attachment'
);
SELECT fad.attached_document_id
INTO l_one_time_att_doc_id
FROM fnd_attached_documents fad, fnd_documents_tl fdt
WHERE fad.entity_name = 'PO_LINES'
AND fad.pk1_value = TO_CHAR (line_rec.po_line_id)
AND fad.document_id = fdt.document_id
AND fdt.LANGUAGE = USERENV ('LANG')
AND fdt.description LIKE 'POR:%'; -- iP unique identifier
UPDATE fnd_attached_documents
SET entity_name = 'PO_SHIPMENTS',
pk1_value = pk1_shipment, --TO_CHAR (x_line_location_id),
pk2_value = 'ONE_TIME_LOCATION'
WHERE attached_document_id = l_one_time_att_doc_id;
x_last_update_login => intf_rec.last_update_login
);
p_last_update_login => intf_rec.last_update_login,
p_auction_header_id => intf_rec.auction_header_id,
p_auction_line_number => intf_rec.auction_line_number,
p_bid_number => intf_rec.bid_number,
p_bid_line_number => intf_rec.bid_line_number
);
SELECT 'N'
INTO x_create_doc_flag
FROM po_headers_all poh, po_doc_style_headers pdsh
WHERE poh.po_header_id = p_po_header_id
AND poh.style_id = pdsh.style_id
AND poh.approved_flag = 'Y'
AND pdsh.change_process_type = 'MODIFICATION';
c) Update Slin's Group Line Id with the Line Id from step2.
3. Get All options
4. For each Option Line.
a) Get the Base Line Id (clm_base_line_num)
b) Find the Line Id of line in Interface table whose Req Line Matches the above Base Line Id
c) Update Slin's clm_base_line_num with the Line Id from step2.
NOTE: This procedure is called from process()
==============================================================================*/
PROCEDURE set_clm_structure
IS
l_api_name VARCHAR2 (30) := 'set_clm_structure';
SELECT pla.group_line_id, pla.po_line_id
FROM po_lines_draft_all pla, po_lines_interface pli
WHERE pli.group_line_id IS NOT NULL
AND pli.interface_header_id =
po_autocreate_params.x_interface_header_id
AND pli.line_num = pla.line_num
AND pla.po_header_id = po_autocreate_params.g_po_header_id
AND pla.draft_id = po_autocreate_params.g_draft_id;
SELECT pla.clm_base_line_num, pla.po_line_id
FROM po_lines_draft_all pla, po_lines_interface pli
WHERE pli.clm_base_line_num IS NOT NULL
AND pli.interface_header_id =
po_autocreate_params.x_interface_header_id
AND pli.line_num = pla.line_num
AND pla.po_header_id = po_autocreate_params.g_po_header_id
AND pla.draft_id = po_autocreate_params.g_draft_id;
SELECT pla.line_num_display,
pla.clm_base_line_num,
pla.po_line_id,
rownum --bug 13584453
FROM po_lines_draft_all pla,
po_lines_interface pli
WHERE pli.clm_base_line_num IS NOT NULL
AND pli.interface_header_id = po_autocreate_params.x_interface_header_id
AND pli.line_num = pla.line_num
AND pla.po_header_id = po_autocreate_params.g_po_header_id
AND pla.draft_id = po_autocreate_params.g_draft_id
order by pla.clm_base_line_num,
pla.line_num_display;
UPDATE po_lines_draft_all
SET group_line_id =
(SELECT pla.po_line_id
FROM po_lines_interface pli, po_lines_draft_all pla
WHERE 1 = 1
AND pla.po_header_id =
po_autocreate_params.g_po_header_id
AND pla.group_line_id IS NULL
AND pla.line_num = pli.line_num
AND pli.interface_line_id = l_rec.group_line_id
AND pla.draft_id = po_autocreate_params.g_draft_id)
WHERE po_line_id = l_rec.po_line_id
AND draft_id = po_autocreate_params.g_draft_id;
UPDATE po_lines_draft_all
SET clm_base_line_num =
(SELECT pla.po_line_id
FROM po_lines_interface pli, po_lines_draft_all pla
WHERE 1 = 1
AND pla.po_header_id =
po_autocreate_params.g_po_header_id
AND pla.clm_base_line_num IS NULL
AND pla.line_num = pli.line_num
AND pli.interface_line_id = l_rec.clm_base_line_num
AND pla.draft_id = po_autocreate_params.g_draft_id)
WHERE po_line_id = l_rec.po_line_id
AND draft_id = po_autocreate_params.g_draft_id;
UPDATE po_lines_draft_all
SET clm_option_num = l_next_option_num
WHERE po_line_id = l_rec.po_line_id
AND draft_id = po_autocreate_params.g_draft_id;
SELECT NVL(MAX(clm_option_num), 0)
INTO l_next_option_num
FROM po_lines_merge_v
WHERE clm_base_line_num = l_rec.clm_base_line_num
AND draft_id = l_draft_id
;
UPDATE po_lines_draft_all
SET clm_option_num = l_next_option_num + DECODE(l_draft_id, -1, l_rec.rownum, 1)
WHERE po_line_id = l_rec.po_line_id
AND draft_id = po_autocreate_params.g_draft_id;
UPDATE po_distributions_draft_all pda
SET group_line_id = ( SELECT pld.po_line_id
FROM po_lines_draft_all pld , po_lines_interface PLI
WHERE pld.draft_id = po_autocreate_params.g_draft_id
AND pld.po_header_id = po_autocreate_params.g_po_header_id
AND pld.line_num = pli.line_num
AND PLI.interface_line_id = pda.group_line_id
)
WHERE pda.po_header_id = po_autocreate_params.g_po_header_id
AND pda.draft_id = po_autocreate_params.g_draft_id;
p_message => 'Number of distributions drafts updated '|| SQL%ROWCOUNT
);
UPDATE po_distributions_draft_all pda3
SET pda3.group_line_id = NULL
WHERE pda3.po_header_id = po_autocreate_params.g_po_header_id
AND pda3.draft_id = po_autocreate_params.g_draft_id
AND pda3.po_line_id IN ( SELECT pda1.po_line_id
FROM po_distributions_draft_all pda1
WHERE pda1.po_header_id = po_autocreate_params.g_po_header_id
AND pda1.draft_id = po_autocreate_params.g_draft_id
AND pda1.group_line_id IS NULL
AND EXISTS ( SELECT pda2.group_line_id
FROM po_distributions_draft_all pda2
WHERE pda2.po_line_id = pda1.po_line_id
AND pda2.group_line_id IS NOT NULL
AND pda2.po_header_id = po_autocreate_params.g_po_header_id
AND pda2.draft_id = po_autocreate_params.g_draft_id
)
);
SELECT po_line_id, line_num_display
FROM po_lines_all
WHERE po_header_id = po_autocreate_params.g_po_header_id
AND group_line_id IS NULL
ORDER BY line_num;
SELECT po_line_id, line_num_display
FROM po_lines_all
WHERE po_header_id = po_autocreate_params.g_po_header_id
AND group_line_id = p_group_line_id
AND NVL (clm_info_flag, 'N') = 'Y'
ORDER BY line_num;
SELECT po_line_id, line_num_display
FROM po_lines_all
WHERE po_header_id = po_autocreate_params.g_po_header_id
AND group_line_id = p_group_line_id
AND NVL (clm_info_flag, 'N') = 'N'
ORDER BY line_num;
SELECT PARENT.line_num_display, CHILD.po_line_id
FROM po_lines_all PARENT, po_lines_all CHILD
WHERE PARENT.po_header_id = po_autocreate_params.g_po_header_id
AND PARENT.group_line_id IS NULL
AND CHILD.po_header_id = po_autocreate_params.g_po_header_id
AND CHILD.group_line_id IS NOT NULL
AND PARENT.po_line_id = CHILD.group_line_id
AND PARENT.line_num_display <>
SUBSTR (CHILD.line_num_display, 1, 4);
SELECT phi.document_num, phi.document_type_code, phi.document_subtype,
phi.group_code, phi.action
INTO x_document_num, x_document_type_code, x_document_subtype,
x_group_code, x_mode
FROM po_headers_interface phi
WHERE phi.interface_header_id =
po_autocreate_params.x_interface_header_id;
UPDATE po_lines_all pla
SET pla.line_num_display =
(SELECT prl.line_num_display
FROM po_requisition_lines_all prl,
po_lines_interface pli
WHERE prl.requisition_line_id =
pli.requisition_line_id
AND pli.interface_header_id =
po_autocreate_params.x_interface_header_id
AND pli.line_num = pla.line_num)
WHERE pla.po_header_id =
po_autocreate_params.g_po_header_id
AND pla.line_num_display IS NULL;
UPDATE po_lines_all
SET line_num_display = l_clin_num
WHERE po_line_id = clin_rec.po_line_id
AND line_num_display IS NULL;
UPDATE po_lines_all
SET line_num_display = l_info_slin_num
WHERE po_line_id = info_slin_rec.po_line_id;
UPDATE po_lines_all
SET line_num_display = l_priced_slin_num
WHERE po_line_id = priced_slin_rec.po_line_id;
UPDATE po_lines_all
SET line_num_display = l_clin_num
WHERE po_line_id = clin_rec.po_line_id;
UPDATE po_lines_all
SET line_num_display = l_info_slin_num
WHERE po_line_id = info_slin_rec.po_line_id;
UPDATE po_lines_all
SET line_num_display = l_priced_slin_num
WHERE po_line_id = priced_slin_rec.po_line_id;
UPDATE po_lines_all
SET line_num_display = l_clin_num
WHERE po_line_id = clin_rec.po_line_id;
UPDATE po_lines_all
SET line_num_display = l_info_slin_num
WHERE po_line_id = info_slin_rec.po_line_id;
UPDATE po_lines_all
SET line_num_display = l_priced_slin_num
WHERE po_line_id = priced_slin_rec.po_line_id;
UPDATE po_lines_all pla
SET pla.line_num_display =
mis_rec.line_num_display
|| SUBSTR (pla.line_num_display, 5, 2)
WHERE pla.po_line_id = mis_rec.po_line_id;
PROCEDURE update_uda_template_id
IS
l_api_name VARCHAR2 (30) := 'update_uda_template_id';
SELECT pld.po_line_id
FROM po_lines_draft_all pld, po_lines_interface PLI
WHERE pld.uda_template_id IS NULL
AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
AND PLD.po_header_id = po_autocreate_params.g_po_header_id
AND pld. line_num =PLI.line_num
AND pld.draft_id = po_autocreate_params.g_draft_id;
SELECT pll.line_location_id
FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll
WHERE pll.uda_template_id IS NULL
AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
AND PLD.po_header_id = po_autocreate_params.g_po_header_id
AND pld. line_num =PLI.line_num
AND pld.draft_id = po_autocreate_params.g_draft_id
AND pld.po_line_id = pll.po_line_id
AND pll.shipment_num=PLI.shipment_num
AND pll.draft_id = po_autocreate_params.g_draft_id;
SELECT style_id
INTO l_style_id
FROM po_headers_interface
WHERE interface_header_id = po_autocreate_params.g_interface_header_id;
SELECT DISTINCT document_level
BULK COLLECT INTO x_doc_level_tbl
FROM po_uda_ag_templates
WHERE functional_area = l_functional_area
AND document_type = po_autocreate_params.g_document_subtype
AND document_style_id = l_style_id;
UPDATE po_headers_draft_all
SET uda_template_id = l_header_uda_tmpl_id
, uda_template_date = sysdate -- bug 10202181
WHERE po_header_id = po_autocreate_params.g_po_header_id
AND draft_id = po_autocreate_params.g_draft_id;
UPDATE po_lines_draft_all
SET uda_template_id = l_line_uda_tmpl_id
WHERE po_line_id = l_line_rec.po_line_id
AND draft_id = po_autocreate_params.g_draft_id;
UPDATE po_line_locations_draft_all
SET uda_template_id = l_ship_uda_tmpl_id
WHERE line_location_id = l_ship_rec.line_location_id
AND draft_id = po_autocreate_params.g_draft_id;
po_message_s.sql_error ('UPDATE_UDA_TEMPLATE_ID', l_progress, SQLCODE);
END update_uda_template_id;
select max(line_num)
into l_max_line_num
from po_lines_merge_v
where po_header_id = p_po_header_id
and draft_id = p_draft_id;
select line_num_display
into l_clin_line_num_display
from po_lines_merge_v
where po_line_id = p_po_line_id
and draft_id = p_draft_id;
INSERT INTO po_lines_draft_all
( draft_id,
po_line_id,
last_update_date,
last_updated_by,
po_header_id,
line_num,
line_num_display,
creation_date,
created_by,
last_update_login,
item_description,
org_id,
group_line_id,
clm_info_flag,
-- Bug 16511873: New Line should have change_status as NEW
change_status,
uda_template_id --
)
SELECT
p_draft_id
,x_slin_line_id
,last_update_date
,last_updated_by
,po_header_id
,l_slin_line_num
,l_slin_line_num_display
,creation_date
,created_by
,last_update_login
,'Funding for Line'||line_num_display
,org_id
,po_line_id
,'Y'
,'NEW' --Bug 16511873
,uda_template_id --
FROM po_lines_draft_all
WHERE po_line_id = p_po_line_id
AND draft_id = p_draft_id;
INSERT INTO po_lines_all
(
po_line_id,
last_update_date,
last_updated_by,
po_header_id,
line_num,
line_num_display,
creation_date,
created_by,
last_update_login,
item_description,
org_id,
group_line_id,
clm_info_flag,
uda_template_id --
)
SELECT
x_slin_line_id
,last_update_date
,last_updated_by
,po_header_id
,l_slin_line_num
,l_slin_line_num_display
,creation_date
,created_by
,last_update_login
,'Funding for Line'||line_num_display
,org_id
,po_line_id
,'Y'
,uda_template_id --
FROM po_lines_all
WHERE po_line_id = p_po_line_id;
when 'Convert Funding to Informational SLINs' action is selected
==============================================================================*/
PROCEDURE convert_fund_to_info_slin( p_po_header_id_tbl IN PO_TBL_NUMBER,
p_po_line_id_tbl IN PO_TBL_NUMBER,
p_draft_id_tbl IN PO_TBL_NUMBER
)
IS
l_api_name VARCHAR2 (30) := 'convert_fund_to_info_slins';
SELECT 'Y'
INTO l_is_convert_valid
FROM po_lines_merge_v polm
WHERE polm.po_line_id = p_po_line_id_tbl(i)
AND polm.draft_id = p_draft_id_tbl(i)
AND polm.group_line_id IS NULL
AND NVL(polm.clm_info_flag,'N') <> 'Y'
AND EXISTS ( SELECT 1 FROM po_distributions_merge_v podm
WHERE podm.po_line_id = polm.po_line_id
AND podm.draft_id = polm.draft_id
AND podm.group_line_id IS NULL);
update po_distributions_draft_all
set group_line_id = x_slin_line_id
where po_line_id = p_po_line_id_tbl(i)
AND draft_id = p_draft_id_tbl(i)
AND group_line_id IS NULL;
update po_distributions_all
set group_line_id = x_slin_line_id
where po_line_id = p_po_line_id_tbl(i)
AND group_line_id IS NULL;
INSERT INTO po_exhibit_details
(
PO_EXHIBIT_DETAILS_ID
,EXHIBIT_NAME
,EXHIBIT_DESCRIPTION
,IS_CDRL
,PO_HEADER_ID
,REFERENCE_LINE_ID
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN
)
SELECT po_exhibit_details_s.NEXTVAL --PO_EXHIBIT_DETAILS_ID
,EXHIBIT_NUMBER --EXHIBIT_NAME
,EXHIBIT_DESCRIPTION --EXHIBIT_DESCRIPTION
,IS_CDRL --IS_CDRL
,po_autocreate_params.g_po_header_id --PO_HEADER_ID
,(SELECT po_line_id FROM po_lines_merge_v
WHERE po_header_id = po_autocreate_params.g_po_header_id
AND AUCTION_LINE_NUMBER = paed.associated_to_line
AND draft_id = Nvl(po_autocreate_params.g_draft_id, -1)
)
,SYSDATE --LAST_UPDATE_DATE
,FND_GLOBAL.user_id --LAST_UPDATED_BY
,SYSDATE --CREATION_DATE
,FND_GLOBAL.user_id --CREATED_BY
,FND_GLOBAL.login_id --LAST_UPDATE_LOGIN
FROM PON_AUCTION_EXHIBIT_DETAILS paed
WHERE (paed.auction_header_id, paed.associated_to_line)
IN (
SELECT auction_header_id,auction_line_number FROM po_lines_merge_v pol
WHERE pol.po_header_id = po_autocreate_params.g_po_header_id
AND pol.draft_id = Nvl(po_autocreate_params.g_draft_id, -1)
)
;
SELECT exhibit_name
BULK COLLECT INTO l_exhibit_tbl
FROM po_exhibit_details
WHERE po_header_id = po_autocreate_params.g_po_header_id
AND is_cdrl = 'Y';