DBA Data[Home] [Help]

APPS.FND_REQUEST dependencies on FND_GLOBAL

Line 549: Sysdate, FND_GLOBAL.conc_login_id, Sysdate,

545: argument81, argument82, argument83, argument84, argument85,
546: argument86, argument87, argument88, argument89, argument90,
547: argument91, argument92, argument93, argument94, argument95,
548: argument96, argument97, argument98, argument99, argument100,
549: Sysdate, FND_GLOBAL.conc_login_id, Sysdate,
550: FND_GLOBAL.conc_login_id, FND_GLOBAL.conc_login_id
551: From Fnd_Application FA,
552: Fnd_Concurrent_Programs FCP
553: Where

Line 550: FND_GLOBAL.conc_login_id, FND_GLOBAL.conc_login_id

546: argument86, argument87, argument88, argument89, argument90,
547: argument91, argument92, argument93, argument94, argument95,
548: argument96, argument97, argument98, argument99, argument100,
549: Sysdate, FND_GLOBAL.conc_login_id, Sysdate,
550: FND_GLOBAL.conc_login_id, FND_GLOBAL.conc_login_id
551: From Fnd_Application FA,
552: Fnd_Concurrent_Programs FCP
553: Where
554: FCP.Enabled_Flag = 'Y'

Line 581: fgloginid := fnd_global.login_id;

577: -- Get info. about requests origination
578: -- If being submitted from another concurrent request get parent
579: -- request information.
580:
581: fgloginid := fnd_global.login_id;
582: par_request_id := FND_GLOBAL.conc_request_id;
583:
584: z_security_group_id := FND_GLOBAL.security_group_id;
585:

Line 582: par_request_id := FND_GLOBAL.conc_request_id;

578: -- If being submitted from another concurrent request get parent
579: -- request information.
580:
581: fgloginid := fnd_global.login_id;
582: par_request_id := FND_GLOBAL.conc_request_id;
583:
584: z_security_group_id := FND_GLOBAL.security_group_id;
585:
586:

Line 584: z_security_group_id := FND_GLOBAL.security_group_id;

580:
581: fgloginid := fnd_global.login_id;
582: par_request_id := FND_GLOBAL.conc_request_id;
583:
584: z_security_group_id := FND_GLOBAL.security_group_id;
585:
586:
587: if (par_request_id > 0) then
588: has_parent := TRUE;

Line 589: pri_request_id := FND_GLOBAL.conc_priority_request;

585:
586:
587: if (par_request_id > 0) then
588: has_parent := TRUE;
589: pri_request_id := FND_GLOBAL.conc_priority_request;
590:
591: -- bug 4438376. check whether the trace is enabled for the parent request.
592: -- if enabled, then enable the trace for child request also
593:

Line 600: loginid := FND_GLOBAL.conc_login_id;

596: else
597: trace_enabled := 'N';
598: end if;
599:
600: loginid := FND_GLOBAL.conc_login_id;
601:
602: if (loginid is null) then
603: loginid := 0;
604:

Line 624: subloginid := FND_GLOBAL.login_id;

620: end if; -- (loginid is null)
621:
622: else -- request being submitted from forms session
623: -- Get LOGIN_ID
624: subloginid := FND_GLOBAL.login_id;
625: pri_request_id := cur_request_id;
626:
627: end if; -- (par_request_id > 0)
628:

Line 638: user_id := FND_GLOBAL.user_id;

634: else
635: cur_req_pri_id := cur_request_id;
636: end if;
637:
638: user_id := FND_GLOBAL.user_id;
639:
640: if (user_id is null) then
641: user_id := -1;
642: end if;

Line 644: resp_id := FND_GLOBAL.resp_id;

640: if (user_id is null) then
641: user_id := -1;
642: end if;
643:
644: resp_id := FND_GLOBAL.resp_id;
645:
646: if (resp_id is null) then
647: resp_id := -1;
648: end if;

Line 650: resp_appl_id := FND_GLOBAL.resp_appl_id;

646: if (resp_id is null) then
647: resp_id := -1;
648: end if;
649:
650: resp_appl_id := FND_GLOBAL.resp_appl_id;
651:
652: if (resp_appl_id is null) then
653: resp_appl_id := -1;
654: end if;

Line 2020: -- Call FND_GLOBAL.RT_TEST_ID() to see if needs to write the request

2016: end if; -- (subloginid is not null)
2017:
2018: -- Submitted request successfully
2019:
2020: -- Call FND_GLOBAL.RT_TEST_ID() to see if needs to write the request
2021: -- id into FND_RT_REQUESTS table.
2022: rttestid := FND_GLOBAL.RT_TEST_ID;
2023: if (rttestid <> -1) then
2024: FND_RT_REQUEST.LOG_REQUEST(rttestid, cur_request_id);

Line 2022: rttestid := FND_GLOBAL.RT_TEST_ID;

2018: -- Submitted request successfully
2019:
2020: -- Call FND_GLOBAL.RT_TEST_ID() to see if needs to write the request
2021: -- id into FND_RT_REQUESTS table.
2022: rttestid := FND_GLOBAL.RT_TEST_ID;
2023: if (rttestid <> -1) then
2024: FND_RT_REQUEST.LOG_REQUEST(rttestid, cur_request_id);
2025: end if;
2026: IF (P_USES_REL_CLASS = 1 AND schedule_type = 'X') THEN

Line 2424: FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID,

2420: ( reqid,
2421: P_NLS_PARAMETERS(i).nls_lang,
2422: P_NLS_PARAMETERS(i).nls_territory,
2423: P_NLS_PARAMETERS(i).nls_num_char,
2424: FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID,
2425: sysdate, FND_GLOBAL.CONC_LOGIN_ID);
2426:
2427: end loop;
2428: end if;

Line 2425: sysdate, FND_GLOBAL.CONC_LOGIN_ID);

2421: P_NLS_PARAMETERS(i).nls_lang,
2422: P_NLS_PARAMETERS(i).nls_territory,
2423: P_NLS_PARAMETERS(i).nls_num_char,
2424: FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID,
2425: sysdate, FND_GLOBAL.CONC_LOGIN_ID);
2426:
2427: end loop;
2428: end if;
2429:

Line 3241: reqid := FND_GLOBAL.conc_request_id;

3237: and action_type = 2
3238: order by sequence;
3239: begin
3240: -- get current request id
3241: reqid := FND_GLOBAL.conc_request_id;
3242:
3243: if ((reqid <= 0) or (reqid is null))
3244: then
3245: init_pvt_vars;

Line 4513: P_ENABLED_FLAG, SYSDATE, FND_GLOBAL.USER_ID,

4509: LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY,
4510: UPDATED_FLAG, DATE1, DATE2,
4511: CLASS_TYPE, CLASS_INFO)
4512: VALUES (P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID, P_RELEASE_CLASS_NAME,
4513: P_ENABLED_FLAG, SYSDATE, FND_GLOBAL.USER_ID,
4514: FND_GLOBAL.CONC_LOGIN_ID, SYSDATE, FND_GLOBAL.USER_ID,
4515: 'Y', decode(P_REPEAT_START_DATE, null, SYSDATE, P_REPEAT_START_DATE), P_REPEAT_END_DATE,
4516: P_CLASS_TYPE, DECODE(P_CLASS_TYPE, 'P', P_REPEAT_VALUE, P_CLASS_INFO));
4517:

Line 4514: FND_GLOBAL.CONC_LOGIN_ID, SYSDATE, FND_GLOBAL.USER_ID,

4510: UPDATED_FLAG, DATE1, DATE2,
4511: CLASS_TYPE, CLASS_INFO)
4512: VALUES (P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID, P_RELEASE_CLASS_NAME,
4513: P_ENABLED_FLAG, SYSDATE, FND_GLOBAL.USER_ID,
4514: FND_GLOBAL.CONC_LOGIN_ID, SYSDATE, FND_GLOBAL.USER_ID,
4515: 'Y', decode(P_REPEAT_START_DATE, null, SYSDATE, P_REPEAT_START_DATE), P_REPEAT_END_DATE,
4516: P_CLASS_TYPE, DECODE(P_CLASS_TYPE, 'P', P_REPEAT_VALUE, P_CLASS_INFO));
4517:
4518: if (sql%rowcount = 0) then

Line 4529: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,

4525: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
4526: CREATION_DATE, CREATED_BY, DESCRIPTION)
4527: SELECT P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID,
4528: L.LANGUAGE_CODE, USERENV('LANG'), P_RELEASE_CLASS_NAME,
4529: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4530: SYSDATE, FND_GLOBAL.USER_ID, P_DESCRIPTION
4531: FROM FND_LANGUAGES L
4532: WHERE L.INSTALLED_FLAG in ('I', 'B');
4533:

Line 4530: SYSDATE, FND_GLOBAL.USER_ID, P_DESCRIPTION

4526: CREATION_DATE, CREATED_BY, DESCRIPTION)
4527: SELECT P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID,
4528: L.LANGUAGE_CODE, USERENV('LANG'), P_RELEASE_CLASS_NAME,
4529: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4530: SYSDATE, FND_GLOBAL.USER_ID, P_DESCRIPTION
4531: FROM FND_LANGUAGES L
4532: WHERE L.INSTALLED_FLAG in ('I', 'B');
4533:
4534: if (sql%rowcount = 0) then

Line 4614: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

4610: 'START', 'S', 'C')), NULL)) INTO P_REPEAT_VALUE FROM SYS.DUAL;
4611:
4612: UPDATE FND_CONC_RELEASE_CLASSES
4613: set LAST_UPDATE_DATE = SYSDATE,
4614: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4615: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
4616: DATE1 = decode(P_REPEAT_START_DATE, null, SYSDATE, P_REPEAT_START_DATE),
4617: DATE2 = P_REPEAT_END_DATE,
4618: CLASS_TYPE = P_CLASS_TYPE,

Line 4615: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

4611:
4612: UPDATE FND_CONC_RELEASE_CLASSES
4613: set LAST_UPDATE_DATE = SYSDATE,
4614: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4615: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
4616: DATE1 = decode(P_REPEAT_START_DATE, null, SYSDATE, P_REPEAT_START_DATE),
4617: DATE2 = P_REPEAT_END_DATE,
4618: CLASS_TYPE = P_CLASS_TYPE,
4619: CLASS_INFO = DECODE(P_CLASS_TYPE, 'P', P_REPEAT_VALUE, P_CLASS_INFO),