APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_ONLINE_REPORT_TEXT

Line 2635: x_text_line po_online_report_text.text_line%TYPE; --Bug9040655

2631: x_msg_count number;
2632: l_doc_org_id number;
2633: -- Bug 3318625
2634: l_consigned_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
2635: x_text_line po_online_report_text.text_line%TYPE; --Bug9040655
2636: max_sequence_num po_online_report_text.sequence%TYPE; --Bug9040655
2637: begin
2638:
2639: l_module := g_log_head||l_api_name||'.'||'000'||'.';

Line 2636: max_sequence_num po_online_report_text.sequence%TYPE; --Bug9040655

2632: l_doc_org_id number;
2633: -- Bug 3318625
2634: l_consigned_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
2635: x_text_line po_online_report_text.text_line%TYPE; --Bug9040655
2636: max_sequence_num po_online_report_text.sequence%TYPE; --Bug9040655
2637: begin
2638:
2639: l_module := g_log_head||l_api_name||'.'||'000'||'.';
2640: /* Bug 2707350.

Line 2715: FROM po_online_report_text_gt

2711: ||TO_CHAR(g_po_header_id_table(i)));
2712: PO_DEBUG.put_line('Reason(s) :');
2713: SELECT MAX(sequence)
2714: INTO max_sequence_num
2715: FROM po_online_report_text_gt
2716: WHERE online_report_id = x_online_report_id ;
2717:
2718: FOR i IN 1..max_sequence_num
2719: LOOP

Line 2722: FROM po_online_report_text_gt

2718: FOR i IN 1..max_sequence_num
2719: LOOP
2720: SELECT text_line
2721: INTO x_text_line
2722: FROM po_online_report_text_gt
2723: WHERE online_report_id = x_online_report_id
2724: AND sequence = i;
2725:
2726: PO_DEBUG.put_line(x_text_line);

Line 2790: x_text_line po_online_report_text.text_line%TYPE; --Bug9040655

2786: x_msg_data varchar2(2000);
2787: x_online_report_id number;
2788: -- Bug 3318625
2789: l_consigned_flag PO_RELEASES_ALL.consigned_consumption_flag%TYPE;
2790: x_text_line po_online_report_text.text_line%TYPE; --Bug9040655
2791: max_sequence_num po_online_report_text.sequence%TYPE; --Bug9040655
2792: begin
2793:
2794: /* Get po_header_id for the documents that are in the Approved STate.

Line 2791: max_sequence_num po_online_report_text.sequence%TYPE; --Bug9040655

2787: x_online_report_id number;
2788: -- Bug 3318625
2789: l_consigned_flag PO_RELEASES_ALL.consigned_consumption_flag%TYPE;
2790: x_text_line po_online_report_text.text_line%TYPE; --Bug9040655
2791: max_sequence_num po_online_report_text.sequence%TYPE; --Bug9040655
2792: begin
2793:
2794: /* Get po_header_id for the documents that are in the Approved STate.
2795: * Call submission checks and initiate approval.

Line 2862: FROM po_online_report_text_gt

2858: ||TO_CHAR(g_po_release_id_table(i)));
2859: PO_DEBUG.put_line('Reason(s) :');
2860: SELECT MAX(sequence)
2861: INTO max_sequence_num
2862: FROM po_online_report_text_gt
2863: WHERE online_report_id = x_online_report_id ;
2864:
2865: FOR i IN 1..max_sequence_num
2866: LOOP

Line 2869: FROM po_online_report_text_gt

2865: FOR i IN 1..max_sequence_num
2866: LOOP
2867: SELECT text_line
2868: INTO x_text_line
2869: FROM po_online_report_text_gt
2870: WHERE online_report_id = x_online_report_id
2871: AND sequence = i;
2872:
2873: PO_DEBUG.put_line(x_text_line);