[Home] [Help]
PACKAGE: APPS.JL_JLZZRCVI_XMLP_PKG
Source
1 PACKAGE JL_JLZZRCVI_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLZZRCVIS.pls 120.1 2007/12/25 16:36:57 dwkrishn noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4 P_SET_OF_BOOKS_ID NUMBER;
5 P_CURRENCY_CODE VARCHAR2(32767);
6 P_IN_VOID_REASON VARCHAR2(30);
7 P_IN_BATCH_SOURCE_ID NUMBER;
8 P_IN_CUST_TRX_TYPE_ID NUMBER;
9 P_DEBUG_SWITCH VARCHAR2(1);
10 P_IN_PREVIEW_REPORT VARCHAR2(1);
11 P_COUNTRY_CODE VARCHAR2(32767);
12 P_IN_NUMBER_TYPE VARCHAR2(40);
13 P_IN_NUMBER_LOW VARCHAR2(80);
14 P_IN_NUMBER_HIGH VARCHAR2(80);
15 P_DYNAMIC_WHERE_TRX_TYPE VARCHAR2(240):=' ';
16 RP_COMPANY_NAME VARCHAR2(50);
17 RP_REPORT_NAME VARCHAR2(240);
18 RP_SUB_TITLE VARCHAR2(80);
19 CP_AUTO_TRX_NUM_FLAG VARCHAR2(1):='Y';
20 CP_DOC_SEQ_NUM_FLAG VARCHAR2(1):='Y';
21 CP_VOID_TYPE_EXIST_FLAG VARCHAR2(1):='Y';
22 CP_VOID_TYPE_UNIQ_FLAG VARCHAR2(1):='Y';
23 CP_VOID_TYPE_NO_NO_FLAG VARCHAR2(1):='Y';
24 CP_AUTO_TRX_NUM_MESG VARCHAR2(240);
25 CP_DOC_SEQ_NUM_MESG VARCHAR2(240);
26 CP_VOID_TYPE_EXIST_MESG VARCHAR2(240);
27 CP_VOID_TYPE_UNIQ_MESG VARCHAR2(240);
28 CP_VOID_TYPE_NO_NO_MESG VARCHAR2(240);
29 CP_SETUP_ERROR_TITLE VARCHAR2(240);
30 CP_ERROR_COUNT NUMBER;
31 CP_ORIG_INV_NOT_FOUND_MESG VARCHAR2(240);
32 RP_BATCH_SOURCE_NAME VARCHAR2(50);
33 RP_NUMBER_TYPE VARCHAR2(80);
34 FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
35 FUNCTION BEFOREREPORT RETURN BOOLEAN;
36 FUNCTION SUB_TITLEFORMULA RETURN VARCHAR2;
37 FUNCTION AFTERREPORT RETURN BOOLEAN;
38 FUNCTION AFTERPFORM RETURN BOOLEAN;
39 FUNCTION CHECK_AUTO_TRX_NUM(P_BATCH_SOURCE_ID IN NUMBER) RETURN BOOLEAN;
40 FUNCTION CHECK_TRANSACTIONS(P_ACTIVITY_FLAG IN VARCHAR2
41 ,P_POSTED_FLAG IN VARCHAR2
42 ,P_CTT_CLASS IN VARCHAR2
43 ,P_COMPLETE_FLAG IN VARCHAR2
44 ,P_GDF_CATEGORY IN VARCHAR2
45 ,P_GDF_ATTRIBUTE20 IN VARCHAR2
46 ,P_ROW_NUM IN NUMBER) RETURN BOOLEAN;
47 FUNCTION UPDATE_ORIGINAL_TRX(P_COUNTRY_CODE IN VARCHAR2
48 ,P_CUSTOMER_TRX_ID IN NUMBER
49 ,P_NEW_TRX_NUMBER IN VARCHAR2
50 ,P_COPY_TRX_STATUS IN VARCHAR2) RETURN BOOLEAN;
51 FUNCTION CHECK_SETUP(P_BATCH_SOURCE_ID IN NUMBER
52 ,P_COUNTRY_CODE IN VARCHAR2) RETURN BOOLEAN;
53 FUNCTION CHECK_VOID_TRX_TYPE(P_COUNTRY_CODE IN VARCHAR2) RETURN BOOLEAN;
54 FUNCTION INSERT_RECUR_INTERIM(P_REQUEST_ID IN NUMBER
55 ,P_CUSTOMER_TRX_ID IN NUMBER
56 ,P_TRX_DATE IN DATE
57 ,P_TERM_DUE_DATE IN DATE
58 ,P_GL_DATE IN DATE
59 ,P_BATCH_SOURCE_ID IN NUMBER
60 ,P_NEW_TRX_NUMBER OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
61 FUNCTION CHECK_ORIG_INV_NOT_FOUND(P_NUMBER_HIGH IN VARCHAR2) RETURN BOOLEAN;
62 FUNCTION GET_HEADER_INFO RETURN BOOLEAN;
63 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
64 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
65 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
66 FUNCTION CP_AUTO_TRX_NUM_FLAG_P RETURN VARCHAR2;
67 FUNCTION CP_DOC_SEQ_NUM_FLAG_P RETURN VARCHAR2;
68 FUNCTION CP_VOID_TYPE_EXIST_FLAG_P RETURN VARCHAR2;
69 FUNCTION CP_VOID_TYPE_UNIQ_FLAG_P RETURN VARCHAR2;
70 FUNCTION CP_VOID_TYPE_NO_NO_FLAG_P RETURN VARCHAR2;
71 FUNCTION CP_AUTO_TRX_NUM_MESG_P RETURN VARCHAR2;
72 FUNCTION CP_DOC_SEQ_NUM_MESG_P RETURN VARCHAR2;
73 FUNCTION CP_VOID_TYPE_EXIST_MESG_P RETURN VARCHAR2;
74 FUNCTION CP_VOID_TYPE_UNIQ_MESG_P RETURN VARCHAR2;
75 FUNCTION CP_VOID_TYPE_NO_NO_MESG_P RETURN VARCHAR2;
76 FUNCTION CP_SETUP_ERROR_TITLE_P RETURN VARCHAR2;
77 FUNCTION CP_ERROR_COUNT_P RETURN NUMBER;
78 FUNCTION CP_ORIG_INV_NOT_FOUND_MESG_P RETURN VARCHAR2;
79 FUNCTION RP_BATCH_SOURCE_NAME_P RETURN VARCHAR2;
80 FUNCTION RP_NUMBER_TYPE_P RETURN VARCHAR2;
81 END JL_JLZZRCVI_XMLP_PKG;
82
83