DBA Data[Home] [Help]

APPS.ZX_AR_EXTRACT_PKG dependencies on FND_GLOBAL

Line 8110: g_created_by := fnd_global.user_id;

8106: i := 1;
8107: total_rec := 0;
8108: init_ar_gt_tables;
8109:
8110: g_created_by := fnd_global.user_id;
8111: g_creation_date := sysdate;
8112: g_last_updated_by := fnd_global.user_id;
8113: g_last_update_login := fnd_global.login_id;
8114: g_last_update_date := sysdate;

Line 8112: g_last_updated_by := fnd_global.user_id;

8108: init_ar_gt_tables;
8109:
8110: g_created_by := fnd_global.user_id;
8111: g_creation_date := sysdate;
8112: g_last_updated_by := fnd_global.user_id;
8113: g_last_update_login := fnd_global.login_id;
8114: g_last_update_date := sysdate;
8115:
8116: -- insert when fetch up to 1000 rows

Line 8113: g_last_update_login := fnd_global.login_id;

8109:
8110: g_created_by := fnd_global.user_id;
8111: g_creation_date := sysdate;
8112: g_last_updated_by := fnd_global.user_id;
8113: g_last_update_login := fnd_global.login_id;
8114: g_last_update_date := sysdate;
8115:
8116: -- insert when fetch up to 1000 rows
8117: --

Line 8374: IF fnd_global.conc_request_id <> -1 THEN

8370: END IF;
8371:
8372: EXCEPTION
8373: WHEN VALUE_ERROR THEN
8374: IF fnd_global.conc_request_id <> -1 THEN
8375: FND_FILE.put_line(which => FND_FILE.LOG
8376: ,buff => 'Exception in VALUE_ERROR ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg : ' || SQLERRM);
8377: END IF;
8378: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);

Line 8390: IF fnd_global.conc_request_id <> -1 THEN

8386: END IF;
8387: g_retcode := 2;
8388:
8389: WHEN NO_DATA_FOUND THEN
8390: IF fnd_global.conc_request_id <> -1 THEN
8391: FND_FILE.put_line(which => FND_FILE.LOG
8392: ,buff => 'Exception in NO_DATA_FOUND ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg : ' || SQLERRM);
8393: END IF;
8394: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 100);

Line 8406: IF fnd_global.conc_request_id <> -1 THEN

8402: END IF;
8403: g_retcode := 2;
8404:
8405: WHEN OTHERS THEN
8406: IF fnd_global.conc_request_id <> -1 THEN
8407: FND_FILE.put_line(which => FND_FILE.LOG
8408: ,buff => 'Exception in OTHERS ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg : ' || SQLERRM);
8409: END IF;
8410: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);