[Home] [Help]
PACKAGE: APPS.ARP_GLOBAL
Source
1 PACKAGE ARP_GLOBAL AS
2 /*$Header: ARCUGLBS.pls 120.6 2004/09/16 16:32:08 rvsharma noship $*/
3 --
4 --
5 -- Public Variables
6 --
7 sysparam AR_SYSTEM_PARAMETERS%ROWTYPE;
8 chart_of_accounts_id NUMBER;
9 set_of_books_id NUMBER;
10 functional_currency GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
11 period_set_name GL_SETS_OF_BOOKS.PERIOD_SET_NAME%TYPE;
12 created_by NUMBER;
13 creation_date DATE;
14 last_updated_by NUMBER;
15 last_update_date DATE;
16 last_update_login NUMBER;
17 request_id NUMBER;
18 program_id NUMBER;
19 program_application_id NUMBER;
20 program_update_date DATE;
21 user_id NUMBER;
22 base_precision fnd_currencies.precision%type;
23 base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
24 tm_installed_flag VARCHAR2(1);
25 tm_default_setup_flag VARCHAR2(1);
26
27 G_CB_RT_ID CONSTANT NUMBER := -11;
28 G_CB_REV_RT_ID CONSTANT NUMBER := -12;
29 G_AR_APP_ID CONSTANT NUMBER := 222;
30 G_GL_APP_ID CONSTANT NUMBER := 101;
31 --
32 G_MAX_DATE CONSTANT DATE := TO_DATE( '12/31/4712', 'MM/DD/YYYY' );
33 --
34 -- Bug 3172032/3146233 : added global variable which is checked in the ra_cust_trx_line_gl_dist_bri trigger
35 G_ALLOW_DATAFIX BOOLEAN := FALSE;
36
37 conc_program_name fnd_concurrent_programs_vl.concurrent_program_name%type; /*Bug 3678916*/
38
39 -- This is the seeded bank branch for credit cards
40 -- The value for this will have to be changed for the cba project.
41
42 CC_BANK_BRANCH_ID CONSTANT NUMBER := 1;
43
44
45 --
46 -- Linefeed character
47 --
48 CRLF CONSTANT VARCHAR2(1) := '
49 ';
50 YES CONSTANT VARCHAR2(1) := 'Y';
51 NO CONSTANT VARCHAR2(1) := 'N';
52 --
53 --
54 --
55 MSG_LEVEL_BASIC CONSTANT NUMBER := 0;
56 MSG_LEVEL_TIMING CONSTANT NUMBER := 1;
57 MSG_LEVEL_DEBUG CONSTANT NUMBER := 2;
58 MSG_LEVEL_DEBUG2 CONSTANT NUMBER := 3;
59 MSG_LEVEL_DEVELOP CONSTANT NUMBER := 10;
60
61 msg_level NUMBER := MSG_LEVEL_DEVELOP;
62
63 --
64 --
65 -- Public Record Type for receivable applications record
66 --
67 TYPE app_rec_type IS RECORD
68 (
69 gl_date_closed DATE,
70 actual_date_closed DATE,
71 --
72 acctd_amount_applied NUMBER,
73 amount_applied NUMBER,
74 line_applied NUMBER,
75 tax_applied NUMBER,
76 freight_applied NUMBER,
77 receivables_charges_applied NUMBER,
78 amount_adjusted_pending NUMBER,
79 --
80 line_ediscounted NUMBER,
81 line_uediscounted NUMBER,
82 tax_ediscounted NUMBER,
83 tax_uediscounted NUMBER,
84 freight_ediscounted NUMBER,
85 freight_uediscounted NUMBER,
86 charges_ediscounted NUMBER,
87 charges_uediscounted NUMBER,
88 --
89 earned_discount_taken NUMBER,
90 unearned_discount_taken NUMBER,
91 acctd_earned_discount_taken NUMBER,
92 acctd_unearned_discount_taken NUMBER,
93 --
94 trx_type VARCHAR2(20),
95 user_id NUMBER,
96 ps_id NUMBER,
97 cash_receipt_ps_id NUMBER,
98 charges_type_adjusted NUMBER /* Bug 3769587 */
99 );
100 --
101
102 /* Bug 1679088 : define new public procedure to allow initialization
103 process to run whenever required */
104 /* Multi-Org Access Control Changes for SSA;Begin;anukumar;09/13/2002*/
105 PROCEDURE INIT_GLOBAL(p_org_id number default null);
106 /* Multi-Org Access Control Changes for SSA;End;anukumar;09/13/2002*/
107
108 /* Bug 3251839 : Function to return cached tm_installed_flag */
109 FUNCTION TM_INSTALLED RETURN VARCHAR2;
110
111 END ARP_GLOBAL;