APPS.INV_MGD_PRD_CONTROL_MEDIATOR dependencies on FND_PROFILE

Line 94: G_DEBUG VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');

90: /* Variable g_log_mode is commented becasue it is no more in use.
91: It was done during bug:3638081 fix to resolve GSCC warning
92: g_log_mode VARCHAR2(3) := 'OFF'; -- possible values: OFF,SQL,SRS
93: */
94: G_DEBUG VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
95:
96: TYPE LRGOS_REPORT_REC IS RECORD
97: ( org VARCHAR2(240)
98: , period VARCHAR2(30)

Line 1213: l_login_id := NVL(TO_NUMBER(FND_PROFILE.Value('LOGIN_ID')),1) ;

1209: );
1210: END IF;
1211:
1212: l_count := 1 ;
1213: l_login_id := NVL(TO_NUMBER(FND_PROFILE.Value('LOGIN_ID')),1) ;
1214: l_user_id := NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),1) ;
1215:
1216: BEGIN
1217: /* Bug: 3638081. Following query is modifed and view org_organization_definitions is replaced with its definition.

Line 1214: l_user_id := NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),1) ;

1210: END IF;
1211:
1212: l_count := 1 ;
1213: l_login_id := NVL(TO_NUMBER(FND_PROFILE.Value('LOGIN_ID')),1) ;
1214: l_user_id := NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),1) ;
1215:
1216: BEGIN
1217: /* Bug: 3638081. Following query is modifed and view org_organization_definitions is replaced with its definition.
1218: SELECT

Line 2017: FND_PROFILE.GET('CST_ALLOW_EARLY_PERIOD_CLOSE',l_allow_close);

2013: -- open date is past otherwise period can not be closed.
2014:
2015: ELSIF NOT l_end_date_is_past THEN
2016:
2017: FND_PROFILE.GET('CST_ALLOW_EARLY_PERIOD_CLOSE',l_allow_close);
2018:
2019: IF l_allow_close = '1' THEN
2020: SELECT TO_NUMBER(HOI.org_information2)
2021: INTO l_legal_entity