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.PA_PROJECT_PUB dependencies on DBMS_SQL

Line 15505: l_cursor := dbms_sql.open_cursor;

15501: l_statement := l_statement ||
15502: -- ' WHERE PROJECT_ID = '|| TO_CHAR(l_project_id);
15503: ' WHERE PROJECT_ID = :prj_id'; --bug 2955326
15504:
15505: l_cursor := dbms_sql.open_cursor;
15506: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
15507:
15508: --bug 2955326
15509: IF l_b_segment1_flag = 'Y' THEN

Line 15506: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);

15502: -- ' WHERE PROJECT_ID = '|| TO_CHAR(l_project_id);
15503: ' WHERE PROJECT_ID = :prj_id'; --bug 2955326
15504:
15505: l_cursor := dbms_sql.open_cursor;
15506: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
15507:
15508: --bug 2955326
15509: IF l_b_segment1_flag = 'Y' THEN
15510: DBMS_SQL.BIND_VARIABLE(l_cursor, ':segment1', RTRIM(p_project_in.pa_project_number));

Line 15510: DBMS_SQL.BIND_VARIABLE(l_cursor, ':segment1', RTRIM(p_project_in.pa_project_number));

15506: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
15507:
15508: --bug 2955326
15509: IF l_b_segment1_flag = 'Y' THEN
15510: DBMS_SQL.BIND_VARIABLE(l_cursor, ':segment1', RTRIM(p_project_in.pa_project_number));
15511: END IF;
15512:
15513: IF l_b_proj_name_flag = 'Y' THEN
15514: DBMS_SQL.BIND_VARIABLE(l_cursor, ':project_name', RTRIM(p_project_in.project_name));

Line 15514: DBMS_SQL.BIND_VARIABLE(l_cursor, ':project_name', RTRIM(p_project_in.project_name));

15510: DBMS_SQL.BIND_VARIABLE(l_cursor, ':segment1', RTRIM(p_project_in.pa_project_number));
15511: END IF;
15512:
15513: IF l_b_proj_name_flag = 'Y' THEN
15514: DBMS_SQL.BIND_VARIABLE(l_cursor, ':project_name', RTRIM(p_project_in.project_name));
15515: END IF;
15516:
15517: IF l_b_long_name_flag = 'Y' THEN
15518: DBMS_SQL.BIND_VARIABLE(l_cursor, ':long_name', RTRIM(p_project_in.long_name));

Line 15518: DBMS_SQL.BIND_VARIABLE(l_cursor, ':long_name', RTRIM(p_project_in.long_name));

15514: DBMS_SQL.BIND_VARIABLE(l_cursor, ':project_name', RTRIM(p_project_in.project_name));
15515: END IF;
15516:
15517: IF l_b_long_name_flag = 'Y' THEN
15518: DBMS_SQL.BIND_VARIABLE(l_cursor, ':long_name', RTRIM(p_project_in.long_name));
15519: END IF;
15520:
15521: IF l_b_pm_proj_ref_flag = 'Y' THEN
15522: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_project_reference', RTRIM(p_project_in.pm_project_reference));

Line 15522: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_project_reference', RTRIM(p_project_in.pm_project_reference));

15518: DBMS_SQL.BIND_VARIABLE(l_cursor, ':long_name', RTRIM(p_project_in.long_name));
15519: END IF;
15520:
15521: IF l_b_pm_proj_ref_flag = 'Y' THEN
15522: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_project_reference', RTRIM(p_project_in.pm_project_reference));
15523: END IF;
15524:
15525: IF l_b_co_org_id_flag = 'Y' THEN
15526: DBMS_SQL.BIND_VARIABLE(l_cursor, ':carrying_out_org_id', TO_CHAR(p_project_in.carrying_out_organization_id));

Line 15526: DBMS_SQL.BIND_VARIABLE(l_cursor, ':carrying_out_org_id', TO_CHAR(p_project_in.carrying_out_organization_id));

15522: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_project_reference', RTRIM(p_project_in.pm_project_reference));
15523: END IF;
15524:
15525: IF l_b_co_org_id_flag = 'Y' THEN
15526: DBMS_SQL.BIND_VARIABLE(l_cursor, ':carrying_out_org_id', TO_CHAR(p_project_in.carrying_out_organization_id));
15527: END IF;
15528:
15529: IF l_b_pub_sec_flag = 'Y' THEN
15530: DBMS_SQL.BIND_VARIABLE(l_cursor, ':public_sector_flag', p_project_in.public_sector_flag);

Line 15530: DBMS_SQL.BIND_VARIABLE(l_cursor, ':public_sector_flag', p_project_in.public_sector_flag);

15526: DBMS_SQL.BIND_VARIABLE(l_cursor, ':carrying_out_org_id', TO_CHAR(p_project_in.carrying_out_organization_id));
15527: END IF;
15528:
15529: IF l_b_pub_sec_flag = 'Y' THEN
15530: DBMS_SQL.BIND_VARIABLE(l_cursor, ':public_sector_flag', p_project_in.public_sector_flag);
15531: END IF;
15532:
15533: IF l_b_dist_rule_flag = 'Y' THEN
15534: DBMS_SQL.BIND_VARIABLE(l_cursor, ':dist_rule', p_project_in.distribution_rule);

Line 15534: DBMS_SQL.BIND_VARIABLE(l_cursor, ':dist_rule', p_project_in.distribution_rule);

15530: DBMS_SQL.BIND_VARIABLE(l_cursor, ':public_sector_flag', p_project_in.public_sector_flag);
15531: END IF;
15532:
15533: IF l_b_dist_rule_flag = 'Y' THEN
15534: DBMS_SQL.BIND_VARIABLE(l_cursor, ':dist_rule', p_project_in.distribution_rule);
15535: --Bug 3279981 Review. Added two bind variables below
15536: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_acc_mth',
15537: substr(p_project_in.distribution_rule, 1, instr(p_project_in.distribution_rule,'/')-1) );
15538: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_mth',

Line 15536: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_acc_mth',

15532:
15533: IF l_b_dist_rule_flag = 'Y' THEN
15534: DBMS_SQL.BIND_VARIABLE(l_cursor, ':dist_rule', p_project_in.distribution_rule);
15535: --Bug 3279981 Review. Added two bind variables below
15536: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_acc_mth',
15537: substr(p_project_in.distribution_rule, 1, instr(p_project_in.distribution_rule,'/')-1) );
15538: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_mth',
15539: substr(p_project_in.distribution_rule, instr(p_project_in.distribution_rule,'/')+1) );
15540: END IF;

Line 15538: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_mth',

15534: DBMS_SQL.BIND_VARIABLE(l_cursor, ':dist_rule', p_project_in.distribution_rule);
15535: --Bug 3279981 Review. Added two bind variables below
15536: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_acc_mth',
15537: substr(p_project_in.distribution_rule, 1, instr(p_project_in.distribution_rule,'/')-1) );
15538: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_mth',
15539: substr(p_project_in.distribution_rule, instr(p_project_in.distribution_rule,'/')+1) );
15540: END IF;
15541:
15542: IF l_b_desc_flag = 'Y' THEN

Line 15543: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', RTRIM(p_project_in.description));

15539: substr(p_project_in.distribution_rule, instr(p_project_in.distribution_rule,'/')+1) );
15540: END IF;
15541:
15542: IF l_b_desc_flag = 'Y' THEN
15543: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', RTRIM(p_project_in.description));
15544: END IF;
15545:
15546: IF l_b_start_date_flag = 'Y' THEN
15547: DBMS_SQL.BIND_VARIABLE(l_cursor, ':start_date', l_project_start_date);

Line 15547: DBMS_SQL.BIND_VARIABLE(l_cursor, ':start_date', l_project_start_date);

15543: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', RTRIM(p_project_in.description));
15544: END IF;
15545:
15546: IF l_b_start_date_flag = 'Y' THEN
15547: DBMS_SQL.BIND_VARIABLE(l_cursor, ':start_date', l_project_start_date);
15548: END IF;
15549:
15550: IF l_b_comp_date_flag = 'Y' THEN
15551: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_date', l_project_completion_date);

Line 15551: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_date', l_project_completion_date);

15547: DBMS_SQL.BIND_VARIABLE(l_cursor, ':start_date', l_project_start_date);
15548: END IF;
15549:
15550: IF l_b_comp_date_flag = 'Y' THEN
15551: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_date', l_project_completion_date);
15552: END IF;
15553:
15554: IF l_b_early_sd_flag = 'Y' THEN
15555: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_start_date', p_project_in.early_start_date);

Line 15555: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_start_date', p_project_in.early_start_date);

15551: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_date', l_project_completion_date);
15552: END IF;
15553:
15554: IF l_b_early_sd_flag = 'Y' THEN
15555: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_start_date', p_project_in.early_start_date);
15556: END IF;
15557:
15558: IF l_b_early_fd_flag = 'Y' THEN
15559: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_finish_date', p_project_in.early_finish_date);

Line 15559: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_finish_date', p_project_in.early_finish_date);

15555: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_start_date', p_project_in.early_start_date);
15556: END IF;
15557:
15558: IF l_b_early_fd_flag = 'Y' THEN
15559: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_finish_date', p_project_in.early_finish_date);
15560: END IF;
15561:
15562: IF l_b_late_sd_flag = 'Y' THEN
15563: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);

Line 15563: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);

15559: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_finish_date', p_project_in.early_finish_date);
15560: END IF;
15561:
15562: IF l_b_late_sd_flag = 'Y' THEN
15563: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);
15564: END IF;
15565:
15566: IF l_b_late_sd_flag = 'Y' THEN
15567: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);

Line 15567: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);

15563: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);
15564: END IF;
15565:
15566: IF l_b_late_sd_flag = 'Y' THEN
15567: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);
15568: END IF;
15569:
15570: IF l_b_late_fd_flag = 'Y' THEN
15571: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_finish_date', p_project_in.late_finish_date);

Line 15571: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_finish_date', p_project_in.late_finish_date);

15567: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);
15568: END IF;
15569:
15570: IF l_b_late_fd_flag = 'Y' THEN
15571: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_finish_date', p_project_in.late_finish_date);
15572: END IF;
15573:
15574: IF l_b_sch_sd_flag = 'Y' THEN
15575: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_start_date', p_project_in.scheduled_start_date);

Line 15575: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_start_date', p_project_in.scheduled_start_date);

15571: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_finish_date', p_project_in.late_finish_date);
15572: END IF;
15573:
15574: IF l_b_sch_sd_flag = 'Y' THEN
15575: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_start_date', p_project_in.scheduled_start_date);
15576: END IF;
15577:
15578: IF l_b_sch_fd_flag = 'Y' THEN
15579: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_finish_date', p_project_in.scheduled_finish_date);

Line 15579: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_finish_date', p_project_in.scheduled_finish_date);

15575: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_start_date', p_project_in.scheduled_start_date);
15576: END IF;
15577:
15578: IF l_b_sch_fd_flag = 'Y' THEN
15579: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_finish_date', p_project_in.scheduled_finish_date);
15580: END IF;
15581:
15582: IF l_b_attr_cat_flag = 'Y' THEN
15583: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(p_project_in.attribute_category));

Line 15583: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(p_project_in.attribute_category));

15579: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_finish_date', p_project_in.scheduled_finish_date);
15580: END IF;
15581:
15582: IF l_b_attr_cat_flag = 'Y' THEN
15583: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(p_project_in.attribute_category));
15584: END IF;
15585:
15586: IF l_b_attr1_flag = 'Y' THEN
15587: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(p_project_in.attribute1));

Line 15587: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(p_project_in.attribute1));

15583: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(p_project_in.attribute_category));
15584: END IF;
15585:
15586: IF l_b_attr1_flag = 'Y' THEN
15587: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(p_project_in.attribute1));
15588: END IF;
15589:
15590: IF l_b_attr2_flag = 'Y' THEN
15591: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(p_project_in.attribute2));

Line 15591: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(p_project_in.attribute2));

15587: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(p_project_in.attribute1));
15588: END IF;
15589:
15590: IF l_b_attr2_flag = 'Y' THEN
15591: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(p_project_in.attribute2));
15592: END IF;
15593:
15594: IF l_b_attr3_flag = 'Y' THEN
15595: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(p_project_in.attribute3));

Line 15595: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(p_project_in.attribute3));

15591: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(p_project_in.attribute2));
15592: END IF;
15593:
15594: IF l_b_attr3_flag = 'Y' THEN
15595: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(p_project_in.attribute3));
15596: END IF;
15597:
15598: IF l_b_attr4_flag = 'Y' THEN
15599: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(p_project_in.attribute4));

Line 15599: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(p_project_in.attribute4));

15595: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(p_project_in.attribute3));
15596: END IF;
15597:
15598: IF l_b_attr4_flag = 'Y' THEN
15599: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(p_project_in.attribute4));
15600: END IF;
15601:
15602: IF l_b_attr5_flag = 'Y' THEN
15603: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(p_project_in.attribute5));

Line 15603: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(p_project_in.attribute5));

15599: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(p_project_in.attribute4));
15600: END IF;
15601:
15602: IF l_b_attr5_flag = 'Y' THEN
15603: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(p_project_in.attribute5));
15604: END IF;
15605:
15606: IF l_b_attr6_flag = 'Y' THEN
15607: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(p_project_in.attribute6));

Line 15607: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(p_project_in.attribute6));

15603: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(p_project_in.attribute5));
15604: END IF;
15605:
15606: IF l_b_attr6_flag = 'Y' THEN
15607: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(p_project_in.attribute6));
15608: END IF;
15609:
15610: IF l_b_attr7_flag = 'Y' THEN
15611: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(p_project_in.attribute7));

Line 15611: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(p_project_in.attribute7));

15607: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(p_project_in.attribute6));
15608: END IF;
15609:
15610: IF l_b_attr7_flag = 'Y' THEN
15611: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(p_project_in.attribute7));
15612: END IF;
15613:
15614: IF l_b_attr8_flag = 'Y' THEN
15615: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(p_project_in.attribute8));

Line 15615: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(p_project_in.attribute8));

15611: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(p_project_in.attribute7));
15612: END IF;
15613:
15614: IF l_b_attr8_flag = 'Y' THEN
15615: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(p_project_in.attribute8));
15616: END IF;
15617:
15618: IF l_b_attr9_flag = 'Y' THEN
15619: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(p_project_in.attribute9));

Line 15619: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(p_project_in.attribute9));

15615: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(p_project_in.attribute8));
15616: END IF;
15617:
15618: IF l_b_attr9_flag = 'Y' THEN
15619: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(p_project_in.attribute9));
15620: END IF;
15621:
15622: IF l_b_attr10_flag = 'Y' THEN
15623: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(p_project_in.attribute10));

Line 15623: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(p_project_in.attribute10));

15619: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(p_project_in.attribute9));
15620: END IF;
15621:
15622: IF l_b_attr10_flag = 'Y' THEN
15623: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(p_project_in.attribute10));
15624: END IF;
15625:
15626: IF l_b_output_tx_code_flag = 'Y' THEN
15627: DBMS_SQL.BIND_VARIABLE(l_cursor, ':output_tx_code', RTRIM(p_project_in.output_tax_code));

Line 15627: DBMS_SQL.BIND_VARIABLE(l_cursor, ':output_tx_code', RTRIM(p_project_in.output_tax_code));

15623: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(p_project_in.attribute10));
15624: END IF;
15625:
15626: IF l_b_output_tx_code_flag = 'Y' THEN
15627: DBMS_SQL.BIND_VARIABLE(l_cursor, ':output_tx_code', RTRIM(p_project_in.output_tax_code));
15628: END IF;
15629:
15630: IF l_b_ret_tx_code_flag = 'Y' THEN
15631: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_tx_code', RTRIM(p_project_in.retention_tax_code));

Line 15631: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_tx_code', RTRIM(p_project_in.retention_tax_code));

15627: DBMS_SQL.BIND_VARIABLE(l_cursor, ':output_tx_code', RTRIM(p_project_in.output_tax_code));
15628: END IF;
15629:
15630: IF l_b_ret_tx_code_flag = 'Y' THEN
15631: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_tx_code', RTRIM(p_project_in.retention_tax_code));
15632: END IF;
15633:
15634: IF l_b_proj_cur_code_flag = 'Y' THEN
15635: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_cur_code', RTRIM(p_project_in.project_currency_code));

Line 15635: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_cur_code', RTRIM(p_project_in.project_currency_code));

15631: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_tx_code', RTRIM(p_project_in.retention_tax_code));
15632: END IF;
15633:
15634: IF l_b_proj_cur_code_flag = 'Y' THEN
15635: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_cur_code', RTRIM(p_project_in.project_currency_code));
15636: END IF;
15637:
15638: IF l_b_allow_x_chg_flag = 'Y' THEN
15639: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_x_chg_flag', RTRIM(p_project_in.allow_cross_charge_flag));

Line 15639: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_x_chg_flag', RTRIM(p_project_in.allow_cross_charge_flag));

15635: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_cur_code', RTRIM(p_project_in.project_currency_code));
15636: END IF;
15637:
15638: IF l_b_allow_x_chg_flag = 'Y' THEN
15639: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_x_chg_flag', RTRIM(p_project_in.allow_cross_charge_flag));
15640: END IF;
15641:
15642: IF l_b_proj_rt_date_flag = 'Y' THEN
15643: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_date', p_project_in.project_rate_date);

Line 15643: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_date', p_project_in.project_rate_date);

15639: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_x_chg_flag', RTRIM(p_project_in.allow_cross_charge_flag));
15640: END IF;
15641:
15642: IF l_b_proj_rt_date_flag = 'Y' THEN
15643: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_date', p_project_in.project_rate_date);
15644: END IF;
15645:
15646: IF l_b_proj_rt_tp_flag = 'Y' THEN
15647: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_tp', RTRIM(p_project_in.project_rate_type));

Line 15647: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_tp', RTRIM(p_project_in.project_rate_type));

15643: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_date', p_project_in.project_rate_date);
15644: END IF;
15645:
15646: IF l_b_proj_rt_tp_flag = 'Y' THEN
15647: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_tp', RTRIM(p_project_in.project_rate_type));
15648: END IF;
15649:
15650: IF l_cc_proc_lb_flag = 'Y' THEN
15651: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lb_flag', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048

Line 15651: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lb_flag', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048

15647: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_tp', RTRIM(p_project_in.project_rate_type));
15648: END IF;
15649:
15650: IF l_cc_proc_lb_flag = 'Y' THEN
15651: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lb_flag', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048
15652: END IF;
15653:
15654: IF l_b_lb_tp_sch_id_flag = 'Y' THEN
15655: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_sch_id', p_project_in.labor_tp_schedule_id );

Line 15655: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_sch_id', p_project_in.labor_tp_schedule_id );

15651: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lb_flag', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048
15652: END IF;
15653:
15654: IF l_b_lb_tp_sch_id_flag = 'Y' THEN
15655: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_sch_id', p_project_in.labor_tp_schedule_id );
15656: END IF;
15657:
15658: IF l_b_lb_tp_fixed_dt_flag = 'Y' THEN
15659: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_fixed_dt', p_project_in.labor_tp_fixed_date);

Line 15659: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_fixed_dt', p_project_in.labor_tp_fixed_date);

15655: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_sch_id', p_project_in.labor_tp_schedule_id );
15656: END IF;
15657:
15658: IF l_b_lb_tp_fixed_dt_flag = 'Y' THEN
15659: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_fixed_dt', p_project_in.labor_tp_fixed_date);
15660: END IF;
15661:
15662: IF l_b_cc_proc_nl_flag = 'Y' THEN
15663: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_flag', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048

Line 15663: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_flag', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048

15659: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_fixed_dt', p_project_in.labor_tp_fixed_date);
15660: END IF;
15661:
15662: IF l_b_cc_proc_nl_flag = 'Y' THEN
15663: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_flag', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048
15664: END IF;
15665:
15666: IF l_b_nl_tp_sch_id_flag = 'Y' THEN
15667: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_project_in.nl_tp_schedule_id);

Line 15667: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_project_in.nl_tp_schedule_id);

15663: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_flag', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048
15664: END IF;
15665:
15666: IF l_b_nl_tp_sch_id_flag = 'Y' THEN
15667: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_project_in.nl_tp_schedule_id);
15668: END IF;
15669:
15670: IF l_b_nl_tp_fx_dt_flag = 'Y' THEN
15671: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_project_in.nl_tp_fixed_date);

Line 15671: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_project_in.nl_tp_fixed_date);

15667: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_project_in.nl_tp_schedule_id);
15668: END IF;
15669:
15670: IF l_b_nl_tp_fx_dt_flag = 'Y' THEN
15671: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_project_in.nl_tp_fixed_date);
15672: END IF;
15673:
15674: IF l_b_role_list_id_flag = 'Y' THEN
15675: DBMS_SQL.BIND_VARIABLE(l_cursor, ':role_list_id', p_project_in.role_list_id);

Line 15675: DBMS_SQL.BIND_VARIABLE(l_cursor, ':role_list_id', p_project_in.role_list_id);

15671: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_project_in.nl_tp_fixed_date);
15672: END IF;
15673:
15674: IF l_b_role_list_id_flag = 'Y' THEN
15675: DBMS_SQL.BIND_VARIABLE(l_cursor, ':role_list_id', p_project_in.role_list_id);
15676: END IF;
15677:
15678: IF l_b_work_type_id_flag = 'Y' THEN
15679: DBMS_SQL.BIND_VARIABLE(l_cursor, ':work_type_id', p_project_in.work_type_id);

Line 15679: DBMS_SQL.BIND_VARIABLE(l_cursor, ':work_type_id', p_project_in.work_type_id);

15675: DBMS_SQL.BIND_VARIABLE(l_cursor, ':role_list_id', p_project_in.role_list_id);
15676: END IF;
15677:
15678: IF l_b_work_type_id_flag = 'Y' THEN
15679: DBMS_SQL.BIND_VARIABLE(l_cursor, ':work_type_id', p_project_in.work_type_id);
15680: END IF;
15681:
15682: IF l_b_cal_id_flag = 'Y' THEN
15683: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cal_id', p_project_in.calendar_id);

Line 15683: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cal_id', p_project_in.calendar_id);

15679: DBMS_SQL.BIND_VARIABLE(l_cursor, ':work_type_id', p_project_in.work_type_id);
15680: END IF;
15681:
15682: IF l_b_cal_id_flag = 'Y' THEN
15683: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cal_id', p_project_in.calendar_id);
15684: END IF;
15685:
15686: IF l_b_loc_id_flag = 'Y' THEN
15687: DBMS_SQL.BIND_VARIABLE(l_cursor, ':loc_id', p_project_in.location_id);

Line 15687: DBMS_SQL.BIND_VARIABLE(l_cursor, ':loc_id', p_project_in.location_id);

15683: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cal_id', p_project_in.calendar_id);
15684: END IF;
15685:
15686: IF l_b_loc_id_flag = 'Y' THEN
15687: DBMS_SQL.BIND_VARIABLE(l_cursor, ':loc_id', p_project_in.location_id);
15688: END IF;
15689:
15690: IF l_b_prob_memb_id_flag = 'Y' THEN
15691: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prob_memb_id', p_project_in.probability_member_id);

Line 15691: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prob_memb_id', p_project_in.probability_member_id);

15687: DBMS_SQL.BIND_VARIABLE(l_cursor, ':loc_id', p_project_in.location_id);
15688: END IF;
15689:
15690: IF l_b_prob_memb_id_flag = 'Y' THEN
15691: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prob_memb_id', p_project_in.probability_member_id);
15692: END IF;
15693:
15694: IF l_b_proj_value_flag = 'Y' THEN
15695: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_value', p_project_in.project_value);

Line 15695: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_value', p_project_in.project_value);

15691: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prob_memb_id', p_project_in.probability_member_id);
15692: END IF;
15693:
15694: IF l_b_proj_value_flag = 'Y' THEN
15695: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_value', p_project_in.project_value);
15696: END IF;
15697:
15698: IF l_b_exp_apprv_dt_flag = 'Y' THEN
15699: DBMS_SQL.BIND_VARIABLE(l_cursor, ':exp_apprv_date', p_project_in.expected_approval_date);

Line 15699: DBMS_SQL.BIND_VARIABLE(l_cursor, ':exp_apprv_date', p_project_in.expected_approval_date);

15695: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_value', p_project_in.project_value);
15696: END IF;
15697:
15698: IF l_b_exp_apprv_dt_flag = 'Y' THEN
15699: DBMS_SQL.BIND_VARIABLE(l_cursor, ':exp_apprv_date', p_project_in.expected_approval_date);
15700: END IF;
15701:
15702: IF l_b_cst_jb_gp_id_flag = 'Y' THEN
15703: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_jb_gp_id', p_project_in.cost_job_group_id);

Line 15703: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_jb_gp_id', p_project_in.cost_job_group_id);

15699: DBMS_SQL.BIND_VARIABLE(l_cursor, ':exp_apprv_date', p_project_in.expected_approval_date);
15700: END IF;
15701:
15702: IF l_b_cst_jb_gp_id_flag = 'Y' THEN
15703: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_jb_gp_id', p_project_in.cost_job_group_id);
15704: END IF;
15705:
15706: IF l_b_bill_jb_gp_id_flag = 'Y' THEN
15707: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bill_jb_gp_id', p_project_in.bill_job_group_id);

Line 15707: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bill_jb_gp_id', p_project_in.bill_job_group_id);

15703: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_jb_gp_id', p_project_in.cost_job_group_id);
15704: END IF;
15705:
15706: IF l_b_bill_jb_gp_id_flag = 'Y' THEN
15707: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bill_jb_gp_id', p_project_in.bill_job_group_id);
15708: END IF;
15709:
15710: IF l_b_emp_bill_rt_sch_id_flag = 'Y' THEN
15711: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_project_in.emp_bill_rate_schedule_id);

Line 15711: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_project_in.emp_bill_rate_schedule_id);

15707: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bill_jb_gp_id', p_project_in.bill_job_group_id);
15708: END IF;
15709:
15710: IF l_b_emp_bill_rt_sch_id_flag = 'Y' THEN
15711: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_project_in.emp_bill_rate_schedule_id);
15712: END IF;
15713:
15714: IF l_b_jb_bill_rt_sch_id_flag = 'Y' THEN
15715: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_project_in.job_bill_rate_schedule_id);

Line 15715: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_project_in.job_bill_rate_schedule_id);

15711: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_project_in.emp_bill_rate_schedule_id);
15712: END IF;
15713:
15714: IF l_b_jb_bill_rt_sch_id_flag = 'Y' THEN
15715: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_project_in.job_bill_rate_schedule_id);
15716: END IF;
15717:
15718: IF l_b_comp_mtch_wt_flag = 'Y' THEN
15719: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_match_wt', p_project_in.competence_match_wt);

Line 15719: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_match_wt', p_project_in.competence_match_wt);

15715: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_project_in.job_bill_rate_schedule_id);
15716: END IF;
15717:
15718: IF l_b_comp_mtch_wt_flag = 'Y' THEN
15719: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_match_wt', p_project_in.competence_match_wt);
15720: END IF;
15721:
15722: IF l_b_avail_mtch_wt_flag = 'Y' THEN
15723: DBMS_SQL.BIND_VARIABLE(l_cursor, ':avail_mtch_wt', p_project_in.availability_match_wt);

Line 15723: DBMS_SQL.BIND_VARIABLE(l_cursor, ':avail_mtch_wt', p_project_in.availability_match_wt);

15719: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_match_wt', p_project_in.competence_match_wt);
15720: END IF;
15721:
15722: IF l_b_avail_mtch_wt_flag = 'Y' THEN
15723: DBMS_SQL.BIND_VARIABLE(l_cursor, ':avail_mtch_wt', p_project_in.availability_match_wt);
15724: END IF;
15725:
15726: IF l_b_jb_lvl_mt_wt_flag = 'Y' THEN
15727: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_lvl_mt_wt', p_project_in.job_level_match_wt);

Line 15727: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_lvl_mt_wt', p_project_in.job_level_match_wt);

15723: DBMS_SQL.BIND_VARIABLE(l_cursor, ':avail_mtch_wt', p_project_in.availability_match_wt);
15724: END IF;
15725:
15726: IF l_b_jb_lvl_mt_wt_flag = 'Y' THEN
15727: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_lvl_mt_wt', p_project_in.job_level_match_wt);
15728: END IF;
15729:
15730: IF l_b_search_min_avail_flag = 'Y' THEN
15731: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_min_avail', p_project_in.search_min_availability);

Line 15731: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_min_avail', p_project_in.search_min_availability);

15727: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_lvl_mt_wt', p_project_in.job_level_match_wt);
15728: END IF;
15729:
15730: IF l_b_search_min_avail_flag = 'Y' THEN
15731: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_min_avail', p_project_in.search_min_availability);
15732: END IF;
15733:
15734: IF l_b_srch_org_hier_id_flag = 'Y' THEN
15735: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_org_hier_id);

Line 15735: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_org_hier_id);

15731: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_min_avail', p_project_in.search_min_availability);
15732: END IF;
15733:
15734: IF l_b_srch_org_hier_id_flag = 'Y' THEN
15735: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_org_hier_id);
15736: END IF;
15737:
15738: IF l_b_srch_st_org_id_flag = 'Y' THEN
15739: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_starting_org_id);

Line 15739: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_starting_org_id);

15735: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_org_hier_id);
15736: END IF;
15737:
15738: IF l_b_srch_st_org_id_flag = 'Y' THEN
15739: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_starting_org_id);
15740: END IF;
15741:
15742: IF l_b_min_can_sc_req_for_nom = 'Y' THEN
15743: DBMS_SQL.BIND_VARIABLE(l_cursor, ':min_can_sc_req_for_nom', p_project_in.min_cand_score_reqd_for_nom);

Line 15743: DBMS_SQL.BIND_VARIABLE(l_cursor, ':min_can_sc_req_for_nom', p_project_in.min_cand_score_reqd_for_nom);

15739: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_starting_org_id);
15740: END IF;
15741:
15742: IF l_b_min_can_sc_req_for_nom = 'Y' THEN
15743: DBMS_SQL.BIND_VARIABLE(l_cursor, ':min_can_sc_req_for_nom', p_project_in.min_cand_score_reqd_for_nom);
15744: END IF;
15745:
15746: /* Commented the code for bug 4630836:
15747: IF l_b_nn_lb_std_bl_rt_sch_id_f = 'Y' THEN

Line 15748: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);

15744: END IF;
15745:
15746: /* Commented the code for bug 4630836:
15747: IF l_b_nn_lb_std_bl_rt_sch_id_f = 'Y' THEN
15748: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);
15749: END IF; */
15750:
15751: IF l_b_proj_bil_xch_rt_flag = 'Y' THEN
15752: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_xch_rt', p_project_in.project_bil_exchange_rate);

Line 15752: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_xch_rt', p_project_in.project_bil_exchange_rate);

15748: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);
15749: END IF; */
15750:
15751: IF l_b_proj_bil_xch_rt_flag = 'Y' THEN
15752: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_xch_rt', p_project_in.project_bil_exchange_rate);
15753: END IF;
15754:
15755: IF l_b_pjfnc_bil_xch_rt_flag = 'Y' THEN
15756: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pjfnc_bil_xch_rt', p_project_in.projfunc_bil_exchange_rate);

Line 15756: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pjfnc_bil_xch_rt', p_project_in.projfunc_bil_exchange_rate);

15752: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_xch_rt', p_project_in.project_bil_exchange_rate);
15753: END IF;
15754:
15755: IF l_b_pjfnc_bil_xch_rt_flag = 'Y' THEN
15756: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pjfnc_bil_xch_rt', p_project_in.projfunc_bil_exchange_rate);
15757: END IF;
15758:
15759: IF l_b_fnding_xch_rt_flag = 'Y' THEN
15760: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_xch_rt', p_project_in.funding_exchange_rate);

Line 15760: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_xch_rt', p_project_in.funding_exchange_rate);

15756: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pjfnc_bil_xch_rt', p_project_in.projfunc_bil_exchange_rate);
15757: END IF;
15758:
15759: IF l_b_fnding_xch_rt_flag = 'Y' THEN
15760: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_xch_rt', p_project_in.funding_exchange_rate);
15761: END IF;
15762:
15763: IF l_b_enable_auto_srch_flag = 'Y' THEN
15764: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_auto_srch', p_project_in.enable_automated_search);

Line 15764: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_auto_srch', p_project_in.enable_automated_search);

15760: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_xch_rt', p_project_in.funding_exchange_rate);
15761: END IF;
15762:
15763: IF l_b_enable_auto_srch_flag = 'Y' THEN
15764: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_auto_srch', p_project_in.enable_automated_search);
15765: END IF;
15766:
15767: IF l_b_srch_cntry_code_flag = 'Y' THEN
15768: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_cntry_code', RTRIM(p_project_in.search_country_code));

Line 15768: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_cntry_code', RTRIM(p_project_in.search_country_code));

15764: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_auto_srch', p_project_in.enable_automated_search);
15765: END IF;
15766:
15767: IF l_b_srch_cntry_code_flag = 'Y' THEN
15768: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_cntry_code', RTRIM(p_project_in.search_country_code));
15769: END IF;
15770:
15771: IF l_b_invproc_crncy_tp_flag = 'Y' THEN
15772: DBMS_SQL.BIND_VARIABLE(l_cursor, ':invproc_currency_type', RTRIM(p_project_in.invproc_currency_type));

Line 15772: DBMS_SQL.BIND_VARIABLE(l_cursor, ':invproc_currency_type', RTRIM(p_project_in.invproc_currency_type));

15768: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_cntry_code', RTRIM(p_project_in.search_country_code));
15769: END IF;
15770:
15771: IF l_b_invproc_crncy_tp_flag = 'Y' THEN
15772: DBMS_SQL.BIND_VARIABLE(l_cursor, ':invproc_currency_type', RTRIM(p_project_in.invproc_currency_type));
15773: END IF;
15774:
15775: IF l_b_revproc_crncy_cd_flag = 'Y' THEN
15776: DBMS_SQL.BIND_VARIABLE(l_cursor, ':revproc_currency_code', RTRIM(p_project_in.revproc_currency_code));

Line 15776: DBMS_SQL.BIND_VARIABLE(l_cursor, ':revproc_currency_code', RTRIM(p_project_in.revproc_currency_code));

15772: DBMS_SQL.BIND_VARIABLE(l_cursor, ':invproc_currency_type', RTRIM(p_project_in.invproc_currency_type));
15773: END IF;
15774:
15775: IF l_b_revproc_crncy_cd_flag = 'Y' THEN
15776: DBMS_SQL.BIND_VARIABLE(l_cursor, ':revproc_currency_code', RTRIM(p_project_in.revproc_currency_code));
15777: END IF;
15778:
15779: IF l_b_prj_bil_rt_dt_code_flag = 'Y' THEN
15780: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rate_date_code', RTRIM(p_project_in.project_bil_rate_date_code));

Line 15780: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rate_date_code', RTRIM(p_project_in.project_bil_rate_date_code));

15776: DBMS_SQL.BIND_VARIABLE(l_cursor, ':revproc_currency_code', RTRIM(p_project_in.revproc_currency_code));
15777: END IF;
15778:
15779: IF l_b_prj_bil_rt_dt_code_flag = 'Y' THEN
15780: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rate_date_code', RTRIM(p_project_in.project_bil_rate_date_code));
15781: END IF;
15782:
15783: IF l_b_proj_bil_rt_tp_flag = 'Y' THEN
15784: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rt_type', RTRIM(p_project_in.project_bil_rate_type));

Line 15784: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rt_type', RTRIM(p_project_in.project_bil_rate_type));

15780: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rate_date_code', RTRIM(p_project_in.project_bil_rate_date_code));
15781: END IF;
15782:
15783: IF l_b_proj_bil_rt_tp_flag = 'Y' THEN
15784: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rt_type', RTRIM(p_project_in.project_bil_rate_type));
15785: END IF;
15786:
15787: IF l_b_prjfnc_crncy_code_flag = 'Y' THEN
15788: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_currency_code', RTRIM(p_project_in.projfunc_currency_code));

Line 15788: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_currency_code', RTRIM(p_project_in.projfunc_currency_code));

15784: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rt_type', RTRIM(p_project_in.project_bil_rate_type));
15785: END IF;
15786:
15787: IF l_b_prjfnc_crncy_code_flag = 'Y' THEN
15788: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_currency_code', RTRIM(p_project_in.projfunc_currency_code));
15789: END IF;
15790:
15791: IF l_b_prjfnc_bil_rt_dt_cd_f = 'Y' THEN
15792: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_dt_code', RTRIM(p_project_in.projfunc_bil_rate_date_code));

Line 15792: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_dt_code', RTRIM(p_project_in.projfunc_bil_rate_date_code));

15788: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_currency_code', RTRIM(p_project_in.projfunc_currency_code));
15789: END IF;
15790:
15791: IF l_b_prjfnc_bil_rt_dt_cd_f = 'Y' THEN
15792: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_dt_code', RTRIM(p_project_in.projfunc_bil_rate_date_code));
15793: END IF;
15794:
15795: IF l_b_prjfnc_bil_rt_tp_flag = 'Y' THEN
15796: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rate_type', RTRIM(p_project_in.projfunc_bil_rate_type));

Line 15796: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rate_type', RTRIM(p_project_in.projfunc_bil_rate_type));

15792: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_dt_code', RTRIM(p_project_in.projfunc_bil_rate_date_code));
15793: END IF;
15794:
15795: IF l_b_prjfnc_bil_rt_tp_flag = 'Y' THEN
15796: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rate_type', RTRIM(p_project_in.projfunc_bil_rate_type));
15797: END IF;
15798:
15799: IF l_b_fndng_rt_dt_cd_flag = 'Y' THEN
15800: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_date_code', RTRIM(p_project_in.funding_rate_date_code));

Line 15800: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_date_code', RTRIM(p_project_in.funding_rate_date_code));

15796: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rate_type', RTRIM(p_project_in.projfunc_bil_rate_type));
15797: END IF;
15798:
15799: IF l_b_fndng_rt_dt_cd_flag = 'Y' THEN
15800: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_date_code', RTRIM(p_project_in.funding_rate_date_code));
15801: END IF;
15802:
15803: IF l_b_fnding_rt_type_flag = 'Y' THEN
15804: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_type', RTRIM(p_project_in.funding_rate_type));

Line 15804: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_type', RTRIM(p_project_in.funding_rate_type));

15800: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_date_code', RTRIM(p_project_in.funding_rate_date_code));
15801: END IF;
15802:
15803: IF l_b_fnding_rt_type_flag = 'Y' THEN
15804: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_type', RTRIM(p_project_in.funding_rate_type));
15805: END IF;
15806:
15807: IF l_b_bsln_fnding_flag = 'Y' THEN
15808: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bsln_fnding_flag', RTRIM(p_project_in.baseline_funding_flag));

Line 15808: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bsln_fnding_flag', RTRIM(p_project_in.baseline_funding_flag));

15804: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_type', RTRIM(p_project_in.funding_rate_type));
15805: END IF;
15806:
15807: IF l_b_bsln_fnding_flag = 'Y' THEN
15808: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bsln_fnding_flag', RTRIM(p_project_in.baseline_funding_flag));
15809: END IF;
15810:
15811: IF l_b_prjfnc_cst_rt_tp_flag = 'Y' THEN
15812: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfnc_cost_rate_type', RTRIM(p_project_in.projfunc_cost_rate_type));

Line 15812: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfnc_cost_rate_type', RTRIM(p_project_in.projfunc_cost_rate_type));

15808: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bsln_fnding_flag', RTRIM(p_project_in.baseline_funding_flag));
15809: END IF;
15810:
15811: IF l_b_prjfnc_cst_rt_tp_flag = 'Y' THEN
15812: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfnc_cost_rate_type', RTRIM(p_project_in.projfunc_cost_rate_type));
15813: END IF;
15814:
15815: IF l_b_inv_bill_txn_cur_flag = 'Y' THEN
15816: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_by_bil_txn_cur_flag', RTRIM(p_project_in.inv_by_bill_trans_curr_flag));

Line 15816: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_by_bil_txn_cur_flag', RTRIM(p_project_in.inv_by_bill_trans_curr_flag));

15812: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfnc_cost_rate_type', RTRIM(p_project_in.projfunc_cost_rate_type));
15813: END IF;
15814:
15815: IF l_b_inv_bill_txn_cur_flag = 'Y' THEN
15816: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_by_bil_txn_cur_flag', RTRIM(p_project_in.inv_by_bill_trans_curr_flag));
15817: END IF;
15818:
15819: IF l_b_multi_crncy_bil_flag = 'Y' THEN
15820: DBMS_SQL.BIND_VARIABLE(l_cursor, ':multi_crncy_bil_flag', RTRIM(p_project_in.multi_currency_billing_flag));

Line 15820: DBMS_SQL.BIND_VARIABLE(l_cursor, ':multi_crncy_bil_flag', RTRIM(p_project_in.multi_currency_billing_flag));

15816: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_by_bil_txn_cur_flag', RTRIM(p_project_in.inv_by_bill_trans_curr_flag));
15817: END IF;
15818:
15819: IF l_b_multi_crncy_bil_flag = 'Y' THEN
15820: DBMS_SQL.BIND_VARIABLE(l_cursor, ':multi_crncy_bil_flag', RTRIM(p_project_in.multi_currency_billing_flag));
15821: END IF;
15822:
15823: IF l_b_prj_bil_rt_dt_flag = 'Y' THEN
15824: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_bil_rt_date', p_project_in.project_bil_rate_date);

Line 15824: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_bil_rt_date', p_project_in.project_bil_rate_date);

15820: DBMS_SQL.BIND_VARIABLE(l_cursor, ':multi_crncy_bil_flag', RTRIM(p_project_in.multi_currency_billing_flag));
15821: END IF;
15822:
15823: IF l_b_prj_bil_rt_dt_flag = 'Y' THEN
15824: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_bil_rt_date', p_project_in.project_bil_rate_date);
15825: END IF;
15826:
15827: IF l_b_prjfnc_bil_rt_dt_flag = 'Y' THEN
15828: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_date', p_project_in.projfunc_bil_rate_date);

Line 15828: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_date', p_project_in.projfunc_bil_rate_date);

15824: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_bil_rt_date', p_project_in.project_bil_rate_date);
15825: END IF;
15826:
15827: IF l_b_prjfnc_bil_rt_dt_flag = 'Y' THEN
15828: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_date', p_project_in.projfunc_bil_rate_date);
15829: END IF;
15830:
15831: IF l_b_fnding_rt_dt_flag = 'Y' THEN
15832: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rt_date', p_project_in.funding_rate_date);

Line 15832: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rt_date', p_project_in.funding_rate_date);

15828: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_date', p_project_in.projfunc_bil_rate_date);
15829: END IF;
15830:
15831: IF l_b_fnding_rt_dt_flag = 'Y' THEN
15832: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rt_date', p_project_in.funding_rate_date);
15833: END IF;
15834:
15835: IF l_b_prjfnc_cst_rt_dt_flag = 'Y' THEN
15836: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_cst_rt_date', p_project_in.projfunc_cost_rate_date);

Line 15836: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_cst_rt_date', p_project_in.projfunc_cost_rate_date);

15832: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rt_date', p_project_in.funding_rate_date);
15833: END IF;
15834:
15835: IF l_b_prjfnc_cst_rt_dt_flag = 'Y' THEN
15836: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_cst_rt_date', p_project_in.projfunc_cost_rate_date);
15837: END IF;
15838:
15839: IF l_b_asgn_prec_tsk_flag = 'Y' THEN
15840: DBMS_SQL.BIND_VARIABLE(l_cursor, ':asgn_prec_tsk_flg', RTRIM(p_project_in.assign_precedes_task));

Line 15840: DBMS_SQL.BIND_VARIABLE(l_cursor, ':asgn_prec_tsk_flg', RTRIM(p_project_in.assign_precedes_task));

15836: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_cst_rt_date', p_project_in.projfunc_cost_rate_date);
15837: END IF;
15838:
15839: IF l_b_asgn_prec_tsk_flag = 'Y' THEN
15840: DBMS_SQL.BIND_VARIABLE(l_cursor, ':asgn_prec_tsk_flg', RTRIM(p_project_in.assign_precedes_task));
15841: END IF;
15842:
15843: IF l_b_splt_cst_fm_wp_flag = 'Y' THEN
15844: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_wp_flag', RTRIM(p_project_in.split_cost_from_workplan_flag));

Line 15844: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_wp_flag', RTRIM(p_project_in.split_cost_from_workplan_flag));

15840: DBMS_SQL.BIND_VARIABLE(l_cursor, ':asgn_prec_tsk_flg', RTRIM(p_project_in.assign_precedes_task));
15841: END IF;
15842:
15843: IF l_b_splt_cst_fm_wp_flag = 'Y' THEN
15844: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_wp_flag', RTRIM(p_project_in.split_cost_from_workplan_flag));
15845: END IF;
15846:
15847: IF l_b_splt_cst_fm_bill_flag = 'Y' THEN
15848: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_bill_flag', RTRIM(p_project_in.split_cost_from_bill_flag));

Line 15848: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_bill_flag', RTRIM(p_project_in.split_cost_from_bill_flag));

15844: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_wp_flag', RTRIM(p_project_in.split_cost_from_workplan_flag));
15845: END IF;
15846:
15847: IF l_b_splt_cst_fm_bill_flag = 'Y' THEN
15848: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_bill_flag', RTRIM(p_project_in.split_cost_from_bill_flag));
15849: END IF;
15850:
15851: IF l_b_adv_act_set_id_flag = 'Y' THEN
15852: DBMS_SQL.BIND_VARIABLE(l_cursor, ':adv_act_set_id', p_project_in.adv_action_set_id);

Line 15852: DBMS_SQL.BIND_VARIABLE(l_cursor, ':adv_act_set_id', p_project_in.adv_action_set_id);

15848: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_bill_flag', RTRIM(p_project_in.split_cost_from_bill_flag));
15849: END IF;
15850:
15851: IF l_b_adv_act_set_id_flag = 'Y' THEN
15852: DBMS_SQL.BIND_VARIABLE(l_cursor, ':adv_act_set_id', p_project_in.adv_action_set_id);
15853: END IF;
15854:
15855: IF l_b_st_adv_act_set_flag = 'Y' THEN
15856: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_adv_act_set_flag', RTRIM(p_project_in.start_adv_action_set_flag));

Line 15856: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_adv_act_set_flag', RTRIM(p_project_in.start_adv_action_set_flag));

15852: DBMS_SQL.BIND_VARIABLE(l_cursor, ':adv_act_set_id', p_project_in.adv_action_set_id);
15853: END IF;
15854:
15855: IF l_b_st_adv_act_set_flag = 'Y' THEN
15856: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_adv_act_set_flag', RTRIM(p_project_in.start_adv_action_set_flag));
15857: END IF;
15858:
15859: IF l_b_pri_code_flag = 'Y' THEN
15860: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pri_code', RTRIM(p_project_in.priority_code));

Line 15860: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pri_code', RTRIM(p_project_in.priority_code));

15856: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_adv_act_set_flag', RTRIM(p_project_in.start_adv_action_set_flag));
15857: END IF;
15858:
15859: IF l_b_pri_code_flag = 'Y' THEN
15860: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pri_code', RTRIM(p_project_in.priority_code));
15861: END IF;
15862:
15863: IF l_b_retn_bil_inv_fmt_id_flg = 'Y' THEN
15864: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_bil_inv_fmt_id', TO_CHAR(p_project_in.retn_billing_inv_format_id));

Line 15864: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_bil_inv_fmt_id', TO_CHAR(p_project_in.retn_billing_inv_format_id));

15860: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pri_code', RTRIM(p_project_in.priority_code));
15861: END IF;
15862:
15863: IF l_b_retn_bil_inv_fmt_id_flg = 'Y' THEN
15864: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_bil_inv_fmt_id', TO_CHAR(p_project_in.retn_billing_inv_format_id));
15865: END IF;
15866:
15867: IF l_b_retn_acnt_flag = 'Y' THEN
15868: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_acnt_flag', RTRIM(p_project_in.retn_accounting_flag));

Line 15868: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_acnt_flag', RTRIM(p_project_in.retn_accounting_flag));

15864: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_bil_inv_fmt_id', TO_CHAR(p_project_in.retn_billing_inv_format_id));
15865: END IF;
15866:
15867: IF l_b_retn_acnt_flag = 'Y' THEN
15868: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_acnt_flag', RTRIM(p_project_in.retn_accounting_flag));
15869: END IF;
15870:
15871: IF l_b_reval_fndng_flag = 'Y' THEN
15872: DBMS_SQL.BIND_VARIABLE(l_cursor, ':reval_fndng_flg', RTRIM(p_project_in.revaluate_funding_flag));

Line 15872: DBMS_SQL.BIND_VARIABLE(l_cursor, ':reval_fndng_flg', RTRIM(p_project_in.revaluate_funding_flag));

15868: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_acnt_flag', RTRIM(p_project_in.retn_accounting_flag));
15869: END IF;
15870:
15871: IF l_b_reval_fndng_flag = 'Y' THEN
15872: DBMS_SQL.BIND_VARIABLE(l_cursor, ':reval_fndng_flg', RTRIM(p_project_in.revaluate_funding_flag));
15873: END IF;
15874:
15875: IF l_b_sec_lvl_flag = 'Y' THEN
15876: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sec_lvl', RTRIM(p_project_in.security_level));

Line 15876: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sec_lvl', RTRIM(p_project_in.security_level));

15872: DBMS_SQL.BIND_VARIABLE(l_cursor, ':reval_fndng_flg', RTRIM(p_project_in.revaluate_funding_flag));
15873: END IF;
15874:
15875: IF l_b_sec_lvl_flag = 'Y' THEN
15876: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sec_lvl', RTRIM(p_project_in.security_level));
15877: END IF;
15878:
15879: IF l_b_lbr_disc_rsn_code_flg = 'Y' THEN
15880: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_code', RTRIM(p_project_in.labor_disc_reason_code));

Line 15880: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_code', RTRIM(p_project_in.labor_disc_reason_code));

15876: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sec_lvl', RTRIM(p_project_in.security_level));
15877: END IF;
15878:
15879: IF l_b_lbr_disc_rsn_code_flg = 'Y' THEN
15880: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_code', RTRIM(p_project_in.labor_disc_reason_code));
15881: END IF;
15882:
15883: IF l_b_nn_lbr_disc_rsn_cd_flg = 'Y' THEN
15884: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));

Line 15884: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));

15880: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_code', RTRIM(p_project_in.labor_disc_reason_code));
15881: END IF;
15882:
15883: IF l_b_nn_lbr_disc_rsn_cd_flg = 'Y' THEN
15884: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));
15885: END IF;
15886:
15887: IF l_b_inc_gn_los_flag = 'Y' THEN
15888: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inc_gn_los_flg', RTRIM(p_project_in.include_gains_losses_flag));

Line 15888: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inc_gn_los_flg', RTRIM(p_project_in.include_gains_losses_flag));

15884: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));
15885: END IF;
15886:
15887: IF l_b_inc_gn_los_flag = 'Y' THEN
15888: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inc_gn_los_flg', RTRIM(p_project_in.include_gains_losses_flag));
15889: END IF;
15890:
15891:
15892: IF l_b_lb_sch_tp_fg = 'Y' THEN

Line 15893: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_type', RTRIM(p_project_in.labor_sch_type));

15889: END IF;
15890:
15891:
15892: IF l_b_lb_sch_tp_fg = 'Y' THEN
15893: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_type', RTRIM(p_project_in.labor_sch_type));
15894: END IF;
15895:
15896: IF l_b_nn_lb_sch_tp_fg = 'Y' THEN
15897: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_tp', RTRIM(p_project_in.non_labor_sch_type));

Line 15897: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_tp', RTRIM(p_project_in.non_labor_sch_type));

15893: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_type', RTRIM(p_project_in.labor_sch_type));
15894: END IF;
15895:
15896: IF l_b_nn_lb_sch_tp_fg = 'Y' THEN
15897: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_tp', RTRIM(p_project_in.non_labor_sch_type));
15898: END IF;
15899:
15900: IF l_b_emp_bill_rt_sch_id_fg2 = 'Y' THEN
15901: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_project_in.emp_bill_rate_schedule_id);

Line 15901: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_project_in.emp_bill_rate_schedule_id);

15897: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_tp', RTRIM(p_project_in.non_labor_sch_type));
15898: END IF;
15899:
15900: IF l_b_emp_bill_rt_sch_id_fg2 = 'Y' THEN
15901: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_project_in.emp_bill_rate_schedule_id);
15902: END IF;
15903:
15904: IF l_b_jb_bill_rt_sch_id_fg2 = 'Y' THEN
15905: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_project_in.job_bill_rate_schedule_id);

Line 15905: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_project_in.job_bill_rate_schedule_id);

15901: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_project_in.emp_bill_rate_schedule_id);
15902: END IF;
15903:
15904: IF l_b_jb_bill_rt_sch_id_fg2 = 'Y' THEN
15905: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_project_in.job_bill_rate_schedule_id);
15906: END IF;
15907:
15908: IF l_b_lb_sch_fx_dt_fg = 'Y' THEN
15909: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_fx_dt', p_project_in.labor_schedule_fixed_date);

Line 15909: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_fx_dt', p_project_in.labor_schedule_fixed_date);

15905: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_project_in.job_bill_rate_schedule_id);
15906: END IF;
15907:
15908: IF l_b_lb_sch_fx_dt_fg = 'Y' THEN
15909: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_fx_dt', p_project_in.labor_schedule_fixed_date);
15910: END IF;
15911:
15912: IF l_b_lb_sch_dsct_fg = 'Y' THEN
15913: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_dsct', p_project_in.labor_schedule_discount);

Line 15913: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_dsct', p_project_in.labor_schedule_discount);

15909: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_fx_dt', p_project_in.labor_schedule_fixed_date);
15910: END IF;
15911:
15912: IF l_b_lb_sch_dsct_fg = 'Y' THEN
15913: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_dsct', p_project_in.labor_schedule_discount);
15914: END IF;
15915:
15916: IF l_b_lb_disc_rn_cd_fg2 = 'Y' THEN
15917: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_disc_rn_cd', RTRIM(p_project_in.labor_disc_reason_code));

Line 15917: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_disc_rn_cd', RTRIM(p_project_in.labor_disc_reason_code));

15913: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_dsct', p_project_in.labor_schedule_discount);
15914: END IF;
15915:
15916: IF l_b_lb_disc_rn_cd_fg2 = 'Y' THEN
15917: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_disc_rn_cd', RTRIM(p_project_in.labor_disc_reason_code));
15918: END IF;
15919:
15920: IF l_b_rv_ind_rt_sch_id_fg = 'Y' THEN
15921: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_project_in.REV_IND_RATE_SCH_ID);

Line 15921: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_project_in.REV_IND_RATE_SCH_ID);

15917: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_disc_rn_cd', RTRIM(p_project_in.labor_disc_reason_code));
15918: END IF;
15919:
15920: IF l_b_rv_ind_rt_sch_id_fg = 'Y' THEN
15921: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_project_in.REV_IND_RATE_SCH_ID);
15922: END IF;
15923:
15924: IF l_b_inv_ind_rt_sch_id_fg = 'Y' THEN
15925: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_project_in.INV_IND_RATE_SCH_ID);

Line 15925: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_project_in.INV_IND_RATE_SCH_ID);

15921: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_project_in.REV_IND_RATE_SCH_ID);
15922: END IF;
15923:
15924: IF l_b_inv_ind_rt_sch_id_fg = 'Y' THEN
15925: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_project_in.INV_IND_RATE_SCH_ID);
15926: END IF;
15927:
15928: IF l_b_ind_sch_fx_dt_fg = 'Y' THEN
15929: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_ind_sch_fx_dt', p_project_in.rev_ind_sch_fixed_date);

Line 15929: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_ind_sch_fx_dt', p_project_in.rev_ind_sch_fixed_date);

15925: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_project_in.INV_IND_RATE_SCH_ID);
15926: END IF;
15927:
15928: IF l_b_ind_sch_fx_dt_fg = 'Y' THEN
15929: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_ind_sch_fx_dt', p_project_in.rev_ind_sch_fixed_date);
15930: END IF;
15931:
15932: IF l_b_inv_ind_sch_fx_dt_fg = 'Y' THEN
15933: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_sch_fx_dt', p_project_in.inv_ind_sch_fixed_date);

Line 15933: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_sch_fx_dt', p_project_in.inv_ind_sch_fixed_date);

15929: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_ind_sch_fx_dt', p_project_in.rev_ind_sch_fixed_date);
15930: END IF;
15931:
15932: IF l_b_inv_ind_sch_fx_dt_fg = 'Y' THEN
15933: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_sch_fx_dt', p_project_in.inv_ind_sch_fixed_date);
15934: END IF;
15935:
15936: IF l_b_nn_lb_bill_rt_org_id_fg = 'Y' THEN
15937: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_bill_rt_org_id', p_project_in.non_labor_bill_rate_org_id);

Line 15937: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_bill_rt_org_id', p_project_in.non_labor_bill_rate_org_id);

15933: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_sch_fx_dt', p_project_in.inv_ind_sch_fixed_date);
15934: END IF;
15935:
15936: IF l_b_nn_lb_bill_rt_org_id_fg = 'Y' THEN
15937: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_bill_rt_org_id', p_project_in.non_labor_bill_rate_org_id);
15938: END IF;
15939:
15940: IF l_b_n_lb_st_bl_rt_sc_id_fg2 = 'Y' THEN
15941: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lab_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);

Line 15941: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lab_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);

15937: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_bill_rt_org_id', p_project_in.non_labor_bill_rate_org_id);
15938: END IF;
15939:
15940: IF l_b_n_lb_st_bl_rt_sc_id_fg2 = 'Y' THEN
15941: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lab_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);
15942: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bill_rt_sch', RTRIM(l_std_bill_rate_schedule));
15943: END IF;
15944:
15945: IF l_b_nn_lb_sch_fx_dt_fg = 'Y' THEN

Line 15942: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bill_rt_sch', RTRIM(l_std_bill_rate_schedule));

15938: END IF;
15939:
15940: IF l_b_n_lb_st_bl_rt_sc_id_fg2 = 'Y' THEN
15941: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lab_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);
15942: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bill_rt_sch', RTRIM(l_std_bill_rate_schedule));
15943: END IF;
15944:
15945: IF l_b_nn_lb_sch_fx_dt_fg = 'Y' THEN
15946: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_fx_dt', p_project_in.non_labor_schedule_fixed_date);

Line 15946: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_fx_dt', p_project_in.non_labor_schedule_fixed_date);

15942: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bill_rt_sch', RTRIM(l_std_bill_rate_schedule));
15943: END IF;
15944:
15945: IF l_b_nn_lb_sch_fx_dt_fg = 'Y' THEN
15946: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_fx_dt', p_project_in.non_labor_schedule_fixed_date);
15947: END IF;
15948:
15949: IF l_b_nn_lb_sch_dst_fg = 'Y' THEN
15950: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_dst', p_project_in.non_labor_schedule_discount);

Line 15950: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_dst', p_project_in.non_labor_schedule_discount);

15946: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_fx_dt', p_project_in.non_labor_schedule_fixed_date);
15947: END IF;
15948:
15949: IF l_b_nn_lb_sch_dst_fg = 'Y' THEN
15950: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_dst', p_project_in.non_labor_schedule_discount);
15951: END IF;
15952:
15953: IF l_b_n_lb_disc_rsn_cd_fg2 = 'Y' THEN
15954: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_dis_rn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));

Line 15954: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_dis_rn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));

15950: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_dst', p_project_in.non_labor_schedule_discount);
15951: END IF;
15952:
15953: IF l_b_n_lb_disc_rsn_cd_fg2 = 'Y' THEN
15954: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_dis_rn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));
15955: END IF;
15956:
15957: IF l_b_as_alloc_mth_fg = 'Y' THEN
15958: DBMS_SQL.BIND_VARIABLE(l_cursor, ':as_alloc_mth', RTRIM(p_project_in.asset_allocation_method));

Line 15958: DBMS_SQL.BIND_VARIABLE(l_cursor, ':as_alloc_mth', RTRIM(p_project_in.asset_allocation_method));

15954: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_dis_rn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));
15955: END IF;
15956:
15957: IF l_b_as_alloc_mth_fg = 'Y' THEN
15958: DBMS_SQL.BIND_VARIABLE(l_cursor, ':as_alloc_mth', RTRIM(p_project_in.asset_allocation_method));
15959: END IF;
15960:
15961: IF l_b_cp_evt_proc_fg = 'Y' THEN
15962: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cp_evt_proc', RTRIM(p_project_in.capital_event_processing));

Line 15962: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cp_evt_proc', RTRIM(p_project_in.capital_event_processing));

15958: DBMS_SQL.BIND_VARIABLE(l_cursor, ':as_alloc_mth', RTRIM(p_project_in.asset_allocation_method));
15959: END IF;
15960:
15961: IF l_b_cp_evt_proc_fg = 'Y' THEN
15962: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cp_evt_proc', RTRIM(p_project_in.capital_event_processing));
15963: END IF;
15964:
15965: IF l_b_cint_rt_sch_id_fg = 'Y' THEN
15966: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_rt_sch', p_project_in.cint_rate_sch_id);

Line 15966: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_rt_sch', p_project_in.cint_rate_sch_id);

15962: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cp_evt_proc', RTRIM(p_project_in.capital_event_processing));
15963: END IF;
15964:
15965: IF l_b_cint_rt_sch_id_fg = 'Y' THEN
15966: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_rt_sch', p_project_in.cint_rate_sch_id);
15967: END IF;
15968:
15969: IF l_b_cint_elg_fg = 'Y' THEN
15970: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_project_in.cint_eligible_flag));

Line 15970: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_project_in.cint_eligible_flag));

15966: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_rt_sch', p_project_in.cint_rate_sch_id);
15967: END IF;
15968:
15969: IF l_b_cint_elg_fg = 'Y' THEN
15970: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_project_in.cint_eligible_flag));
15971: END IF;
15972:
15973: IF l_b_cint_stp_dt_fg = 'Y' THEN
15974: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', p_project_in.cint_stop_date);

Line 15974: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', p_project_in.cint_stop_date);

15970: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_project_in.cint_eligible_flag));
15971: END IF;
15972:
15973: IF l_b_cint_stp_dt_fg = 'Y' THEN
15974: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', p_project_in.cint_stop_date);
15975: END IF;
15976:
15977: /* Added for bug 6248841 */
15978: IF l_b_cc_tax_task_id = 'Y' THEN

Line 15979: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_cc_tax_task_id', p_project_in.cc_tax_task_id);

15975: END IF;
15976:
15977: /* Added for bug 6248841 */
15978: IF l_b_cc_tax_task_id = 'Y' THEN
15979: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_cc_tax_task_id', p_project_in.cc_tax_task_id);
15980: END IF;
15981:
15982: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
15983: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);

Line 15982: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);

15978: IF l_b_cc_tax_task_id = 'Y' THEN
15979: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_cc_tax_task_id', p_project_in.cc_tax_task_id);
15980: END IF;
15981:
15982: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
15983: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
15984: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
15985:
15986: --end bug 2955326

Line 15983: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);

15979: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_cc_tax_task_id', p_project_in.cc_tax_task_id);
15980: END IF;
15981:
15982: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
15983: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
15984: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
15985:
15986: --end bug 2955326
15987:

Line 15984: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);

15980: END IF;
15981:
15982: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
15983: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
15984: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
15985:
15986: --end bug 2955326
15987:
15988: -- FP_M changes begin (venkat) 3

Line 15993: -- DBMS_SQL.BIND_VARIABLE(l_cursor, ':sys_program_flg', RTRIM(p_project_in.sys_program_flag));

15989:
15990: -- COMMENT BEGIN --
15991: -------------- Begin Comment : Diable for now as the col sys_program_flag not in pa_projects -------
15992: -- IF l_sys_program_flag = 'Y' THEN
15993: -- DBMS_SQL.BIND_VARIABLE(l_cursor, ':sys_program_flg', RTRIM(p_project_in.sys_program_flag));
15994: -- END IF;
15995: -------------- end Comment : Diable for now as the col sys_program_flag not in pa_projects ---------
15996: -- COMMENT END --
15997:

Line 16001: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sys_program_flag', RTRIM(p_project_in.sys_program_flag));

15997:
15998: -- Bug # 5072032.
15999:
16000: IF l_b_sys_program_flag_fg = 'Y' THEN
16001: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sys_program_flag', RTRIM(p_project_in.sys_program_flag));
16002: END IF;
16003:
16004: IF l_b_allow_multi_prog_rollup_fg = 'Y' THEN
16005: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_multi_program_rollup', RTRIM(p_project_in.allow_multi_program_rollup));

Line 16005: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_multi_program_rollup', RTRIM(p_project_in.allow_multi_program_rollup));

16001: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sys_program_flag', RTRIM(p_project_in.sys_program_flag));
16002: END IF;
16003:
16004: IF l_b_allow_multi_prog_rollup_fg = 'Y' THEN
16005: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_multi_program_rollup', RTRIM(p_project_in.allow_multi_program_rollup));
16006: END IF;
16007:
16008: -- End of Bug # 5072032.
16009:

Line 16012: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_cust_flg', RTRIM(p_project_in.enable_top_task_customer_flag));

16008: -- End of Bug # 5072032.
16009:
16010:
16011: IF l_enable_top_task_cust_flag = 'Y' THEN
16012: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_cust_flg', RTRIM(p_project_in.enable_top_task_customer_flag));
16013: END IF;
16014:
16015: IF l_enable_top_task_inv_mth_flag = 'Y' THEN
16016: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_inv_mth_flg', RTRIM(p_project_in.enable_top_task_inv_mth_flag));

Line 16016: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_inv_mth_flg', RTRIM(p_project_in.enable_top_task_inv_mth_flag));

16012: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_cust_flg', RTRIM(p_project_in.enable_top_task_customer_flag));
16013: END IF;
16014:
16015: IF l_enable_top_task_inv_mth_flag = 'Y' THEN
16016: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_inv_mth_flg', RTRIM(p_project_in.enable_top_task_inv_mth_flag));
16017: END IF;
16018:
16019: IF l_projfunc_attr_for_ar_flag = 'Y' THEN
16020: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfunc_attr_for_ar_flg', RTRIM(p_project_in.projfunc_attr_for_ar_flag));

Line 16020: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfunc_attr_for_ar_flg', RTRIM(p_project_in.projfunc_attr_for_ar_flag));

16016: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_inv_mth_flg', RTRIM(p_project_in.enable_top_task_inv_mth_flag));
16017: END IF;
16018:
16019: IF l_projfunc_attr_for_ar_flag = 'Y' THEN
16020: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfunc_attr_for_ar_flg', RTRIM(p_project_in.projfunc_attr_for_ar_flag));
16021: END IF;
16022:
16023: -- FP_M changes end (venkat)
16024:

Line 16027: DBMS_SQL.BIND_VARIABLE(l_cursor, ':date_eff_funds_consumption', RTRIM(p_project_in.date_eff_funds_flag));

16023: -- FP_M changes end (venkat)
16024:
16025: --sunkalya federal bug#5511353
16026: IF l_date_eff_funds_flag = 'Y' THEN
16027: DBMS_SQL.BIND_VARIABLE(l_cursor, ':date_eff_funds_consumption', RTRIM(p_project_in.date_eff_funds_flag));
16028: END IF;
16029:
16030: --sunkalya federal bug#5511353
16031:

Line 16034: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ar_rec_notify_flag', RTRIM(p_project_in.ar_rec_notify_flag));

16030: --sunkalya federal bug#5511353
16031:
16032: /* 7508661 : EnC : Start */
16033: IF l_ar_rec_notify_flag = 'Y' THEN
16034: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ar_rec_notify_flag', RTRIM(p_project_in.ar_rec_notify_flag));
16035: END IF;
16036:
16037: IF l_auto_release_pwp_inv = 'Y' THEN
16038: DBMS_SQL.BIND_VARIABLE(l_cursor, ':auto_release_pwp_inv', RTRIM(p_project_in.auto_release_pwp_inv));

Line 16038: DBMS_SQL.BIND_VARIABLE(l_cursor, ':auto_release_pwp_inv', RTRIM(p_project_in.auto_release_pwp_inv));

16034: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ar_rec_notify_flag', RTRIM(p_project_in.ar_rec_notify_flag));
16035: END IF;
16036:
16037: IF l_auto_release_pwp_inv = 'Y' THEN
16038: DBMS_SQL.BIND_VARIABLE(l_cursor, ':auto_release_pwp_inv', RTRIM(p_project_in.auto_release_pwp_inv));
16039: END IF;
16040: /* 7508661 : EnC : End */
16041:
16042: l_rows := dbms_sql.execute(l_cursor);

Line 16042: l_rows := dbms_sql.execute(l_cursor);

16038: DBMS_SQL.BIND_VARIABLE(l_cursor, ':auto_release_pwp_inv', RTRIM(p_project_in.auto_release_pwp_inv));
16039: END IF;
16040: /* 7508661 : EnC : End */
16041:
16042: l_rows := dbms_sql.execute(l_cursor);
16043:
16044: IF dbms_sql.is_open (l_cursor)
16045: THEN
16046: dbms_sql.close_cursor (l_cursor);

Line 16044: IF dbms_sql.is_open (l_cursor)

16040: /* 7508661 : EnC : End */
16041:
16042: l_rows := dbms_sql.execute(l_cursor);
16043:
16044: IF dbms_sql.is_open (l_cursor)
16045: THEN
16046: dbms_sql.close_cursor (l_cursor);
16047: END IF;
16048:

Line 16046: dbms_sql.close_cursor (l_cursor);

16042: l_rows := dbms_sql.execute(l_cursor);
16043:
16044: IF dbms_sql.is_open (l_cursor)
16045: THEN
16046: dbms_sql.close_cursor (l_cursor);
16047: END IF;
16048:
16049: IF l_debug_mode = 'Y' THEN
16050: pa_debug.g_err_stage := 'Done with updating project level data...';

Line 21264: l_cursor := dbms_sql.open_cursor;

21260:
21261: l_statement := l_statement ||
21262: ' WHERE PROJECT_ID = '|| TO_CHAR(l_project_id);
21263:
21264: l_cursor := dbms_sql.open_cursor;
21265: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
21266: l_rows := dbms_sql.execute(l_cursor);
21267: IF dbms_sql.is_open (l_cursor) THEN
21268: dbms_sql.close_cursor (l_cursor);

Line 21265: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);

21261: l_statement := l_statement ||
21262: ' WHERE PROJECT_ID = '|| TO_CHAR(l_project_id);
21263:
21264: l_cursor := dbms_sql.open_cursor;
21265: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
21266: l_rows := dbms_sql.execute(l_cursor);
21267: IF dbms_sql.is_open (l_cursor) THEN
21268: dbms_sql.close_cursor (l_cursor);
21269: END IF;

Line 21266: l_rows := dbms_sql.execute(l_cursor);

21262: ' WHERE PROJECT_ID = '|| TO_CHAR(l_project_id);
21263:
21264: l_cursor := dbms_sql.open_cursor;
21265: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
21266: l_rows := dbms_sql.execute(l_cursor);
21267: IF dbms_sql.is_open (l_cursor) THEN
21268: dbms_sql.close_cursor (l_cursor);
21269: END IF;
21270:

Line 21267: IF dbms_sql.is_open (l_cursor) THEN

21263:
21264: l_cursor := dbms_sql.open_cursor;
21265: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
21266: l_rows := dbms_sql.execute(l_cursor);
21267: IF dbms_sql.is_open (l_cursor) THEN
21268: dbms_sql.close_cursor (l_cursor);
21269: END IF;
21270:
21271: /*Stubbed Out Auto Initiate Demand on Project Approval functionality

Line 21268: dbms_sql.close_cursor (l_cursor);

21264: l_cursor := dbms_sql.open_cursor;
21265: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
21266: l_rows := dbms_sql.execute(l_cursor);
21267: IF dbms_sql.is_open (l_cursor) THEN
21268: dbms_sql.close_cursor (l_cursor);
21269: END IF;
21270:
21271: /*Stubbed Out Auto Initiate Demand on Project Approval functionality
21272: Bug 3819086