DBA Data[Home] [Help]

APPS.PA_ADW_CREATE_VIEWS dependencies on DBMS_SQL

Line 27: view_act_cmt dbms_sql.varchar2s;

23: dim_operating_unit VARCHAR2(1);
24:
25: -- PL/SQL array and its index for storing View Definition
26:
27: view_act_cmt dbms_sql.varchar2s;
28: view_ref_act_cmt dbms_sql.varchar2s;
29: view_ref_ser_type_act_cmt dbms_sql.varchar2s;
30: view_budget_lines dbms_sql.varchar2s;
31: view_ref_budget_lines dbms_sql.varchar2s;

Line 28: view_ref_act_cmt dbms_sql.varchar2s;

24:
25: -- PL/SQL array and its index for storing View Definition
26:
27: view_act_cmt dbms_sql.varchar2s;
28: view_ref_act_cmt dbms_sql.varchar2s;
29: view_ref_ser_type_act_cmt dbms_sql.varchar2s;
30: view_budget_lines dbms_sql.varchar2s;
31: view_ref_budget_lines dbms_sql.varchar2s;
32:

Line 29: view_ref_ser_type_act_cmt dbms_sql.varchar2s;

25: -- PL/SQL array and its index for storing View Definition
26:
27: view_act_cmt dbms_sql.varchar2s;
28: view_ref_act_cmt dbms_sql.varchar2s;
29: view_ref_ser_type_act_cmt dbms_sql.varchar2s;
30: view_budget_lines dbms_sql.varchar2s;
31: view_ref_budget_lines dbms_sql.varchar2s;
32:
33: view_idx_act_cmt BINARY_INTEGER;

Line 30: view_budget_lines dbms_sql.varchar2s;

26:
27: view_act_cmt dbms_sql.varchar2s;
28: view_ref_act_cmt dbms_sql.varchar2s;
29: view_ref_ser_type_act_cmt dbms_sql.varchar2s;
30: view_budget_lines dbms_sql.varchar2s;
31: view_ref_budget_lines dbms_sql.varchar2s;
32:
33: view_idx_act_cmt BINARY_INTEGER;
34: view_idx_ref_act_cmt BINARY_INTEGER;

Line 31: view_ref_budget_lines dbms_sql.varchar2s;

27: view_act_cmt dbms_sql.varchar2s;
28: view_ref_act_cmt dbms_sql.varchar2s;
29: view_ref_ser_type_act_cmt dbms_sql.varchar2s;
30: view_budget_lines dbms_sql.varchar2s;
31: view_ref_budget_lines dbms_sql.varchar2s;
32:
33: view_idx_act_cmt BINARY_INTEGER;
34: view_idx_ref_act_cmt BINARY_INTEGER;
35: view_idx_ref_ser_type_act_cmt BINARY_INTEGER;