[Home] [Help]
4288: p_batch_id NUMBER,
4289: x_return_status IN OUT NOCOPY VARCHAR2
4290: ) AS
4291:
4292: l_document_type pon_auc_doctypes.internal_name%TYPE;
4293:
4294: BEGIN
4295:
4296: SELECT internal_name INTO l_document_type
4293:
4294: BEGIN
4295:
4296: SELECT internal_name INTO l_document_type
4297: FROM pon_auc_doctypes
4298: WHERE doctype_id = neg_header_record_data.doctype_id;
4299:
4300:
4301: INSERT INTO PON_AUCTION_HEADERS_ALL (
4960: SELECT doctype_id, org_id, style_id, po_style_name, trading_partner_contact_name
4961: INTO l_doctype_id, l_org_id, l_style_id, l_po_style_name, l_tpc_name
4962: FROM pon_auction_headers_Interface WHERE batch_id = p_batch_id;
4963:
4964: SELECT DOCTYPE_ID INTO rfi_doctype_id FROM pon_auc_doctypes WHERE INTERNAL_NAME='REQUEST_FOR_INFORMATION';
4965:
4966: BEGIN
4967: SELECT user_id INTO l_tpc_id
4968: FROM fnd_user
5057:
5058: print_Log('header_initial_validation : batch_id validated ');
5059:
5060: begin
5061: SELECT doctype_group_name INTO dummy1 FROM pon_auc_doctypes WHERE doctype_id = l_doctype_id;
5062: EXCEPTION
5063: WHEN OTHERS THEN
5064: INSERT INTO PON_INTERFACE_ERRORS
5065: (
5380:
5381: null_check_status VARCHAR2(1);
5382: invalid_val_exist_flag VARCHAR2(1);
5383:
5384: doctype_name pon_auc_doctypes.doctype_group_name%TYPE;
5385:
5386: l_cp_user_id NUMBER;
5387: l_cp_login_id NUMBER;
5388:
5487:
5488: print_Log('validate_header: columns are successfully validated for allowed values' );
5489:
5490:
5491: SELECT doctype_group_name INTO doctype_name FROM pon_auc_doctypes WHERE doctype_id = neg_header_record_data.doctype_id;
5492:
5493: isFederal := PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id);
5494:
5495: INSERT ALL
6283: p_src_auction_header_id IN NUMBER)
6284: AS
6285:
6286: l_org_default_data org_default_data;
6287: l_document_type pon_auc_doctypes.internal_name%TYPE;
6288:
6289: -- po doc style related fields
6290: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6291: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6602: WHERE batch_id = p_batch_id;
6603:
6604: SELECT internal_name, transaction_type
6605: INTO l_document_type, neg_header_record_data.auction_type
6606: FROM pon_auc_doctypes
6607: WHERE doctype_id = neg_header_record_data.doctype_id;
6608:
6609: IF ( p_is_amendment = 'Y' ) THEN
6610: SELECT org_id, doctype_id, style_id, po_style_Id, contract_type
6646: p_src_auction_Header_id IN NUMBER) AS
6647:
6648: --organization based default data
6649: l_org_default_data org_default_data;
6650: l_document_type pon_auc_doctypes.internal_name%TYPE;
6651: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
6652: -- po doc style related fields
6653: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6654: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6669: print_log('init_rule_based_header_data begin ');
6670:
6671: SELECT internal_name, transaction_type
6672: INTO l_document_type, neg_header_record_data.auction_type
6673: FROM pon_auc_doctypes
6674: WHERE doctype_id = neg_header_record_data.doctype_id;
6675:
6676: SELECT DOCTYPE_ID INTO rfi_doctype_id FROM pon_auc_doctypes WHERE INTERNAL_NAME='REQUEST_FOR_INFORMATION';
6677:
6672: INTO l_document_type, neg_header_record_data.auction_type
6673: FROM pon_auc_doctypes
6674: WHERE doctype_id = neg_header_record_data.doctype_id;
6675:
6676: SELECT DOCTYPE_ID INTO rfi_doctype_id FROM pon_auc_doctypes WHERE INTERNAL_NAME='REQUEST_FOR_INFORMATION';
6677:
6678: BEGIN
6679: IF (p_is_amendment <> 'Y' AND rfi_doctype_id<>neg_header_record_data.doctype_id) THEN
6680:
6739: , gl_sets_of_books sob
6740: , hr_locations_all_tl bill_to
6741: , hr_locations_all_tl ship_to
6742: , ( SELECT po.org_id, po.security_level_code, pon.doctype_id
6743: FROM po_document_types_all po, pon_auc_doctypes pon
6744: WHERE po.document_type_code = pon.document_type_code
6745: AND po.document_subtype = pon.document_subtype
6746: AND po.security_level_code is not null
6747: ) posl