[Home] [Help]
1392: -- Sunset Memo Project : Skip SGD generation, if Mod is of Special Draft type
1393: IF ( (PO_CLM_INTG_GRP.is_clm_document(p_doc_type => p_document_type,
1394: p_document_id => l_document_id)='Y' )
1395: AND (l_draft_type = 'MOD') -- Change Desc only for Mod.
1396: AND ( l_draft_sub_type IS NULL OR PO_CORE_S3.get_bypass_sgd_generation_flag(l_draft_sub_type) <> 'Y') ) THEN
1397:
1398: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'SGD validation starts');
1399:
1400: SELECT Nvl(Max(SEQUENCE), 0) + 1
25103: 'E'
25104: FROM (SELECT lines.line_num,
25105: pll.shipment_num,
25106: pda.distribution_num,
25107: po_core_s3.Get_fiscal_year(
25108: (SELECT Min(pll.clm_period_perf_start_date)
25109: FROM po_line_locations_gt poll
25110: WHERE poll.po_line_id = pll.po_line_id
25111: AND poll.po_header_id = pll.po_header_id),
25109: FROM po_line_locations_gt poll
25110: WHERE poll.po_line_id = pll.po_line_id
25111: AND poll.po_header_id = pll.po_header_id),
25112: pda.set_of_books_id) Min_start_date_fiscal_year,
25113: po_core_s3.Get_fiscal_year(pll.clm_period_perf_end_date,
25114: pda.set_of_books_id) end_date_fiscal_year
25115: FROM po_distributions_gt pda,
25116: po_line_locations_gt pll,
25117: (SELECT pol.po_line_id,
25136: AND pll.po_line_id = lines.po_line_id
25137: AND pda.line_location_id = pll.line_location_id
25138: AND pda.po_line_id = pll.po_line_id
25139: AND pda.po_header_id = pll.po_header_id
25140: AND po_core_s3.Is_non_annual_fund(pda.code_combination_id, pda.set_of_books_id) = 'Y'
25141: AND pda.code_combination_id IS NOT NULL)
25142: WHERE min_start_date_fiscal_year <> end_date_fiscal_year ;
25143:
25144: p_sequence := p_sequence + SQL%ROWCOUNT;