DBA Data[Home] [Help]

APPS.CSI_ML_CREATE_PVT dependencies on FND_PROFILE

Line 47: l_enable_contracts_oi VARCHAR2(1) := NVL(FND_PROFILE.VALUE('CSI_ENABLE_CONTRACTS_FOR_MASS_LOAD'),'Y'); --bug#13072088

43: l_sql_error VARCHAR2(2000);
44: l_commit_recs NUMBER := 0;
45: l_txn_type_id NUMBER;
46: l_error_message VARCHAR2(2000);
47: l_enable_contracts_oi VARCHAR2(1) := NVL(FND_PROFILE.VALUE('CSI_ENABLE_CONTRACTS_FOR_MASS_LOAD'),'Y'); --bug#13072088
48:
49: a NUMBER := 0;
50: b NUMBER := 0;
51: c NUMBER := 0;

Line 57: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));

53: e NUMBER := 0;
54: f NUMBER := 0;
55: g NUMBER := 0;
56: h NUMBER := 0;
57: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
58:
59: CURSOR c_inst (pc_txn_from_date IN DATE,
60: pc_txn_to_date IN DATE,
61: pc_source_system_name IN VARCHAR2,

Line 2536: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));

2532: l_api_name VARCHAR2(255) :=
2533: 'CSI_ML_CREATE_PVT.GET_IFACE_REL_RECS';
2534:
2535: l_sql_error VARCHAR2(2000);
2536: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
2537:
2538: a NUMBER := 0;
2539:
2540: CURSOR c_rel (pc_txn_from_date IN DATE,