APPS.AD_PATCH_LEVEL dependencies on DBMS_SQL

Line 19: c := dbms_sql.open_cursor;

15: l_patch_level varchar2(30);
16:
17: begin
18:
19: c := dbms_sql.open_cursor;
20:
21: c_statement:= 'SELECT PI.PATCH_LEVEL FROM ' ||
22: 'FND_PRODUCT_INSTALLATIONS PI, FND_APPLICATION FA ' ||
23: 'WHERE FA.APPLICATION_ID = PI.APPLICATION_ID AND ' ||

Line 27: dbms_sql.parse(c, c_statement, dbms_sql.native);

23: 'WHERE FA.APPLICATION_ID = PI.APPLICATION_ID AND ' ||
24: 'UPPER(APPLICATION_SHORT_NAME)=' ||
25: 'UPPER(:short_name)';
26:
27: dbms_sql.parse(c, c_statement, dbms_sql.native);
28: dbms_sql.bind_variable(c,'short_name',apps_short_name);
29: dbms_sql.define_column(c,1,l_patch_level,30);
30:
31: rows_processed := dbms_sql.execute(c);

Line 28: dbms_sql.bind_variable(c,'short_name',apps_short_name);

24: 'UPPER(APPLICATION_SHORT_NAME)=' ||
25: 'UPPER(:short_name)';
26:
27: dbms_sql.parse(c, c_statement, dbms_sql.native);
28: dbms_sql.bind_variable(c,'short_name',apps_short_name);
29: dbms_sql.define_column(c,1,l_patch_level,30);
30:
31: rows_processed := dbms_sql.execute(c);
32:

Line 29: dbms_sql.define_column(c,1,l_patch_level,30);

25: 'UPPER(:short_name)';
26:
27: dbms_sql.parse(c, c_statement, dbms_sql.native);
28: dbms_sql.bind_variable(c,'short_name',apps_short_name);
29: dbms_sql.define_column(c,1,l_patch_level,30);
30:
31: rows_processed := dbms_sql.execute(c);
32:
33: if dbms_sql.fetch_rows(c) > 0 then

Line 31: rows_processed := dbms_sql.execute(c);

27: dbms_sql.parse(c, c_statement, dbms_sql.native);
28: dbms_sql.bind_variable(c,'short_name',apps_short_name);
29: dbms_sql.define_column(c,1,l_patch_level,30);
30:
31: rows_processed := dbms_sql.execute(c);
32:
33: if dbms_sql.fetch_rows(c) > 0 then
34: dbms_sql.column_value(c,1,l_patch_level);
35: else

Line 33: if dbms_sql.fetch_rows(c) > 0 then

29: dbms_sql.define_column(c,1,l_patch_level,30);
30:
31: rows_processed := dbms_sql.execute(c);
32:
33: if dbms_sql.fetch_rows(c) > 0 then
34: dbms_sql.column_value(c,1,l_patch_level);
35: else
36: raise no_data_found;
37: end if;

Line 34: dbms_sql.column_value(c,1,l_patch_level);

30:
31: rows_processed := dbms_sql.execute(c);
32:
33: if dbms_sql.fetch_rows(c) > 0 then
34: dbms_sql.column_value(c,1,l_patch_level);
35: else
36: raise no_data_found;
37: end if;
38:

Line 39: dbms_sql.close_cursor(c);

35: else
36: raise no_data_found;
37: end if;
38:
39: dbms_sql.close_cursor(c);
40:
41: fp_level := l_patch_level;
42:
43: exception

Line 45: dbms_sql.close_cursor(c);

41: fp_level := l_patch_level;
42:
43: exception
44: when others then
45: dbms_sql.close_cursor(c);
46: raise;
47: end;
48:
49:

Line 64: c := dbms_sql.open_cursor;

60: l_release_name varchar2(50);
61:
62: begin
63:
64: c := dbms_sql.open_cursor;
65:
66: c_statement:= 'SELECT RELEASE_NAME FROM ' ||
67: 'FND_PRODUCT_GROUPS WHERE PRODUCT_GROUP_ID=1';
68:

Line 69: dbms_sql.parse(c, c_statement, dbms_sql.native);

65:
66: c_statement:= 'SELECT RELEASE_NAME FROM ' ||
67: 'FND_PRODUCT_GROUPS WHERE PRODUCT_GROUP_ID=1';
68:
69: dbms_sql.parse(c, c_statement, dbms_sql.native);
70: dbms_sql.define_column(c,1,l_release_name,30);
71:
72: rows_processed := dbms_sql.execute(c);
73:

Line 70: dbms_sql.define_column(c,1,l_release_name,30);

66: c_statement:= 'SELECT RELEASE_NAME FROM ' ||
67: 'FND_PRODUCT_GROUPS WHERE PRODUCT_GROUP_ID=1';
68:
69: dbms_sql.parse(c, c_statement, dbms_sql.native);
70: dbms_sql.define_column(c,1,l_release_name,30);
71:
72: rows_processed := dbms_sql.execute(c);
73:
74: if dbms_sql.fetch_rows(c) > 0 then

Line 72: rows_processed := dbms_sql.execute(c);

68:
69: dbms_sql.parse(c, c_statement, dbms_sql.native);
70: dbms_sql.define_column(c,1,l_release_name,30);
71:
72: rows_processed := dbms_sql.execute(c);
73:
74: if dbms_sql.fetch_rows(c) > 0 then
75: dbms_sql.column_value(c,1,l_release_name);
76: else

Line 74: if dbms_sql.fetch_rows(c) > 0 then

70: dbms_sql.define_column(c,1,l_release_name,30);
71:
72: rows_processed := dbms_sql.execute(c);
73:
74: if dbms_sql.fetch_rows(c) > 0 then
75: dbms_sql.column_value(c,1,l_release_name);
76: else
77: raise no_data_found;
78: end if;

Line 75: dbms_sql.column_value(c,1,l_release_name);

71:
72: rows_processed := dbms_sql.execute(c);
73:
74: if dbms_sql.fetch_rows(c) > 0 then
75: dbms_sql.column_value(c,1,l_release_name);
76: else
77: raise no_data_found;
78: end if;
79:

Line 80: dbms_sql.close_cursor(c);

76: else
77: raise no_data_found;
78: end if;
79:
80: dbms_sql.close_cursor(c);
81:
82: apps_release_level := l_release_name;
83:
84: exception

Line 86: dbms_sql.close_cursor(c);

82: apps_release_level := l_release_name;
83:
84: exception
85: when others then
86: dbms_sql.close_cursor(c);
87: raise;
88: end;
89:
90: