[Home] [Help]
PACKAGE: APPS.GMF_SUBLEDGER_REPORT
Source
1 PACKAGE GMF_SUBLEDGER_REPORT AUTHID CURRENT_USER AS
2 /* $Header: gmfsubrs.pls 115.7 2004/07/23 16:53:12 dvadivel ship $ */
3
4 PROCEDURE RUN(
5 errbuf OUT NOCOPY VARCHAR2,
6 retcode OUT NOCOPY VARCHAR2,
7 preference_no IN VARCHAR2,
8 pco_code IN VARCHAR2,
9 pcurrency_code IN VARCHAR2,
10 pfiscal_year IN VARCHAR2,
11 pperiod IN VARCHAR2,
12 pstart_date IN VARCHAR2,
13 pend_date IN VARCHAR2,
14 pfrom_voucher_no IN VARCHAR2,
15 pto_voucher_no IN VARCHAR2,
16 pfrom_source_code IN VARCHAR2,
17 pto_source_code IN VARCHAR2,
18 pfrom_sub_event_code IN VARCHAR2,
19 pto_sub_event_code IN VARCHAR2,
20 report_on IN VARCHAR2,
21 rep_mode IN VARCHAR2,
22 plines_per_page IN VARCHAR2,
23 ppage_size IN NUMBER DEFAULT 132); -- Bug 2804810
24
25 PROCEDURE PRINT_TOTALS(
26 line_id IN VARCHAR2,
27 doc_no IN VARCHAR2,
28 sub_event_code IN VARCHAR2,
29 voucher_id IN NUMBER,
30 rep_mode IN VARCHAR2,
31 ppage_size IN NUMBER DEFAULT 132); -- Bug 2804810
32
33 PROCEDURE PRINT_LINE(
34 line_text IN VARCHAR2);
35
36 PROCEDURE INITIALIZE_LABELS;
37
38 -- variables for report labels.
39 L_GMF_SUBLEDGER_REPORT VARCHAR2(2000);
40 L_GMF_SOURCE VARCHAR2(2000);
41 L_GMF_SUB_EVENT VARCHAR2(2000);
42 L_GMF_VOUCHER VARCHAR2(2000);
43 L_GMF_DOCUMENT VARCHAR2(2000);
44 L_GMF_DOC_NO VARCHAR2(2000);
45 L_GMF_DOC_TYPE VARCHAR2(2000);
46 L_GMF_DOC_DATE VARCHAR2(2000);
47 L_GMF_LINE VARCHAR2(2000);
48 L_GMF_ITEM VARCHAR2(2000);
49 L_GMF_TRANS_DATE VARCHAR2(2000);
50 L_GMF_WHSE VARCHAR2(2000);
51 L_GMF_QUANTITY VARCHAR2(2000);
52 L_GMF_UOM VARCHAR2(2000);
53 L_GMF_TTL VARCHAR2(2000);
54 L_GMF_BASE_CURR VARCHAR2(2000);
55 L_GMF_BILL_CURR VARCHAR2(2000);
56 L_GMF_DEBIT VARCHAR2(2000);
57 L_GMF_CREDIT VARCHAR2(2000);
58 L_GMF_JV_QTY VARCHAR2(2000);
59 L_GMF_REFERENCE_NO VARCHAR2(2000);
60 L_GMF_COMPANY VARCHAR2(2000);
61 L_GMF_CURRENCY VARCHAR2(2000);
62 L_GMF_FISCAL_YEAR VARCHAR2(2000);
63 L_GMF_PERIOD VARCHAR2(2000);
64 L_GMF_START_DATE VARCHAR2(2000);
65 L_GMF_END_DATE VARCHAR2(2000);
66 L_GMF_FROM VARCHAR2(2000);
67 L_GMF_TO VARCHAR2(2000);
68 L_GMF_AU_AND_ACCT VARCHAR2(2000);
69 L_GMF_TEST VARCHAR2(2000);
70 /* Bug 1924250 */
71 L_GMF_VENDOR VARCHAR2(2000);
72 L_GMF_PO_NO VARCHAR2(2000);
73 L_GMF_XCHG_RATE VARCHAR2(2000);
74 L_GMF_RECEIPT VARCHAR2(2000);
75 L_GMF_RECEIPT_DATE VARCHAR2(2000);
76 L_GMF_FORMULA VARCHAR2(2000);
77 L_GMF_VERSION VARCHAR2(2000);
78 L_GMF_ACTUAL_START_DATE VARCHAR2(2000);
79 L_GMF_ACTUAL_CMPLT_DATE VARCHAR2(2000);
80 L_GMF_ROUTING VARCHAR2(2000);
81 L_GMF_CUSTOMER VARCHAR2(2000);
82 L_GMF_SO_NO VARCHAR2(2000);
83 L_GMF_SO_DATE VARCHAR2(2000);
84 L_GMF_WIP_WHSE VARCHAR2(2000);
85 /* End of code for Bug 1924250 */
86 /* Bug 2048108 */
87 L_GMF_UNIT_PRICE VARCHAR2(2000);
88 L_GMF_REAS_CODE VARCHAR2(2000);
89 L_GMF_PLAN_QTY VARCHAR2(2000);
90 L_GMF_ACTL_QTY VARCHAR2(2000);
91 L_GMF_ORIG_QTY VARCHAR2(2000); -- Bug 3772552 - Fwd port of 3544905
92 L_GMF_BATCH_STATUS VARCHAR2(2000);
93 L_GMF_PAGE_NO VARCHAR2(2000);
94 /* End of code for Bug 2048108 */
95
96 END;