[Home] [Help]
711: l_is_first_slin := 'N';
712: l_slin_count := To_Number(l_slin_num_display);
713: ELSE
714: l_progress :='065';
715: SELECT LPad(l_slin_count + 1,6,'0') INTO l_slin_num_display FROM dual;
716: l_slin_count := l_slin_count + 1;
717: END IF;
718:
719: IF g_debug_stmt THEN
2497: OR PO_AUTOCREATE_PARAMS.g_document_subtype='PLANNED'
2498: OR PO_AUTOCREATE_PARAMS.g_document_subtype='BLANKET' ) THEN
2499: l_progress :='290';
2500:
2501: SELECT po_lines_s.nextval INTO x_po_line_id FROM sys.dual;
2502:
2503: l_progress:='300';
2504: -- Call the Pricing API only when...
2505: --
2722: l_negotiated_by_preparer_flag:=NULL;
2723: END;
2724:
2725: --
2726: -- IF secondary quantity is null and item is dual uom control , default the secondary qty.
2727: IF ( PO_AUTOCREATE_PARAMS.g_document_subtype ='STANDARD'
2728: OR PO_AUTOCREATE_PARAMS.g_document_subtype='PLANNED'
2729: OR PO_AUTOCREATE_PARAMS.g_document_type = 'PA') THEN
2730: l_progress := '410';
2864: p_lines.oke_contract_version_id_tbl(i) ,
2865: p_lines.quantity_committed_tbl(i) ,
2866: p_lines.committed_amount_tbl(i) ,
2867: p_lines.price_break_lookup_code_tbl(i)
2868: FROM dual;
2869:
2870: IF g_debug_stmt THEN
2871: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2872: p_token => l_progress, p_message => 'Before Insert into Lines Draft '
3314: -- because x_po_line_id is the blanket line_id for 'Release'
3315: -- Introducing the 'If' statement for checking that its not a release
3316: IF (PO_AUTOCREATE_PARAMS.g_document_subtype <> 'RELEASE') THEN
3317:
3318: /** If FSP org and item combination is dual uom control, update the po lines secondary quantity
3319: with the default conversion based on the PO lines quantity **/
3320:
3321: --
3322: