DBA Data[Home] [Help]

APPS.FND_REQUEST dependencies on FND_GLOBAL

Line 500: Sysdate, FND_GLOBAL.conc_login_id, Sysdate,

496: argument81, argument82, argument83, argument84, argument85,
497: argument86, argument87, argument88, argument89, argument90,
498: argument91, argument92, argument93, argument94, argument95,
499: argument96, argument97, argument98, argument99, argument100,
500: Sysdate, FND_GLOBAL.conc_login_id, Sysdate,
501: FND_GLOBAL.conc_login_id, FND_GLOBAL.conc_login_id
502: From Fnd_Application FA,
503: Fnd_Concurrent_Programs FCP
504: Where

Line 501: FND_GLOBAL.conc_login_id, FND_GLOBAL.conc_login_id

497: argument86, argument87, argument88, argument89, argument90,
498: argument91, argument92, argument93, argument94, argument95,
499: argument96, argument97, argument98, argument99, argument100,
500: Sysdate, FND_GLOBAL.conc_login_id, Sysdate,
501: FND_GLOBAL.conc_login_id, FND_GLOBAL.conc_login_id
502: From Fnd_Application FA,
503: Fnd_Concurrent_Programs FCP
504: Where
505: FCP.Enabled_Flag = 'Y'

Line 532: fgloginid := fnd_global.login_id;

528: -- Get info. about requests origination
529: -- If being submitted from another concurrent request get parent
530: -- request information.
531:
532: fgloginid := fnd_global.login_id;
533: par_request_id := FND_GLOBAL.conc_request_id;
534:
535: z_security_group_id := FND_GLOBAL.security_group_id;
536:

Line 533: par_request_id := FND_GLOBAL.conc_request_id;

529: -- If being submitted from another concurrent request get parent
530: -- request information.
531:
532: fgloginid := fnd_global.login_id;
533: par_request_id := FND_GLOBAL.conc_request_id;
534:
535: z_security_group_id := FND_GLOBAL.security_group_id;
536:
537:

Line 535: z_security_group_id := FND_GLOBAL.security_group_id;

531:
532: fgloginid := fnd_global.login_id;
533: par_request_id := FND_GLOBAL.conc_request_id;
534:
535: z_security_group_id := FND_GLOBAL.security_group_id;
536:
537:
538: if (par_request_id > 0) then
539: has_parent := TRUE;

Line 540: pri_request_id := FND_GLOBAL.conc_priority_request;

536:
537:
538: if (par_request_id > 0) then
539: has_parent := TRUE;
540: pri_request_id := FND_GLOBAL.conc_priority_request;
541:
542: -- bug 4438376. check whether the trace is enabled for the parent request.
543: -- if enabled, then enable the trace for child request also
544:

Line 551: loginid := FND_GLOBAL.conc_login_id;

547: else
548: trace_enabled := 'N';
549: end if;
550:
551: loginid := FND_GLOBAL.conc_login_id;
552:
553: if (loginid is null) then
554: loginid := 0;
555:

Line 575: subloginid := FND_GLOBAL.login_id;

571: end if; -- (loginid is null)
572:
573: else -- request being submitted from forms session
574: -- Get LOGIN_ID
575: subloginid := FND_GLOBAL.login_id;
576: pri_request_id := cur_request_id;
577:
578: end if; -- (par_request_id > 0)
579:

Line 589: user_id := FND_GLOBAL.user_id;

585: else
586: cur_req_pri_id := cur_request_id;
587: end if;
588:
589: user_id := FND_GLOBAL.user_id;
590:
591: if (user_id is null) then
592: user_id := -1;
593: end if;

Line 595: resp_id := FND_GLOBAL.resp_id;

591: if (user_id is null) then
592: user_id := -1;
593: end if;
594:
595: resp_id := FND_GLOBAL.resp_id;
596:
597: if (resp_id is null) then
598: resp_id := -1;
599: end if;

Line 601: resp_appl_id := FND_GLOBAL.resp_appl_id;

597: if (resp_id is null) then
598: resp_id := -1;
599: end if;
600:
601: resp_appl_id := FND_GLOBAL.resp_appl_id;
602:
603: if (resp_appl_id is null) then
604: resp_appl_id := -1;
605: end if;

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

1911: end if; -- (subloginid is not null)
1912:
1913: -- Submitted request successfully
1914:
1915: -- Call FND_GLOBAL.RT_TEST_ID() to see if needs to write the request
1916: -- id into FND_RT_REQUESTS table.
1917: rttestid := FND_GLOBAL.RT_TEST_ID;
1918: if (rttestid <> -1) then
1919: FND_RT_REQUEST.LOG_REQUEST(rttestid, cur_request_id);

Line 1917: rttestid := FND_GLOBAL.RT_TEST_ID;

1913: -- Submitted request successfully
1914:
1915: -- Call FND_GLOBAL.RT_TEST_ID() to see if needs to write the request
1916: -- id into FND_RT_REQUESTS table.
1917: rttestid := FND_GLOBAL.RT_TEST_ID;
1918: if (rttestid <> -1) then
1919: FND_RT_REQUEST.LOG_REQUEST(rttestid, cur_request_id);
1920: end if;
1921: IF (P_USES_REL_CLASS = 1 AND schedule_type = 'X') THEN

Line 2682: reqid := FND_GLOBAL.conc_request_id;

2678: and action_type = 2
2679: order by sequence;
2680: begin
2681: -- get current request id
2682: reqid := FND_GLOBAL.conc_request_id;
2683:
2684: if ((reqid <= 0) or (reqid is null))
2685: then
2686: init_pvt_vars;

Line 3825: 'Y', SYSDATE, FND_GLOBAL.USER_ID,

3821: LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY,
3822: UPDATED_FLAG, DATE1, DATE2,
3823: CLASS_TYPE, CLASS_INFO)
3824: VALUES (P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID, P_RELEASE_CLASS_NAME,
3825: 'Y', SYSDATE, FND_GLOBAL.USER_ID,
3826: FND_GLOBAL.CONC_LOGIN_ID, SYSDATE, FND_GLOBAL.USER_ID,
3827: 'Y', decode(P_REPEAT_START_DATE, null, SYSDATE, P_REPEAT_START_DATE), P_REPEAT_END_DATE,
3828: P_CLASS_TYPE, DECODE(P_CLASS_TYPE, 'P', P_REPEAT_VALUE, P_CLASS_INFO));
3829:

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

3822: UPDATED_FLAG, DATE1, DATE2,
3823: CLASS_TYPE, CLASS_INFO)
3824: VALUES (P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID, P_RELEASE_CLASS_NAME,
3825: 'Y', SYSDATE, FND_GLOBAL.USER_ID,
3826: FND_GLOBAL.CONC_LOGIN_ID, SYSDATE, FND_GLOBAL.USER_ID,
3827: 'Y', decode(P_REPEAT_START_DATE, null, SYSDATE, P_REPEAT_START_DATE), P_REPEAT_END_DATE,
3828: P_CLASS_TYPE, DECODE(P_CLASS_TYPE, 'P', P_REPEAT_VALUE, P_CLASS_INFO));
3829:
3830: if (sql%rowcount = 0) then

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

3837: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
3838: CREATION_DATE, CREATED_BY, DESCRIPTION)
3839: SELECT P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID,
3840: L.LANGUAGE_CODE, USERENV('LANG'), P_RELEASE_CLASS_NAME,
3841: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
3842: SYSDATE, FND_GLOBAL.USER_ID, P_DESCRIPTION
3843: FROM FND_LANGUAGES L
3844: WHERE L.INSTALLED_FLAG in ('I', 'B');
3845:

Line 3842: SYSDATE, FND_GLOBAL.USER_ID, P_DESCRIPTION

3838: CREATION_DATE, CREATED_BY, DESCRIPTION)
3839: SELECT P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID,
3840: L.LANGUAGE_CODE, USERENV('LANG'), P_RELEASE_CLASS_NAME,
3841: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
3842: SYSDATE, FND_GLOBAL.USER_ID, P_DESCRIPTION
3843: FROM FND_LANGUAGES L
3844: WHERE L.INSTALLED_FLAG in ('I', 'B');
3845:
3846: if (sql%rowcount = 0) then