DBA Data[Home] [Help]

APPS.GCS_WEBADI_PKG dependencies on FND_GLOBAL

Line 75: l_user_id NUMBER := fnd_global.user_id;

71: p_currency_code IN VARCHAR2,
72: p_amount_type IN VARCHAR2,
73: p_measure_type IN VARCHAR2,
74: p_rule_set IN VARCHAR2) IS
75: l_user_id NUMBER := fnd_global.user_id;
76: l_login_id NUMBER := fnd_global.login_id;
77: l_api_name CONSTANT VARCHAR2(30) := 'datasub_upload';
78:
79: BEGIN

Line 76: l_login_id NUMBER := fnd_global.login_id;

72: p_amount_type IN VARCHAR2,
73: p_measure_type IN VARCHAR2,
74: p_rule_set IN VARCHAR2) IS
75: l_user_id NUMBER := fnd_global.user_id;
76: l_login_id NUMBER := fnd_global.login_id;
77: l_api_name CONSTANT VARCHAR2(30) := 'datasub_upload';
78:
79: BEGIN
80:

Line 364: l_user_id NUMBER := fnd_global.user_id;

360: l_view_select_cols VARCHAR2(2500);
361: l_from_clause VARCHAR2(500);
362: l_where_clause VARCHAR2(2500);
363: l_index_column_name VARCHAR2(30);
364: l_user_id NUMBER := fnd_global.user_id;
365: l_login_id NUMBER := fnd_global.login_id;
366: l_app_id CONSTANT NUMBER(15) := 266;
367: body VARCHAR2(5000);
368: l_api_name CONSTANT VARCHAR2(30) := 'Execute_Event';

Line 365: l_login_id NUMBER := fnd_global.login_id;

361: l_from_clause VARCHAR2(500);
362: l_where_clause VARCHAR2(2500);
363: l_index_column_name VARCHAR2(30);
364: l_user_id NUMBER := fnd_global.user_id;
365: l_login_id NUMBER := fnd_global.login_id;
366: l_app_id CONSTANT NUMBER(15) := 266;
367: body VARCHAR2(5000);
368: l_api_name CONSTANT VARCHAR2(30) := 'Execute_Event';
369:

Line 1384: WHERE request_id = FND_GLOBAL.conc_request_id;

1380:
1381: SELECT status_code
1382: INTO l_status_code
1383: FROM Fnd_Concurrent_Requests
1384: WHERE request_id = FND_GLOBAL.conc_request_id;
1385:
1386:
1387: IF (l_status_code = 'E') THEN
1388:

Line 1517: l_user_id NUMBER := fnd_global.user_id;

1513: l_level_exists_flag VARCHAR2(1);
1514: l_status_code VARCHAR2(1);
1515: l_folder_name VARCHAR2(150);
1516: l_statement VARCHAR2(1000);
1517: l_user_id NUMBER := fnd_global.user_id;
1518: l_login_id NUMBER := fnd_global.login_id;
1519: l_api_name VARCHAR2(30) := 'DIM_HIER_IMPORT';
1520:
1521: --Bugfix 4665921: Added support for causing impact when value set map is uploaded

Line 1518: l_login_id NUMBER := fnd_global.login_id;

1514: l_status_code VARCHAR2(1);
1515: l_folder_name VARCHAR2(150);
1516: l_statement VARCHAR2(1000);
1517: l_user_id NUMBER := fnd_global.user_id;
1518: l_login_id NUMBER := fnd_global.login_id;
1519: l_api_name VARCHAR2(30) := 'DIM_HIER_IMPORT';
1520:
1521: --Bugfix 4665921: Added support for causing impact when value set map is uploaded
1522: l_object_id NUMBER;

Line 1717: WHERE request_id = FND_GLOBAL.conc_request_id;

1713:
1714: SELECT status_code
1715: INTO l_status_code
1716: FROM Fnd_Concurrent_Requests
1717: WHERE request_id = FND_GLOBAL.conc_request_id;
1718:
1719: FND_FILE.PUT_LINE(FND_FILE.LOG,
1720: g_pkg_name || '.' || l_api_name ||
1721: ' FEM_HIER_LOADER_PKG return status : ' ||