[Home] [Help]
804: IF (l_type_lookup_code = 'QUOTATION') THEN
805: x_draft_info.doc_type := 'QUOTATION';
806: x_draft_info.doc_subtype := l_quote_type_lookup_code;
807: ELSE
808: IF (l_type_lookup_code = 'STANDARD') THEN
809: x_draft_info.doc_type := 'PO';
810: ELSIF (l_type_lookup_code IN ('BLANKET', 'CONTRACT')) THEN
811: x_draft_info.doc_type := 'PA';
812: END IF;
1449: -- then user should see the error as the "Document is locked by other Role"
1450: -- if the lock owner is Cat.Admin/Supplier and Buyer is the current role,
1451: -- the user should get a warning and he can break the lock and continue
1452: -- If the Upload failure is due to PDOI Error, then also the USer will see the
1453: -- Standard Upload Error, In View Upload Errors, he/she will be able to see the exact error message.
1454: ELSIF (l_draft_status = g_status_PDOI_ERROR
1455: AND l_calling_module <> g_call_mod_PDOI) THEN
1456:
1457: if(l_current_lock_owner_role = p_role OR l_current_lock_owner_role IS NULL) THEN
3444: -- apply_changes proc of PO_XX_DRAFT_PVT above has a call to update_req_for_linked_po_count, where
3445: -- the linked_po_count is updated for unlinked requisitions and those reqs CLINs(Autocreated/SoftLinked)
3446: -- and PSlins(Softlinked) inserted into GT table for further procession(updating the reqs_in_pool_flag for entire
3447: -- Clin-Slin structure if eligible) in the below proc update_reqs_in_pool_flag.
3448: -- This should be called only for CLM Standard document.
3449:
3450: IF (p_draft_info.doc_subtype = 'STANDARD' AND l_is_clm_document = 'Y') THEN
3451: PO_REQ_LINES_SV.update_reqs_in_pool_flag;
3452: END IF;
3446: -- and PSlins(Softlinked) inserted into GT table for further procession(updating the reqs_in_pool_flag for entire
3447: -- Clin-Slin structure if eligible) in the below proc update_reqs_in_pool_flag.
3448: -- This should be called only for CLM Standard document.
3449:
3450: IF (p_draft_info.doc_subtype = 'STANDARD' AND l_is_clm_document = 'Y') THEN
3451: PO_REQ_LINES_SV.update_reqs_in_pool_flag;
3452: END IF;
3453:
3454: d_position := 100;
8960: WHERE phm.po_header_id = phe.po_header_id
8961: AND phm.draft_id = Nvl(phe.draft_id,-1)
8962: AND ptu.attribute_category = 'FORMS'
8963: AND ptu.template_id = phm.uda_template_id
8964: AND Nvl(ptu.attribute1, '*') <> Nvl(phm.clm_standard_form, '*')
8965: AND phe.attr_group_id = ptu.attribute_group_id
8966: );
8967: IF (PO_LOG.d_stmt) THEN
8968: PO_LOG.stmt(d_module,d_position ,'Deleted extra forms uda records from po_headers_all_ext_b');
8980: WHERE phm.po_header_id = phe.po_header_id
8981: AND phm.draft_id = Nvl(phe.draft_id,-1)
8982: AND ptu.attribute_category = 'FORMS'
8983: AND ptu.template_id = phm.uda_template_id
8984: AND Nvl(ptu.attribute1, '*') <> Nvl(phm.clm_standard_form, '*')
8985: AND phe.attr_group_id = ptu.attribute_group_id
8986: );
8987: IF (PO_LOG.d_stmt) THEN
8988: PO_LOG.stmt(d_module,d_position ,'Deleted extra forms uda records from po_headers_all_ext_tl');