DBA Data[Home] [Help]

APPS.AME_UTILITY_PKG dependencies on FND_GLOBAL

Line 19: tempstring := ' ' || replace(replace(replace(queryStringIn,fnd_global.local_chr(10),' '),

15: errInBindVar boolean := true;
16: invalidBindException exception;
17: begin
18: --+
19: tempstring := ' ' || replace(replace(replace(queryStringIn,fnd_global.local_chr(10),' '),
20: fnd_global.local_chr(13),' '),' ',' ') || ' ';
21: col1Position := instrb(tempstring, ':', 1) ;
22: --+
23: while col1Position > 0 loop

Line 20: fnd_global.local_chr(13),' '),' ',' ') || ' ';

16: invalidBindException exception;
17: begin
18: --+
19: tempstring := ' ' || replace(replace(replace(queryStringIn,fnd_global.local_chr(10),' '),
20: fnd_global.local_chr(13),' '),' ',' ') || ' ';
21: col1Position := instrb(tempstring, ':', 1) ;
22: --+
23: while col1Position > 0 loop
24: --+

Line 86: fnd_global.local_chr(10),

82: end if;
83:
84: /* Remove any new lines and replace with spaces */
85: temp_query_string := ' ' || replace(replace(replace(p_query_string,
86: fnd_global.local_chr(10),
87: ' '),
88: fnd_global.local_chr(13),
89: ' '),
90: ' ',

Line 88: fnd_global.local_chr(13),

84: /* Remove any new lines and replace with spaces */
85: temp_query_string := ' ' || replace(replace(replace(p_query_string,
86: fnd_global.local_chr(10),
87: ' '),
88: fnd_global.local_chr(13),
89: ' '),
90: ' ',
91: ' ') || ' ';
92:

Line 907: fnd_global.local_chr(10),

903: l_before_from,
904: instrb(lower(l_before_from),'select')+6
905: )
906: ),
907: fnd_global.local_chr(10),
908: '');
909:
910: l_column1 := substrb(l_before_from,1,instrb(l_before_from,',')-1);
911: l_before_from := substrb(l_before_from,instrb(l_before_from,',')+1);

Line 1498: if fnd_global.resp_name = 'AME Developer' then

1494: end get_rule_end_date;
1495:
1496: function check_seeddb return varchar2 as
1497: begin
1498: if fnd_global.resp_name = 'AME Developer' then
1499: return 'Y';
1500: end if;
1501: return 'N';
1502: end check_seeddb;

Line 1507: if fnd_global.resp_name = 'AME Developer' then

1503:
1504: function get_rule_id return number is
1505: l_rule_id number;
1506: begin
1507: if fnd_global.resp_name = 'AME Developer' then
1508: select min(rule_id) - 1
1509: into l_rule_id
1510: from ame_rules;
1511: else

Line 1522: if fnd_global.resp_name = 'AME Developer' then

1518:
1519: function get_condition_id return number is
1520: l_condition_id number;
1521: begin
1522: if fnd_global.resp_name = 'AME Developer' then
1523: select min(condition_id) - 1
1524: into l_condition_id
1525: from ame_conditions;
1526: else