1 PACKAGE BODY FV_GTAS_UTILITY_PKG AS
2 /* $Header: FVGTSUTB.pls 120.1 2012/01/05 19:40:08 snama noship $ * */
3
4 g_module_name VARCHAR2(200);
5 --This procedure is called by AP during invoice import as well as during
6 --invoice validation
7 PROCEDURE ap_check_gdf_valid(P_id NUMBER, --invoice_id/interface_invoice_id,supplier_id
8 P_calling_mode VARCHAR2, --invoice validation (INV_VLD)/ invoice import (INV_IMP)/ supplier import (SUP_IMP)
9 P_table_name VARCHAR2, --on which table to query
10 P_hold_reject_exists_flag OUT NOCOPY VARCHAR2, --to release/place hold and import/reject invoice
11 P_return_code OUT NOCOPY VARCHAR2, --hold code /reject code/null if valid
12 P_return_status OUT NOCOPY BOOLEAN) IS
13
14 BEGIN
15
16 P_return_status := TRUE;
17
18 EXCEPTION WHEN OTHERS THEN NULL;
19 END ap_check_gdf_valid;
20 --------------------------------------------------------------------------------
21 PROCEDURE ar_check_gdf_pre_processor(p_id NUMBER, --Request id of the AR interface run
22 p_mode VARCHAR2, --mode like AUTO_INV, COPY_INV, IMP_API, etc
23 p_return_status OUT NOCOPY BOOLEAN) IS
24 BEGIN
25
26 P_return_status := TRUE;
27
28 EXCEPTION WHEN OTHERS THEN NULL;
29 END ar_check_gdf_pre_processor;
30 --------------------------------------------------------------------------------
31 PROCEDURE ar_check_gdf_post_processor(p_id NUMBER, --Request id of the AR interface run
32 p_mode VARCHAR2,--mode like AUTO_INV, COPY_INV, IMP_API, etc
33 --p_ccid NUMBER,
34 p_return_status OUT NOCOPY BOOLEAN) IS
35 BEGIN
36
37 P_return_status := TRUE;
38
39 EXCEPTION WHEN OTHERS THEN NULL;
40 END ar_check_gdf_post_processor;
41 --------------------------------------------------------------------------------
42 BEGIN
43 g_module_name := 'fv.plsql.FV_GTAS_UTILITY_PKG.';
44 --------------------------------------------------------------------------------
45 END FV_GTAS_UTILITY_PKG;