APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_LINES_ALL

Line 2797: FROM po_lines_all PLA

2793: AND PLD.item_id IS NOT NULL
2794: AND PLD.order_type_lookup_code = 'QUANTITY'
2795: AND NOT EXISTS
2796: (SELECT 1
2797: FROM po_lines_all PLA
2798: WHERE PLD.po_line_id = PLA.po_line_id);
2799:
2800: IF (PO_LOG.d_proc) THEN
2801: PO_LOG.proc_end(d_module);

Line 4224: --Update the templated id in po_lines_all

4220: );
4221: IF (PO_LOG.d_stmt) THEN
4222: PO_LOG.stmt(d_module, d_position,'l_line_template_id was null in postproc: ' || l_line_template_id);
4223: END IF;
4224: --Update the templated id in po_lines_all
4225: UPDATE po_lines_draft_all SET
4226: uda_template_id = l_line_template_id
4227: WHERE po_header_id = p_po_header_id
4228: AND Nvl(draft_id,-1) = p_draft_id;

Line 4326: FROM po_lines_all

4322: d_position NUMBER;
4323: CURSOR c_clin
4324: IS
4325: SELECT po_line_id, line_num_display
4326: FROM po_lines_all
4327: WHERE po_header_id = p_po_header_id
4328: AND group_line_id IS NULL
4329: ORDER BY line_num;
4330:

Line 4334: FROM po_lines_all

4330:
4331: CURSOR c_info_slin (p_group_line_id NUMBER)
4332: IS
4333: SELECT po_line_id, line_num_display
4334: FROM po_lines_all
4335: WHERE po_header_id = p_po_header_id
4336: AND group_line_id = p_group_line_id
4337: AND NVL (clm_info_flag, 'N') = 'Y'
4338: ORDER BY line_num;

Line 4343: FROM po_lines_all

4339:
4340: CURSOR c_priced_slin (p_group_line_id NUMBER)
4341: IS
4342: SELECT po_line_id, line_num_display
4343: FROM po_lines_all
4344: WHERE po_header_id = p_po_header_id
4345: AND group_line_id = p_group_line_id
4346: AND NVL (clm_info_flag, 'N') = 'N'
4347: ORDER BY line_num;

Line 4362: FROM po_lines_all

4358:
4359: --Fetch the max clin line num display
4360: SELECT Nvl(Max(line_num_display),'0000')
4361: INTO l_clin_num
4362: FROM po_lines_all
4363: WHERE po_header_id = p_po_header_id
4364: AND group_line_id IS NULL;
4365:
4366: --Increment the max line num display for clin & generate

Line 4378: UPDATE po_lines_all

4374: d_position := 0;
4375: IF clin_rec.line_num_display IS NULL
4376: THEN
4377: --Update the line_num_display for clin
4378: UPDATE po_lines_all
4379: SET line_num_display = l_new_clin_num
4380: WHERE po_line_id = clin_rec.po_line_id
4381: AND line_num_display IS NULL;
4382:

Line 4397: UPDATE po_lines_all

4393: LOOP
4394:
4395: d_position := 20;
4396: --Update the line_num_display for info_slin
4397: UPDATE po_lines_all
4398: SET line_num_display = l_info_slin_num
4399: WHERE po_line_id = info_slin_rec.po_line_id;
4400:
4401: l_info_slin_num :=

Line 4412: UPDATE po_lines_all

4408: --loop through the priced_slin for the clin
4409: FOR priced_slin_rec IN c_priced_slin (clin_rec.po_line_id)
4410: LOOP
4411: --Update the line_num_display for priced_slin
4412: UPDATE po_lines_all
4413: SET line_num_display = l_priced_slin_num
4414: WHERE po_line_id = priced_slin_rec.po_line_id;
4415:
4416: d_position := 40;

Line 4473: FROM po_lines_all

4469: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4470:
4471: SELECT po_line_id
4472: BULK COLLECT INTO l_po_line_id_tbl
4473: FROM po_lines_all
4474: WHERE po_header_id = p_po_header_id
4475: AND order_type_lookup_code = 'AMOUNT';
4476:
4477: FOR i IN 1..l_po_line_id_tbl.Count

Line 4486: FROM po_lines_all pol,

4482: FROM dual
4483: WHERE EXISTS (
4484: SELECT 1
4485:
4486: FROM po_lines_all pol,
4487: po_lines_all_ext_b ple,
4488: po_uda_ag_template_usages ptu
4489: WHERE pol.po_line_id = l_po_line_id_tbl(i)
4490: AND ple.po_line_id = pol.po_line_id

Line 4487: po_lines_all_ext_b ple,

4483: WHERE EXISTS (
4484: SELECT 1
4485:
4486: FROM po_lines_all pol,
4487: po_lines_all_ext_b ple,
4488: po_uda_ag_template_usages ptu
4489: WHERE pol.po_line_id = l_po_line_id_tbl(i)
4490: AND ple.po_line_id = pol.po_line_id
4491: --AND ple.draft_id = p_draft_id