[Home] [Help]
1139: v_progress := '001';
1140:
1141: SELECT icx_po_history_details_s.nextval
1142: INTO p_sequence_num
1143: FROM DUAL;
1144:
1145: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1146: l_log_msg := v_progress||' : Getting sequence number: '||p_sequence_num;
1147: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
2300:
2301: x_revision_num := 1;
2302: END;
2303:
2304: SELECT LPad(x_revision_num ,3,'0') INTO l_val FROM dual;
2305:
2306: x_segment1 := p_req_number||'-'||l_val;
2307:
2308: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2452: END IF;
2453:
2454: SELECT po_req_distributions_s.NEXTVAL
2455: INTO x_new_dist_id
2456: FROM dual;
2457:
2458: INSERT INTO po_req_distributions_all
2459: (distribution_id,
2460: last_update_date,
2868: END IF;
2869:
2870: SELECT po_requisition_lines_s.NEXTVAL
2871: INTO x_new_line_id
2872: FROM dual;
2873:
2874: INSERT INTO po_requisition_lines_all
2875: (requisition_line_id,
2876: requisition_header_id,
3879: x_return_msg := NULL;
3880:
3881: SELECT po_requisition_headers_s.NEXTVAL
3882: INTO x_to_req_header_id
3883: FROM dual;
3884:
3885: v_progress := '001';
3886: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3887: l_log_msg := v_progress||' : x_to_req_header_id: ' ||x_to_req_header_id;
4168: EXIT WHEN line_cursor%NOTFOUND;
4169:
4170: SELECT po_requisition_lines_s.NEXTVAL
4171: INTO to_req_line_id
4172: FROM dual;
4173:
4174:
4175: INSERT INTO po_requisition_lines_all (
4176: requisition_line_id,
6741:
6742: IF p_sequence_num = 0 THEN
6743: SELECT icx_po_history_details_s.nextval
6744: INTO p_sequence_num
6745: FROM DUAL;
6746: END IF;
6747:
6748: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
6749: l_log_msg := v_progress||' : Getting sequence number: '||p_sequence_num;