APPS.CSTPPINV dependencies on FND_PROFILE

Line 4: l_debug CONSTANT VARCHAR2(1) := FND_PROFILE.VALUE('MRP_DEBUG');

1: PACKAGE BODY CSTPPINV AS
2: /* $Header: CSTPINVB.pls 120.27.12010000.3 2008/10/29 13:00:19 lchevala ship $ */
3:
4: l_debug CONSTANT VARCHAR2(1) := FND_PROFILE.VALUE('MRP_DEBUG');
5:
6:
7: PROCEDURE cost_inv_txn (
8: i_pac_period_id IN NUMBER,

Line 780: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)

776: l_stmt_num := 20;
777:
778: /* Get the profile status for Internal Sales Order. */
779: BEGIN
780: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
781: INTO l_tprice_option
782: FROM mtl_intercompany_parameters MIP
783: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
784: AND MIP.flow_type = 1

Line 783: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1

779: BEGIN
780: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
781: INTO l_tprice_option
782: FROM mtl_intercompany_parameters MIP
783: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
784: AND MIP.flow_type = 1
785: AND MIP.ship_organization_id = (SELECT to_number(HOI.org_information3)
786: FROM hr_organization_information HOI
787: WHERE HOI.organization_id = l_from_org

Line 2221: FND_PROFILE.get('CURRENCY_CONVERSION_TYPE', l_curr_type);

2217: FROM mtl_material_transactions
2218: WHERE transaction_id = i_txn_id;
2219:
2220: if (l_curr_type is NULL) then
2221: FND_PROFILE.get('CURRENCY_CONVERSION_TYPE', l_curr_type);
2222: end if;
2223:
2224: if (l_rcv_curr <> l_snd_curr) then
2225: l_stmt_num := 60;