DBA Data[Home] [Help]

APPS.RCI_SIG_ACCT_EVAL_SUMM_PKG dependencies on FND_GLOBAL

Line 15: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

11: -- Person Date Comments
12: -- --------- ------ ------------------------------------------
13: -- Enter procedure, function bodies as shown below
14:
15: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
16: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
17:
18: PROCEDURE get_kpi(
19: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

Line 16: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

12: -- --------- ------ ------------------------------------------
13: -- Enter procedure, function bodies as shown below
14:
15: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
16: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
17:
18: PROCEDURE get_kpi(
19: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
20: ,p_exp_source_sql out NOCOPY VARCHAR2

Line 1383: l_user_id := NVL(fnd_global.USER_ID, -1);

1379: AND FINANCIAL_ITEM_ID = p_financial_item_id;
1380:
1381: END LOOP;
1382: */
1383: l_user_id := NVL(fnd_global.USER_ID, -1);
1384: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1385: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1386: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1387: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

Line 1384: l_login_id := NVL(fnd_global.LOGIN_ID, -1);

1380:
1381: END LOOP;
1382: */
1383: l_user_id := NVL(fnd_global.USER_ID, -1);
1384: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1385: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1386: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1387: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1388: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

Line 1385: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);

1381: END LOOP;
1382: */
1383: l_user_id := NVL(fnd_global.USER_ID, -1);
1384: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1385: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1386: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1387: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1388: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1389: l_run_date := sysdate - 5/(24*60);

Line 1386: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);

1382: */
1383: l_user_id := NVL(fnd_global.USER_ID, -1);
1384: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1385: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1386: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1387: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1388: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1389: l_run_date := sysdate - 5/(24*60);
1390:

Line 1387: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

1383: l_user_id := NVL(fnd_global.USER_ID, -1);
1384: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1385: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1386: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1387: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1388: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1389: l_run_date := sysdate - 5/(24*60);
1390:
1391: DELETE FROM rci_dr_inc WHERE fact_name='RCI_SIG_ACCT_EVAL_F';

Line 1388: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

1384: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1385: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1386: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1387: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1388: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1389: l_run_date := sysdate - 5/(24*60);
1390:
1391: DELETE FROM rci_dr_inc WHERE fact_name='RCI_SIG_ACCT_EVAL_F';
1392: