APPS.JE_ES_MODELO_EXT_PKG dependencies on FND_PROFILE

Line 1003: lv_decimal_separator := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),1,1); -- Bug 5525421

999: lv_decimal_separator varchar2 (1);
1000: begin
1001:
1002: /* Get the decimal separator from the profile */
1003: lv_decimal_separator := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),1,1); -- Bug 5525421
1004:
1005: -- lv_decimal_separator := '.';
1006: /** author: brathod
1007: date : 22/05/2006

Line 1389: AND CR.RECEIPT_METHOD_ID = fnd_profile.value('JEES_MOD347_RECEIPT_METHOD');

1385: ))
1386: OR (P_REPORT_NAME = 'JEESAMOR' AND JZVRS.tax_calendar_year = P_TAX_YEAR ))
1387: AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1388: AND JZVTD.trx_id = RA.APPLIED_CUSTOMER_TRX_ID
1389: AND CR.RECEIPT_METHOD_ID = fnd_profile.value('JEES_MOD347_RECEIPT_METHOD');
1390: ELSE
1391: SELECT SUM(NVL(DECODE(CR.type,'MISC', 0
1392: ,DECODE(RA.status,'APP',RA.AMOUNT_APPLIED,0)),0))
1393: / COUNT(JZVTD.trx_id)

Line 1447: AND CR.RECEIPT_METHOD_ID = fnd_profile.value('JEES_MOD347_RECEIPT_METHOD');

1443: ))
1444: OR (P_REPORT_NAME = 'JEESAMOR' AND JZVRS.tax_calendar_year = P_TAX_YEAR ))
1445: AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1446: AND JZVTD.trx_id = RA.APPLIED_CUSTOMER_TRX_ID
1447: AND CR.RECEIPT_METHOD_ID = fnd_profile.value('JEES_MOD347_RECEIPT_METHOD');
1448: END IF;
1449:
1450: RETURN( NVL(v_cash_received_amount,0));
1451:

Line 1505: AND CR.RECEIPT_METHOD_ID = fnd_profile.value('JEES_MOD347_RECEIPT_METHOD');

1501: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id
1502: AND P_REPORT_NAME = 'JEESAMOR' AND JZVRS.tax_calendar_year = P_TAX_YEAR
1503: AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1504: AND JZVTD.trx_id = RA.APPLIED_CUSTOMER_TRX_ID
1505: AND CR.RECEIPT_METHOD_ID = fnd_profile.value('JEES_MOD347_RECEIPT_METHOD');
1506:
1507:
1508: RETURN( NVL(v_cash_received_amount,0));
1509:

Line 3986: --fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));

3982: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q1 :='||ln_transmission_prop_amt_q1);
3983: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q2 :='||ln_transmission_prop_amt_q2);
3984: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q3 :='||ln_transmission_prop_amt_q3);
3985: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q4 :='||ln_transmission_prop_amt_q4);
3986: --fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));
3987: END IF;
3988:
3989: /* Bug 8485057 Transmission of property transactions are always different than property rental transactions */
3990: INSERT INTO JG_ZZ_VAT_TRX_GT

Line 4071: -- fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));

4067: , p_year_of_amts_rec_cash => ln_year_of_amts_received_cash);
4068:
4069: IF G_DEBUG THEN
4070: fnd_file.put_line(FND_FILE.LOG,'ln_cash_received_amount :='||ln_cash_received_amount);
4071: -- fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));
4072: END IF;
4073:
4074: INSERT INTO JG_ZZ_VAT_TRX_GT
4075: ( jg_info_v1 -- lc_clave_operation