DBA Data[Home] [Help]

APPS.OPI_DBI_INV_VALUE_OPM_INCR_PKG dependencies on FND_GLOBAL

Line 4: g_user_id NUMBER := nvl(fnd_global.user_id, -1);

1: PACKAGE BODY OPI_DBI_INV_VALUE_OPM_INCR_PKG as
2: /* $Header: OPIDIPRB.pls 120.1 2005/08/02 01:46:47 achandak noship $ */
3:
4: g_user_id NUMBER := nvl(fnd_global.user_id, -1);
5: g_login_id NUMBER := nvl(fnd_global.login_id, -1);
6:
7: g_sysdate DATE;
8: g_created_by NUMBER;

Line 5: g_login_id NUMBER := nvl(fnd_global.login_id, -1);

1: PACKAGE BODY OPI_DBI_INV_VALUE_OPM_INCR_PKG as
2: /* $Header: OPIDIPRB.pls 120.1 2005/08/02 01:46:47 achandak noship $ */
3:
4: g_user_id NUMBER := nvl(fnd_global.user_id, -1);
5: g_login_id NUMBER := nvl(fnd_global.login_id, -1);
6:
7: g_sysdate DATE;
8: g_created_by NUMBER;
9: g_last_update_login NUMBER;

Line 1098: g_created_by := fnd_global.user_id;

1094: bis_collection_utilities.put_line('Set global variables.');
1095: l_rows1 := 0;
1096: l_rows2 := 0;
1097: g_sysdate := sysdate;
1098: g_created_by := fnd_global.user_id;
1099: g_last_update_login := fnd_global.login_id;
1100: g_last_updated_by := fnd_global.user_id;
1101:
1102: bis_collection_utilities.put_line('Collection started at ' || TO_CHAR(g_sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 1099: g_last_update_login := fnd_global.login_id;

1095: l_rows1 := 0;
1096: l_rows2 := 0;
1097: g_sysdate := sysdate;
1098: g_created_by := fnd_global.user_id;
1099: g_last_update_login := fnd_global.login_id;
1100: g_last_updated_by := fnd_global.user_id;
1101:
1102: bis_collection_utilities.put_line('Collection started at ' || TO_CHAR(g_sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1103:

Line 1100: g_last_updated_by := fnd_global.user_id;

1096: l_rows2 := 0;
1097: g_sysdate := sysdate;
1098: g_created_by := fnd_global.user_id;
1099: g_last_update_login := fnd_global.login_id;
1100: g_last_updated_by := fnd_global.user_id;
1101:
1102: bis_collection_utilities.put_line('Collection started at ' || TO_CHAR(g_sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1103:
1104: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into g_global_start_date from DUAL;