1 PACKAGE AP_APXBCRPT_XMLP_PKG AS
2 /* $Header: APXBCRPTS.pls 120.0 2007/12/27 07:30:51 vjaganat noship $ */
3 P_TRANSFERRING_BANK_NAME VARCHAR2(60);
4
5 P_TRANSFER_PRIORITY VARCHAR2(25);
6
7 P_ORDER_BY VARCHAR2(25);
8
9 P_CONC_REQUEST_ID NUMBER := 0;
10
11 P_CURRENCY_CODE VARCHAR2(15);
12
13 LP_AP_AR_TAB VARCHAR2(2000);
14
15 LP_AP_AR_WHERE VARCHAR2(2000);
16
17 H_APPLICATION_ID NUMBER;
18
19 H_COMPANY_NAME VARCHAR2(30);
20
21 H_CURRENCY_CODE VARCHAR2(15);
22
23 H_SORT_BY_PHONETIC VARCHAR2(1) := 'N';
24
25 FUNCTION BEFOREREPORT RETURN BOOLEAN;
26
27 FUNCTION AFTERREPORT RETURN BOOLEAN;
28
29 FUNCTION C_LINE_TRANSFER_PRIORITYFORMUL(C_TRANSFER_PRIORITY IN VARCHAR2) RETURN VARCHAR2;
30
31 FUNCTION H_APPLICATION_ID_P RETURN NUMBER;
32
33 FUNCTION H_COMPANY_NAME_P RETURN VARCHAR2;
34
35 FUNCTION H_CURRENCY_CODE_P RETURN VARCHAR2;
36
37 FUNCTION H_SORT_BY_PHONETIC_P RETURN VARCHAR2;
38
39 PROCEDURE PUT(NAME IN VARCHAR2
40 ,VAL IN VARCHAR2);
41
42 FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
43
44 PROCEDURE GET(NAME IN VARCHAR2
45 ,VAL OUT NOCOPY VARCHAR2);
46
47 FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
48
49 FUNCTION VALUE_WNPS(NAME IN VARCHAR2) RETURN VARCHAR2;
50
51 FUNCTION SAVE_USER(X_NAME IN VARCHAR2
52 ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
53
54 FUNCTION SAVE(X_NAME IN VARCHAR2
55 ,X_VALUE IN VARCHAR2
56 ,X_LEVEL_NAME IN VARCHAR2
57 ,X_LEVEL_VALUE IN VARCHAR2
58 ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
59
60 PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
61 ,USER_ID_Z IN NUMBER
62 ,RESPONSIBILITY_ID_Z IN NUMBER
63 ,APPLICATION_ID_Z IN NUMBER
64 ,VAL_Z OUT NOCOPY VARCHAR2
65 ,DEFINED_Z OUT NOCOPY BOOLEAN);
66
67 FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
68 ,USER_ID IN NUMBER
69 ,RESPONSIBILITY_ID IN NUMBER
70 ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
71
72 PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
73 ,RESPONSIBILITY_ID_Z IN NUMBER
74 ,APPLICATION_ID_Z IN NUMBER
75 ,SITE_ID_Z IN NUMBER);
76
77 PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
78 ,VALS IN VARCHAR2
79 ,NUM IN NUMBER);
80
81 END AP_APXBCRPT_XMLP_PKG;
82
83