APPS.JL_BR_SPED_PKG dependencies on FND_PROFILE

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

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

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

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

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

420: L_COUNTRY_CODE VARCHAR2(30);
421: L_ACCESS_CODE NUMBER;
422: L_ISSUE_AUTHORITY VARCHAR2(1);
423: BEGIN
424: FND_PROFILE.GET('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);
425:
426: BEGIN
427: SELECT NVL(B.GLOBAL_ATTRIBUTE5, 'N') INTO L_ISSUE_AUTHORITY
428: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

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

1080: L_ACCESS_CODE NUMBER;
1081: L_ISSUE_AUTHORITY VARCHAR2(1);
1082: BEGIN
1083:
1084: FND_PROFILE.GET ('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);
1085: IF L_COUNTRY_CODE = 'BR' THEN
1086:
1087: -- Processing for Transaction Header Attributes
1088: OPEN C_APIINV_ATTR;

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

1355: CURSOR C_CM_Details( p_type_id IN NUMBER ) IS
1356: SELECT TYPE, DEFAULT_STATUS FROM ra_cust_trx_types WHERE cust_trx_type_id = p_type_id;
1357: L_COUNTRY_CODE varchar2(30);
1358: BEGIN
1359: FND_PROFILE.GET ('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);
1360: IF L_COUNTRY_CODE = 'BR' THEN
1361:
1362: OPEN C_trx_details(p_inv_customer_trx_id);
1363: FETCH C_trx_details INTO l_trx_status,l_trx_amount;