DBA Data[Home] [Help]

APPS.PA_CAPITAL_EVENTS_PVT dependencies on FND_GLOBAL

Line 33: v_user_id NUMBER := FND_GLOBAL.user_id;

29: ORDER BY p.segment1;
30:
31: ac_projects_rec ac_projects_cur%ROWTYPE;
32:
33: v_user_id NUMBER := FND_GLOBAL.user_id;
34: v_login_id NUMBER := FND_GLOBAL.login_id;
35: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
36: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
37: v_program_id NUMBER := FND_GLOBAL.conc_program_id;

Line 34: v_login_id NUMBER := FND_GLOBAL.login_id;

30:
31: ac_projects_rec ac_projects_cur%ROWTYPE;
32:
33: v_user_id NUMBER := FND_GLOBAL.user_id;
34: v_login_id NUMBER := FND_GLOBAL.login_id;
35: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
36: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
37: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
38: v_null_rowid ROWID := NULL;

Line 35: v_request_id NUMBER := FND_GLOBAL.conc_request_id;

31: ac_projects_rec ac_projects_cur%ROWTYPE;
32:
33: v_user_id NUMBER := FND_GLOBAL.user_id;
34: v_login_id NUMBER := FND_GLOBAL.login_id;
35: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
36: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
37: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
38: v_null_rowid ROWID := NULL;
39: -- v_org_id NUMBER := TO_NUMBER(FND_PROFILE.value('ORG_ID'));

Line 36: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;

32:
33: v_user_id NUMBER := FND_GLOBAL.user_id;
34: v_login_id NUMBER := FND_GLOBAL.login_id;
35: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
36: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
37: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
38: v_null_rowid ROWID := NULL;
39: -- v_org_id NUMBER := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
40: v_org_id NUMBER := PA_MOAC_UTILS.get_current_org_id ;

Line 37: v_program_id NUMBER := FND_GLOBAL.conc_program_id;

33: v_user_id NUMBER := FND_GLOBAL.user_id;
34: v_login_id NUMBER := FND_GLOBAL.login_id;
35: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
36: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
37: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
38: v_null_rowid ROWID := NULL;
39: -- v_org_id NUMBER := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
40: v_org_id NUMBER := PA_MOAC_UTILS.get_current_org_id ;
41:

Line 209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

205:
206: --Print Report Title
207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,TO_CHAR(sysdate,'DD-MON-YYYY')||
208: ' '||v_report_title);
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
210:
211:
212:
213: FOR report_rec IN report_cur(v_request_id) LOOP

Line 219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

215: IF NVL(curr_project_id,-1) <> report_rec.project_id THEN
216:
217: --Print Project Header
218:
219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
221: -- Replaced with translated lookup values for headings
222: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('Project Number',25,' ')||RPAD('Project Name',30,' '));
223: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('==============',25,' ')||RPAD('============',30,' '));

Line 220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

216:
217: --Print Project Header
218:
219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
221: -- Replaced with translated lookup values for headings
222: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('Project Number',25,' ')||RPAD('Project Name',30,' '));
223: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('==============',25,' ')||RPAD('============',30,' '));
224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_proj_heading1);

Line 247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

243:
244: IF NVL(curr_capital_type,'X') <> report_rec.capital_type THEN
245:
246: --Print Project Header
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,report_rec.capital_type_desc||' '||v_event_information);
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------');
250:
251: curr_capital_type := report_rec.capital_type;

Line 260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

256: --Print blank line for report formatting during control break
257: IF report_rec.context = '3' THEN
258:
259: --Print Blank Line
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
261:
262: END IF;
263:
264:

Line 270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

266: IF NVL(curr_context,report_rec.context) <> report_rec.context
267: AND NVL(curr_context,'X') = '1' THEN
268:
269: --Print Blank Line
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
271:
272: curr_context := report_rec.context;
273: END IF;
274:

Line 290: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||assets_added_rec.asset_name||' - '||assets_added_rec.asset_description);
287: END LOOP;
288:
289: FOR costs_added_rec IN costs_added_cur(report_rec.project_id, report_rec.capital_event_id, v_cost_type) LOOP
290: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||v_cost_included||' '||TO_CHAR(costs_added_rec.total_cost,pa_currency.currency_fmt_mask(15)));
292: END LOOP;
293:
294: END IF;

Line 320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

316:
317: --Print current Cost Total for Existing Event
318:
319: FOR current_costs_rec IN current_costs_cur(report_rec.project_id, report_rec.capital_event_id, v_cost_type) LOOP
320: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
321: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||v_total_cost||' '||TO_CHAR(current_costs_rec.total_cost,pa_currency.currency_fmt_mask(15)));
322: END LOOP;
323:
324: END IF;

Line 832: v_user_id NUMBER := FND_GLOBAL.user_id;

828:
829: task_asgn_assets_rec task_asgn_assets_cur%ROWTYPE;
830:
831:
832: v_user_id NUMBER := FND_GLOBAL.user_id;
833: v_login_id NUMBER := FND_GLOBAL.login_id;
834: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
835: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
836: v_program_id NUMBER := FND_GLOBAL.conc_program_id;

Line 833: v_login_id NUMBER := FND_GLOBAL.login_id;

829: task_asgn_assets_rec task_asgn_assets_cur%ROWTYPE;
830:
831:
832: v_user_id NUMBER := FND_GLOBAL.user_id;
833: v_login_id NUMBER := FND_GLOBAL.login_id;
834: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
835: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
836: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
837: v_null_rowid ROWID := NULL;

Line 834: v_request_id NUMBER := FND_GLOBAL.conc_request_id;

830:
831:
832: v_user_id NUMBER := FND_GLOBAL.user_id;
833: v_login_id NUMBER := FND_GLOBAL.login_id;
834: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
835: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
836: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
837: v_null_rowid ROWID := NULL;
838: -- v_org_id NUMBER := TO_NUMBER(FND_PROFILE.value('ORG_ID'));

Line 835: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;

831:
832: v_user_id NUMBER := FND_GLOBAL.user_id;
833: v_login_id NUMBER := FND_GLOBAL.login_id;
834: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
835: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
836: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
837: v_null_rowid ROWID := NULL;
838: -- v_org_id NUMBER := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
839: v_org_id NUMBER := PA_MOAC_UTILS.get_current_org_id ;

Line 836: v_program_id NUMBER := FND_GLOBAL.conc_program_id;

832: v_user_id NUMBER := FND_GLOBAL.user_id;
833: v_login_id NUMBER := FND_GLOBAL.login_id;
834: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
835: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
836: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
837: v_null_rowid ROWID := NULL;
838: -- v_org_id NUMBER := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
839: v_org_id NUMBER := PA_MOAC_UTILS.get_current_org_id ;
840:

Line 2448: v_user_id NUMBER := FND_GLOBAL.user_id;

2444:
2445:
2446:
2447: v_event_type PA_CAPITAL_EVENTS.event_type%TYPE;
2448: v_user_id NUMBER := FND_GLOBAL.user_id;
2449: v_login_id NUMBER := FND_GLOBAL.login_id;
2450:
2451:
2452: BEGIN

Line 2449: v_login_id NUMBER := FND_GLOBAL.login_id;

2445:
2446:
2447: v_event_type PA_CAPITAL_EVENTS.event_type%TYPE;
2448: v_user_id NUMBER := FND_GLOBAL.user_id;
2449: v_login_id NUMBER := FND_GLOBAL.login_id;
2450:
2451:
2452: BEGIN
2453: x_return_status := 'S';

Line 2612: v_user_id NUMBER := FND_GLOBAL.user_id;

2608:
2609:
2610:
2611: v_event_type PA_CAPITAL_EVENTS.event_type%TYPE;
2612: v_user_id NUMBER := FND_GLOBAL.user_id;
2613: v_login_id NUMBER := FND_GLOBAL.login_id;
2614: v_attach_ei VARCHAR2(1) := 'N';
2615: v_project_assignment VARCHAR2(1) := 'N';
2616: v_task_assignment VARCHAR2(1) := 'N';

Line 2613: v_login_id NUMBER := FND_GLOBAL.login_id;

2609:
2610:
2611: v_event_type PA_CAPITAL_EVENTS.event_type%TYPE;
2612: v_user_id NUMBER := FND_GLOBAL.user_id;
2613: v_login_id NUMBER := FND_GLOBAL.login_id;
2614: v_attach_ei VARCHAR2(1) := 'N';
2615: v_project_assignment VARCHAR2(1) := 'N';
2616: v_task_assignment VARCHAR2(1) := 'N';
2617: v_common_asgn_exists VARCHAR2(1) := 'N';