[Home] [Help]
157: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
158: l_enc_enabled VARCHAR2(1);
159: l_org_id NUMBER;
160:
161: -- bug13114217, added join with AP_INVOICES_ALL
162: -- changed the join conditions for XTE to pick up
163: -- index XLA_TRANSACTION_ENTITIES_N1
164: --
165: CURSOR c_get_unprocessed_events IS
165: CURSOR c_get_unprocessed_events IS
166: SELECT xla.event_id
167: FROM xla_events xla,
168: xla_transaction_entities xte,
169: ap_invoices_all ai
170: WHERE NVL(xla.budgetary_control_flag, 'N') ='Y'
171: AND xla.application_id = 200
172: AND xte.application_id = 200
173: AND xla.event_status_code <> 'P'
191: l_curr_calling_sequence := 'AP_FUNDS_CONTROL_PKG.'||'<-'||p_calling_sequence;
192:
193: SELECT org_id
194: INTO l_org_id
195: FROM ap_invoices_all
196: where invoice_id=p_invoice_id;
197:
198: SELECT nvl(purch_encumbrance_flag,'N')
199: INTO l_enc_enabled
820: AND NOT EXISTS ( select 'Advance Exists'
821: from po_distributions_all pod,
822: po_headers_all poh,
823: ap_invoice_distributions_all ainvd,
824: ap_invoices_all ainv,
825: po_doc_style_headers pdsa
826: where pod.po_distribution_id = D.po_distribution_id
827: and poh.po_header_id = pod.po_header_id
828: and poh.style_id = pdsa.style_id
918: AND NOT EXISTS ( select 'Advance Exists'
919: from po_distributions_all pod,
920: po_headers_all poh,
921: ap_invoice_distributions_all ainvd,
922: ap_invoices_all ainv,
923: po_doc_style_headers pdsa
924: where pod.po_distribution_id = T.po_distribution_id
925: and poh.po_header_id = pod.po_header_id
926: and poh.style_id = pdsa.style_id
1002: END IF;
1003:
1004: SELECT org_id
1005: INTO l_org_id
1006: FROM AP_INVOICES_ALL
1007: WHERE invoice_id = p_invoice_id;
1008:
1009: IF (Encumbrance_Enabled(l_org_id)) THEN
1010:
2671: NULL, --result_code
2672: NULL, --status_code
2673: 'N' self_assessed_flag --self_assessed_flag --bug7109594
2674: FROM ap_invoice_distributions_all aid,
2675: ap_invoices_all ai,
2676: ap_invoice_lines_all ail,
2677: gl_period_statuses per
2678: WHERE ai.invoice_id = p_invoice_id
2679: AND aid.invoice_id = ai.invoice_id
2709: NULL, -- result_code
2710: NULL, -- status_code
2711: 'N' self_assessed_flag -- self_assessed_flag --bug7109594
2712: FROM ap_invoice_distributions_all aid,
2713: ap_invoices_all ai,
2714: ap_invoice_lines_all ail,
2715: gl_period_statuses per,
2716: po_distributions_all pod
2717: WHERE ai.invoice_id = p_invoice_id
2741: AND NOT EXISTS ( select 'Advance Exists'
2742: from po_distributions_all pod,
2743: po_headers_all poh,
2744: ap_invoice_distributions_all ainvd,
2745: ap_invoices_all ainv,
2746: po_doc_style_headers pdsa
2747: where pod.po_distribution_id = aid.po_distribution_id
2748: and poh.po_header_id = pod.po_header_id
2749: and poh.style_id = pdsa.style_id
2770: NULL, --result_code
2771: NULL, --status_code
2772: T.self_assessed_flag --self_assessed_flag --bug7109594
2773: FROM ap_self_assessed_tax_dist_all t,
2774: ap_invoices_all ai,
2775: gl_period_statuses per
2776: WHERE ai.invoice_id = p_invoice_id
2777: AND t.invoice_id = ai.invoice_id
2778: AND (p_inv_line_num IS NULL OR
2804: NULL, -- result_code
2805: NULL, -- status_code
2806: T.self_assessed_flag -- self_assessed_flag --bug7109594
2807: FROM ap_self_assessed_tax_dist_all t,
2808: ap_invoices_all ai,
2809: gl_period_statuses per
2810: WHERE ai.invoice_id = p_invoice_id
2811: AND t.invoice_id = ai.invoice_id
2812: AND (p_inv_line_num IS NULL OR
2825: AND NOT EXISTS ( select 'Advance Exists'
2826: from po_distributions_all pod,
2827: po_headers_all poh,
2828: ap_invoice_distributions_all ainvd,
2829: ap_invoices_all ainv,
2830: po_doc_style_headers pdsa
2831: where pod.po_distribution_id = t.po_distribution_id
2832: and poh.po_header_id = pod.po_header_id
2833: and poh.style_id = pdsa.style_id
2895: END IF;
2896:
2897: SELECT org_id
2898: INTO l_org_id
2899: FROM AP_INVOICES_ALL
2900: WHERE invoice_id = p_invoice_id;
2901:
2902:
2903: /*-----------------------------------------------------------------+