[Home] [Help]
PACKAGE BODY: APPS.AP_APXINRIR_XMLP_PKG
Source
1 PACKAGE BODY AP_APXINRIR_XMLP_PKG AS
2 /* $Header: APXINRIRB.pls 120.0 2007/12/27 07:59:45 vjaganat noship $ */
3
4 function BeforeReport return boolean is
5 begin
6
7 DECLARE
8
9 init_failure EXCEPTION;
10
11 BEGIN
12
13
14 p_unapprove_flag_1 := p_unapprove_flag;
15 CP_START_DATE := to_char(P_START_DATE,'DD-MON-YY');
16 CP_END_DATE := to_char(P_END_DATE,'DD-MON-YY');
17 /*SRW.USER_EXIT('FND SRWINIT');*/null;
18
19 IF (p_debug_switch = 'Y') THEN
20 /*SRW.MESSAGE('1','After SRWINIT');*/null;
21
22 END IF;
23
24
25 /*SRW.MESSAGE('1','i am here 21');*/null;
26
27
28 IF (get_company_name() <> TRUE) THEN RAISE init_failure;
29 END IF;
30 IF (p_debug_switch = 'Y') THEN
31 /*SRW.MESSAGE('2','After Get_Company_Name');*/null;
32
33 END IF;
34
35
36 IF (get_nls_strings() <> TRUE) THEN RAISE init_failure;
37 END IF;
38 IF (p_debug_switch = 'Y') THEN
39 /*SRW.MESSAGE('3','After Get_NLS_Strings');*/null;
40
41 END IF;
42
43
44 IF (get_supplier_invoice_info() <> TRUE) THEN RAISE init_failure;
45 END IF;
46 IF (p_debug_switch = 'Y') THEN
47 /*SRW.MESSAGE('4','After Get_Supplier_Invoice_Info');*/null;
48
49 END IF;
50
51
52 IF (get_base_curr_data() <> TRUE) THEN RAISE init_failure;
53 END IF;
54 IF (p_debug_switch = 'Y') THEN
55 /*SRW.MESSAGE('5','After Get_Base_Curr_Data');*/null;
56
57 END IF;
58
59
60 IF (custom_init() <> TRUE) THEN RAISE_application_error(-20101,null);/*SRW.PROGRAM_ABORT;*/null;
61
62 END IF;
63 IF (p_debug_switch = 'Y') THEN
64 /*SRW.MESSAGE('6','After Custom_Init');*/null;
65
66 END IF;
67
68 IF (get_flexdata() <> TRUE) THEN RAISE_application_error(-20101,null);/*SRW.PROGRAM_ABORT;*/null;
69
70 END IF;
71 IF (p_debug_switch = 'Y') THEN
72 /*SRW.MESSAGE('7','After get_flexdata');*/null;
73
74 END IF;
75
76
77 IF (set_p_where() <> TRUE) THEN RAISE_application_error(-20101,null);/*SRW.PROGRAM_ABORT;*/null;
78
79 END IF;
80 IF (p_debug_switch = 'Y') THEN
81 /*SRW.MESSAGE('8','After set_p_where');*/null;
82
83 END IF;
84
85 IF (p_debug_switch = 'Y') THEN
86 /*SRW.MESSAGE('9','P_DYNAMIC_BATCH_ORDERBY = ' || P_dynamic_batch_orderby);*/null;
87
88 /*SRW.MESSAGE('10','P_invoice_amount = ' || P_invoice_amount);*/null;
89
90 /*SRW.MESSAGE('11','P_flexdata = ' || P_flexdata);*/null;
91
92 /*SRW.MESSAGE('12','P_flexdata1 = ' || P_flexdata1);*/null;
93
94 /*SRW.MESSAGE('13','P_gl_code_combinations2 = ' || P_gl_code_combinations2);*/null;
95
96 /*SRW.MESSAGE('14','c_invoice_id_predicate = ' || c_invoice_id_predicate);*/null;
97
98 /*SRW.MESSAGE('15','c_batch_predicate = ' || c_batch_predicate);*/null;
99
100 /*SRW.MESSAGE('16','c_match_status_predicate = ' || c_match_status_predicate);*/null;
101
102 /*SRW.MESSAGE('17','c_inv_type_pred = ' || c_inv_type_pred);*/null;
103
104 /*SRW.MESSAGE('18','c_accounting_date_predicate = ' || c_accounting_date_predicate);*/null;
105
106 /*SRW.MESSAGE('19','c_invoice_cancelled_predicate = ' || c_invoice_cancelled_predicate);*/null;
107
108 /*SRW.MESSAGE('20','c_created_by_predicate = ' || c_created_by_predicate);*/null;
109
110 /*SRW.MESSAGE('21','c_start_date_predicate = ' || c_start_date_predicate);*/null;
111
112 /*SRW.MESSAGE('22','c_end_date_predicate = ' || c_end_date_predicate);*/null;
113
114 /*SRW.MESSAGE('23','c_gl_ccid2_predicate = ' || c_gl_ccid2_predicate);*/null;
115
116 /*SRW.MESSAGE('24','c_orderby_batch_id = ' || c_orderby_batch_id);*/null;
117
118 END IF;
119
120
121 BEGIN
122
123
124 SELECT sort_by_alternate_field
125 INTO SORT_BY_ALTERNATE
126 FROM AP_SYSTEM_PARAMETERS;
127
128
129
130 EXCEPTION
131 WHEN OTHERS THEN
132 SORT_BY_ALTERNATE := 'N';
133 END;
134
135 RETURN (TRUE);
136
137 EXCEPTION
138
139 WHEN OTHERS THEN
140
141 /*SRW.USER_EXIT('FND SRWEXIT');*/null;
142
143 RETURN (FALSE);
144
145 END; return (TRUE);
146 end;
147
148 function AfterReport return boolean is
149 begin
150
151 BEGIN
152 /*SRW.USER_EXIT('FND SRWEXIT');*/null;
153
154 END; return (TRUE);
155 end;
156
157 FUNCTION custom_init RETURN BOOLEAN IS
158 l_batch_flag VARCHAR2(1);
159 l_show_lib_acct VARCHAR2(1);
160 l_batchid number(15);
161 l_userid number(14);
162 l_cash_basis_flag VARCHAR2(1);
163 BEGIN
164 BEGIN
165 SELECT ap_system_parameters.batch_control_flag
166 INTO l_batch_flag
167 FROM ap_system_parameters;
168 C_BATCH_FLAG := l_batch_flag;
169 EXCEPTION
170 WHEN NO_DATA_FOUND THEN NULL;
171 END;
172
173 BEGIN
174 SELECT nvl(sla_ledger_cash_basis_flag, 'N')
175 INTO l_cash_basis_flag
176 FROM gl_sets_of_books sob,
177 ap_system_parameters asp
178 WHERE asp.set_of_books_id = sob.set_of_books_id;
179 EXCEPTION
180 WHEN NO_DATA_FOUND THEN
181 l_cash_basis_flag :='N';
182 END;
183 BEGIN
184 if (l_cash_basis_flag = 'Y' ) then
185 C_SHOW_LIB_ACCT := 'N';
186 else
187 C_SHOW_LIB_ACCT := 'Y';
188 end if;
189 END;
190 BEGIN
191 if (upper(p_batch) <> 'ALL' and p_batch is not null) then
192 SELECT ap_batches.batch_id
193 INTO l_batchid
194 FROM ap_batches
195 where batch_name = p_batch;
196 C_BATCH_ID := to_char(l_batchid);
197 end if;
198 EXCEPTION
199 WHEN NO_DATA_FOUND THEN NULL;
200 END;
201 BEGIN
202 SELECT decode(p_entry_person,null,'',fnd_user.user_id)
203 INTO l_userid
204 FROM fnd_user
205 WHERE user_name = decode(p_entry_person,null,user_name,p_entry_person);
206 C_USER_ID := l_userid;
207 EXCEPTION
208 WHEN NO_DATA_FOUND THEN NULL;
209 END;
210
211 RETURN (TRUE);
212
213 RETURN NULL; EXCEPTION
214
215 WHEN OTHERS THEN NULL;
216
217 RETURN NULL; END;
218
219 FUNCTION get_base_curr_data RETURN BOOLEAN IS
220
221 l_base_curr VARCHAR2(15); l_prec NUMBER; l_min_au NUMBER; l_sob_id NUMBER;
222
223 BEGIN
224
225 SELECT p.base_currency_code,
226 c.precision,
227 c.minimum_accountable_unit
228 INTO l_base_curr,
229 l_prec,
230 l_min_au
231 FROM ap_system_parameters p,
232 fnd_currencies_vl c
233 WHERE p.base_currency_code = c.currency_code;
234
235 c_base_currency_code := l_base_curr;
236 c_base_precision := l_prec;
237 c_base_min_acct_unit := l_min_au;
238 RETURN (TRUE);
239
240 RETURN NULL; EXCEPTION
241
242 WHEN OTHERS THEN Null;
243
244 RETURN NULL; END;
245
246 FUNCTION get_company_name RETURN BOOLEAN IS
247
248 l_chart_of_accounts_id NUMBER;
249 l_name VARCHAR2(30); l_sob_id NUMBER;
250
251 BEGIN
252
253
254 select set_of_books_id
255 into l_sob_id
256 from ap_system_parameters;
257
258 p_sob_id := l_sob_id;
259 SELECT substr(name,1,30),
260 chart_of_accounts_id
261 INTO l_name,
262 l_chart_of_accounts_id
263 FROM gl_sets_of_books
264 WHERE set_of_books_id = l_sob_id;
265
266 c_company_name_header := l_name;
267 c_chart_of_accounts_id := l_chart_of_accounts_id;
268
269 RETURN (TRUE);
270
271 RETURN NULL; EXCEPTION
272
273 WHEN OTHERS THEN
274 RETURN (FALSE);
275
276 END;
277
278 FUNCTION get_nls_strings RETURN BOOLEAN IS
279 nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
280 BEGIN
281
282 nls_all := '';
283 nls_yes := '';
284 nls_no := '';
285
286 SELECT ly.meaning,
287 ln.meaning,
288 la.displayed_field
289 INTO nls_yes, nls_no, nls_all
290 FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la
291 WHERE ly.lookup_type = 'YES_NO'
292 AND ly.lookup_code = 'Y'
293 AND ln.lookup_type = 'YES_NO'
294 AND ln.lookup_code = 'N'
295 AND la.lookup_type = 'NLS REPORT PARAMETER'
296 AND la.lookup_code = 'ALL';
297
298 c_nls_yes := nls_yes;
299 c_nls_no := nls_no;
300 c_nls_all := nls_all;
301
302 /*SRW.USER_EXIT('FND MESSAGE_NAME APPL="SQLAP" NAME="AP_APPRVL_NO_DATA"');*/null;
303
304 /*SRW.USER_EXIT('FND MESSAGE_GET OUTPUT_FIELD=":c_nls_no_data_exists"');*/null;
305
306 c_nls_no_data_exists := 'No Data Found';
307
308 /*SRW.USER_EXIT('FND MESSAGE_NAME APPL="SQLAP" NAME="AP_ALL_END_OF_REPORT"');*/null;
309
310 /*SRW.USER_EXIT('FND MESSAGE_GET OUTPUT_FIELD=":c_nls_end_of_report"');*/null;
311
312 c_nls_end_of_report := 'End of Report';
313
314 if p_unapprove_flag_1 = 'Y' THEN
315 c_unapproved_invoices_only := nls_yes;
316 else
317 c_unapproved_invoices_only := nls_no;
318 end if;
319
320 if p_cancelled_flag = 'Y' THEN
321 c_cancelled_invoices_only := nls_yes;
322 else
323 c_cancelled_invoices_only := nls_no;
324 end if;
325
326
327 RETURN (TRUE);
328
329 RETURN NULL; EXCEPTION
330 WHEN OTHERS THEN
331 RETURN (FALSE);
332 END;
333
334 FUNCTION get_flexdata RETURN BOOLEAN IS
335 BEGIN
336
337
338 null;
339
340
341 null;
342 return(TRUE);
343 END;
344
345 FUNCTION set_p_where RETURN BOOLEAN IS
346
347 l_nls_yes varchar2(4);
348 l_type_of_report varchar2(40);
349 l_start_date gl_period_statuses.start_date%TYPE;
350 l_end_date gl_period_statuses.end_date%TYPE;
351
352
353 BEGIN
354
355
356 if (p_cancelled_flag = 'Y') then
357 p_unapprove_flag_1 := 'N';
358 end if;
359
360
361 if (c_show_lib_acct <> 'Y') then
362 if (p_batch is null or
363 (p_batch = c_nls_na and c_batch_flag <> 'Y')) then
364 if (p_unapprove_flag_1 <> 'Y') then
365 l_type_of_report := 'SEL_INVOICES';
366 else
367 l_type_of_report := 'SEL_UNAPPROVED_INVOICES';
368 end if;
369 else
370 if (p_unapprove_flag_1 <> 'Y') then
371 l_type_of_report := 'SEL_BATCH_INVOICES';
372 else
373 l_type_of_report := 'SEL_UNAPPROVED_BATCH';
374 end if;
375 end if;
376 else
377 if (p_batch is null or
378 (p_batch = c_nls_na and c_batch_flag <> 'Y')) then
379 if (p_unapprove_flag_1 <> 'Y') then
380 l_type_of_report := 'SEL_INVOICES_WITH_LA';
381 else
382 l_type_of_report :=
383 'SEL_UNAPPROVED_INVOICES_WITH_LA';
384 end if;
385 else
386 if (p_unapprove_flag_1 <> 'Y') then
387 l_type_of_report := 'SEL_BATCH_INVOICES_WITH_LA';
388 else
389 l_type_of_report := 'SEL_UNAPPROVED_BATCH_WITH_LA';
390 end if;
391 end if;
392 end if;
393
394
395
396
397 if (l_type_of_report = 'SEL_BATCH_INVOICES') then
398
399 P_invoice_amount := 'decode(inv1.cancelled_date, null, inv1.invoice_amount, inv1.cancelled_amount)';
400 C_batch_predicate := 'and inv1.batch_id = '||C_batch_id;
401 P_flexdata1 := 'null';
402 P_gl_code_combinations2 := ' ';
403 C_match_status_predicate := ' ';
404
405 elsif (l_type_of_report = 'SEL_BATCH_INVOICES_WITH_LA') then
406
407 P_invoice_amount := 'decode(inv1.cancelled_date, null, inv1.invoice_amount, inv1.cancelled_amount)';
408 C_batch_predicate := 'and inv1.batch_id = '||C_batch_id;
409 C_match_status_predicate := ' ';
410 C_gl_ccid2_predicate := 'and GC2.code_combination_id(+) = dist.accts_pay_code_combination_id';
411
412
413 elsif (l_type_of_report = 'SEL_UNAPPROVED_BATCH') then
414
418 P_gl_code_combinations2 := ' ';
415 P_invoice_amount := 'inv1.invoice_amount';
416 C_batch_predicate := 'and inv1.batch_id = '||C_batch_id;
417 P_flexdata1 := 'null';
419 C_match_status_predicate := ' ';
420
421 elsif (l_type_of_report = 'SEL_UNAPPROVED_BATCH_WITH_LA') then
422
423 P_invoice_amount := 'inv1.invoice_amount';
424 C_batch_predicate := 'and inv1.batch_id = '||C_batch_id;
425 C_match_status_predicate := 'and (dist.match_status_flag = ''N'' or dist.match_status_flag is null)';
426 C_gl_ccid2_predicate := 'and GC2.code_combination_id(+) = dist.accts_pay_code_combination_id';
427
428 elsif (l_type_of_report = 'SEL_INVOICES') then
429
430 P_invoice_amount := 'decode(inv1.cancelled_date, null, inv1.invoice_amount, inv1.cancelled_amount)';
431 P_dynamic_batch_orderby := 'bat.batch_id';
432 C_orderby_batch_id := 'bat.batch_id,';
433 P_flexdata1 := 'null';
434 P_gl_code_combinations2 := ' ';
435 C_batch_predicate := ' ';
436 C_match_status_predicate := ' ';
437
438 elsif (l_type_of_report = 'SEL_INVOICES_WITH_LA') then
439
440 P_invoice_amount := 'decode(inv1.cancelled_date, null, inv1.invoice_amount, inv1.cancelled_amount)';
441 P_dynamic_batch_orderby := 'bat.batch_id';
442 C_orderby_batch_id := 'bat.batch_id,';
443 C_batch_predicate := ' ';
444 C_match_status_predicate := ' ';
445 C_gl_ccid2_predicate := 'and GC2.code_combination_id(+) = dist.accts_pay_code_combination_id';
446
447 elsif (l_type_of_report = 'SEL_UNAPPROVED_INVOICES') then
448
449 P_invoice_amount := 'inv1.invoice_amount';
450 C_match_status_predicate := 'and (dist.match_status_flag = ''N'' or dist.match_status_flag is null)';
451 P_dynamic_batch_orderby := 'bat.batch_id';
452 C_orderby_batch_id := 'bat.batch_id,';
453 P_flexdata1 := 'null';
454 P_gl_code_combinations2 := ' ';
455 C_batch_predicate := ' ';
456
457 elsif (l_type_of_report = 'SEL_UNAPPROVED_INVOICES_WITH_LA') then
458
459 P_invoice_amount := 'inv1.invoice_amount';
460 C_match_status_predicate := 'and (dist.match_status_flag = ''N'' or dist.match_status_flag is null)';
461 P_dynamic_batch_orderby := 'bat.batch_id';
462 C_orderby_batch_id := 'bat.batch_id,';
463 C_batch_predicate := ' ';
464 C_gl_ccid2_predicate := 'and GC2.code_combination_id(+) = dist.accts_pay_code_combination_id';
465
466 else
467 C_batch_predicate := ' ';
468 C_match_status_predicate := ' ' ;
469 end if;
470
471
472
473
474 C_invoice_cancelled_predicate := 'AND 1 = DECODE('''||P_CANCELLED_FLAG||''', ''N'', 1, ''Y'', DECODE(inv1.cancelled_date, NULL, 0, 1))';
475
476
477 if (C_user_id is not null) then
478 C_created_by_predicate := 'and inv1.created_by = '||C_user_id;
479 ELSE
480 C_created_by_predicate := ' ';
481 end if;
482
483
484
485 if (P_start_date is not null) then
486 C_start_date_predicate := 'and inv1.creation_date >= TO_DATE('''||to_char(P_start_date
487 ,'DD-MON-YYYY')||' 00:00:00'', ''DD-MON-YYYY HH24:MI:SS'')';
488 ELSE
489 C_start_date_predicate := ' ';
490 end if;
491
492 if (P_end_date is not null) then
493 C_end_date_predicate := 'and inv1.creation_date <= TO_DATE('''||to_char(P_end_date
494 ,'DD-MON-YYYY')||' 23:59:59'', ''DD-MON-YYYY HH24:MI:SS'')';
495 ELSE
496 C_end_date_predicate := ' ';
497 end if;
498
499 if (P_INVOICE_TYPE is not null) then
500 C_INV_TYPE_PRED := 'and inv1.invoice_type_lookup_code = '''||P_INVOICE_TYPE||'''';
501 ELSE
502 C_INV_TYPE_PRED := ' ';
503
504 end if;
505
506
507 C_INVOICE_ID_PREDICATE := 'AND inv1.invoice_id = lines.invoice_id(+) '||
508 'AND lines.invoice_id = dist.invoice_id(+) '||
509 'AND lines.line_number = dist.invoice_line_number(+) ';
510
511 if P_ACCOUNTING_PERIOD is not null then
512 BEGIN
513 SELECT start_date, end_date
514 INTO l_start_date, l_end_date
515 FROM gl_period_statuses
516 WHERE period_name = P_ACCOUNTING_PERIOD
517 AND set_of_books_id = P_SOB_ID
518 AND application_id = 200
519 AND NVL(adjustment_period_flag, 'N') = 'N';
520
521 C_ACCOUNTING_DATE_PREDICATE := 'AND dist.accounting_date between '''||
522 to_char(l_start_date)||''' AND '''||to_char(l_end_date)||'''';
523
524 C_INVOICE_ID_PREDICATE := 'AND inv1.invoice_id = dist.invoice_id';
525
526 EXCEPTION
527 WHEN NO_DATA_FOUND THEN NULL;
528
529 END;
530 ELSE
531 C_ACCOUNTING_DATE_PREDICATE := ' ';
532 end if;
533
534 return(TRUE);
535 END;
536
537 FUNCTION GET_SUPPLIER_INVOICE_INFO RETURN BOOLEAN IS
538
539 l_supplier_name po_vendors.vendor_name%TYPE;
540 l_invoice_type varchar2(80);
541
542 BEGIN
543
544 IF p_vendor_id IS NOT NULL THEN
545
546 Select vendor_name
547 into l_supplier_name
548 from po_vendors
549 where vendor_id = p_vendor_id;
550
551 c_supplier_name := l_supplier_name;
552
553 END IF;
554
555
556
557 IF p_invoice_type IS NOT NULL THEN
558
559 Select displayed_field
560 into l_invoice_type
561 from ap_lookup_codes
562 where lookup_code = p_invoice_type
563 and lookup_type = 'INVOICE TYPE'
564 and nvl(inactive_date, sysdate+1) > sysdate;
565
566 c_invoice_type1 := l_invoice_type;
567
568 END IF;
569
570
571 RETURN (TRUE);
572
573 RETURN NULL; EXCEPTION
574
575 WHEN OTHERS THEN
576 RETURN (FALSE);
577
578 END;
579
580 --Functions to refer Oracle report placeholders--
581
582 Function C_BASE_CURRENCY_CODE_p return varchar2 is
583 Begin
584 return C_BASE_CURRENCY_CODE;
585 END;
586 Function C_BASE_PRECISION_p return number is
587 Begin
588 return C_BASE_PRECISION;
589 END;
590 Function C_BASE_MIN_ACCT_UNIT_p return number is
591 Begin
592 return C_BASE_MIN_ACCT_UNIT;
593 END;
594 Function C_NLS_YES_p return varchar2 is
595 Begin
596 return C_NLS_YES;
597 END;
598 Function C_NLS_NO_p return varchar2 is
599 Begin
600 return C_NLS_NO;
601 END;
602 Function C_NLS_ALL_p return varchar2 is
603 Begin
604 return C_NLS_ALL;
605 END;
606 Function C_COMPANY_NAME_HEADER_p return varchar2 is
607 Begin
608 return C_COMPANY_NAME_HEADER;
609 END;
610 Function C_CHART_OF_ACCOUNTS_ID_p return number is
611 Begin
612 return C_CHART_OF_ACCOUNTS_ID;
613 END;
614 Function C_NLS_NA_p return varchar2 is
615 Begin
616 return C_NLS_NA;
617 END;
618 Function C_NLS_NO_DATA_EXISTS_p return varchar2 is
619 Begin
620 return C_NLS_NO_DATA_EXISTS;
621 END;
622 Function C_SHOW_LIB_ACCT_p return varchar2 is
623 Begin
624 return C_SHOW_LIB_ACCT;
625 END;
626 Function C_BATCH_FLAG_p return varchar2 is
627 Begin
628 return C_BATCH_FLAG;
629 END;
630 Function C_BATCH_ID_p return varchar2 is
631 Begin
632 return C_BATCH_ID;
633 END;
634 Function C_USER_ID_p return varchar2 is
635 Begin
636 return C_USER_ID;
637 END;
638 Function C_liability_acct_flex_p return varchar2 is
639 Begin
640 return C_liability_acct_flex;
641 END;
642 Function C_batch_predicate_p return varchar2 is
643 Begin
644 return C_batch_predicate;
645 END;
646 Function C_match_status_predicate_p return varchar2 is
647 Begin
648 return C_match_status_predicate;
649 END;
650 Function C_invoice_cancelled_pred_1 return varchar2 is
651 Begin
652 return C_invoice_cancelled_predicate;
653 END;
654 Function C_created_by_predicate_p return varchar2 is
655 Begin
656 return C_created_by_predicate;
657 END;
658 Function C_start_date_predicate_p return varchar2 is
659 Begin
660 return C_start_date_predicate;
661 END;
662 Function C_end_date_predicate_p return varchar2 is
663 Begin
664 return C_end_date_predicate;
665 END;
666 Function C_gl_ccid2_predicate_p return varchar2 is
667 Begin
668 return C_gl_ccid2_predicate;
669 END;
670 Function C_orderby_batch_id_p return varchar2 is
671 Begin
672 return C_orderby_batch_id;
673 END;
674 Function C_INV_TYPE_PRED_p return varchar2 is
675 Begin
676 return C_INV_TYPE_PRED;
677 END;
678 Function C_NLS_END_OF_REPORT_p return varchar2 is
679 Begin
680 return C_NLS_END_OF_REPORT;
681 END;
682 Function C_INVOICE_ID_PREDICATE_p return varchar2 is
683 Begin
684 return C_INVOICE_ID_PREDICATE;
685 END;
686 Function C_ACCOUNTING_DATE_PREDICATE_p return varchar2 is
687 Begin
688 return C_ACCOUNTING_DATE_PREDICATE;
689 END;
690 Function C_CANCELLED_INVOICES_ONLY_p return varchar2 is
691 Begin
692 return C_CANCELLED_INVOICES_ONLY;
693 END;
694 Function C_UNAPPROVED_INVOICES_ONLY_p return varchar2 is
695 Begin
696 return C_UNAPPROVED_INVOICES_ONLY;
697 END;
698 Function C_Supplier_Name_p return varchar2 is
699 Begin
700 return C_Supplier_Name;
701 END;
702 Function C_INVOICE_TYPE1_p return varchar2 is
703 Begin
704 return C_INVOICE_TYPE1;
705 END;
706 END AP_APXINRIR_XMLP_PKG ;
707
708