eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on PO_AUTOCREATE_PARAMS

Line 87: IF po_autocreate_params.g_is_clm_po = 'Y'

83:
84: /*
85: * Set the CLM structure and UDA tempalte id only when the target docuemnt is CLM enabled.
86: */
87: IF po_autocreate_params.g_is_clm_po = 'Y'
88: THEN
89: l_progress := '002';
90: set_clm_structure;
91: l_progress := '003';

Line 96: IF create_doc_from_draft_check (po_autocreate_params.g_po_header_id) = 'Y'

92: update_uda_template_id;
93: END IF;
94:
95: l_progress := '004';
96: IF create_doc_from_draft_check (po_autocreate_params.g_po_header_id) = 'Y'
97: THEN
98: l_draft_id := -1;
99: ELSE
100: l_draft_id := po_autocreate_params.g_draft_id;

Line 100: l_draft_id := po_autocreate_params.g_draft_id;

96: IF create_doc_from_draft_check (po_autocreate_params.g_po_header_id) = 'Y'
97: THEN
98: l_draft_id := -1;
99: ELSE
100: l_draft_id := po_autocreate_params.g_draft_id;
101: END IF;
102:
103: l_progress := '005';
104:

Line 107: IF Nvl(po_autocreate_params.g_process_code,'*') <> 'ADD_FUNDS'

103: l_progress := '005';
104:
105: -- : The uda data needs to be copied into the ext tables
106: --for all flows except in case of ADD FUNDS TO MOD
107: IF Nvl(po_autocreate_params.g_process_code,'*') <> 'ADD_FUNDS'
108: THEN
109: PO_UDA_AUTOCREATE_PKG.autocreate_uda_data(
110: p_source_document => NULL , -- PR,SOL
111: p_target_document => NULL, -- SOL,PO,IDV

Line 114: p_tar_pk1_value => po_autocreate_params.g_po_header_id, -- PO_HEADER_ID

110: p_source_document => NULL , -- PR,SOL
111: p_target_document => NULL, -- SOL,PO,IDV
112: p_src_pk1_value => NULL,
113: p_src_pk2_value => NULL,
114: p_tar_pk1_value => po_autocreate_params.g_po_header_id, -- PO_HEADER_ID
115: p_tar_pk2_value => l_draft_id, -- DRAFT_ID
116: x_return_status => x_return_status,
117: x_errorcode => x_errorcode,
118: x_msg_count => x_msg_count,

Line 123: IF po_autocreate_params.g_mode = 'NEW'

119: x_msg_data => x_msg_data);
120: END IF;
121:
122: /*Bug 13547051 starts*/
123: IF po_autocreate_params.g_mode = 'NEW'
124: -- : c_ext_attr40 value to be updated for all NEW flows.
125: --Removing SOURCING condition
126: THEN
127:

Line 139: WHERE po_header_id = po_autocreate_params.g_po_header_id

135: */
136:
137: UPDATE po_headers_all_ext_b
138: SET c_ext_attr40 = 'PO_UDA_ADDRESS_TYPES'
139: WHERE po_header_id = po_autocreate_params.g_po_header_id
140: AND draft_id = -1
141: AND c_ext_attr39 NOT IN ('MOD_ADMIN_OFFICE', 'MOD_ISSUING_OFFICE')
142: AND attr_group_id = (SELECT attr_group_id
143: FROM ego_attr_groups_v

Line 176: IF po_autocreate_params.g_mode = 'NEW' AND po_autocreate_params.g_clm_source_document_id IS NOT NULL

172: x_dodaac := NULL;
173:
174: END;
175:
176: IF po_autocreate_params.g_mode = 'NEW' AND po_autocreate_params.g_clm_source_document_id IS NOT NULL
177: THEN
178:
179: SELECT umbrella_program_id,
180: clm_contract_finance_code

Line 184: WHERE po_header_id =po_autocreate_params.g_clm_source_document_id;

180: clm_contract_finance_code
181: INTO l_umbrella_program_id,
182: l_clm_contract_fin_code
183: FROM po_headers_all
184: WHERE po_header_id =po_autocreate_params.g_clm_source_document_id;
185:
186: -- Bug 10057141: Removed the additional WHERE condition
187: UPDATE po_headers_draft_all
188: SET clm_source_document_id = po_autocreate_params.g_clm_source_document_id,

Line 188: SET clm_source_document_id = po_autocreate_params.g_clm_source_document_id,

184: WHERE po_header_id =po_autocreate_params.g_clm_source_document_id;
185:
186: -- Bug 10057141: Removed the additional WHERE condition
187: UPDATE po_headers_draft_all
188: SET clm_source_document_id = po_autocreate_params.g_clm_source_document_id,
189: /*umbrella program changes*/
190: umbrella_program_id = nvl(umbrella_program_id,l_umbrella_program_id),
191: /*umbrella program changes*/
192: --Bug 16399373 - contract financing value to be carried forwarded from idv to the award

Line 209: AND PO_AUTOCREATE_PARAMS.g_document_type <> 'PA'; --Bug 13787095

205: po_headers_all pha
206: WHERE phda.po_header_id = l_doc_row.po_header_id
207: AND pha.po_header_id = phda.clm_source_document_id
208: AND pha.clm_award_type IS NOT NULL
209: AND PO_AUTOCREATE_PARAMS.g_document_type <> 'PA'; --Bug 13787095
210: -- While creating CLM IDV with lines from sourcing
211: -- if reference IDV is provided ignore it
212:
213: EXCEPTION

Line 222: IF po_autocreate_params.g_mode = 'NEW'

218: END;
219:
220:
221: -- Get new document number
222: IF po_autocreate_params.g_mode = 'NEW'
223: THEN
224: IF po_autocreate_params.g_sys.user_defined_po_num_code =
225: 'AUTOMATIC'
226: AND ( po_autocreate_params.g_document_subtype = 'BLANKET'

Line 224: IF po_autocreate_params.g_sys.user_defined_po_num_code =

220:
221: -- Get new document number
222: IF po_autocreate_params.g_mode = 'NEW'
223: THEN
224: IF po_autocreate_params.g_sys.user_defined_po_num_code =
225: 'AUTOMATIC'
226: AND ( po_autocreate_params.g_document_subtype = 'BLANKET'
227: OR po_autocreate_params.g_document_subtype = 'STANDARD'
228: )

Line 226: AND ( po_autocreate_params.g_document_subtype = 'BLANKET'

222: IF po_autocreate_params.g_mode = 'NEW'
223: THEN
224: IF po_autocreate_params.g_sys.user_defined_po_num_code =
225: 'AUTOMATIC'
226: AND ( po_autocreate_params.g_document_subtype = 'BLANKET'
227: OR po_autocreate_params.g_document_subtype = 'STANDARD'
228: )
229: AND
230: /* If emergency po number is mentioned then the interface document number

Line 227: OR po_autocreate_params.g_document_subtype = 'STANDARD'

223: THEN
224: IF po_autocreate_params.g_sys.user_defined_po_num_code =
225: 'AUTOMATIC'
226: AND ( po_autocreate_params.g_document_subtype = 'BLANKET'
227: OR po_autocreate_params.g_document_subtype = 'STANDARD'
228: )
229: AND
230: /* If emergency po number is mentioned then the interface document number
231: will have that value and it can be alphanumeric though the po num code

Line 249: p_document_type => PO_AUTOCREATE_PARAMS.g_document_subtype,

245: l_progress := '003';
246:
247: -- Call Document Numbering API to get the order number
248: x_template_id := PO_UDA_DATA_UTIL.GET_TEMPLATE_ID(p_functional_area => 'PURCHASING',
249: p_document_type => PO_AUTOCREATE_PARAMS.g_document_subtype,
250: p_document_style_id => l_doc_row.po_style_id,
251: p_document_level => 'HEADER',
252: p_input_date => sysdate,
253: x_return_status => x_return_status,

Line 302: p_org_id => po_autocreate_params.g_purchasing_ou_id

298: IF Length(x_document_num) > 20 THEN
299:
300: x_document_num := po_core_sv1.default_po_unique_identifier
301: (p_table_name => 'PO_HEADERS',
302: p_org_id => po_autocreate_params.g_purchasing_ou_id
303: );
304:
305: END IF;
306: ELSE

Line 310: p_org_id => po_autocreate_params.g_purchasing_ou_id

306: ELSE
307:
308: x_document_num := po_core_sv1.default_po_unique_identifier
309: (p_table_name => 'PO_HEADERS',
310: p_org_id => po_autocreate_params.g_purchasing_ou_id
311: );
312: END IF;
313:
314: UPDATE po_headers_draft_all

Line 319: END IF; -- po_autocreate_params.g_sys.user_defined_po_num_code =

315: SET segment1 = x_document_num,
316: clm_document_number = x_doc_number
317: WHERE po_header_id = l_doc_row.po_header_id;
318:
319: END IF; -- po_autocreate_params.g_sys.user_defined_po_num_code =
320:
321: ELSIF po_autocreate_params.g_mode = 'ADD' THEN
322: /*Bug 12611018 : The Document number UDA attributes should not be defaulted
323: when the award that we are adding to is an Incomplete Award.

Line 321: ELSIF po_autocreate_params.g_mode = 'ADD' THEN

317: WHERE po_header_id = l_doc_row.po_header_id;
318:
319: END IF; -- po_autocreate_params.g_sys.user_defined_po_num_code =
320:
321: ELSIF po_autocreate_params.g_mode = 'ADD' THEN
322: /*Bug 12611018 : The Document number UDA attributes should not be defaulted
323: when the award that we are adding to is an Incomplete Award.
324: Hence skip the defaulting when award is Incomplete.*/
325: BEGIN

Line 330: WHERE po_header_id = PO_AUTOCREATE_PARAMS.g_po_header_id;

326:
327: select authorization_status
328: INTO l_authorization_status
329: FROM po_headers_all
330: WHERE po_header_id = PO_AUTOCREATE_PARAMS.g_po_header_id;
331:
332: EXCEPTION
333: WHEN No_Data_Found THEN
334: l_authorization_status:='';

Line 338: IF PO_AUTOCREATE_PARAMS.g_is_mod_exists = FALSE -- New Mod

334: l_authorization_status:='';
335: END;
336: /*Bug 12611018 ends */
337:
338: IF PO_AUTOCREATE_PARAMS.g_is_mod_exists = FALSE -- New Mod
339: AND Nvl(l_authorization_status,'INCOMPLETE') = 'APPROVED' THEN -- Bug 12611018
340:
341: -- Call Document Numbering API to get the order number
342: x_template_id := PO_UDA_DATA_UTIL.GET_TEMPLATE_ID(p_functional_area => 'PURCHASING',

Line 343: p_document_type => PO_AUTOCREATE_PARAMS.g_document_subtype,

339: AND Nvl(l_authorization_status,'INCOMPLETE') = 'APPROVED' THEN -- Bug 12611018
340:
341: -- Call Document Numbering API to get the order number
342: x_template_id := PO_UDA_DATA_UTIL.GET_TEMPLATE_ID(p_functional_area => 'PURCHASING',
343: p_document_type => PO_AUTOCREATE_PARAMS.g_document_subtype,
344: p_document_style_id => l_doc_row.po_style_id,
345: p_document_level => 'HEADER',
346: p_input_date => sysdate,
347: x_return_status => x_return_status,

Line 387: IF po_autocreate_params.g_mode = 'ADD' AND

383: l_create_doc_from_draft := create_doc_from_draft_check(l_doc_row.po_header_id);
384:
385:
386: -- Getting CLM Standard Form and CLM Document Format
387: IF po_autocreate_params.g_mode = 'ADD' AND
388: l_create_doc_from_draft = 'N' AND
389: NOT PO_AUTOCREATE_PARAMS.g_is_mod_exists -- New Mod
390: THEN
391:

Line 389: NOT PO_AUTOCREATE_PARAMS.g_is_mod_exists -- New Mod

385:
386: -- Getting CLM Standard Form and CLM Document Format
387: IF po_autocreate_params.g_mode = 'ADD' AND
388: l_create_doc_from_draft = 'N' AND
389: NOT PO_AUTOCREATE_PARAMS.g_is_mod_exists -- New Mod
390: THEN
391:
392: l_print_doc_type := 'PO_MOD_STD_FORM';
393:

Line 394: ELSIF po_autocreate_params.g_mode = 'NEW' OR

390: THEN
391:
392: l_print_doc_type := 'PO_MOD_STD_FORM';
393:
394: ELSIF po_autocreate_params.g_mode = 'NEW' OR
395: l_create_doc_from_draft = 'Y'
396: THEN
397:
398: BEGIN

Line 431: IF PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD' THEN

427:
428: IF l_is_ord_off_idv = 'Y' THEN
429: l_print_doc_type := 'PO_DEL_ORD_STD_FORM';
430: ELSE
431: IF PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD' THEN
432: l_print_doc_type := 'PO_AWARD_STD_FORM';
433: ELSIF PO_AUTOCREATE_PARAMS.g_document_subtype = 'BLANKET' THEN
434: l_print_doc_type := 'PO_IDV_STD_FORM';
435: ELSIF PO_AUTOCREATE_PARAMS.g_document_subtype = 'CONTRACT' THEN

Line 433: ELSIF PO_AUTOCREATE_PARAMS.g_document_subtype = 'BLANKET' THEN

429: l_print_doc_type := 'PO_DEL_ORD_STD_FORM';
430: ELSE
431: IF PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD' THEN
432: l_print_doc_type := 'PO_AWARD_STD_FORM';
433: ELSIF PO_AUTOCREATE_PARAMS.g_document_subtype = 'BLANKET' THEN
434: l_print_doc_type := 'PO_IDV_STD_FORM';
435: ELSIF PO_AUTOCREATE_PARAMS.g_document_subtype = 'CONTRACT' THEN
436: l_print_doc_type := 'PO_IDV_STD_FORM';
437: END IF;

Line 435: ELSIF PO_AUTOCREATE_PARAMS.g_document_subtype = 'CONTRACT' THEN

431: IF PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD' THEN
432: l_print_doc_type := 'PO_AWARD_STD_FORM';
433: ELSIF PO_AUTOCREATE_PARAMS.g_document_subtype = 'BLANKET' THEN
434: l_print_doc_type := 'PO_IDV_STD_FORM';
435: ELSIF PO_AUTOCREATE_PARAMS.g_document_subtype = 'CONTRACT' THEN
436: l_print_doc_type := 'PO_IDV_STD_FORM';
437: END IF;
438: END IF; -- IF l_is_ord_off_idv = 'Y'
439:

Line 440: END IF; -- IF po_autocreate_params.g_mode = 'NEW' OR l_create_doc_from_draft = 'Y'

436: l_print_doc_type := 'PO_IDV_STD_FORM';
437: END IF;
438: END IF; -- IF l_is_ord_off_idv = 'Y'
439:
440: END IF; -- IF po_autocreate_params.g_mode = 'NEW' OR l_create_doc_from_draft = 'Y'
441:
442: -- Getting Standard Form and Document Format of the output document
443: BEGIN
444: --Validating the standard_form and document_format in interface

Line 485: IF po_autocreate_params.g_mode = 'NEW' THEN

481:
482: -- New PO case
483: -- Default the value of clm_standard_form and clm_standard_form in Award
484: -- CLM-LnSc: Default clm_default_dist_flag for New PO
485: IF po_autocreate_params.g_mode = 'NEW' THEN
486:
487: --
488: -- Fetch the value for CLM_DEFAULT_DIST_FLAG
489: l_clm_default_dist := PO_CORE_S.get_create_default_dist(

Line 490: p_org_id => PO_AUTOCREATE_PARAMS.g_purchasing_ou_id,

486:
487: --
488: -- Fetch the value for CLM_DEFAULT_DIST_FLAG
489: l_clm_default_dist := PO_CORE_S.get_create_default_dist(
490: p_org_id => PO_AUTOCREATE_PARAMS.g_purchasing_ou_id,
491: p_style_id => l_doc_row.po_style_id,
492: p_doc_sub_type => PO_AUTOCREATE_PARAMS.g_document_subtype);
493: --
494:

Line 492: p_doc_sub_type => PO_AUTOCREATE_PARAMS.g_document_subtype);

488: -- Fetch the value for CLM_DEFAULT_DIST_FLAG
489: l_clm_default_dist := PO_CORE_S.get_create_default_dist(
490: p_org_id => PO_AUTOCREATE_PARAMS.g_purchasing_ou_id,
491: p_style_id => l_doc_row.po_style_id,
492: p_doc_sub_type => PO_AUTOCREATE_PARAMS.g_document_subtype);
493: --
494:
495: UPDATE po_headers_draft_all
496: SET clm_standard_form = l_standard_form,

Line 506: IF po_autocreate_params.g_mode = 'ADD'

502:
503:
504: -- Add to PO case
505: -- Default the value of clm_standard_form and clm_standard_form in Modification
506: IF po_autocreate_params.g_mode = 'ADD'
507: -- AND create_doc_from_draft_check (l_doc_row.po_header_id) = 'N'
508: AND l_create_doc_from_draft = 'N'
509: AND NOT PO_AUTOCREATE_PARAMS.g_is_mod_exists -- New Mod
510: THEN

Line 509: AND NOT PO_AUTOCREATE_PARAMS.g_is_mod_exists -- New Mod

505: -- Default the value of clm_standard_form and clm_standard_form in Modification
506: IF po_autocreate_params.g_mode = 'ADD'
507: -- AND create_doc_from_draft_check (l_doc_row.po_header_id) = 'N'
508: AND l_create_doc_from_draft = 'N'
509: AND NOT PO_AUTOCREATE_PARAMS.g_is_mod_exists -- New Mod
510: THEN
511: UPDATE po_drafts
512: SET draft_type = 'MOD'
513: ,modification_number = x_doc_number

Line 517: WHERE draft_id = po_autocreate_params.g_draft_id;

513: ,modification_number = x_doc_number
514: ,mod_effective_date = sysdate
515: ,clm_standard_form = l_standard_form
516: ,clm_document_format = l_document_format
517: WHERE draft_id = po_autocreate_params.g_draft_id;
518:
519: SELECT po_ame_approvals_s.nextval
520: INTO l_ame_approval_id
521: FROM dual;

Line 541: p_org_id => PO_AUTOCREATE_PARAMS.g_purchasing_ou_id,

537:
538: --
539: -- Fetch the value for CLM_DEFAULT_DIST_FLAG for New Mod
540: l_clm_default_dist := PO_CORE_S.get_create_default_dist(
541: p_org_id => PO_AUTOCREATE_PARAMS.g_purchasing_ou_id,
542: p_style_id => l_doc_row.po_style_id,
543: p_doc_sub_type => PO_AUTOCREATE_PARAMS.g_document_subtype);
544: --
545:

Line 543: p_doc_sub_type => PO_AUTOCREATE_PARAMS.g_document_subtype);

539: -- Fetch the value for CLM_DEFAULT_DIST_FLAG for New Mod
540: l_clm_default_dist := PO_CORE_S.get_create_default_dist(
541: p_org_id => PO_AUTOCREATE_PARAMS.g_purchasing_ou_id,
542: p_style_id => l_doc_row.po_style_id,
543: p_doc_sub_type => PO_AUTOCREATE_PARAMS.g_document_subtype);
544: --
545:
546: UPDATE po_headers_draft_all
547: SET ame_approval_id = l_ame_approval_id,

Line 558: IF ( (po_autocreate_params.g_interface_source_code = 'SOURCING'

554: copy_attachment (p_doc_rec => l_doc_row, p_is_mod => 'Y');
555: l_progress := '30';
556:
557: -- Contract terms
558: IF ( (po_autocreate_params.g_interface_source_code = 'SOURCING'
559: )
560: AND (po_autocreate_params.x_conterms_exist_flag = 'Y')
561: )
562: THEN

Line 560: AND (po_autocreate_params.x_conterms_exist_flag = 'Y')

556:
557: -- Contract terms
558: IF ( (po_autocreate_params.g_interface_source_code = 'SOURCING'
559: )
560: AND (po_autocreate_params.x_conterms_exist_flag = 'Y')
561: )
562: THEN
563: l_progress := '40';
564: l_contract_doc_type :=

Line 572: po_autocreate_params.x_interface_header_id;

568: SELECT MAX (pli.bid_number)
569: INTO x_bid_number
570: FROM po_lines_interface pli
571: WHERE pli.interface_header_id =
572: po_autocreate_params.x_interface_header_id;
573:
574: IF g_debug_stmt
575: THEN --< Bug 3210331: use proper debugging >
576: po_debug.debug_stmt

Line 615: p_value => po_autocreate_params.x_sourcing_k_doc_type

611: po_debug.debug_var
612: (p_log_head => g_log_head || l_api_name,
613: p_progress => l_progress,
614: p_name => 'p_sourcing_k_doc_type',
615: p_value => po_autocreate_params.x_sourcing_k_doc_type
616: );
617: po_debug.debug_stmt
618: (p_log_head => g_log_head || l_api_name,
619: p_token => l_progress,

Line 627: p_source_doc_type => po_autocreate_params.x_sourcing_k_doc_type,

623:
624: l_progress := '050';
625: okc_terms_copy_grp.copy_doc
626: (p_api_version => 1.0,
627: p_source_doc_type => po_autocreate_params.x_sourcing_k_doc_type,
628: p_source_doc_id => x_bid_number,
629: p_target_doc_type => l_contract_doc_type,
630: p_target_doc_id => l_doc_row.draft_id,
631: p_keep_version => 'Y',

Line 659: END IF; -- If PO_AUTOCREATE_PARAMS.x_conterms_exist_flag= 'Y'

655: IF l_return_status <> fnd_api.g_ret_sts_success
656: THEN
657: RAISE l_contracts_call_exception;
658: END IF; -- Return status from contracts
659: END IF; -- If PO_AUTOCREATE_PARAMS.x_conterms_exist_flag= 'Y'
660:
661: END IF; --IF ... AND l_create_doc_from_draft = 'N'
662:
663: l_progress := '070';

Line 665: IF po_autocreate_params.g_mode = 'NEW'

661: END IF; --IF ... AND l_create_doc_from_draft = 'N'
662:
663: l_progress := '070';
664: -- Transfer draft records to transaction
665: IF po_autocreate_params.g_mode = 'NEW'
666: -- OR create_doc_from_draft_check (l_doc_row.po_header_id) = 'Y'
667: OR l_create_doc_from_draft = 'Y'
668: THEN
669: -- The records are insterted in the draft tables

Line 696: WHERE po_header_id = po_autocreate_params.g_po_header_id;

692: THEN
693:
694: UPDATE po_headers_all
695: SET CLM_SPECIAL_CONTRACT_TYPE = 'OBLIGATION_DOC'
696: WHERE po_header_id = po_autocreate_params.g_po_header_id;
697:
698: PO_CLM_CAR_UTIL.car_for_control_type
699: ( p_po_header_id => po_autocreate_params.g_po_header_id,
700: p_draft_id => l_draft_id,

Line 699: ( p_po_header_id => po_autocreate_params.g_po_header_id,

695: SET CLM_SPECIAL_CONTRACT_TYPE = 'OBLIGATION_DOC'
696: WHERE po_header_id = po_autocreate_params.g_po_header_id;
697:
698: PO_CLM_CAR_UTIL.car_for_control_type
699: ( p_po_header_id => po_autocreate_params.g_po_header_id,
700: p_draft_id => l_draft_id,
701: p_special_contract_type => 'OBLIGATION_DOC'
702: );
703:

Line 707: po_autocreate_params.g_draft_id := NULL;

703:
704: END IF ;
705: --<>
706:
707: po_autocreate_params.g_draft_id := NULL;
708:
709: IF (l_return_status <> fnd_api.g_ret_sts_success)
710: THEN
711: RAISE fnd_api.g_exc_unexpected_error;

Line 717: IF po_autocreate_params.g_document_subtype = 'BLANKET'

713:
714: l_progress := '080';
715:
716: -- Document specific actions
717: IF po_autocreate_params.g_document_subtype = 'BLANKET'
718: THEN
719: create_blanket (l_doc_row);
720: ELSIF po_autocreate_params.g_document_subtype = 'STANDARD'
721: THEN

Line 720: ELSIF po_autocreate_params.g_document_subtype = 'STANDARD'

716: -- Document specific actions
717: IF po_autocreate_params.g_document_subtype = 'BLANKET'
718: THEN
719: create_blanket (l_doc_row);
720: ELSIF po_autocreate_params.g_document_subtype = 'STANDARD'
721: THEN
722: create_standard_po (l_doc_row);
723: END IF;
724:

Line 731: IF ( (po_autocreate_params.g_interface_source_code = 'SOURCING'

727: copy_attachment (p_doc_rec => l_doc_row);
728: l_progress := '100';
729:
730: -- Contract terms
731: IF ( (po_autocreate_params.g_interface_source_code = 'SOURCING'
732: )
733: AND (po_autocreate_params.x_conterms_exist_flag = 'Y')
734: )
735: THEN

Line 733: AND (po_autocreate_params.x_conterms_exist_flag = 'Y')

729:
730: -- Contract terms
731: IF ( (po_autocreate_params.g_interface_source_code = 'SOURCING'
732: )
733: AND (po_autocreate_params.x_conterms_exist_flag = 'Y')
734: )
735: THEN
736: l_progress := '110';
737: l_contract_doc_type :=

Line 745: po_autocreate_params.x_interface_header_id;

741: SELECT MAX (pli.bid_number)
742: INTO x_bid_number
743: FROM po_lines_interface pli
744: WHERE pli.interface_header_id =
745: po_autocreate_params.x_interface_header_id;
746:
747: IF g_debug_stmt
748: THEN --< Bug 3210331: use proper debugging >
749: po_debug.debug_stmt

Line 782: p_value => po_autocreate_params.x_sourcing_k_doc_type

778: po_debug.debug_var
779: (p_log_head => g_log_head || l_api_name,
780: p_progress => l_progress,
781: p_name => 'p_sourcing_k_doc_type',
782: p_value => po_autocreate_params.x_sourcing_k_doc_type
783: );
784: po_debug.debug_stmt
785: (p_log_head => g_log_head || l_api_name,
786: p_token => l_progress,

Line 794: p_source_doc_type => po_autocreate_params.x_sourcing_k_doc_type,

790:
791: l_progress := '120';
792: okc_terms_copy_grp.copy_doc
793: (p_api_version => 1.0,
794: p_source_doc_type => po_autocreate_params.x_sourcing_k_doc_type,
795: p_source_doc_id => x_bid_number,
796: p_target_doc_type => l_contract_doc_type,
797: p_target_doc_id => l_doc_row.po_header_id,
798: p_keep_version => 'Y',

Line 826: END IF; -- If PO_AUTOCREATE_PARAMS.x_conterms_exist_flag= 'Y'

822: IF l_return_status <> fnd_api.g_ret_sts_success
823: THEN
824: RAISE l_contracts_call_exception;
825: END IF; -- Return status from contracts
826: END IF; -- If PO_AUTOCREATE_PARAMS.x_conterms_exist_flag= 'Y'
827:
828: /* Update the terms after the successful completion of PO */
829: l_progress := '140';
830:

Line 831: IF (po_autocreate_params.g_document_subtype = 'STANDARD')

827:
828: /* Update the terms after the successful completion of PO */
829: l_progress := '140';
830:
831: IF (po_autocreate_params.g_document_subtype = 'STANDARD')
832: AND (po_autocreate_params.g_interface_source_code <>
833: 'CONSUMPTION_ADVICE'
834: )
835: THEN -- CONSIGNED FPI

Line 832: AND (po_autocreate_params.g_interface_source_code <>

828: /* Update the terms after the successful completion of PO */
829: l_progress := '140';
830:
831: IF (po_autocreate_params.g_document_subtype = 'STANDARD')
832: AND (po_autocreate_params.g_interface_source_code <>
833: 'CONSUMPTION_ADVICE'
834: )
835: THEN -- CONSIGNED FPI
836: po_interface_s2.update_terms (l_doc_row.po_header_id);

Line 857: END IF; --PO_AUTOCREATE_PARAMS.g_mode = 'NEW'

853: ame_transaction_type = l_ame_transaction_type
854: WHERE po_header_id = l_doc_row.po_header_id
855: AND draft_id = l_doc_row.draft_id;
856:
857: END IF; --PO_AUTOCREATE_PARAMS.g_mode = 'NEW'
858:
859: END LOOP;
860:
861: CLOSE c_doc;

Line 867: --IF (po_autocreate_params.g_interface_source_code <> 'SOURCING')

863: l_progress := '160';
864:
865:
866: /*Autocreate grouping phase2. Calling the set_line_num_display when the g_interface_source_code is 'SOURCING' too. Earlier in case of 'SOURCING' we were not making this call.*/
867: --IF (po_autocreate_params.g_interface_source_code <> 'SOURCING')
868: --THEN
869: set_line_num_display;
870: -- END IF;
871:

Line 875: IF (po_autocreate_params.g_interface_source_code = 'SOURCING')

871:
872: --CLM Phase4 Changes
873: l_progress := '165';
874: --copy data from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS when coming from Sourcing
875: IF (po_autocreate_params.g_interface_source_code = 'SOURCING')
876: THEN
877: copy_exhibit_from_sol(l_contract_doc_type, po_autocreate_params.g_purchasing_ou_id);
878: END IF;
879:

Line 877: copy_exhibit_from_sol(l_contract_doc_type, po_autocreate_params.g_purchasing_ou_id);

873: l_progress := '165';
874: --copy data from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS when coming from Sourcing
875: IF (po_autocreate_params.g_interface_source_code = 'SOURCING')
876: THEN
877: copy_exhibit_from_sol(l_contract_doc_type, po_autocreate_params.g_purchasing_ou_id);
878: END IF;
879:
880:
881: l_progress := '170';

Line 882: IF (po_autocreate_params.g_org_context_changed = 'Y') THEN

878: END IF;
879:
880:
881: l_progress := '170';
882: IF (po_autocreate_params.g_org_context_changed = 'Y') THEN
883: PO_MOAC_UTILS_PVT.set_org_context(po_autocreate_params.g_original_operating_unit_id) ;
884: END IF;
885:
886:

Line 883: PO_MOAC_UTILS_PVT.set_org_context(po_autocreate_params.g_original_operating_unit_id) ;

879:
880:
881: l_progress := '170';
882: IF (po_autocreate_params.g_org_context_changed = 'Y') THEN
883: PO_MOAC_UTILS_PVT.set_org_context(po_autocreate_params.g_original_operating_unit_id) ;
884: END IF;
885:
886:
887:

Line 906: PO_AUTOCREATE_PARAMS.g_number_records_processed := 0;

902:
903: fnd_message.set_name ('PO', 'PO_UDA_TEMPLATE_ID_NULL');
904: fnd_msg_pub.ADD;
905:
906: PO_AUTOCREATE_PARAMS.g_number_records_processed := 0;
907: CLOSE c_doc;
908:
909: --CLM Phase 2 changes : error handling
910: PO_AUTOCREATE_PVT.report_error('PO_AUTO_POST_UDA_TEMP_ERR',x_token1_value => sqlerrm);

Line 999: PO_AUTOCREATE_PARAMS.g_number_records_processed := 0;

995: );
996: END LOOP;
997: END IF;
998:
999: PO_AUTOCREATE_PARAMS.g_number_records_processed := 0;
1000: IF (c_doc%ISOPEN) THEN
1001: CLOSE c_doc;
1002: END IF;
1003:

Line 1108: IF po_autocreate_params.g_interface_source_code = 'SOURCING'

1104: END IF;
1105:
1106: NULL;
1107:
1108: IF po_autocreate_params.g_interface_source_code = 'SOURCING'
1109: THEN
1110: -- PO_ATTRIBUTE_VALUES_PVT.transfer_intf_item_attribs(p_doc_rec.interface_header_id);
1111: NULL;
1112: END IF;

Line 1211: WHERE pla.po_header_id = po_autocreate_params.g_po_header_id

1207: CURSOR c_line_attach
1208: IS
1209: SELECT plt.purchase_basis, pla.po_line_id, pla.line_num
1210: FROM po_lines_merge_v pla, po_line_types plt
1211: WHERE pla.po_header_id = po_autocreate_params.g_po_header_id
1212: AND pla.draft_id = l_draft_id
1213: AND plt.line_type_id(+) = pla.line_type_id
1214: AND EXISTS (
1215: SELECT 'Y'

Line 1219: po_autocreate_params.x_interface_header_id);

1215: SELECT 'Y'
1216: FROM po_lines_interface pli
1217: WHERE pli.line_num = pla.line_num
1218: AND pli.interface_header_id =
1219: po_autocreate_params.x_interface_header_id);
1220:
1221: CURSOR c_copy_header_attachment
1222: IS
1223: SELECT pli.requisition_line_id, pli.created_by, pli.creation_date,

Line 1230: po_autocreate_params.x_interface_header_id

1226: pli.auction_header_id, pli.auction_line_number,
1227: pli.bid_number, pli.bid_line_number, pli.interface_line_id
1228: FROM po_lines_interface pli
1229: WHERE pli.interface_header_id =
1230: po_autocreate_params.x_interface_header_id
1231: AND Nvl(pli.shipment_type, 'NONE') <> 'PRICE BREAK';
1232:
1233: CURSOR c_interface_info (p_line_num NUMBER)
1234: IS

Line 1243: po_autocreate_params.x_interface_header_id

1239: pli.bid_number, pli.bid_line_number, pli.interface_line_id,
1240: pli.shipment_type
1241: FROM po_lines_interface pli
1242: WHERE pli.interface_header_id =
1243: po_autocreate_params.x_interface_header_id
1244: AND pli.line_num = p_line_num;
1245:
1246: CURSOR c_copy_lineloc_attachment (p_po_line_id NUMBER)
1247: IS

Line 1255: po_autocreate_params.g_po_header_id

1251: po_lines_all pla
1252: WHERE pll.po_line_id = p_po_line_id
1253: AND pll.draft_id = l_draft_id
1254: AND pli.interface_header_id =
1255: po_autocreate_params.g_po_header_id
1256: AND pli.shipment_num = pll.shipment_num
1257: AND pla.line_num = pli.line_num
1258: ORDER BY pll.line_location_id;
1259:

Line 1291: po_autocreate_params.x_interface_header_id;

1287: SELECT MAX (pli.auction_header_id)
1288: INTO x_auction_header_id
1289: FROM po_lines_interface pli
1290: WHERE pli.interface_header_id =
1291: po_autocreate_params.x_interface_header_id;
1292:
1293: IF p_is_mod = 'Y' THEN
1294: pk1_header := to_char(p_doc_rec.po_header_id) || '-' || to_char(p_doc_rec.draft_id);
1295: l_draft_id := p_doc_rec.draft_id;

Line 1302: IF po_autocreate_params.g_interface_source_code = 'SOURCING'

1298: l_draft_id := -1;
1299: END IF;
1300:
1301: -- Copying Sourcing Header Level attachment to PO header
1302: IF po_autocreate_params.g_interface_source_code = 'SOURCING'
1303: THEN
1304: -- copy attachments from negotiation header to blanket header
1305: po_negotiations_sv2.copy_attachments ('PON_AUCTION_HEADERS_ALL',
1306: x_auction_header_id,

Line 1376: END IF; -- PO_AUTOCREATE_PARAMS.g_interface_source_code ='SOURCING'

1372: END IF;
1373: END IF;
1374: -- Nvl(c_copy_header_attachment_rec.clm_info_flag,'N')<>'Y'
1375: END LOOP; -- c_copy_header_attachment
1376: END IF; -- PO_AUTOCREATE_PARAMS.g_interface_source_code ='SOURCING'
1377:
1378: -- Sourcing Header attachment copy ends here
1379:
1380: -- Copying line level attachment

Line 1436: IF po_autocreate_params.g_interface_source_code NOT IN

1432: );
1433: END IF; -- ( l_job_long_description IS NOT NULL )
1434: END IF; -- ( l_purchase_basis = 'TEMP LABOR' )
1435:
1436: IF po_autocreate_params.g_interface_source_code NOT IN
1437: ('SOURCING', 'CONSUMPTION_ADVICE')
1438: THEN -- CONSIGNED FPI
1439: l_progress := '050';
1440: fnd_attached_documents2_pkg.copy_attachments

Line 1502: IF po_autocreate_params.g_interface_source_code = 'SOURCING'

1498: );
1499: END IF;
1500:
1501: --copy attachments/notes from negotiation/bid to po/blanket line
1502: IF po_autocreate_params.g_interface_source_code = 'SOURCING'
1503: THEN
1504: IF po_autocreate_params.g_document_subtype = 'STANDARD'
1505: THEN
1506: IF intf_rec.requisition_line_id IS NOT NULL

Line 1504: IF po_autocreate_params.g_document_subtype = 'STANDARD'

1500:
1501: --copy attachments/notes from negotiation/bid to po/blanket line
1502: IF po_autocreate_params.g_interface_source_code = 'SOURCING'
1503: THEN
1504: IF po_autocreate_params.g_document_subtype = 'STANDARD'
1505: THEN
1506: IF intf_rec.requisition_line_id IS NOT NULL
1507: THEN
1508: x_column1 := 'NEGREQ';

Line 1518: ELSIF po_autocreate_params.g_document_subtype = 'BLANKET'

1514: WHERE requisition_line_id = intf_rec.requisition_line_id;
1515: ELSE
1516: x_column1 := 'NEG';
1517: END IF; -- attach_rec.requisition_line_id is not null
1518: ELSIF po_autocreate_params.g_document_subtype = 'BLANKET'
1519: THEN --po_autocreate_params.g_document_subtype = 'STANDARD'
1520: x_column1 := 'NEG';
1521: END IF;
1522:

Line 1519: THEN --po_autocreate_params.g_document_subtype = 'STANDARD'

1515: ELSE
1516: x_column1 := 'NEG';
1517: END IF; -- attach_rec.requisition_line_id is not null
1518: ELSIF po_autocreate_params.g_document_subtype = 'BLANKET'
1519: THEN --po_autocreate_params.g_document_subtype = 'STANDARD'
1520: x_column1 := 'NEG';
1521: END IF;
1522:
1523: IF ( po_autocreate_params.g_document_subtype IN

Line 1523: IF ( po_autocreate_params.g_document_subtype IN

1519: THEN --po_autocreate_params.g_document_subtype = 'STANDARD'
1520: x_column1 := 'NEG';
1521: END IF;
1522:
1523: IF ( po_autocreate_params.g_document_subtype IN
1524: ('BLANKET', 'STANDARD')
1525: /*AND NVL (intf_rec.clm_info_flag, 'N') <> 'Y'*/ AND Nvl(intf_rec.shipment_type, 'NONE') <> 'PRICE BREAK'
1526: )
1527: THEN

Line 1558: IF (po_autocreate_params.g_document_subtype IN

1554: END IF;
1555:
1556: -- If autocreating a SPO or PPO, and the requisition line has a one-time
1557: -- location, move the attachment from the PO line to the PO shipment
1558: IF (po_autocreate_params.g_document_subtype IN
1559: ('STANDARD', 'PLANNED')
1560: )
1561: AND (po_autocreate_mainproc_pvt.has_one_time_location
1562: (intf_rec.requisition_line_id)

Line 1627: IF (po_autocreate_params.g_is_complex_work_po)

1623: END;
1624: END IF;
1625:
1626: -- : Copy attachments to payitems
1627: IF (po_autocreate_params.g_is_complex_work_po)
1628: THEN
1629: l_progress := '140';
1630:
1631: FOR c_payitem_rec IN

Line 1786: po_autocreate_params.x_interface_header_id

1782: SELECT pla.group_line_id, pla.po_line_id
1783: FROM po_lines_draft_all pla, po_lines_interface pli
1784: WHERE pli.group_line_id IS NOT NULL
1785: AND pli.interface_header_id =
1786: po_autocreate_params.x_interface_header_id
1787: AND pli.line_num = pla.line_num
1788: AND pla.po_header_id = po_autocreate_params.g_po_header_id
1789: AND pla.draft_id = po_autocreate_params.g_draft_id;
1790:

Line 1788: AND pla.po_header_id = po_autocreate_params.g_po_header_id

1784: WHERE pli.group_line_id IS NOT NULL
1785: AND pli.interface_header_id =
1786: po_autocreate_params.x_interface_header_id
1787: AND pli.line_num = pla.line_num
1788: AND pla.po_header_id = po_autocreate_params.g_po_header_id
1789: AND pla.draft_id = po_autocreate_params.g_draft_id;
1790:
1791: CURSOR c_old_base
1792: IS

Line 1789: AND pla.draft_id = po_autocreate_params.g_draft_id;

1785: AND pli.interface_header_id =
1786: po_autocreate_params.x_interface_header_id
1787: AND pli.line_num = pla.line_num
1788: AND pla.po_header_id = po_autocreate_params.g_po_header_id
1789: AND pla.draft_id = po_autocreate_params.g_draft_id;
1790:
1791: CURSOR c_old_base
1792: IS
1793: SELECT pla.clm_base_line_num, pla.po_line_id

Line 1797: po_autocreate_params.x_interface_header_id

1793: SELECT pla.clm_base_line_num, pla.po_line_id
1794: FROM po_lines_draft_all pla, po_lines_interface pli
1795: WHERE pli.clm_base_line_num IS NOT NULL
1796: AND pli.interface_header_id =
1797: po_autocreate_params.x_interface_header_id
1798: AND pli.line_num = pla.line_num
1799: AND pla.po_header_id = po_autocreate_params.g_po_header_id
1800: AND pla.draft_id = po_autocreate_params.g_draft_id;
1801:

Line 1799: AND pla.po_header_id = po_autocreate_params.g_po_header_id

1795: WHERE pli.clm_base_line_num IS NOT NULL
1796: AND pli.interface_header_id =
1797: po_autocreate_params.x_interface_header_id
1798: AND pli.line_num = pla.line_num
1799: AND pla.po_header_id = po_autocreate_params.g_po_header_id
1800: AND pla.draft_id = po_autocreate_params.g_draft_id;
1801:
1802: CURSOR c_old_option_line
1803: IS

Line 1800: AND pla.draft_id = po_autocreate_params.g_draft_id;

1796: AND pli.interface_header_id =
1797: po_autocreate_params.x_interface_header_id
1798: AND pli.line_num = pla.line_num
1799: AND pla.po_header_id = po_autocreate_params.g_po_header_id
1800: AND pla.draft_id = po_autocreate_params.g_draft_id;
1801:
1802: CURSOR c_old_option_line
1803: IS
1804: SELECT pla.line_num_display,

Line 1811: AND pli.interface_header_id = po_autocreate_params.x_interface_header_id

1807: rownum --bug 13584453
1808: FROM po_lines_draft_all pla,
1809: po_lines_interface pli
1810: WHERE pli.clm_base_line_num IS NOT NULL
1811: AND pli.interface_header_id = po_autocreate_params.x_interface_header_id
1812: AND pli.line_num = pla.line_num
1813: AND pla.po_header_id = po_autocreate_params.g_po_header_id
1814: AND pla.draft_id = po_autocreate_params.g_draft_id
1815: order by pla.clm_base_line_num,

Line 1813: AND pla.po_header_id = po_autocreate_params.g_po_header_id

1809: po_lines_interface pli
1810: WHERE pli.clm_base_line_num IS NOT NULL
1811: AND pli.interface_header_id = po_autocreate_params.x_interface_header_id
1812: AND pli.line_num = pla.line_num
1813: AND pla.po_header_id = po_autocreate_params.g_po_header_id
1814: AND pla.draft_id = po_autocreate_params.g_draft_id
1815: order by pla.clm_base_line_num,
1816: pla.line_num_display;
1817:

Line 1814: AND pla.draft_id = po_autocreate_params.g_draft_id

1810: WHERE pli.clm_base_line_num IS NOT NULL
1811: AND pli.interface_header_id = po_autocreate_params.x_interface_header_id
1812: AND pli.line_num = pla.line_num
1813: AND pla.po_header_id = po_autocreate_params.g_po_header_id
1814: AND pla.draft_id = po_autocreate_params.g_draft_id
1815: order by pla.clm_base_line_num,
1816: pla.line_num_display;
1817:
1818: BEGIN

Line 1834: po_autocreate_params.g_po_header_id

1830: (SELECT pla.po_line_id
1831: FROM po_lines_interface pli, po_lines_draft_all pla
1832: WHERE 1 = 1
1833: AND pla.po_header_id =
1834: po_autocreate_params.g_po_header_id
1835: AND pla.group_line_id IS NULL
1836: AND pla.line_num = pli.line_num
1837: AND pli.interface_line_id = l_rec.group_line_id
1838: AND pla.draft_id = po_autocreate_params.g_draft_id)

Line 1838: AND pla.draft_id = po_autocreate_params.g_draft_id)

1834: po_autocreate_params.g_po_header_id
1835: AND pla.group_line_id IS NULL
1836: AND pla.line_num = pli.line_num
1837: AND pli.interface_line_id = l_rec.group_line_id
1838: AND pla.draft_id = po_autocreate_params.g_draft_id)
1839: WHERE po_line_id = l_rec.po_line_id
1840: AND draft_id = po_autocreate_params.g_draft_id;
1841: END LOOP;
1842:

Line 1840: AND draft_id = po_autocreate_params.g_draft_id;

1836: AND pla.line_num = pli.line_num
1837: AND pli.interface_line_id = l_rec.group_line_id
1838: AND pla.draft_id = po_autocreate_params.g_draft_id)
1839: WHERE po_line_id = l_rec.po_line_id
1840: AND draft_id = po_autocreate_params.g_draft_id;
1841: END LOOP;
1842:
1843: IF g_debug_stmt
1844: THEN

Line 1862: po_autocreate_params.g_po_header_id

1858: (SELECT pla.po_line_id
1859: FROM po_lines_interface pli, po_lines_draft_all pla
1860: WHERE 1 = 1
1861: AND pla.po_header_id =
1862: po_autocreate_params.g_po_header_id
1863: AND pla.clm_base_line_num IS NULL
1864: AND pla.line_num = pli.line_num
1865: AND pli.interface_line_id = l_rec.clm_base_line_num
1866: AND pla.draft_id = po_autocreate_params.g_draft_id)

Line 1866: AND pla.draft_id = po_autocreate_params.g_draft_id)

1862: po_autocreate_params.g_po_header_id
1863: AND pla.clm_base_line_num IS NULL
1864: AND pla.line_num = pli.line_num
1865: AND pli.interface_line_id = l_rec.clm_base_line_num
1866: AND pla.draft_id = po_autocreate_params.g_draft_id)
1867: WHERE po_line_id = l_rec.po_line_id
1868: AND draft_id = po_autocreate_params.g_draft_id;
1869: END LOOP;
1870:

Line 1868: AND draft_id = po_autocreate_params.g_draft_id;

1864: AND pla.line_num = pli.line_num
1865: AND pli.interface_line_id = l_rec.clm_base_line_num
1866: AND pla.draft_id = po_autocreate_params.g_draft_id)
1867: WHERE po_line_id = l_rec.po_line_id
1868: AND draft_id = po_autocreate_params.g_draft_id;
1869: END LOOP;
1870:
1871:
1872: /*CLM Phase-2 : Autocreate Grouping*/

Line 1881: p_message => 'po_autocreate_params.g_mode: '||po_autocreate_params.g_mode

1877: THEN
1878: po_debug.debug_stmt
1879: (p_log_head => g_log_head || l_api_name,
1880: p_token => l_progress,
1881: p_message => 'po_autocreate_params.g_mode: '||po_autocreate_params.g_mode
1882: );
1883: END IF;
1884: IF po_autocreate_params.g_mode = 'NEW' THEN
1885:

Line 1884: IF po_autocreate_params.g_mode = 'NEW' THEN

1880: p_token => l_progress,
1881: p_message => 'po_autocreate_params.g_mode: '||po_autocreate_params.g_mode
1882: );
1883: END IF;
1884: IF po_autocreate_params.g_mode = 'NEW' THEN
1885:
1886: /*bug 13584453 the option num was always set as 1 due to this incorrect logic.
1887: Getting the max(clm_otiopn_num) for the given clm_base_line_num
1888: and setting the subsequent option nums by incrementing it.*/

Line 1905: AND draft_id = po_autocreate_params.g_draft_id;

1901:
1902: UPDATE po_lines_draft_all
1903: SET clm_option_num = l_next_option_num
1904: WHERE po_line_id = l_rec.po_line_id
1905: AND draft_id = po_autocreate_params.g_draft_id;
1906:
1907: ELSIF po_autocreate_params.g_mode = 'ADD' THEN
1908:
1909: --bug 13584453 start

Line 1907: ELSIF po_autocreate_params.g_mode = 'ADD' THEN

1903: SET clm_option_num = l_next_option_num
1904: WHERE po_line_id = l_rec.po_line_id
1905: AND draft_id = po_autocreate_params.g_draft_id;
1906:
1907: ELSIF po_autocreate_params.g_mode = 'ADD' THEN
1908:
1909: --bug 13584453 start
1910:
1911: IF l_curr_clm_base_line_num <> l_rec.clm_base_line_num THEN

Line 1915: IF create_doc_from_draft_check (po_autocreate_params.g_po_header_id) = 'Y'

1911: IF l_curr_clm_base_line_num <> l_rec.clm_base_line_num THEN
1912: l_curr_clm_base_line_num := l_rec.clm_base_line_num;
1913: END IF;
1914:
1915: IF create_doc_from_draft_check (po_autocreate_params.g_po_header_id) = 'Y'
1916: THEN
1917: l_draft_id := -1;
1918: ELSE
1919: l_draft_id := po_autocreate_params.g_draft_id;

Line 1919: l_draft_id := po_autocreate_params.g_draft_id;

1915: IF create_doc_from_draft_check (po_autocreate_params.g_po_header_id) = 'Y'
1916: THEN
1917: l_draft_id := -1;
1918: ELSE
1919: l_draft_id := po_autocreate_params.g_draft_id;
1920: END IF;
1921:
1922: IF g_debug_stmt
1923: THEN

Line 1941: AND draft_id = po_autocreate_params.g_draft_id;

1937:
1938: UPDATE po_lines_draft_all
1939: SET clm_option_num = l_next_option_num + DECODE(l_draft_id, -1, l_rec.rownum, 1)
1940: WHERE po_line_id = l_rec.po_line_id
1941: AND draft_id = po_autocreate_params.g_draft_id;
1942:
1943: END IF;
1944:
1945: IF g_debug_stmt

Line 1973: WHERE pld.draft_id = po_autocreate_params.g_draft_id

1969:
1970: UPDATE po_distributions_draft_all pda
1971: SET group_line_id = ( SELECT pld.po_line_id
1972: FROM po_lines_draft_all pld , po_lines_interface PLI
1973: WHERE pld.draft_id = po_autocreate_params.g_draft_id
1974: AND pld.po_header_id = po_autocreate_params.g_po_header_id
1975: AND pld.line_num = pli.line_num
1976: AND PLI.interface_line_id = pda.group_line_id
1977: )

Line 1974: AND pld.po_header_id = po_autocreate_params.g_po_header_id

1970: UPDATE po_distributions_draft_all pda
1971: SET group_line_id = ( SELECT pld.po_line_id
1972: FROM po_lines_draft_all pld , po_lines_interface PLI
1973: WHERE pld.draft_id = po_autocreate_params.g_draft_id
1974: AND pld.po_header_id = po_autocreate_params.g_po_header_id
1975: AND pld.line_num = pli.line_num
1976: AND PLI.interface_line_id = pda.group_line_id
1977: )
1978: WHERE pda.po_header_id = po_autocreate_params.g_po_header_id

Line 1978: WHERE pda.po_header_id = po_autocreate_params.g_po_header_id

1974: AND pld.po_header_id = po_autocreate_params.g_po_header_id
1975: AND pld.line_num = pli.line_num
1976: AND PLI.interface_line_id = pda.group_line_id
1977: )
1978: WHERE pda.po_header_id = po_autocreate_params.g_po_header_id
1979: AND pda.draft_id = po_autocreate_params.g_draft_id;
1980:
1981: IF g_debug_stmt
1982: THEN

Line 1979: AND pda.draft_id = po_autocreate_params.g_draft_id;

1975: AND pld.line_num = pli.line_num
1976: AND PLI.interface_line_id = pda.group_line_id
1977: )
1978: WHERE pda.po_header_id = po_autocreate_params.g_po_header_id
1979: AND pda.draft_id = po_autocreate_params.g_draft_id;
1980:
1981: IF g_debug_stmt
1982: THEN
1983: po_debug.debug_stmt

Line 1995: WHERE pda3.po_header_id = po_autocreate_params.g_po_header_id

1991: /*CLM Phase-2 : Autocreate Grouping*/
1992: -- If you have dist at both clin and slin level, move all dist to clin level.
1993: UPDATE po_distributions_draft_all pda3
1994: SET pda3.group_line_id = NULL
1995: WHERE pda3.po_header_id = po_autocreate_params.g_po_header_id
1996: AND pda3.draft_id = po_autocreate_params.g_draft_id
1997: AND pda3.po_line_id IN ( SELECT pda1.po_line_id
1998: FROM po_distributions_draft_all pda1
1999: WHERE pda1.po_header_id = po_autocreate_params.g_po_header_id

Line 1996: AND pda3.draft_id = po_autocreate_params.g_draft_id

1992: -- If you have dist at both clin and slin level, move all dist to clin level.
1993: UPDATE po_distributions_draft_all pda3
1994: SET pda3.group_line_id = NULL
1995: WHERE pda3.po_header_id = po_autocreate_params.g_po_header_id
1996: AND pda3.draft_id = po_autocreate_params.g_draft_id
1997: AND pda3.po_line_id IN ( SELECT pda1.po_line_id
1998: FROM po_distributions_draft_all pda1
1999: WHERE pda1.po_header_id = po_autocreate_params.g_po_header_id
2000: AND pda1.draft_id = po_autocreate_params.g_draft_id

Line 1999: WHERE pda1.po_header_id = po_autocreate_params.g_po_header_id

1995: WHERE pda3.po_header_id = po_autocreate_params.g_po_header_id
1996: AND pda3.draft_id = po_autocreate_params.g_draft_id
1997: AND pda3.po_line_id IN ( SELECT pda1.po_line_id
1998: FROM po_distributions_draft_all pda1
1999: WHERE pda1.po_header_id = po_autocreate_params.g_po_header_id
2000: AND pda1.draft_id = po_autocreate_params.g_draft_id
2001: AND pda1.group_line_id IS NULL
2002: AND EXISTS ( SELECT pda2.group_line_id
2003: FROM po_distributions_draft_all pda2

Line 2000: AND pda1.draft_id = po_autocreate_params.g_draft_id

1996: AND pda3.draft_id = po_autocreate_params.g_draft_id
1997: AND pda3.po_line_id IN ( SELECT pda1.po_line_id
1998: FROM po_distributions_draft_all pda1
1999: WHERE pda1.po_header_id = po_autocreate_params.g_po_header_id
2000: AND pda1.draft_id = po_autocreate_params.g_draft_id
2001: AND pda1.group_line_id IS NULL
2002: AND EXISTS ( SELECT pda2.group_line_id
2003: FROM po_distributions_draft_all pda2
2004: WHERE pda2.po_line_id = pda1.po_line_id

Line 2006: AND pda2.po_header_id = po_autocreate_params.g_po_header_id

2002: AND EXISTS ( SELECT pda2.group_line_id
2003: FROM po_distributions_draft_all pda2
2004: WHERE pda2.po_line_id = pda1.po_line_id
2005: AND pda2.group_line_id IS NOT NULL
2006: AND pda2.po_header_id = po_autocreate_params.g_po_header_id
2007: AND pda2.draft_id = po_autocreate_params.g_draft_id
2008: )
2009: );
2010:

Line 2007: AND pda2.draft_id = po_autocreate_params.g_draft_id

2003: FROM po_distributions_draft_all pda2
2004: WHERE pda2.po_line_id = pda1.po_line_id
2005: AND pda2.group_line_id IS NOT NULL
2006: AND pda2.po_header_id = po_autocreate_params.g_po_header_id
2007: AND pda2.draft_id = po_autocreate_params.g_draft_id
2008: )
2009: );
2010:
2011: /*CLM Phas-2 changes end*/

Line 2061: WHERE po_header_id = po_autocreate_params.g_po_header_id

2057: CURSOR c_clin
2058: IS
2059: SELECT po_line_id, line_num_display
2060: FROM po_lines_all
2061: WHERE po_header_id = po_autocreate_params.g_po_header_id
2062: AND group_line_id IS NULL
2063: ORDER BY line_num;
2064:
2065: CURSOR c_info_slin (p_group_line_id NUMBER)

Line 2069: WHERE po_header_id = po_autocreate_params.g_po_header_id

2065: CURSOR c_info_slin (p_group_line_id NUMBER)
2066: IS
2067: SELECT po_line_id, line_num_display
2068: FROM po_lines_all
2069: WHERE po_header_id = po_autocreate_params.g_po_header_id
2070: AND group_line_id = p_group_line_id
2071: AND NVL (clm_info_flag, 'N') = 'Y'
2072: ORDER BY line_num;
2073:

Line 2078: WHERE po_header_id = po_autocreate_params.g_po_header_id

2074: CURSOR c_priced_slin (p_group_line_id NUMBER)
2075: IS
2076: SELECT po_line_id, line_num_display
2077: FROM po_lines_all
2078: WHERE po_header_id = po_autocreate_params.g_po_header_id
2079: AND group_line_id = p_group_line_id
2080: AND NVL (clm_info_flag, 'N') = 'N'
2081: ORDER BY line_num;
2082:

Line 2087: WHERE PARENT.po_header_id = po_autocreate_params.g_po_header_id

2083: CURSOR c_mismatch
2084: IS
2085: SELECT PARENT.line_num_display, CHILD.po_line_id
2086: FROM po_lines_all PARENT, po_lines_all CHILD
2087: WHERE PARENT.po_header_id = po_autocreate_params.g_po_header_id
2088: AND PARENT.group_line_id IS NULL
2089: AND CHILD.po_header_id = po_autocreate_params.g_po_header_id
2090: AND CHILD.group_line_id IS NOT NULL
2091: AND PARENT.po_line_id = CHILD.group_line_id

Line 2089: AND CHILD.po_header_id = po_autocreate_params.g_po_header_id

2085: SELECT PARENT.line_num_display, CHILD.po_line_id
2086: FROM po_lines_all PARENT, po_lines_all CHILD
2087: WHERE PARENT.po_header_id = po_autocreate_params.g_po_header_id
2088: AND PARENT.group_line_id IS NULL
2089: AND CHILD.po_header_id = po_autocreate_params.g_po_header_id
2090: AND CHILD.group_line_id IS NOT NULL
2091: AND PARENT.po_line_id = CHILD.group_line_id
2092: AND PARENT.line_num_display <>
2093: SUBSTR (CHILD.line_num_display, 1, 4);

Line 2114: po_autocreate_params.x_interface_header_id;

2110: INTO x_document_num, x_document_type_code, x_document_subtype,
2111: x_group_code, x_mode
2112: FROM po_headers_interface phi
2113: WHERE phi.interface_header_id =
2114: po_autocreate_params.x_interface_header_id;
2115:
2116: IF (po_autocreate_params.g_group_code = 'REQUISITION')
2117: THEN
2118: IF (po_autocreate_params.g_mode = 'NEW')

Line 2116: IF (po_autocreate_params.g_group_code = 'REQUISITION')

2112: FROM po_headers_interface phi
2113: WHERE phi.interface_header_id =
2114: po_autocreate_params.x_interface_header_id;
2115:
2116: IF (po_autocreate_params.g_group_code = 'REQUISITION')
2117: THEN
2118: IF (po_autocreate_params.g_mode = 'NEW')
2119: THEN
2120: -- Create a new PO with Req. lines in

Line 2118: IF (po_autocreate_params.g_mode = 'NEW')

2114: po_autocreate_params.x_interface_header_id;
2115:
2116: IF (po_autocreate_params.g_group_code = 'REQUISITION')
2117: THEN
2118: IF (po_autocreate_params.g_mode = 'NEW')
2119: THEN
2120: -- Create a new PO with Req. lines in
2121: -- the same order as on the requisition.
2122: -- The interface table will hold the requisition line id

Line 2145: po_autocreate_params.x_interface_header_id

2141: po_lines_interface pli
2142: WHERE prl.requisition_line_id =
2143: pli.requisition_line_id
2144: AND pli.interface_header_id =
2145: po_autocreate_params.x_interface_header_id
2146: AND pli.line_num = pla.line_num)
2147: WHERE pla.po_header_id =
2148: po_autocreate_params.g_po_header_id
2149: AND pla.line_num_display IS NULL;

Line 2148: po_autocreate_params.g_po_header_id

2144: AND pli.interface_header_id =
2145: po_autocreate_params.x_interface_header_id
2146: AND pli.line_num = pla.line_num)
2147: WHERE pla.po_header_id =
2148: po_autocreate_params.g_po_header_id
2149: AND pla.line_num_display IS NULL;
2150: ELSE
2151: -- use sequential numbers
2152: l_progress := '040';

Line 2211: || po_autocreate_params.g_mode

2207: po_debug.debug_stmt
2208: (p_log_head => g_log_head || l_api_name,
2209: p_token => l_progress,
2210: p_message => 'set_line_num_display mode is :'
2211: || po_autocreate_params.g_mode
2212: );
2213: END IF;
2214:
2215: l_progress := '140';

Line 2223: (po_autocreate_params.g_po_header_id,

2219: IF clin_rec.line_num_display IS NULL
2220: THEN
2221: l_clin_num :=
2222: pon_clo_renumber_pkg.next_clin_num_wrapper
2223: (po_autocreate_params.g_po_header_id,
2224: 'PO'
2225: );
2226:
2227: UPDATE po_lines_all

Line 2281: (po_autocreate_params.g_po_header_id,

2277: IF clin_rec.line_num_display IS NULL
2278: THEN
2279: l_clin_num :=
2280: pon_clo_renumber_pkg.next_clin_num_wrapper
2281: (po_autocreate_params.g_po_header_id,
2282: 'PO'
2283: );
2284:
2285: UPDATE po_lines_all

Line 2374: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id

2370:
2371: SELECT pld.po_line_id
2372: FROM po_lines_draft_all pld, po_lines_interface PLI
2373: WHERE pld.uda_template_id IS NULL
2374: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
2375: AND PLD.po_header_id = po_autocreate_params.g_po_header_id
2376: AND pld. line_num =PLI.line_num
2377: AND pld.draft_id = po_autocreate_params.g_draft_id;
2378:

Line 2375: AND PLD.po_header_id = po_autocreate_params.g_po_header_id

2371: SELECT pld.po_line_id
2372: FROM po_lines_draft_all pld, po_lines_interface PLI
2373: WHERE pld.uda_template_id IS NULL
2374: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
2375: AND PLD.po_header_id = po_autocreate_params.g_po_header_id
2376: AND pld. line_num =PLI.line_num
2377: AND pld.draft_id = po_autocreate_params.g_draft_id;
2378:
2379:

Line 2377: AND pld.draft_id = po_autocreate_params.g_draft_id;

2373: WHERE pld.uda_template_id IS NULL
2374: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
2375: AND PLD.po_header_id = po_autocreate_params.g_po_header_id
2376: AND pld. line_num =PLI.line_num
2377: AND pld.draft_id = po_autocreate_params.g_draft_id;
2378:
2379:
2380: CURSOR c_shipments
2381: IS

Line 2386: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id

2382:
2383: SELECT pll.line_location_id
2384: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll
2385: WHERE pll.uda_template_id IS NULL
2386: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
2387: AND PLD.po_header_id = po_autocreate_params.g_po_header_id
2388: AND pld. line_num =PLI.line_num
2389: AND pld.draft_id = po_autocreate_params.g_draft_id
2390: AND pld.po_line_id = pll.po_line_id

Line 2387: AND PLD.po_header_id = po_autocreate_params.g_po_header_id

2383: SELECT pll.line_location_id
2384: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll
2385: WHERE pll.uda_template_id IS NULL
2386: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
2387: AND PLD.po_header_id = po_autocreate_params.g_po_header_id
2388: AND pld. line_num =PLI.line_num
2389: AND pld.draft_id = po_autocreate_params.g_draft_id
2390: AND pld.po_line_id = pll.po_line_id
2391: AND pll.shipment_num=PLI.shipment_num

Line 2389: AND pld.draft_id = po_autocreate_params.g_draft_id

2385: WHERE pll.uda_template_id IS NULL
2386: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
2387: AND PLD.po_header_id = po_autocreate_params.g_po_header_id
2388: AND pld. line_num =PLI.line_num
2389: AND pld.draft_id = po_autocreate_params.g_draft_id
2390: AND pld.po_line_id = pll.po_line_id
2391: AND pll.shipment_num=PLI.shipment_num
2392: AND pll.draft_id = po_autocreate_params.g_draft_id;
2393:

Line 2392: AND pll.draft_id = po_autocreate_params.g_draft_id;

2388: AND pld. line_num =PLI.line_num
2389: AND pld.draft_id = po_autocreate_params.g_draft_id
2390: AND pld.po_line_id = pll.po_line_id
2391: AND pll.shipment_num=PLI.shipment_num
2392: AND pll.draft_id = po_autocreate_params.g_draft_id;
2393:
2394: l_style_id NUMBER;
2395: l_template_id NUMBER;
2396:

Line 2411: WHERE interface_header_id = po_autocreate_params.g_interface_header_id;

2407: l_progress := '020';
2408: SELECT style_id
2409: INTO l_style_id
2410: FROM po_headers_interface
2411: WHERE interface_header_id = po_autocreate_params.g_interface_header_id;
2412:
2413: IF g_debug_stmt
2414: THEN
2415: po_debug.debug_stmt

Line 2428: AND document_type = po_autocreate_params.g_document_subtype

2424: SELECT DISTINCT document_level
2425: BULK COLLECT INTO x_doc_level_tbl
2426: FROM po_uda_ag_templates
2427: WHERE functional_area = l_functional_area
2428: AND document_type = po_autocreate_params.g_document_subtype
2429: AND document_style_id = l_style_id;
2430:
2431: IF g_debug_stmt
2432: THEN

Line 2446: p_document_type => po_autocreate_params.g_document_subtype,

2442: LOOP
2443:
2444: l_progress := '060';
2445: l_template_id := po_uda_data_util.get_template_id( p_functional_area => l_functional_area,
2446: p_document_type => po_autocreate_params.g_document_subtype,
2447: p_document_style_id => l_style_id,
2448: p_document_level => x_doc_level_tbl(i),
2449: p_input_date => SYSDATE,
2450: x_return_status => l_return_status,

Line 2478: IF po_autocreate_params.g_mode='NEW'

2474: FOR i IN 1..x_doc_level_tbl.Count
2475: LOOP
2476: IF x_doc_level_tbl(i) = 'HEADER'
2477: THEN
2478: IF po_autocreate_params.g_mode='NEW'
2479: OR (po_autocreate_params.g_mode='ADD'
2480: AND NOT po_autocreate_params.g_is_mod_exists)
2481: THEN
2482:

Line 2479: OR (po_autocreate_params.g_mode='ADD'

2475: LOOP
2476: IF x_doc_level_tbl(i) = 'HEADER'
2477: THEN
2478: IF po_autocreate_params.g_mode='NEW'
2479: OR (po_autocreate_params.g_mode='ADD'
2480: AND NOT po_autocreate_params.g_is_mod_exists)
2481: THEN
2482:
2483: l_progress := '080';

Line 2480: AND NOT po_autocreate_params.g_is_mod_exists)

2476: IF x_doc_level_tbl(i) = 'HEADER'
2477: THEN
2478: IF po_autocreate_params.g_mode='NEW'
2479: OR (po_autocreate_params.g_mode='ADD'
2480: AND NOT po_autocreate_params.g_is_mod_exists)
2481: THEN
2482:
2483: l_progress := '080';
2484:

Line 2491: WHERE po_header_id = po_autocreate_params.g_po_header_id

2487: null value, now stamping it with sysdate*/
2488: UPDATE po_headers_draft_all
2489: SET uda_template_id = l_header_uda_tmpl_id
2490: , uda_template_date = sysdate -- bug 10202181
2491: WHERE po_header_id = po_autocreate_params.g_po_header_id
2492: AND draft_id = po_autocreate_params.g_draft_id;
2493:
2494: END IF;
2495: ELSIF x_doc_level_tbl(i) = 'LINE' THEN

Line 2492: AND draft_id = po_autocreate_params.g_draft_id;

2488: UPDATE po_headers_draft_all
2489: SET uda_template_id = l_header_uda_tmpl_id
2490: , uda_template_date = sysdate -- bug 10202181
2491: WHERE po_header_id = po_autocreate_params.g_po_header_id
2492: AND draft_id = po_autocreate_params.g_draft_id;
2493:
2494: END IF;
2495: ELSIF x_doc_level_tbl(i) = 'LINE' THEN
2496: FOR l_line_rec IN c_lines

Line 2502: AND draft_id = po_autocreate_params.g_draft_id;

2498: l_progress := '100';
2499: UPDATE po_lines_draft_all
2500: SET uda_template_id = l_line_uda_tmpl_id
2501: WHERE po_line_id = l_line_rec.po_line_id
2502: AND draft_id = po_autocreate_params.g_draft_id;
2503: END LOOP;
2504:
2505: ELSIF x_doc_level_tbl(i) = 'SHIPMENT' THEN
2506: FOR l_ship_rec IN c_shipments

Line 2512: AND draft_id = po_autocreate_params.g_draft_id;

2508: l_progress := '120';
2509: UPDATE po_line_locations_draft_all
2510: SET uda_template_id = l_ship_uda_tmpl_id
2511: WHERE line_location_id = l_ship_rec.line_location_id
2512: AND draft_id = po_autocreate_params.g_draft_id;
2513: END LOOP;
2514: END IF;
2515: END LOOP;
2516:

Line 2871: ,po_autocreate_params.g_po_header_id --PO_HEADER_ID

2867: SELECT po_exhibit_details_s.NEXTVAL --PO_EXHIBIT_DETAILS_ID
2868: ,EXHIBIT_NUMBER --EXHIBIT_NAME
2869: ,EXHIBIT_DESCRIPTION --EXHIBIT_DESCRIPTION
2870: ,IS_CDRL --IS_CDRL
2871: ,po_autocreate_params.g_po_header_id --PO_HEADER_ID
2872: ,(SELECT po_line_id FROM po_lines_merge_v
2873: WHERE po_header_id = po_autocreate_params.g_po_header_id
2874: AND AUCTION_LINE_NUMBER = paed.associated_to_line
2875: AND draft_id = Nvl(po_autocreate_params.g_draft_id, -1)

Line 2873: WHERE po_header_id = po_autocreate_params.g_po_header_id

2869: ,EXHIBIT_DESCRIPTION --EXHIBIT_DESCRIPTION
2870: ,IS_CDRL --IS_CDRL
2871: ,po_autocreate_params.g_po_header_id --PO_HEADER_ID
2872: ,(SELECT po_line_id FROM po_lines_merge_v
2873: WHERE po_header_id = po_autocreate_params.g_po_header_id
2874: AND AUCTION_LINE_NUMBER = paed.associated_to_line
2875: AND draft_id = Nvl(po_autocreate_params.g_draft_id, -1)
2876: )
2877: ,SYSDATE --LAST_UPDATE_DATE

Line 2875: AND draft_id = Nvl(po_autocreate_params.g_draft_id, -1)

2871: ,po_autocreate_params.g_po_header_id --PO_HEADER_ID
2872: ,(SELECT po_line_id FROM po_lines_merge_v
2873: WHERE po_header_id = po_autocreate_params.g_po_header_id
2874: AND AUCTION_LINE_NUMBER = paed.associated_to_line
2875: AND draft_id = Nvl(po_autocreate_params.g_draft_id, -1)
2876: )
2877: ,SYSDATE --LAST_UPDATE_DATE
2878: ,FND_GLOBAL.user_id --LAST_UPDATED_BY
2879: ,SYSDATE --CREATION_DATE

Line 2886: WHERE pol.po_header_id = po_autocreate_params.g_po_header_id

2882: FROM PON_AUCTION_EXHIBIT_DETAILS paed
2883: WHERE (paed.auction_header_id, paed.associated_to_line)
2884: IN (
2885: SELECT auction_header_id,auction_line_number FROM po_lines_merge_v pol
2886: WHERE pol.po_header_id = po_autocreate_params.g_po_header_id
2887: AND pol.draft_id = Nvl(po_autocreate_params.g_draft_id, -1)
2888: )
2889: ;
2890:

Line 2887: AND pol.draft_id = Nvl(po_autocreate_params.g_draft_id, -1)

2883: WHERE (paed.auction_header_id, paed.associated_to_line)
2884: IN (
2885: SELECT auction_header_id,auction_line_number FROM po_lines_merge_v pol
2886: WHERE pol.po_header_id = po_autocreate_params.g_po_header_id
2887: AND pol.draft_id = Nvl(po_autocreate_params.g_draft_id, -1)
2888: )
2889: ;
2890:
2891: l_progress := '020';

Line 2906: WHERE po_header_id = po_autocreate_params.g_po_header_id

2902: -- Delete the deliverables whose referenced lines are not awarded.
2903: SELECT exhibit_name
2904: BULK COLLECT INTO l_exhibit_tbl
2905: FROM po_exhibit_details
2906: WHERE po_header_id = po_autocreate_params.g_po_header_id
2907: AND is_cdrl = 'Y';
2908:
2909: IF(l_exhibit_tbl IS NOT NULL) THEN
2910:

Line 2916: p_doc_id => po_autocreate_params.g_po_header_id,

2912: p_api_version => 1.0,
2913: p_init_msg_list => FND_API.G_TRUE,
2914: p_commit => FND_API.G_FALSE,
2915: p_doc_type => p_contract_doc_type,
2916: p_doc_id => po_autocreate_params.g_po_header_id,
2917: p_doc_version => NULL,
2918: p_mode => NULL,
2919: p_exhibit_tbl => l_exhibit_tbl,
2920: x_msg_data => l_msg_data,