30: position NUMBER;
31: l_aw_space_name VARCHAR2(30);
32:
33: BEGIN
34: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
35: fnd_log.string
36: (
37: FND_LOG.LEVEL_PROCEDURE,
38: 'fpa.sql.fpa_global_pvt.is_aw_attached.begin',
31: l_aw_space_name VARCHAR2(30);
32:
33: BEGIN
34: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
35: fnd_log.string
36: (
37: FND_LOG.LEVEL_PROCEDURE,
38: 'fpa.sql.fpa_global_pvt.is_aw_attached.begin',
39: 'Entering fpa_global_pvt.is_aw_attached'
33: BEGIN
34: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
35: fnd_log.string
36: (
37: FND_LOG.LEVEL_PROCEDURE,
38: 'fpa.sql.fpa_global_pvt.is_aw_attached.begin',
39: 'Entering fpa_global_pvt.is_aw_attached'
40: );
41: END IF;
48:
49: position := instr(text_buffer, 'yes', 1);
50: is_attached := position <> 0;
51:
52: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
53: fnd_log.string
54: (
55: FND_LOG.LEVEL_STATEMENT,
56: 'fpa.sql.fpa_global_pvt.is_aw_attached.begin',
49: position := instr(text_buffer, 'yes', 1);
50: is_attached := position <> 0;
51:
52: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
53: fnd_log.string
54: (
55: FND_LOG.LEVEL_STATEMENT,
56: 'fpa.sql.fpa_global_pvt.is_aw_attached.begin',
57: 'Is AW attached: ' || text_buffer
51:
52: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
53: fnd_log.string
54: (
55: FND_LOG.LEVEL_STATEMENT,
56: 'fpa.sql.fpa_global_pvt.is_aw_attached.begin',
57: 'Is AW attached: ' || text_buffer
58: );
59: END IF;
63: RETURN TRUE;
64: ELSE
65: RETURN FALSE;
66: END IF;
67: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
68: fnd_log.string
69: (
70: FND_LOG.LEVEL_PROCEDURE,
71: 'fpa.sql.fpa_global_pvt.is_aw_attached.end',
64: ELSE
65: RETURN FALSE;
66: END IF;
67: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
68: fnd_log.string
69: (
70: FND_LOG.LEVEL_PROCEDURE,
71: 'fpa.sql.fpa_global_pvt.is_aw_attached.end',
72: 'Exiting fpa_global_pvt.is_aw_attached'
66: END IF;
67: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
68: fnd_log.string
69: (
70: FND_LOG.LEVEL_PROCEDURE,
71: 'fpa.sql.fpa_global_pvt.is_aw_attached.end',
72: 'Exiting fpa_global_pvt.is_aw_attached'
73: );
74: END IF;