[Home] [Help]
387: SELECT
388: 'Exist'
389: INTO
390: dummy
391: FROM sys.dual
392: WHERE exists
393: (SELECT
394: 'Yes'
395: FROM
457: SELECT
458: 'Exist'
459: INTO
460: dummy
461: FROM sys.dual
462: WHERE exists
463: (SELECT
464: 'Yes'
465: FROM
632: x_err_stage := 'Create Project Asset Line';
633:
634: SELECT pa_project_asset_lines_s.nextval
635: INTO project_asset_line_id
636: FROM sys.dual;
637:
638: INSERT INTO pa_project_asset_lines(
639: project_asset_line_id,
640: description,
720: ,x_capital_event_id
721: ,x_retirement_cost_type
722: ,L_org_id
723: FROM
724: sys.dual;
725:
726: IF l_mrc_flag = 'Y' THEN
727: create_alc_proj_asset_lines (project_asset_line_id,
728: x_project_asset_line_detail_id,
1325: x_err_stage := 'Create Project Asset Line details';
1326:
1327: SELECT pa_proj_asset_line_dtls_uniq_s.nextval
1328: INTO l_proj_asset_line_dtl_uniq_id
1329: FROM sys.dual;
1330:
1331: INSERT INTO pa_project_asset_line_details(
1332: proj_asset_line_dtl_uniq_id,
1333: expenditure_item_id,
1359: x_request_id,
1360: x_program_application_id,
1361: x_program_id
1362: FROM
1363: sys.dual;
1364:
1365: IF l_mrc_flag = 'Y' THEN
1366: create_alc_asset_line_details (l_proj_asset_line_dtl_uniq_id,
1367: x_expenditure_item_id,
2210: x_err_code);
2211:
2212: SELECT pa_project_asset_line_det_s.nextval
2213: INTO proj_asset_line_detail_id
2214: FROM sys.dual;
2215: curr_grouping_method:=cdlrec.grouping_method;
2216: description:= curr_grouping_method ;
2217:
2218: --Get Meaning from pa_lookups for Retirement Cost Type, populate Retirement Cost Type
2333: x_err_code);
2334:
2335: SELECT pa_project_asset_line_det_s.nextval
2336: INTO proj_asset_line_detail_id
2337: FROM sys.dual;
2338: -- create a detail line here
2339:
2340: create_proj_asset_line_details
2341: (cdlrec.expenditure_item_id,
2965: fa_mass_additions_s.nextval
2966: INTO
2967: x_mass_addition_id
2968: FROM
2969: SYS.DUAL;
2970:
2971: /*If this is a new asset */
2972: IF x_add_to_asset_id is NULL THEN
2973: x_amort_flag := Null;
3192: x_manufacturer_name,
3193: x_model_number,
3194: x_serial_number,
3195: x_tag_number
3196: FROM SYS.DUAL;
3197:
3198: /* Bug#3224283. Added Call to pa_crl_faxface after inserting the
3199: record into fa_mass_additions */
3200: if (PA_INSTALL.is_product_installed('IPA')) then --CRL Installed
3765: curr_add_to_asset_id := NULL;
3766: BEGIN
3767: SELECT '1'
3768: INTO fa_posted_count
3769: FROM DUAL
3770: WHERE EXISTS (SELECT mass_addition_id
3771: FROM fa_mass_additions
3772: WHERE asset_number = assetlinerec.asset_number AND
3773: posting_status = 'POSTED');
4370:
4371: BEGIN
4372: SELECT 'Y'
4373: INTO v_ret_cost_tasks_exist
4374: FROM sys.dual
4375: WHERE EXISTS
4376: (SELECT task_id
4377: FROM pa_tasks
4378: WHERE project_id = projrec.project_id
4988: Commented the Select statement for Bug#2540426 and
4989: split this statement into three separate selects
4990:
4991: SELECT 1 INTO dummy
4992: FROM dual
4993: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
4994: FROM pa_cost_distribution_lines_all pcdl,
4995: pa_expenditure_items_all pei,
4996: pa_tasks pat,
5029:
5030: BEGIN
5031:
5032: SELECT 1 INTO dummy
5033: FROM DUAL
5034: WHERE EXISTS (SELECT 'x' -- project has assets to be reverse capitalized
5035: FROM pa_project_assets ppa
5036: WHERE ppa.project_id+0 = p_project_id
5037: AND ppa.reverse_flag = 'Y'
5051:
5052: BEGIN
5053:
5054: SELECT 1 INTO dummy
5055: FROM DUAL
5056: WHERE EXISTS (SELECT 'x' -- Untransferred assetlines exist
5057: FROM pa_project_asset_lines pal
5058: WHERE pal.project_id = p_project_id
5059: AND pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
5076:
5077: BEGIN
5078:
5079: SELECT 1 INTO dummy
5080: FROM dual
5081: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized Retirement Cost expenditure items
5082: FROM pa_cost_distribution_lines_all pcdl,
5083: pa_expenditure_items_all pei,
5084: pa_tasks pat,
5127:
5128: BEGIN
5129:
5130: SELECT 1 INTO dummy
5131: FROM dual
5132: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5133: FROM pa_cost_distribution_lines_all pcdl,
5134: pa_expenditure_items_all pei,
5135: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5872: when NO_DATA_FOUND then
5873:
5874: SELECT 'N'
5875: into l_alc_exists
5876: from dual
5877: WHERE NOT EXISTS (
5878: SELECT gl.ledger_id
5879: FROM gl_alc_ledger_rships_v gl
5880: WHERE gl.source_ledger_id = v_alc_ledger.set_of_books_id