eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.QLTTRAWB dependencies on FND_API

Line 1264: null_num number := fnd_api.G_NULL_NUM;

1260: -- 240 Characters.pdube Thu Dec 31 01:40:03 PST 2009
1261: -- ERRMSG VARCHAR2(30);
1262: ERRMSG VARCHAR2(240);
1263:
1264: null_num number := fnd_api.G_NULL_NUM;
1265: null_char varchar2(1) := fnd_api.G_NULL_char;
1266: null_date date := fnd_api.G_NULL_date;
1267: BEGIN
1268: I := 0;

Line 1265: null_char varchar2(1) := fnd_api.G_NULL_char;

1261: -- ERRMSG VARCHAR2(30);
1262: ERRMSG VARCHAR2(240);
1263:
1264: null_num number := fnd_api.G_NULL_NUM;
1265: null_char varchar2(1) := fnd_api.G_NULL_char;
1266: null_date date := fnd_api.G_NULL_date;
1267: BEGIN
1268: I := 0;
1269:

Line 1266: null_date date := fnd_api.G_NULL_date;

1262: ERRMSG VARCHAR2(240);
1263:
1264: null_num number := fnd_api.G_NULL_NUM;
1265: null_char varchar2(1) := fnd_api.G_NULL_char;
1266: null_date date := fnd_api.G_NULL_date;
1267: BEGIN
1268: I := 0;
1269:
1270: -- Bug 2941809. Need to use bind variables instead of literal values when

Line 1390: null_num number := fnd_api.G_NULL_NUM;

1386: l_col3 varchar2(100);
1387: l_col4 varchar2(100);
1388: l_col5 varchar2(100);
1389:
1390: null_num number := fnd_api.G_NULL_NUM;
1391: null_char varchar2(1) := fnd_api.G_NULL_char;
1392: null_date date := fnd_api.G_NULL_date;
1393:
1394: BEGIN

Line 1391: null_char varchar2(1) := fnd_api.G_NULL_char;

1387: l_col4 varchar2(100);
1388: l_col5 varchar2(100);
1389:
1390: null_num number := fnd_api.G_NULL_NUM;
1391: null_char varchar2(1) := fnd_api.G_NULL_char;
1392: null_date date := fnd_api.G_NULL_date;
1393:
1394: BEGIN
1395:

Line 1392: null_date date := fnd_api.G_NULL_date;

1388: l_col5 varchar2(100);
1389:
1390: null_num number := fnd_api.G_NULL_NUM;
1391: null_char varchar2(1) := fnd_api.G_NULL_char;
1392: null_date date := fnd_api.G_NULL_date;
1393:
1394: BEGIN
1395:
1396: -- Bug 3136107.SQL Bind project.

Line 3263: null_num number := fnd_api.G_NULL_NUM;

3259: l_col3 varchar2(100);
3260: l_col4 varchar2(100);
3261: l_col5 varchar2(100);
3262:
3263: null_num number := fnd_api.G_NULL_NUM;
3264: null_char varchar2(1) := fnd_api.G_NULL_char;
3265: null_date date := fnd_api.G_NULL_date;
3266: BEGIN
3267: -- Bug 3136107.SQL Bind project.

Line 3264: null_char varchar2(1) := fnd_api.G_NULL_char;

3260: l_col4 varchar2(100);
3261: l_col5 varchar2(100);
3262:
3263: null_num number := fnd_api.G_NULL_NUM;
3264: null_char varchar2(1) := fnd_api.G_NULL_char;
3265: null_date date := fnd_api.G_NULL_date;
3266: BEGIN
3267: -- Bug 3136107.SQL Bind project.
3268: parse_error_columns(error_col_list, l_col1, l_col2, l_col3, l_col4, l_col5);

Line 3265: null_date date := fnd_api.G_NULL_date;

3261: l_col5 varchar2(100);
3262:
3263: null_num number := fnd_api.G_NULL_NUM;
3264: null_char varchar2(1) := fnd_api.G_NULL_char;
3265: null_date date := fnd_api.G_NULL_date;
3266: BEGIN
3267: -- Bug 3136107.SQL Bind project.
3268: parse_error_columns(error_col_list, l_col1, l_col2, l_col3, l_col4, l_col5);
3269:

Line 7888: null_num number := fnd_api.G_NULL_NUM;

7884:
7885: TYPE sc_elements_tab_typ IS TABLE OF qa_plan_chars.result_column_name%TYPE INDEX BY BINARY_INTEGER;
7886: sc_elements_tab sc_elements_tab_typ;
7887:
7888: null_num number := fnd_api.G_NULL_NUM;
7889: null_char varchar2(1) := fnd_api.G_NULL_char;
7890: null_date date := fnd_api.G_NULL_date;
7891:
7892: qri_update_str_tab DBMS_SQL.VARCHAR2S;

Line 7889: null_char varchar2(1) := fnd_api.G_NULL_char;

7885: TYPE sc_elements_tab_typ IS TABLE OF qa_plan_chars.result_column_name%TYPE INDEX BY BINARY_INTEGER;
7886: sc_elements_tab sc_elements_tab_typ;
7887:
7888: null_num number := fnd_api.G_NULL_NUM;
7889: null_char varchar2(1) := fnd_api.G_NULL_char;
7890: null_date date := fnd_api.G_NULL_date;
7891:
7892: qri_update_str_tab DBMS_SQL.VARCHAR2S;
7893: update_qri_cur PLS_INTEGER;

Line 7890: null_date date := fnd_api.G_NULL_date;

7886: sc_elements_tab sc_elements_tab_typ;
7887:
7888: null_num number := fnd_api.G_NULL_NUM;
7889: null_char varchar2(1) := fnd_api.G_NULL_char;
7890: null_date date := fnd_api.G_NULL_date;
7891:
7892: qri_update_str_tab DBMS_SQL.VARCHAR2S;
7893: update_qri_cur PLS_INTEGER;
7894: update_qri_status NUMBER;