DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on FND_PROFILE

Line 8: NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_CONCURRENT_ON'),'N') ;

4: -- Global Variables
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_RETROACTIVE_PRICING_PVT';
6: G_BULK_LIMIT number := 1000;
7: g_log_mode VARCHAR2(240) :=
8: NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_CONCURRENT_ON'),'N') ;
9: TYPE g_agreement_cur_type IS REF CURSOR;
10: TYPE num_table is table of number index by binary_integer;
11: TYPE char30_table is table of varchar2(30) index by binary_integer;
12: TYPE date_table is table of date index by binary_integer;

Line 45: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

41:
42: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
43: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
44: -- Read the profile option that enables/disables the debug log
45: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
46:
47: -- Bug 3231062
48: g_projects_11i10_installed CONSTANT VARCHAR2(1) :=
49: PA_PO_INTEGRATION.is_pjc_11i10_enabled;

Line 603: FND_PROFILE.get('QP_LICENSED_FOR_PRODUCT',l_qp_license);

599: l_qp_license_on VARCHAR2(240) := NULL;
600:
601: BEGIN
602: --Bug 4176111: Set the variable based on profile value for Adv Pricing API
603: FND_PROFILE.get('QP_LICENSED_FOR_PRODUCT',l_qp_license);
604: IF (l_qp_license IS NULL OR l_qp_license <> 'PO') THEN
605: l_qp_license_on := 'N';
606: l_retro_date_clause := 'and pol.retroactive_date is not null ';
607: ELSE

Line 3080: FND_PROFILE.get('PO_ALLOW_RETROPRICING_OF_PO',l_retroactive_update);

3076: IF g_debug_stmt THEN
3077: PO_DEBUG.debug_begin(l_log_head);
3078: END IF;
3079:
3080: FND_PROFILE.get('PO_ALLOW_RETROPRICING_OF_PO',l_retroactive_update);
3081: IF (l_retroactive_update IS NULL) THEN
3082: l_retroactive_update := 'NEVER';
3083: END IF; /* IF (l_retroactive_update IS NULL) */
3084: