DBA Data[Home] [Help]

APPS.AR_INVOICE_DEFAULT_PVT dependencies on FND_PROFILE

Line 4: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

1: PACKAGE BODY AR_INVOICE_DEFAULT_PVT AS
2: /* $Header: ARXVINDB.pls 120.7.12010000.2 2008/11/13 05:41:45 dgaurab ship $ */
3:
4: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
5:
6: PROCEDURE Get_system_parameters (
7: p_trx_system_parameters_rec OUT NOCOPY trx_system_parameters_rec_type,
8: x_errmsg OUT NOCOPY VARCHAR2,

Line 127: trx_profile_rec.ar_unique_seq_numbers := fnd_profile.value('UNIQUE:SEQ_NUMBERS');

123: END IF;
124:
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126:
127: trx_profile_rec.ar_unique_seq_numbers := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
128:
129: /* 4743228 - swap AR to ZX profiles for etax */
130: trx_profile_rec.ar_allow_manual_tax_lines := fnd_profile.value('ZX_ALLOW_MANUAL_TAX_LINES');
131: trx_profile_rec.ar_allow_tax_code_override := fnd_profile.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE');

Line 130: trx_profile_rec.ar_allow_manual_tax_lines := fnd_profile.value('ZX_ALLOW_MANUAL_TAX_LINES');

126:
127: trx_profile_rec.ar_unique_seq_numbers := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
128:
129: /* 4743228 - swap AR to ZX profiles for etax */
130: trx_profile_rec.ar_allow_manual_tax_lines := fnd_profile.value('ZX_ALLOW_MANUAL_TAX_LINES');
131: trx_profile_rec.ar_allow_tax_code_override := fnd_profile.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE');
132: trx_profile_rec.ar_allow_trx_line_exemptions := fnd_profile.value('ZX_ALLOW_TRX_LINE_EXEMPTIONS');
133: /* 4743228 - end */
134:

Line 131: trx_profile_rec.ar_allow_tax_code_override := fnd_profile.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE');

127: trx_profile_rec.ar_unique_seq_numbers := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
128:
129: /* 4743228 - swap AR to ZX profiles for etax */
130: trx_profile_rec.ar_allow_manual_tax_lines := fnd_profile.value('ZX_ALLOW_MANUAL_TAX_LINES');
131: trx_profile_rec.ar_allow_tax_code_override := fnd_profile.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE');
132: trx_profile_rec.ar_allow_trx_line_exemptions := fnd_profile.value('ZX_ALLOW_TRX_LINE_EXEMPTIONS');
133: /* 4743228 - end */
134:
135: trx_profile_rec.ar_batch_source := fnd_profile.value('AR_BATCH_SOURCE');

Line 132: trx_profile_rec.ar_allow_trx_line_exemptions := fnd_profile.value('ZX_ALLOW_TRX_LINE_EXEMPTIONS');

128:
129: /* 4743228 - swap AR to ZX profiles for etax */
130: trx_profile_rec.ar_allow_manual_tax_lines := fnd_profile.value('ZX_ALLOW_MANUAL_TAX_LINES');
131: trx_profile_rec.ar_allow_tax_code_override := fnd_profile.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE');
132: trx_profile_rec.ar_allow_trx_line_exemptions := fnd_profile.value('ZX_ALLOW_TRX_LINE_EXEMPTIONS');
133: /* 4743228 - end */
134:
135: trx_profile_rec.ar_batch_source := fnd_profile.value('AR_BATCH_SOURCE');
136: trx_profile_rec.ar_ra_batch_source := fnd_profile.value('AR_RA_BATCH_SOURCE');

Line 135: trx_profile_rec.ar_batch_source := fnd_profile.value('AR_BATCH_SOURCE');

131: trx_profile_rec.ar_allow_tax_code_override := fnd_profile.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE');
132: trx_profile_rec.ar_allow_trx_line_exemptions := fnd_profile.value('ZX_ALLOW_TRX_LINE_EXEMPTIONS');
133: /* 4743228 - end */
134:
135: trx_profile_rec.ar_batch_source := fnd_profile.value('AR_BATCH_SOURCE');
136: trx_profile_rec.ar_ra_batch_source := fnd_profile.value('AR_RA_BATCH_SOURCE');
137: trx_profile_rec.ar_update_due_date := fnd_profile.value('AR_UPDATE_DUE_DATE');
138: trx_profile_rec.ussgl_option := NVL(fnd_profile.value('USSGL_OPTION'),'N');
139: trx_profile_rec.ar_allow_salescredit_update := fnd_profile.value('AR_ALLOW_SALESCREDIT_UPDATE');

Line 136: trx_profile_rec.ar_ra_batch_source := fnd_profile.value('AR_RA_BATCH_SOURCE');

132: trx_profile_rec.ar_allow_trx_line_exemptions := fnd_profile.value('ZX_ALLOW_TRX_LINE_EXEMPTIONS');
133: /* 4743228 - end */
134:
135: trx_profile_rec.ar_batch_source := fnd_profile.value('AR_BATCH_SOURCE');
136: trx_profile_rec.ar_ra_batch_source := fnd_profile.value('AR_RA_BATCH_SOURCE');
137: trx_profile_rec.ar_update_due_date := fnd_profile.value('AR_UPDATE_DUE_DATE');
138: trx_profile_rec.ussgl_option := NVL(fnd_profile.value('USSGL_OPTION'),'N');
139: trx_profile_rec.ar_allow_salescredit_update := fnd_profile.value('AR_ALLOW_SALESCREDIT_UPDATE');
140: trx_profile_rec.so_organization_id := oe_profile.value('SO_ORGANIZATION_ID');

Line 137: trx_profile_rec.ar_update_due_date := fnd_profile.value('AR_UPDATE_DUE_DATE');

133: /* 4743228 - end */
134:
135: trx_profile_rec.ar_batch_source := fnd_profile.value('AR_BATCH_SOURCE');
136: trx_profile_rec.ar_ra_batch_source := fnd_profile.value('AR_RA_BATCH_SOURCE');
137: trx_profile_rec.ar_update_due_date := fnd_profile.value('AR_UPDATE_DUE_DATE');
138: trx_profile_rec.ussgl_option := NVL(fnd_profile.value('USSGL_OPTION'),'N');
139: trx_profile_rec.ar_allow_salescredit_update := fnd_profile.value('AR_ALLOW_SALESCREDIT_UPDATE');
140: trx_profile_rec.so_organization_id := oe_profile.value('SO_ORGANIZATION_ID');
141: trx_profile_rec.so_source_code := oe_profile.value('SO_SOURCE_CODE');

Line 138: trx_profile_rec.ussgl_option := NVL(fnd_profile.value('USSGL_OPTION'),'N');

134:
135: trx_profile_rec.ar_batch_source := fnd_profile.value('AR_BATCH_SOURCE');
136: trx_profile_rec.ar_ra_batch_source := fnd_profile.value('AR_RA_BATCH_SOURCE');
137: trx_profile_rec.ar_update_due_date := fnd_profile.value('AR_UPDATE_DUE_DATE');
138: trx_profile_rec.ussgl_option := NVL(fnd_profile.value('USSGL_OPTION'),'N');
139: trx_profile_rec.ar_allow_salescredit_update := fnd_profile.value('AR_ALLOW_SALESCREDIT_UPDATE');
140: trx_profile_rec.so_organization_id := oe_profile.value('SO_ORGANIZATION_ID');
141: trx_profile_rec.so_source_code := oe_profile.value('SO_SOURCE_CODE');
142: trx_profile_rec.so_id_flex_code := oe_profile.value('SO_ID_FLEX_CODE');

Line 139: trx_profile_rec.ar_allow_salescredit_update := fnd_profile.value('AR_ALLOW_SALESCREDIT_UPDATE');

135: trx_profile_rec.ar_batch_source := fnd_profile.value('AR_BATCH_SOURCE');
136: trx_profile_rec.ar_ra_batch_source := fnd_profile.value('AR_RA_BATCH_SOURCE');
137: trx_profile_rec.ar_update_due_date := fnd_profile.value('AR_UPDATE_DUE_DATE');
138: trx_profile_rec.ussgl_option := NVL(fnd_profile.value('USSGL_OPTION'),'N');
139: trx_profile_rec.ar_allow_salescredit_update := fnd_profile.value('AR_ALLOW_SALESCREDIT_UPDATE');
140: trx_profile_rec.so_organization_id := oe_profile.value('SO_ORGANIZATION_ID');
141: trx_profile_rec.so_source_code := oe_profile.value('SO_SOURCE_CODE');
142: trx_profile_rec.so_id_flex_code := oe_profile.value('SO_ID_FLEX_CODE');
143: trx_profile_rec.ar_jg_create_bank_charges := NVL(fnd_profile.value('AR_JG_CREATE_BANK_CHARGES'),'N');

Line 143: trx_profile_rec.ar_jg_create_bank_charges := NVL(fnd_profile.value('AR_JG_CREATE_BANK_CHARGES'),'N');

139: trx_profile_rec.ar_allow_salescredit_update := fnd_profile.value('AR_ALLOW_SALESCREDIT_UPDATE');
140: trx_profile_rec.so_organization_id := oe_profile.value('SO_ORGANIZATION_ID');
141: trx_profile_rec.so_source_code := oe_profile.value('SO_SOURCE_CODE');
142: trx_profile_rec.so_id_flex_code := oe_profile.value('SO_ID_FLEX_CODE');
143: trx_profile_rec.ar_jg_create_bank_charges := NVL(fnd_profile.value('AR_JG_CREATE_BANK_CHARGES'),'N');
144:
145:
146: fnd_profile.get('AR_DEFAULT_EXCHANGE_RATE_TYPE', l_profile_value);
147: IF (l_profile_value IS NOT NULL) THEN

Line 146: fnd_profile.get('AR_DEFAULT_EXCHANGE_RATE_TYPE', l_profile_value);

142: trx_profile_rec.so_id_flex_code := oe_profile.value('SO_ID_FLEX_CODE');
143: trx_profile_rec.ar_jg_create_bank_charges := NVL(fnd_profile.value('AR_JG_CREATE_BANK_CHARGES'),'N');
144:
145:
146: fnd_profile.get('AR_DEFAULT_EXCHANGE_RATE_TYPE', l_profile_value);
147: IF (l_profile_value IS NOT NULL) THEN
148: BEGIN
149: SELECT user_conversion_type
150: INTO l_user_conversion_type

Line 156: FROM FND_PROFILE_OPTIONS_VL

152: WHERE conversion_type = l_profile_value;
153:
154: SELECT user_profile_option_name
155: INTO l_user_profile_option_name
156: FROM FND_PROFILE_OPTIONS_VL
157: WHERE application_id = 222
158: AND profile_option_name = 'AR_DEFAULT_EXCHANGE_RATE_TYPE';
159:
160: