[Home] [Help]
414: SELECT
415: 'Exist'
416: INTO
417: dummy
418: FROM sys.dual
419: WHERE exists
420: (SELECT
421: 'Yes'
422: FROM
484: SELECT
485: 'Exist'
486: INTO
487: dummy
488: FROM sys.dual
489: WHERE exists
490: (SELECT
491: 'Yes'
492: FROM
663: x_err_stage := 'Create Project Asset Line';
664:
665: SELECT pa_project_asset_lines_s.nextval
666: INTO project_asset_line_id
667: FROM sys.dual;
668:
669: -- Start: Added as part of the Bug 13256490
670: IF (x_invoice_id is not null and x_invoice_distribution_id is not null) then
671:
778: ,x_capital_event_id
779: ,x_retirement_cost_type
780: ,L_org_id
781: FROM
782: sys.dual;
783:
784: IF l_mrc_flag = 'Y' THEN
785: create_alc_proj_asset_lines (project_asset_line_id,
786: x_project_asset_line_detail_id,
1412: x_err_stage := 'Create Project Asset Line details';
1413:
1414: SELECT pa_proj_asset_line_dtls_uniq_s.nextval
1415: INTO l_proj_asset_line_dtl_uniq_id
1416: FROM sys.dual;
1417:
1418: INSERT INTO pa_project_asset_line_details(
1419: proj_asset_line_dtl_uniq_id,
1420: expenditure_item_id,
1446: x_request_id,
1447: x_program_application_id,
1448: x_program_id
1449: FROM
1450: sys.dual;
1451:
1452: IF l_mrc_flag = 'Y' THEN
1453: create_alc_asset_line_details (l_proj_asset_line_dtl_uniq_id,
1454: x_expenditure_item_id,
2535: x_err_code);
2536:
2537: SELECT pa_project_asset_line_det_s.nextval
2538: INTO proj_asset_line_detail_id
2539: FROM sys.dual;
2540: curr_grouping_method:=cdlrec.grouping_method;
2541: description:= curr_grouping_method ;
2542:
2543: --Get Meaning from pa_lookups for Retirement Cost Type, populate Retirement Cost Type
2660: x_err_code);
2661:
2662: SELECT pa_project_asset_line_det_s.nextval
2663: INTO proj_asset_line_detail_id
2664: FROM sys.dual;
2665: -- create a detail line here
2666:
2667: create_proj_asset_line_details
2668: (cdlrec.expenditure_item_id,
3327: fa_mass_additions_s.nextval
3328: INTO
3329: x_mass_addition_id
3330: FROM
3331: SYS.DUAL;
3332:
3333: /*If this is a new asset */
3334: IF x_add_to_asset_id is NULL THEN
3335: x_amort_flag := Null;
3560: x_manufacturer_name,
3561: x_model_number,
3562: x_serial_number,
3563: x_tag_number
3564: FROM SYS.DUAL;
3565:
3566: /* Bug#3224283. Added Call to pa_crl_faxface after inserting the
3567: record into fa_mass_additions */
3568: if (PA_INSTALL.is_product_installed('IPA')) then --CRL Installed
4149: curr_add_to_asset_id := NULL;
4150: BEGIN
4151: SELECT '1'
4152: INTO fa_posted_count
4153: FROM DUAL
4154: WHERE EXISTS (SELECT mass_addition_id
4155: FROM fa_mass_additions
4156: WHERE asset_number = assetlinerec.asset_number AND
4157: posting_status = 'POSTED');
4756:
4757: BEGIN
4758: SELECT 'Y'
4759: INTO v_ret_cost_tasks_exist
4760: FROM sys.dual
4761: WHERE EXISTS
4762: (SELECT task_id
4763: FROM pa_tasks
4764: WHERE project_id = projrec.project_id
5374: Commented the Select statement for Bug#2540426 and
5375: split this statement into three separate selects
5376:
5377: SELECT 1 INTO dummy
5378: FROM dual
5379: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5380: FROM pa_cost_distribution_lines_all pcdl,
5381: pa_expenditure_items_all pei,
5382: pa_tasks pat,
5415:
5416: BEGIN
5417:
5418: SELECT 1 INTO dummy
5419: FROM DUAL
5420: WHERE EXISTS (SELECT 'x' -- project has assets to be reverse capitalized
5421: FROM pa_project_assets ppa
5422: WHERE ppa.project_id+0 = p_project_id
5423: AND ppa.reverse_flag = 'Y'
5437:
5438: BEGIN
5439:
5440: SELECT 1 INTO dummy
5441: FROM DUAL
5442: WHERE EXISTS (SELECT 'x' -- Untransferred assetlines exist
5443: FROM pa_project_asset_lines pal
5444: WHERE pal.project_id = p_project_id
5445: AND pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
5462:
5463: BEGIN
5464:
5465: SELECT 1 INTO dummy
5466: FROM dual
5467: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized Retirement Cost expenditure items
5468: FROM pa_cost_distribution_lines_all pcdl,
5469: pa_expenditure_items_all pei,
5470: pa_tasks pat,
5513:
5514: BEGIN
5515:
5516: SELECT 1 INTO dummy
5517: FROM dual
5518: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5519: FROM pa_cost_distribution_lines_all pcdl,
5520: pa_expenditure_items_all pei,
5521: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
6318: when NO_DATA_FOUND then
6319:
6320: SELECT 'N'
6321: into l_alc_exists
6322: from dual
6323: WHERE NOT EXISTS (
6324: SELECT gl.ledger_id
6325: FROM gl_alc_ledger_rships_v gl
6326: WHERE gl.source_ledger_id = v_alc_ledger.set_of_books_id