[Home] [Help]
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)
290: ELSE
291: G_LOG_REPORT_TABLE(I).request_status := NULL;
292: --Changes for bug 9793691: ignore the count contributed by entries with request_id -1
293: --if "CST: Period Summary" is set to Manual(2) or NULL.
294: if (G_LOG_REPORT_TABLE(I).request_id <> -1 or FND_PROFILE.VALUE('CST_PERIOD_SUMMARY') = '1')
295: then
296: l_count := NVL(l_count,0) + 1;
297: end if;
298: END IF;
1223: );
1224: END IF;
1225:
1226: l_count := 1 ;
1227: l_login_id := NVL(TO_NUMBER(FND_PROFILE.Value('LOGIN_ID')),1) ;
1228: l_user_id := NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),1) ;
1229:
1230: BEGIN
1231: /* Bug: 3638081. Following query is modifed and view org_organization_definitions is replaced with its definition.
1224: END IF;
1225:
1226: l_count := 1 ;
1227: l_login_id := NVL(TO_NUMBER(FND_PROFILE.Value('LOGIN_ID')),1) ;
1228: l_user_id := NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),1) ;
1229:
1230: BEGIN
1231: /* Bug: 3638081. Following query is modifed and view org_organization_definitions is replaced with its definition.
1232: SELECT
2216: -- open date is past otherwise period can not be closed.
2217:
2218: ELSIF NOT l_end_date_is_past THEN
2219:
2220: FND_PROFILE.GET('CST_ALLOW_EARLY_PERIOD_CLOSE',l_allow_close);
2221:
2222: IF l_allow_close = '1' THEN
2223: SELECT TO_NUMBER(HOI.org_information2)
2224: INTO l_legal_entity