APPS.JL_BR_SPED_PKG dependencies on FND_PROFILE

Line 41: FND_PROFILE.GET('JGZZ_COUNTRY_CODE', l_country_code);

37: l_country_code VARCHAR2(30);
38:
39: BEGIN
40:
41: FND_PROFILE.GET('JGZZ_COUNTRY_CODE', l_country_code);
42:
43: IF (l_country_code = 'BR') THEN
44:
45: FOR batch_source_rec IN C_BATCH_SOURCE LOOP

Line 83: FND_PROFILE.GET('JGZZ_COUNTRY_CODE', l_country_code);

79: WHERE T.CUSTOMER_TRX_ID = p_customer_trx_id
80: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID;
81: l_country_code varchar2(30);
82: BEGIN
83: FND_PROFILE.GET('JGZZ_COUNTRY_CODE', l_country_code);
84:
85: IF (l_country_code = 'BR') THEN
86:
87: FOR BATCH_SOURCE_REC IN C_BATCH_SOURCE LOOP

Line 191: FND_PROFILE.GET('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);

187:
188: L_COUNTRY_CODE VARCHAR2(30);
189:
190: BEGIN
191: FND_PROFILE.GET('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);
192:
193: IF L_COUNTRY_CODE = 'BR' THEN
194: IF P_CALLED_FROM = 'RAXTRX' THEN
195:

Line 366: FND_PROFILE.GET ('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);

362: WHERE GT.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
363: L_COUNTRY_CODE VARCHAR2 (30);
364: BEGIN
365:
366: FND_PROFILE.GET ('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);
367: IF L_COUNTRY_CODE = 'BR' THEN
368: OPEN C_APIINV_ATTR;
369: FETCH C_APIINV_ATTR BULK COLLECT INTO
370: CUSTOMER_TRX_ID,

Line 446: FND_PROFILE.GET ('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);

442: CURSOR C_CM_Details( p_type_id IN NUMBER ) IS
443: SELECT TYPE, DEFAULT_STATUS FROM ra_cust_trx_types WHERE cust_trx_type_id = p_type_id;
444: L_COUNTRY_CODE varchar2(30);
445: BEGIN
446: FND_PROFILE.GET ('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);
447: IF L_COUNTRY_CODE = 'BR' THEN
448:
449: OPEN C_trx_details(p_inv_customer_trx_id);
450: FETCH C_trx_details INTO l_trx_status,l_trx_amount;