APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on PO_LINES

Line 2325: --* : po_lines SELECT *--

2321: --* : fv_utility.debug_mesg *--
2322: --* : fv_utility.log_mesg *--
2323: --* Tables Used : po_headers SELECT *--
2324: --* : po_distributions SELECT *--
2325: --* : po_lines SELECT *--
2326: --* : ap_invoice_distributions SELECT *--
2327: --* : ap_recurring_payments_v SELECT *--
2328: --* Logic : *--
2329: --****************************************************************************************--

Line 2341: l_line_closed_code po_lines.closed_code%TYPE;

2337: IS
2338: l_module_name VARCHAR2(200);
2339: l_location VARCHAR2(200);
2340: l_hdr_closed_code po_headers.closed_code%TYPE;
2341: l_line_closed_code po_lines.closed_code%TYPE;
2342: l_count_po_disb_lines NUMBER;
2343: l_count_matched_disb_lines NUMBER;
2344: l_exists NUMBER;
2345: l_validation_code fv_ipac_import_errors.error_code%TYPE;

Line 2432: po_lines pl

2428:
2429: SELECT COUNT(*)
2430: INTO l_count_po_disb_lines
2431: FROM po_distributions pd,
2432: po_lines pl
2433: WHERE pd.po_header_id = p_ap_inv_lines_rec.po_header_id
2434: AND pl.po_line_id = pd.po_line_id
2435: AND pd.set_of_books_id = g_set_of_books_id;
2436:

Line 2463: po_lines pl

2459: SELECT COUNT(*)
2460: INTO l_count_matched_disb_lines
2461: FROM ap_invoice_distributions aid ,
2462: po_distributions pd ,
2463: po_lines pl
2464: WHERE aid.po_distribution_id = pd.po_distribution_id
2465: AND pd.po_header_id = p_ap_inv_lines_rec.po_header_id
2466: AND pl.po_line_id = pd.po_line_id
2467: AND aid.final_match_flag = 'D'

Line 2524: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_lines');

2520: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_line_number='||p_ap_inv_lines_rec.po_line_number);
2521: END IF;
2522: BEGIN
2523: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2524: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_lines');
2525: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_header_id = '||p_ap_inv_lines_rec.po_header_id);
2526: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'line_num = '||p_ap_inv_lines_rec.po_line_number);
2527: END IF;
2528:

Line 2535: FROM po_lines pl

2531: pl.unit_meas_lookup_code
2532: INTO p_ap_inv_lines_rec.po_line_id,
2533: l_line_closed_code,
2534: p_ap_inv_lines_rec.po_unit_of_measure
2535: FROM po_lines pl
2536: WHERE po_header_id = p_ap_inv_lines_rec.po_header_id
2537: AND line_num = NVL(p_ap_inv_lines_rec.po_line_number, 1);
2538:
2539: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 2540: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_lines');

2536: WHERE po_header_id = p_ap_inv_lines_rec.po_header_id
2537: AND line_num = NVL(p_ap_inv_lines_rec.po_line_number, 1);
2538:
2539: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2540: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_lines');
2541: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_line_id = '||p_ap_inv_lines_rec.po_line_id);
2542: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'closed_code = '||l_line_closed_code);
2543: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'unit_meas_lookup_code = '||p_ap_inv_lines_rec.po_unit_of_measure);
2544: END IF;

Line 2563: l_location := l_module_name||'.select_po_lines';

2559: END IF;
2560: WHEN OTHERS THEN
2561: p_error_code := g_FAILURE;
2562: p_error_desc := SQLERRM;
2563: l_location := l_module_name||'.select_po_lines';
2564: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2565: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2566: END;
2567: END IF;