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.

APPS.CST_MGD_INFL_ADJUSTMENT_PVT dependencies on FND_PROFILE

Line 652: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);

648: l_transfer_rec.organization_id := p_organization_id;
649: l_transfer_rec.acct_period_id := p_acct_period_id;
650: l_transfer_rec.last_update_date := SYSDATE;
651: l_transfer_rec.last_updated_by :=
652: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);
653: l_transfer_rec.creation_date := SYSDATE;
654: l_transfer_rec.created_by :=
655: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);
656: l_transfer_rec.last_update_login :=

Line 655: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);

651: l_transfer_rec.last_updated_by :=
652: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);
653: l_transfer_rec.creation_date := SYSDATE;
654: l_transfer_rec.created_by :=
655: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);
656: l_transfer_rec.last_update_login :=
657: TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'));
658: l_transfer_rec.request_id :=
659: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'));

Line 657: TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'));

653: l_transfer_rec.creation_date := SYSDATE;
654: l_transfer_rec.created_by :=
655: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);
656: l_transfer_rec.last_update_login :=
657: TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'));
658: l_transfer_rec.request_id :=
659: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'));
660: l_transfer_rec.program_application_id :=
661: TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'));

Line 659: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'));

655: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);
656: l_transfer_rec.last_update_login :=
657: TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'));
658: l_transfer_rec.request_id :=
659: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'));
660: l_transfer_rec.program_application_id :=
661: TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'));
662: l_transfer_rec.program_id :=
663: TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'));

Line 661: TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'));

657: TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'));
658: l_transfer_rec.request_id :=
659: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'));
660: l_transfer_rec.program_application_id :=
661: TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'));
662: l_transfer_rec.program_id :=
663: TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'));
664: l_transfer_rec.program_update_date := SYSDATE;
665: l_transfer_rec.country_code := p_country_code;

Line 663: TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'));

659: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'));
660: l_transfer_rec.program_application_id :=
661: TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'));
662: l_transfer_rec.program_id :=
663: TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'));
664: l_transfer_rec.program_update_date := SYSDATE;
665: l_transfer_rec.country_code := p_country_code;
666: l_transfer_rec.transfer_organization_id := p_transfer_org_id;
667:

Line 2166: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);

2162: l_acct_entry_tbl_rec(l_counter).currency_code := p_currency_code;
2163: l_acct_entry_tbl_rec(l_counter).date_created := SYSDATE;
2164:
2165: l_acct_entry_tbl_rec(l_counter).created_by :=
2166: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);
2167:
2168: l_acct_entry_tbl_rec(l_counter).actual_flag := 'A';
2169:
2170: -- ======================================================================================

Line 2335: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);

2331:
2332: l_acct_entry_tbl_rec(l_counter).date_created := SYSDATE;
2333:
2334: l_acct_entry_tbl_rec(l_counter).created_by :=
2335: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);
2336:
2337: l_acct_entry_tbl_rec(l_counter).actual_flag := 'A';
2338: l_acct_entry_tbl_rec(l_counter).code_combination_id := l_inv_adj_ccid;
2339:

Line 2569: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)

2565: VALUES(
2566: p_org_id
2567: , p_acct_period_id
2568: , SYSDATE
2569: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2570: , SYSDATE
2571: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2572: , TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2573: , TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))

Line 2571: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)

2567: , p_acct_period_id
2568: , SYSDATE
2569: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2570: , SYSDATE
2571: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2572: , TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2573: , TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))
2574: , TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'))
2575: , TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))

Line 2572: , TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))

2568: , SYSDATE
2569: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2570: , SYSDATE
2571: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2572: , TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2573: , TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))
2574: , TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'))
2575: , TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))
2576: , SYSDATE

Line 2573: , TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))

2569: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2570: , SYSDATE
2571: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2572: , TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2573: , TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))
2574: , TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'))
2575: , TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))
2576: , SYSDATE
2577: , 'PROCESS'

Line 2574: , TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'))

2570: , SYSDATE
2571: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2572: , TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2573: , TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))
2574: , TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'))
2575: , TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))
2576: , SYSDATE
2577: , 'PROCESS'
2578: );

Line 2575: , TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))

2571: , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2572: , TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2573: , TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))
2574: , TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'))
2575: , TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))
2576: , SYSDATE
2577: , 'PROCESS'
2578: );
2579:

Line 2626: , Last_Updated_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)

2622:
2623: UPDATE CST_MGD_INFL_ADJ_PER_STATUSES
2624: SET Status = 'FINAL'
2625: , Last_Update_Date = SYSDATE
2626: , Last_Updated_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2627: , Creation_Date = SYSDATE
2628: , Created_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2629: , Last_Update_Login = TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2630: , Request_ID = TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))

Line 2628: , Created_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)

2624: SET Status = 'FINAL'
2625: , Last_Update_Date = SYSDATE
2626: , Last_Updated_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2627: , Creation_Date = SYSDATE
2628: , Created_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2629: , Last_Update_Login = TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2630: , Request_ID = TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))
2631: , Program_Application_ID = TO_NUMBER(FND_PROFILE.Value('PROG_APPLD_ID'))
2632: , Program_ID = TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))

Line 2629: , Last_Update_Login = TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))

2625: , Last_Update_Date = SYSDATE
2626: , Last_Updated_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2627: , Creation_Date = SYSDATE
2628: , Created_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2629: , Last_Update_Login = TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2630: , Request_ID = TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))
2631: , Program_Application_ID = TO_NUMBER(FND_PROFILE.Value('PROG_APPLD_ID'))
2632: , Program_ID = TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))
2633: , Program_Update_Date = SYSDATE

Line 2630: , Request_ID = TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))

2626: , Last_Updated_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2627: , Creation_Date = SYSDATE
2628: , Created_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2629: , Last_Update_Login = TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2630: , Request_ID = TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))
2631: , Program_Application_ID = TO_NUMBER(FND_PROFILE.Value('PROG_APPLD_ID'))
2632: , Program_ID = TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))
2633: , Program_Update_Date = SYSDATE
2634: WHERE organization_id = p_org_id

Line 2631: , Program_Application_ID = TO_NUMBER(FND_PROFILE.Value('PROG_APPLD_ID'))

2627: , Creation_Date = SYSDATE
2628: , Created_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2629: , Last_Update_Login = TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2630: , Request_ID = TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))
2631: , Program_Application_ID = TO_NUMBER(FND_PROFILE.Value('PROG_APPLD_ID'))
2632: , Program_ID = TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))
2633: , Program_Update_Date = SYSDATE
2634: WHERE organization_id = p_org_id
2635: AND acct_period_id = p_acct_period_id;

Line 2632: , Program_ID = TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))

2628: , Created_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2629: , Last_Update_Login = TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
2630: , Request_ID = TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))
2631: , Program_Application_ID = TO_NUMBER(FND_PROFILE.Value('PROG_APPLD_ID'))
2632: , Program_ID = TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))
2633: , Program_Update_Date = SYSDATE
2634: WHERE organization_id = p_org_id
2635: AND acct_period_id = p_acct_period_id;
2636:

Line 2754: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);

2750:
2751: IF (l_historical_infl_adj_rec.last_updated_by IS NULL)
2752: THEN
2753: l_historical_infl_adj_rec.last_updated_by :=
2754: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);
2755: END IF;
2756:
2757: IF (l_historical_infl_adj_rec.creation_date IS NULL)
2758: THEN

Line 2765: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);

2761:
2762: IF (l_historical_infl_adj_rec.created_by IS NULL)
2763: THEN
2764: l_historical_infl_adj_rec.created_by :=
2765: NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0);
2766: END IF;
2767:
2768: IF (l_historical_infl_adj_rec.last_update_login IS NULL)
2769: THEN

Line 2771: TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'));

2767:
2768: IF (l_historical_infl_adj_rec.last_update_login IS NULL)
2769: THEN
2770: l_historical_infl_adj_rec.last_update_login :=
2771: TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'));
2772: END IF;
2773:
2774: IF (l_historical_infl_adj_rec.request_id IS NULL)
2775: THEN

Line 2777: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'));

2773:
2774: IF (l_historical_infl_adj_rec.request_id IS NULL)
2775: THEN
2776: l_historical_infl_adj_rec.request_id :=
2777: TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'));
2778: END IF;
2779:
2780: IF (l_historical_infl_adj_rec.program_application_id IS NULL)
2781: THEN

Line 2783: TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'));

2779:
2780: IF (l_historical_infl_adj_rec.program_application_id IS NULL)
2781: THEN
2782: l_historical_infl_adj_rec.program_application_id :=
2783: TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'));
2784: END IF;
2785:
2786: IF (l_historical_infl_adj_rec.program_id IS NULL)
2787: THEN

Line 2789: TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'));

2785:
2786: IF (l_historical_infl_adj_rec.program_id IS NULL)
2787: THEN
2788: l_historical_infl_adj_rec.program_id :=
2789: TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'));
2790: END IF;
2791:
2792: IF (l_historical_infl_adj_rec.program_update_date IS NULL)
2793: THEN