DBA Data[Home] [Help]

APPS.ARP_GLOBAL dependencies on FND_GLOBAL

Line 17: user_id := nvl(FND_GLOBAL.user_id,-1);

13: BEGIN
14: --
15: arp_util.debug( 'arp_global.init_global()+' );
16: --
17: user_id := nvl(FND_GLOBAL.user_id,-1);
18: created_by := nvl(FND_GLOBAL.user_id,-1);
19: creation_date := SYSDATE;
20: last_updated_by := nvl(FND_GLOBAL.user_id,-1);
21: last_update_date := SYSDATE;

Line 18: created_by := nvl(FND_GLOBAL.user_id,-1);

14: --
15: arp_util.debug( 'arp_global.init_global()+' );
16: --
17: user_id := nvl(FND_GLOBAL.user_id,-1);
18: created_by := nvl(FND_GLOBAL.user_id,-1);
19: creation_date := SYSDATE;
20: last_updated_by := nvl(FND_GLOBAL.user_id,-1);
21: last_update_date := SYSDATE;
22: last_update_login := nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id);

Line 20: last_updated_by := nvl(FND_GLOBAL.user_id,-1);

16: --
17: user_id := nvl(FND_GLOBAL.user_id,-1);
18: created_by := nvl(FND_GLOBAL.user_id,-1);
19: creation_date := SYSDATE;
20: last_updated_by := nvl(FND_GLOBAL.user_id,-1);
21: last_update_date := SYSDATE;
22: last_update_login := nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id);
23: --
24: IF ( FND_GLOBAL.conc_request_id = -1 ) OR

Line 22: last_update_login := nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id);

18: created_by := nvl(FND_GLOBAL.user_id,-1);
19: creation_date := SYSDATE;
20: last_updated_by := nvl(FND_GLOBAL.user_id,-1);
21: last_update_date := SYSDATE;
22: last_update_login := nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id);
23: --
24: IF ( FND_GLOBAL.conc_request_id = -1 ) OR
25: ( FND_GLOBAL.conc_request_id IS NULL )
26: THEN

Line 24: IF ( FND_GLOBAL.conc_request_id = -1 ) OR

20: last_updated_by := nvl(FND_GLOBAL.user_id,-1);
21: last_update_date := SYSDATE;
22: last_update_login := nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id);
23: --
24: IF ( FND_GLOBAL.conc_request_id = -1 ) OR
25: ( FND_GLOBAL.conc_request_id IS NULL )
26: THEN
27: request_id := NULL;
28: ELSE

Line 25: ( FND_GLOBAL.conc_request_id IS NULL )

21: last_update_date := SYSDATE;
22: last_update_login := nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id);
23: --
24: IF ( FND_GLOBAL.conc_request_id = -1 ) OR
25: ( FND_GLOBAL.conc_request_id IS NULL )
26: THEN
27: request_id := NULL;
28: ELSE
29: request_id := FND_GLOBAL.conc_request_id;

Line 29: request_id := FND_GLOBAL.conc_request_id;

25: ( FND_GLOBAL.conc_request_id IS NULL )
26: THEN
27: request_id := NULL;
28: ELSE
29: request_id := FND_GLOBAL.conc_request_id;
30: END IF;
31: --
32: IF ( FND_GLOBAL.conc_program_id = -1 ) OR
33: ( FND_GLOBAL.conc_program_id IS NULL )

Line 32: IF ( FND_GLOBAL.conc_program_id = -1 ) OR

28: ELSE
29: request_id := FND_GLOBAL.conc_request_id;
30: END IF;
31: --
32: IF ( FND_GLOBAL.conc_program_id = -1 ) OR
33: ( FND_GLOBAL.conc_program_id IS NULL )
34: THEN
35: program_id := NULL;
36: ELSE

Line 33: ( FND_GLOBAL.conc_program_id IS NULL )

29: request_id := FND_GLOBAL.conc_request_id;
30: END IF;
31: --
32: IF ( FND_GLOBAL.conc_program_id = -1 ) OR
33: ( FND_GLOBAL.conc_program_id IS NULL )
34: THEN
35: program_id := NULL;
36: ELSE
37: program_id := FND_GLOBAL.conc_program_id;

Line 37: program_id := FND_GLOBAL.conc_program_id;

33: ( FND_GLOBAL.conc_program_id IS NULL )
34: THEN
35: program_id := NULL;
36: ELSE
37: program_id := FND_GLOBAL.conc_program_id;
38: END IF;
39: --
40: IF ( FND_GLOBAL.prog_appl_id = -1 ) OR
41: ( FND_GLOBAL.prog_appl_id IS NULL )

Line 40: IF ( FND_GLOBAL.prog_appl_id = -1 ) OR

36: ELSE
37: program_id := FND_GLOBAL.conc_program_id;
38: END IF;
39: --
40: IF ( FND_GLOBAL.prog_appl_id = -1 ) OR
41: ( FND_GLOBAL.prog_appl_id IS NULL )
42: THEN
43: program_application_id := NULL;
44: ELSE

Line 41: ( FND_GLOBAL.prog_appl_id IS NULL )

37: program_id := FND_GLOBAL.conc_program_id;
38: END IF;
39: --
40: IF ( FND_GLOBAL.prog_appl_id = -1 ) OR
41: ( FND_GLOBAL.prog_appl_id IS NULL )
42: THEN
43: program_application_id := NULL;
44: ELSE
45: program_application_id := FND_GLOBAL.prog_appl_id;

Line 45: program_application_id := FND_GLOBAL.prog_appl_id;

41: ( FND_GLOBAL.prog_appl_id IS NULL )
42: THEN
43: program_application_id := NULL;
44: ELSE
45: program_application_id := FND_GLOBAL.prog_appl_id;
46: END IF;
47: --
48: IF ( program_id IS NULL )
49: THEN

Line 295: IF fnd_global.conc_program_id IS NOT NULL

291: END IF;
292: /* Bug 4624926 API failing in R12-Ends*/
293: /*Bug 3678916*/
294:
295: IF fnd_global.conc_program_id IS NOT NULL
296: THEN
297: BEGIN
298:
299: SELECT concurrent_program_name

Line 302: WHERE concurrent_program_id = fnd_global.conc_program_id

298:
299: SELECT concurrent_program_name
300: INTO conc_program_name
301: FROM fnd_concurrent_programs_vl
302: WHERE concurrent_program_id = fnd_global.conc_program_id
303: AND application_id = 222;
304:
305: EXCEPTION
306: WHEN others THEN