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 15847: l_cursor := dbms_sql.open_cursor;

15843: l_statement := l_statement ||
15844: -- ' WHERE PROJECT_ID = '|| TO_CHAR(l_project_id);
15845: ' WHERE PROJECT_ID = :prj_id'; --bug 2955326
15846: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' THEN
15847: l_cursor := dbms_sql.open_cursor;
15848: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
15849:
15850: --bug 2955326
15851: IF l_b_segment1_flag = 'Y' THEN

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

15844: -- ' WHERE PROJECT_ID = '|| TO_CHAR(l_project_id);
15845: ' WHERE PROJECT_ID = :prj_id'; --bug 2955326
15846: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' THEN
15847: l_cursor := dbms_sql.open_cursor;
15848: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
15849:
15850: --bug 2955326
15851: IF l_b_segment1_flag = 'Y' THEN
15852: DBMS_SQL.BIND_VARIABLE(l_cursor, ':segment1', RTRIM(p_project_in.pa_project_number));

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

15848: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
15849:
15850: --bug 2955326
15851: IF l_b_segment1_flag = 'Y' THEN
15852: DBMS_SQL.BIND_VARIABLE(l_cursor, ':segment1', RTRIM(p_project_in.pa_project_number));
15853: END IF;
15854:
15855: IF l_b_proj_name_flag = 'Y' THEN
15856: DBMS_SQL.BIND_VARIABLE(l_cursor, ':project_name', RTRIM(p_project_in.project_name));

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

15852: DBMS_SQL.BIND_VARIABLE(l_cursor, ':segment1', RTRIM(p_project_in.pa_project_number));
15853: END IF;
15854:
15855: IF l_b_proj_name_flag = 'Y' THEN
15856: DBMS_SQL.BIND_VARIABLE(l_cursor, ':project_name', RTRIM(p_project_in.project_name));
15857: END IF;
15858:
15859: IF l_b_long_name_flag = 'Y' THEN
15860: DBMS_SQL.BIND_VARIABLE(l_cursor, ':long_name', RTRIM(p_project_in.long_name));

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

15856: DBMS_SQL.BIND_VARIABLE(l_cursor, ':project_name', RTRIM(p_project_in.project_name));
15857: END IF;
15858:
15859: IF l_b_long_name_flag = 'Y' THEN
15860: DBMS_SQL.BIND_VARIABLE(l_cursor, ':long_name', RTRIM(p_project_in.long_name));
15861: END IF;
15862:
15863: IF l_b_pm_proj_ref_flag = 'Y' THEN
15864: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_project_reference', RTRIM(p_project_in.pm_project_reference));

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

15860: DBMS_SQL.BIND_VARIABLE(l_cursor, ':long_name', RTRIM(p_project_in.long_name));
15861: END IF;
15862:
15863: IF l_b_pm_proj_ref_flag = 'Y' THEN
15864: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_project_reference', RTRIM(p_project_in.pm_project_reference));
15865: END IF;
15866:
15867: IF l_b_co_org_id_flag = 'Y' THEN
15868: DBMS_SQL.BIND_VARIABLE(l_cursor, ':carrying_out_org_id', TO_CHAR(p_project_in.carrying_out_organization_id));

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

15864: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_project_reference', RTRIM(p_project_in.pm_project_reference));
15865: END IF;
15866:
15867: IF l_b_co_org_id_flag = 'Y' THEN
15868: DBMS_SQL.BIND_VARIABLE(l_cursor, ':carrying_out_org_id', TO_CHAR(p_project_in.carrying_out_organization_id));
15869: END IF;
15870:
15871: IF l_b_pub_sec_flag = 'Y' THEN
15872: DBMS_SQL.BIND_VARIABLE(l_cursor, ':public_sector_flag', p_project_in.public_sector_flag);

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

15868: DBMS_SQL.BIND_VARIABLE(l_cursor, ':carrying_out_org_id', TO_CHAR(p_project_in.carrying_out_organization_id));
15869: END IF;
15870:
15871: IF l_b_pub_sec_flag = 'Y' THEN
15872: DBMS_SQL.BIND_VARIABLE(l_cursor, ':public_sector_flag', p_project_in.public_sector_flag);
15873: END IF;
15874:
15875: IF l_b_dist_rule_flag = 'Y' THEN
15876: DBMS_SQL.BIND_VARIABLE(l_cursor, ':dist_rule', p_project_in.distribution_rule);

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

15872: DBMS_SQL.BIND_VARIABLE(l_cursor, ':public_sector_flag', p_project_in.public_sector_flag);
15873: END IF;
15874:
15875: IF l_b_dist_rule_flag = 'Y' THEN
15876: DBMS_SQL.BIND_VARIABLE(l_cursor, ':dist_rule', p_project_in.distribution_rule);
15877: --Bug 3279981 Review. Added two bind variables below
15878: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_acc_mth',
15879: substr(p_project_in.distribution_rule, 1, instr(p_project_in.distribution_rule,'/')-1) );
15880: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_mth',

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

15874:
15875: IF l_b_dist_rule_flag = 'Y' THEN
15876: DBMS_SQL.BIND_VARIABLE(l_cursor, ':dist_rule', p_project_in.distribution_rule);
15877: --Bug 3279981 Review. Added two bind variables below
15878: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_acc_mth',
15879: substr(p_project_in.distribution_rule, 1, instr(p_project_in.distribution_rule,'/')-1) );
15880: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_mth',
15881: substr(p_project_in.distribution_rule, instr(p_project_in.distribution_rule,'/')+1) );
15882: END IF;

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

15876: DBMS_SQL.BIND_VARIABLE(l_cursor, ':dist_rule', p_project_in.distribution_rule);
15877: --Bug 3279981 Review. Added two bind variables below
15878: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_acc_mth',
15879: substr(p_project_in.distribution_rule, 1, instr(p_project_in.distribution_rule,'/')-1) );
15880: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_mth',
15881: substr(p_project_in.distribution_rule, instr(p_project_in.distribution_rule,'/')+1) );
15882: END IF;
15883:
15884: IF l_b_desc_flag = 'Y' THEN

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

15881: substr(p_project_in.distribution_rule, instr(p_project_in.distribution_rule,'/')+1) );
15882: END IF;
15883:
15884: IF l_b_desc_flag = 'Y' THEN
15885: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', RTRIM(p_project_in.description));
15886: END IF;
15887:
15888: IF l_b_start_date_flag = 'Y' THEN
15889: DBMS_SQL.BIND_VARIABLE(l_cursor, ':start_date', l_project_start_date);

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

15885: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', RTRIM(p_project_in.description));
15886: END IF;
15887:
15888: IF l_b_start_date_flag = 'Y' THEN
15889: DBMS_SQL.BIND_VARIABLE(l_cursor, ':start_date', l_project_start_date);
15890: END IF;
15891:
15892: IF l_b_comp_date_flag = 'Y' THEN
15893: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_date', l_project_completion_date);

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

15889: DBMS_SQL.BIND_VARIABLE(l_cursor, ':start_date', l_project_start_date);
15890: END IF;
15891:
15892: IF l_b_comp_date_flag = 'Y' THEN
15893: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_date', l_project_completion_date);
15894: END IF;
15895:
15896: IF l_b_early_sd_flag = 'Y' THEN
15897: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_start_date', p_project_in.early_start_date);

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

15893: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_date', l_project_completion_date);
15894: END IF;
15895:
15896: IF l_b_early_sd_flag = 'Y' THEN
15897: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_start_date', p_project_in.early_start_date);
15898: END IF;
15899:
15900: IF l_b_early_fd_flag = 'Y' THEN
15901: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_finish_date', p_project_in.early_finish_date);

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

15897: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_start_date', p_project_in.early_start_date);
15898: END IF;
15899:
15900: IF l_b_early_fd_flag = 'Y' THEN
15901: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_finish_date', p_project_in.early_finish_date);
15902: END IF;
15903:
15904: IF l_b_late_sd_flag = 'Y' THEN
15905: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);

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

15901: DBMS_SQL.BIND_VARIABLE(l_cursor, ':early_finish_date', p_project_in.early_finish_date);
15902: END IF;
15903:
15904: IF l_b_late_sd_flag = 'Y' THEN
15905: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);
15906: END IF;
15907:
15908: IF l_b_late_sd_flag = 'Y' THEN
15909: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);

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

15905: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);
15906: END IF;
15907:
15908: IF l_b_late_sd_flag = 'Y' THEN
15909: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);
15910: END IF;
15911:
15912: IF l_b_late_fd_flag = 'Y' THEN
15913: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_finish_date', p_project_in.late_finish_date);

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

15909: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_start_date', p_project_in.late_start_date);
15910: END IF;
15911:
15912: IF l_b_late_fd_flag = 'Y' THEN
15913: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_finish_date', p_project_in.late_finish_date);
15914: END IF;
15915:
15916: IF l_b_sch_sd_flag = 'Y' THEN
15917: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_start_date', p_project_in.scheduled_start_date);

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

15913: DBMS_SQL.BIND_VARIABLE(l_cursor, ':late_finish_date', p_project_in.late_finish_date);
15914: END IF;
15915:
15916: IF l_b_sch_sd_flag = 'Y' THEN
15917: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_start_date', p_project_in.scheduled_start_date);
15918: END IF;
15919:
15920: IF l_b_sch_fd_flag = 'Y' THEN
15921: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_finish_date', p_project_in.scheduled_finish_date);

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

15917: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_start_date', p_project_in.scheduled_start_date);
15918: END IF;
15919:
15920: IF l_b_sch_fd_flag = 'Y' THEN
15921: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_finish_date', p_project_in.scheduled_finish_date);
15922: END IF;
15923:
15924: IF l_b_attr_cat_flag = 'Y' THEN
15925: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(p_project_in.attribute_category));

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

15921: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_finish_date', p_project_in.scheduled_finish_date);
15922: END IF;
15923:
15924: IF l_b_attr_cat_flag = 'Y' THEN
15925: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(p_project_in.attribute_category));
15926: END IF;
15927:
15928: IF l_b_attr1_flag = 'Y' THEN
15929: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(p_project_in.attribute1));

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

15925: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(p_project_in.attribute_category));
15926: END IF;
15927:
15928: IF l_b_attr1_flag = 'Y' THEN
15929: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(p_project_in.attribute1));
15930: END IF;
15931:
15932: IF l_b_attr2_flag = 'Y' THEN
15933: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(p_project_in.attribute2));

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

15929: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(p_project_in.attribute1));
15930: END IF;
15931:
15932: IF l_b_attr2_flag = 'Y' THEN
15933: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(p_project_in.attribute2));
15934: END IF;
15935:
15936: IF l_b_attr3_flag = 'Y' THEN
15937: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(p_project_in.attribute3));

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

15933: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(p_project_in.attribute2));
15934: END IF;
15935:
15936: IF l_b_attr3_flag = 'Y' THEN
15937: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(p_project_in.attribute3));
15938: END IF;
15939:
15940: IF l_b_attr4_flag = 'Y' THEN
15941: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(p_project_in.attribute4));

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

15937: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(p_project_in.attribute3));
15938: END IF;
15939:
15940: IF l_b_attr4_flag = 'Y' THEN
15941: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(p_project_in.attribute4));
15942: END IF;
15943:
15944: IF l_b_attr5_flag = 'Y' THEN
15945: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(p_project_in.attribute5));

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

15941: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(p_project_in.attribute4));
15942: END IF;
15943:
15944: IF l_b_attr5_flag = 'Y' THEN
15945: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(p_project_in.attribute5));
15946: END IF;
15947:
15948: IF l_b_attr6_flag = 'Y' THEN
15949: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(p_project_in.attribute6));

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

15945: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(p_project_in.attribute5));
15946: END IF;
15947:
15948: IF l_b_attr6_flag = 'Y' THEN
15949: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(p_project_in.attribute6));
15950: END IF;
15951:
15952: IF l_b_attr7_flag = 'Y' THEN
15953: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(p_project_in.attribute7));

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

15949: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(p_project_in.attribute6));
15950: END IF;
15951:
15952: IF l_b_attr7_flag = 'Y' THEN
15953: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(p_project_in.attribute7));
15954: END IF;
15955:
15956: IF l_b_attr8_flag = 'Y' THEN
15957: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(p_project_in.attribute8));

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

15953: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(p_project_in.attribute7));
15954: END IF;
15955:
15956: IF l_b_attr8_flag = 'Y' THEN
15957: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(p_project_in.attribute8));
15958: END IF;
15959:
15960: IF l_b_attr9_flag = 'Y' THEN
15961: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(p_project_in.attribute9));

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

15957: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(p_project_in.attribute8));
15958: END IF;
15959:
15960: IF l_b_attr9_flag = 'Y' THEN
15961: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(p_project_in.attribute9));
15962: END IF;
15963:
15964: IF l_b_attr10_flag = 'Y' THEN
15965: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(p_project_in.attribute10));

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

15961: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(p_project_in.attribute9));
15962: END IF;
15963:
15964: IF l_b_attr10_flag = 'Y' THEN
15965: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(p_project_in.attribute10));
15966: END IF;
15967:
15968: IF l_b_output_tx_code_flag = 'Y' THEN
15969: DBMS_SQL.BIND_VARIABLE(l_cursor, ':output_tx_code', RTRIM(p_project_in.output_tax_code));

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

15965: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(p_project_in.attribute10));
15966: END IF;
15967:
15968: IF l_b_output_tx_code_flag = 'Y' THEN
15969: DBMS_SQL.BIND_VARIABLE(l_cursor, ':output_tx_code', RTRIM(p_project_in.output_tax_code));
15970: END IF;
15971:
15972: IF l_b_ret_tx_code_flag = 'Y' THEN
15973: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_tx_code', RTRIM(p_project_in.retention_tax_code));

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

15969: DBMS_SQL.BIND_VARIABLE(l_cursor, ':output_tx_code', RTRIM(p_project_in.output_tax_code));
15970: END IF;
15971:
15972: IF l_b_ret_tx_code_flag = 'Y' THEN
15973: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_tx_code', RTRIM(p_project_in.retention_tax_code));
15974: END IF;
15975:
15976: IF l_b_proj_cur_code_flag = 'Y' THEN
15977: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_cur_code', RTRIM(p_project_in.project_currency_code));

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

15973: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_tx_code', RTRIM(p_project_in.retention_tax_code));
15974: END IF;
15975:
15976: IF l_b_proj_cur_code_flag = 'Y' THEN
15977: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_cur_code', RTRIM(p_project_in.project_currency_code));
15978: END IF;
15979:
15980: IF l_b_allow_x_chg_flag = 'Y' THEN
15981: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_x_chg_flag', RTRIM(p_project_in.allow_cross_charge_flag));

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

15977: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_cur_code', RTRIM(p_project_in.project_currency_code));
15978: END IF;
15979:
15980: IF l_b_allow_x_chg_flag = 'Y' THEN
15981: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_x_chg_flag', RTRIM(p_project_in.allow_cross_charge_flag));
15982: END IF;
15983:
15984: IF l_b_proj_rt_date_flag = 'Y' THEN
15985: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_date', p_project_in.project_rate_date);

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

15981: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_x_chg_flag', RTRIM(p_project_in.allow_cross_charge_flag));
15982: END IF;
15983:
15984: IF l_b_proj_rt_date_flag = 'Y' THEN
15985: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_date', p_project_in.project_rate_date);
15986: END IF;
15987:
15988: IF l_b_proj_rt_tp_flag = 'Y' THEN
15989: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_tp', RTRIM(p_project_in.project_rate_type));

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

15985: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_date', p_project_in.project_rate_date);
15986: END IF;
15987:
15988: IF l_b_proj_rt_tp_flag = 'Y' THEN
15989: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_tp', RTRIM(p_project_in.project_rate_type));
15990: END IF;
15991:
15992: IF l_cc_proc_lb_flag = 'Y' THEN
15993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lb_flag', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048

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

15989: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_rt_tp', RTRIM(p_project_in.project_rate_type));
15990: END IF;
15991:
15992: IF l_cc_proc_lb_flag = 'Y' THEN
15993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lb_flag', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048
15994: END IF;
15995:
15996: IF l_b_lb_tp_sch_id_flag = 'Y' THEN
15997: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_sch_id', p_project_in.labor_tp_schedule_id );

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

15993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lb_flag', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048
15994: END IF;
15995:
15996: IF l_b_lb_tp_sch_id_flag = 'Y' THEN
15997: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_sch_id', p_project_in.labor_tp_schedule_id );
15998: END IF;
15999:
16000: IF l_b_lb_tp_fixed_dt_flag = 'Y' THEN
16001: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_fixed_dt', p_project_in.labor_tp_fixed_date);

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

15997: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_sch_id', p_project_in.labor_tp_schedule_id );
15998: END IF;
15999:
16000: IF l_b_lb_tp_fixed_dt_flag = 'Y' THEN
16001: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_fixed_dt', p_project_in.labor_tp_fixed_date);
16002: END IF;
16003:
16004: IF l_b_cc_proc_nl_flag = 'Y' THEN
16005: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_flag', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048

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

16001: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_tp_fixed_dt', p_project_in.labor_tp_fixed_date);
16002: END IF;
16003:
16004: IF l_b_cc_proc_nl_flag = 'Y' THEN
16005: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_flag', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048
16006: END IF;
16007:
16008: IF l_b_nl_tp_sch_id_flag = 'Y' THEN
16009: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_project_in.nl_tp_schedule_id);

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

16005: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_flag', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048
16006: END IF;
16007:
16008: IF l_b_nl_tp_sch_id_flag = 'Y' THEN
16009: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_project_in.nl_tp_schedule_id);
16010: END IF;
16011:
16012: IF l_b_nl_tp_fx_dt_flag = 'Y' THEN
16013: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_project_in.nl_tp_fixed_date);

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

16009: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_project_in.nl_tp_schedule_id);
16010: END IF;
16011:
16012: IF l_b_nl_tp_fx_dt_flag = 'Y' THEN
16013: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_project_in.nl_tp_fixed_date);
16014: END IF;
16015:
16016: IF l_b_role_list_id_flag = 'Y' THEN
16017: DBMS_SQL.BIND_VARIABLE(l_cursor, ':role_list_id', p_project_in.role_list_id);

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

16013: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_project_in.nl_tp_fixed_date);
16014: END IF;
16015:
16016: IF l_b_role_list_id_flag = 'Y' THEN
16017: DBMS_SQL.BIND_VARIABLE(l_cursor, ':role_list_id', p_project_in.role_list_id);
16018: END IF;
16019:
16020: IF l_b_work_type_id_flag = 'Y' THEN
16021: DBMS_SQL.BIND_VARIABLE(l_cursor, ':work_type_id', p_project_in.work_type_id);

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

16017: DBMS_SQL.BIND_VARIABLE(l_cursor, ':role_list_id', p_project_in.role_list_id);
16018: END IF;
16019:
16020: IF l_b_work_type_id_flag = 'Y' THEN
16021: DBMS_SQL.BIND_VARIABLE(l_cursor, ':work_type_id', p_project_in.work_type_id);
16022: END IF;
16023:
16024: IF l_b_cal_id_flag = 'Y' THEN
16025: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cal_id', p_project_in.calendar_id);

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

16021: DBMS_SQL.BIND_VARIABLE(l_cursor, ':work_type_id', p_project_in.work_type_id);
16022: END IF;
16023:
16024: IF l_b_cal_id_flag = 'Y' THEN
16025: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cal_id', p_project_in.calendar_id);
16026: END IF;
16027:
16028: IF l_b_loc_id_flag = 'Y' THEN
16029: DBMS_SQL.BIND_VARIABLE(l_cursor, ':loc_id', p_project_in.location_id);

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

16025: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cal_id', p_project_in.calendar_id);
16026: END IF;
16027:
16028: IF l_b_loc_id_flag = 'Y' THEN
16029: DBMS_SQL.BIND_VARIABLE(l_cursor, ':loc_id', p_project_in.location_id);
16030: END IF;
16031:
16032: IF l_b_prob_memb_id_flag = 'Y' THEN
16033: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prob_memb_id', p_project_in.probability_member_id);

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

16029: DBMS_SQL.BIND_VARIABLE(l_cursor, ':loc_id', p_project_in.location_id);
16030: END IF;
16031:
16032: IF l_b_prob_memb_id_flag = 'Y' THEN
16033: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prob_memb_id', p_project_in.probability_member_id);
16034: END IF;
16035:
16036: IF l_b_proj_value_flag = 'Y' THEN
16037: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_value', p_project_in.project_value);

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

16033: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prob_memb_id', p_project_in.probability_member_id);
16034: END IF;
16035:
16036: IF l_b_proj_value_flag = 'Y' THEN
16037: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_value', p_project_in.project_value);
16038: END IF;
16039:
16040: IF l_b_exp_apprv_dt_flag = 'Y' THEN
16041: DBMS_SQL.BIND_VARIABLE(l_cursor, ':exp_apprv_date', p_project_in.expected_approval_date);

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

16037: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_value', p_project_in.project_value);
16038: END IF;
16039:
16040: IF l_b_exp_apprv_dt_flag = 'Y' THEN
16041: DBMS_SQL.BIND_VARIABLE(l_cursor, ':exp_apprv_date', p_project_in.expected_approval_date);
16042: END IF;
16043:
16044: IF l_b_cst_jb_gp_id_flag = 'Y' THEN
16045: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_jb_gp_id', p_project_in.cost_job_group_id);

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

16041: DBMS_SQL.BIND_VARIABLE(l_cursor, ':exp_apprv_date', p_project_in.expected_approval_date);
16042: END IF;
16043:
16044: IF l_b_cst_jb_gp_id_flag = 'Y' THEN
16045: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_jb_gp_id', p_project_in.cost_job_group_id);
16046: END IF;
16047:
16048: IF l_b_bill_jb_gp_id_flag = 'Y' THEN
16049: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bill_jb_gp_id', p_project_in.bill_job_group_id);

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

16045: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_jb_gp_id', p_project_in.cost_job_group_id);
16046: END IF;
16047:
16048: IF l_b_bill_jb_gp_id_flag = 'Y' THEN
16049: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bill_jb_gp_id', p_project_in.bill_job_group_id);
16050: END IF;
16051:
16052: IF l_b_emp_bill_rt_sch_id_flag = 'Y' THEN
16053: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_project_in.emp_bill_rate_schedule_id);

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

16049: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bill_jb_gp_id', p_project_in.bill_job_group_id);
16050: END IF;
16051:
16052: IF l_b_emp_bill_rt_sch_id_flag = 'Y' THEN
16053: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_project_in.emp_bill_rate_schedule_id);
16054: END IF;
16055:
16056: IF l_b_jb_bill_rt_sch_id_flag = 'Y' THEN
16057: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_project_in.job_bill_rate_schedule_id);

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

16053: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_project_in.emp_bill_rate_schedule_id);
16054: END IF;
16055:
16056: IF l_b_jb_bill_rt_sch_id_flag = 'Y' THEN
16057: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_project_in.job_bill_rate_schedule_id);
16058: END IF;
16059:
16060: IF l_b_comp_mtch_wt_flag = 'Y' THEN
16061: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_match_wt', p_project_in.competence_match_wt);

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

16057: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_project_in.job_bill_rate_schedule_id);
16058: END IF;
16059:
16060: IF l_b_comp_mtch_wt_flag = 'Y' THEN
16061: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_match_wt', p_project_in.competence_match_wt);
16062: END IF;
16063:
16064: IF l_b_avail_mtch_wt_flag = 'Y' THEN
16065: DBMS_SQL.BIND_VARIABLE(l_cursor, ':avail_mtch_wt', p_project_in.availability_match_wt);

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

16061: DBMS_SQL.BIND_VARIABLE(l_cursor, ':comp_match_wt', p_project_in.competence_match_wt);
16062: END IF;
16063:
16064: IF l_b_avail_mtch_wt_flag = 'Y' THEN
16065: DBMS_SQL.BIND_VARIABLE(l_cursor, ':avail_mtch_wt', p_project_in.availability_match_wt);
16066: END IF;
16067:
16068: IF l_b_jb_lvl_mt_wt_flag = 'Y' THEN
16069: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_lvl_mt_wt', p_project_in.job_level_match_wt);

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

16065: DBMS_SQL.BIND_VARIABLE(l_cursor, ':avail_mtch_wt', p_project_in.availability_match_wt);
16066: END IF;
16067:
16068: IF l_b_jb_lvl_mt_wt_flag = 'Y' THEN
16069: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_lvl_mt_wt', p_project_in.job_level_match_wt);
16070: END IF;
16071:
16072: IF l_b_search_min_avail_flag = 'Y' THEN
16073: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_min_avail', p_project_in.search_min_availability);

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

16069: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_lvl_mt_wt', p_project_in.job_level_match_wt);
16070: END IF;
16071:
16072: IF l_b_search_min_avail_flag = 'Y' THEN
16073: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_min_avail', p_project_in.search_min_availability);
16074: END IF;
16075:
16076: IF l_b_srch_org_hier_id_flag = 'Y' THEN
16077: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_org_hier_id);

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

16073: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_min_avail', p_project_in.search_min_availability);
16074: END IF;
16075:
16076: IF l_b_srch_org_hier_id_flag = 'Y' THEN
16077: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_org_hier_id);
16078: END IF;
16079:
16080: IF l_b_srch_st_org_id_flag = 'Y' THEN
16081: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_starting_org_id);

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

16077: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_org_hier_id);
16078: END IF;
16079:
16080: IF l_b_srch_st_org_id_flag = 'Y' THEN
16081: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_starting_org_id);
16082: END IF;
16083:
16084: IF l_b_min_can_sc_req_for_nom = 'Y' THEN
16085: DBMS_SQL.BIND_VARIABLE(l_cursor, ':min_can_sc_req_for_nom', p_project_in.min_cand_score_reqd_for_nom);

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

16081: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_org_hier_id', p_project_in.search_starting_org_id);
16082: END IF;
16083:
16084: IF l_b_min_can_sc_req_for_nom = 'Y' THEN
16085: DBMS_SQL.BIND_VARIABLE(l_cursor, ':min_can_sc_req_for_nom', p_project_in.min_cand_score_reqd_for_nom);
16086: END IF;
16087:
16088: /* Commented the code for bug 4630836:
16089: IF l_b_nn_lb_std_bl_rt_sch_id_f = 'Y' THEN

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

16086: END IF;
16087:
16088: /* Commented the code for bug 4630836:
16089: IF l_b_nn_lb_std_bl_rt_sch_id_f = 'Y' THEN
16090: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);
16091: END IF; */
16092:
16093: IF l_b_proj_bil_xch_rt_flag = 'Y' THEN
16094: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_xch_rt', p_project_in.project_bil_exchange_rate);

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

16090: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);
16091: END IF; */
16092:
16093: IF l_b_proj_bil_xch_rt_flag = 'Y' THEN
16094: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_xch_rt', p_project_in.project_bil_exchange_rate);
16095: END IF;
16096:
16097: IF l_b_pjfnc_bil_xch_rt_flag = 'Y' THEN
16098: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pjfnc_bil_xch_rt', p_project_in.projfunc_bil_exchange_rate);

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

16094: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_xch_rt', p_project_in.project_bil_exchange_rate);
16095: END IF;
16096:
16097: IF l_b_pjfnc_bil_xch_rt_flag = 'Y' THEN
16098: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pjfnc_bil_xch_rt', p_project_in.projfunc_bil_exchange_rate);
16099: END IF;
16100:
16101: IF l_b_fnding_xch_rt_flag = 'Y' THEN
16102: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_xch_rt', p_project_in.funding_exchange_rate);

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

16098: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pjfnc_bil_xch_rt', p_project_in.projfunc_bil_exchange_rate);
16099: END IF;
16100:
16101: IF l_b_fnding_xch_rt_flag = 'Y' THEN
16102: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_xch_rt', p_project_in.funding_exchange_rate);
16103: END IF;
16104:
16105: IF l_b_enable_auto_srch_flag = 'Y' THEN
16106: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_auto_srch', p_project_in.enable_automated_search);

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

16102: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_xch_rt', p_project_in.funding_exchange_rate);
16103: END IF;
16104:
16105: IF l_b_enable_auto_srch_flag = 'Y' THEN
16106: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_auto_srch', p_project_in.enable_automated_search);
16107: END IF;
16108:
16109: IF l_b_srch_cntry_code_flag = 'Y' THEN
16110: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_cntry_code', RTRIM(p_project_in.search_country_code));

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

16106: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_auto_srch', p_project_in.enable_automated_search);
16107: END IF;
16108:
16109: IF l_b_srch_cntry_code_flag = 'Y' THEN
16110: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_cntry_code', RTRIM(p_project_in.search_country_code));
16111: END IF;
16112:
16113: IF l_b_invproc_crncy_tp_flag = 'Y' THEN
16114: DBMS_SQL.BIND_VARIABLE(l_cursor, ':invproc_currency_type', RTRIM(p_project_in.invproc_currency_type));

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

16110: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srch_cntry_code', RTRIM(p_project_in.search_country_code));
16111: END IF;
16112:
16113: IF l_b_invproc_crncy_tp_flag = 'Y' THEN
16114: DBMS_SQL.BIND_VARIABLE(l_cursor, ':invproc_currency_type', RTRIM(p_project_in.invproc_currency_type));
16115: END IF;
16116:
16117: IF l_b_revproc_crncy_cd_flag = 'Y' THEN
16118: DBMS_SQL.BIND_VARIABLE(l_cursor, ':revproc_currency_code', RTRIM(p_project_in.revproc_currency_code));

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

16114: DBMS_SQL.BIND_VARIABLE(l_cursor, ':invproc_currency_type', RTRIM(p_project_in.invproc_currency_type));
16115: END IF;
16116:
16117: IF l_b_revproc_crncy_cd_flag = 'Y' THEN
16118: DBMS_SQL.BIND_VARIABLE(l_cursor, ':revproc_currency_code', RTRIM(p_project_in.revproc_currency_code));
16119: END IF;
16120:
16121: IF l_b_prj_bil_rt_dt_code_flag = 'Y' THEN
16122: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rate_date_code', RTRIM(p_project_in.project_bil_rate_date_code));

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

16118: DBMS_SQL.BIND_VARIABLE(l_cursor, ':revproc_currency_code', RTRIM(p_project_in.revproc_currency_code));
16119: END IF;
16120:
16121: IF l_b_prj_bil_rt_dt_code_flag = 'Y' THEN
16122: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rate_date_code', RTRIM(p_project_in.project_bil_rate_date_code));
16123: END IF;
16124:
16125: IF l_b_proj_bil_rt_tp_flag = 'Y' THEN
16126: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rt_type', RTRIM(p_project_in.project_bil_rate_type));

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

16122: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rate_date_code', RTRIM(p_project_in.project_bil_rate_date_code));
16123: END IF;
16124:
16125: IF l_b_proj_bil_rt_tp_flag = 'Y' THEN
16126: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rt_type', RTRIM(p_project_in.project_bil_rate_type));
16127: END IF;
16128:
16129: IF l_b_prjfnc_crncy_code_flag = 'Y' THEN
16130: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_currency_code', RTRIM(p_project_in.projfunc_currency_code));

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

16126: DBMS_SQL.BIND_VARIABLE(l_cursor, ':proj_bil_rt_type', RTRIM(p_project_in.project_bil_rate_type));
16127: END IF;
16128:
16129: IF l_b_prjfnc_crncy_code_flag = 'Y' THEN
16130: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_currency_code', RTRIM(p_project_in.projfunc_currency_code));
16131: END IF;
16132:
16133: IF l_b_prjfnc_bil_rt_dt_cd_f = 'Y' THEN
16134: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_dt_code', RTRIM(p_project_in.projfunc_bil_rate_date_code));

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

16130: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_currency_code', RTRIM(p_project_in.projfunc_currency_code));
16131: END IF;
16132:
16133: IF l_b_prjfnc_bil_rt_dt_cd_f = 'Y' THEN
16134: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_dt_code', RTRIM(p_project_in.projfunc_bil_rate_date_code));
16135: END IF;
16136:
16137: IF l_b_prjfnc_bil_rt_tp_flag = 'Y' THEN
16138: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rate_type', RTRIM(p_project_in.projfunc_bil_rate_type));

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

16134: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_dt_code', RTRIM(p_project_in.projfunc_bil_rate_date_code));
16135: END IF;
16136:
16137: IF l_b_prjfnc_bil_rt_tp_flag = 'Y' THEN
16138: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rate_type', RTRIM(p_project_in.projfunc_bil_rate_type));
16139: END IF;
16140:
16141: IF l_b_fndng_rt_dt_cd_flag = 'Y' THEN
16142: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_date_code', RTRIM(p_project_in.funding_rate_date_code));

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

16138: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rate_type', RTRIM(p_project_in.projfunc_bil_rate_type));
16139: END IF;
16140:
16141: IF l_b_fndng_rt_dt_cd_flag = 'Y' THEN
16142: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_date_code', RTRIM(p_project_in.funding_rate_date_code));
16143: END IF;
16144:
16145: IF l_b_fnding_rt_type_flag = 'Y' THEN
16146: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_type', RTRIM(p_project_in.funding_rate_type));

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

16142: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_date_code', RTRIM(p_project_in.funding_rate_date_code));
16143: END IF;
16144:
16145: IF l_b_fnding_rt_type_flag = 'Y' THEN
16146: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_type', RTRIM(p_project_in.funding_rate_type));
16147: END IF;
16148:
16149: IF l_b_bsln_fnding_flag = 'Y' THEN
16150: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bsln_fnding_flag', RTRIM(p_project_in.baseline_funding_flag));

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

16146: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rate_type', RTRIM(p_project_in.funding_rate_type));
16147: END IF;
16148:
16149: IF l_b_bsln_fnding_flag = 'Y' THEN
16150: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bsln_fnding_flag', RTRIM(p_project_in.baseline_funding_flag));
16151: END IF;
16152:
16153: IF l_b_prjfnc_cst_rt_tp_flag = 'Y' THEN
16154: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfnc_cost_rate_type', RTRIM(p_project_in.projfunc_cost_rate_type));

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

16150: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bsln_fnding_flag', RTRIM(p_project_in.baseline_funding_flag));
16151: END IF;
16152:
16153: IF l_b_prjfnc_cst_rt_tp_flag = 'Y' THEN
16154: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfnc_cost_rate_type', RTRIM(p_project_in.projfunc_cost_rate_type));
16155: END IF;
16156:
16157: IF l_b_inv_bill_txn_cur_flag = 'Y' THEN
16158: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_by_bil_txn_cur_flag', RTRIM(p_project_in.inv_by_bill_trans_curr_flag));

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

16154: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfnc_cost_rate_type', RTRIM(p_project_in.projfunc_cost_rate_type));
16155: END IF;
16156:
16157: IF l_b_inv_bill_txn_cur_flag = 'Y' THEN
16158: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_by_bil_txn_cur_flag', RTRIM(p_project_in.inv_by_bill_trans_curr_flag));
16159: END IF;
16160:
16161: IF l_b_multi_crncy_bil_flag = 'Y' THEN
16162: DBMS_SQL.BIND_VARIABLE(l_cursor, ':multi_crncy_bil_flag', RTRIM(p_project_in.multi_currency_billing_flag));

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

16158: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_by_bil_txn_cur_flag', RTRIM(p_project_in.inv_by_bill_trans_curr_flag));
16159: END IF;
16160:
16161: IF l_b_multi_crncy_bil_flag = 'Y' THEN
16162: DBMS_SQL.BIND_VARIABLE(l_cursor, ':multi_crncy_bil_flag', RTRIM(p_project_in.multi_currency_billing_flag));
16163: END IF;
16164:
16165: IF l_b_prj_bil_rt_dt_flag = 'Y' THEN
16166: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_bil_rt_date', p_project_in.project_bil_rate_date);

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

16162: DBMS_SQL.BIND_VARIABLE(l_cursor, ':multi_crncy_bil_flag', RTRIM(p_project_in.multi_currency_billing_flag));
16163: END IF;
16164:
16165: IF l_b_prj_bil_rt_dt_flag = 'Y' THEN
16166: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_bil_rt_date', p_project_in.project_bil_rate_date);
16167: END IF;
16168:
16169: IF l_b_prjfnc_bil_rt_dt_flag = 'Y' THEN
16170: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_date', p_project_in.projfunc_bil_rate_date);

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

16166: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_bil_rt_date', p_project_in.project_bil_rate_date);
16167: END IF;
16168:
16169: IF l_b_prjfnc_bil_rt_dt_flag = 'Y' THEN
16170: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_date', p_project_in.projfunc_bil_rate_date);
16171: END IF;
16172:
16173: IF l_b_fnding_rt_dt_flag = 'Y' THEN
16174: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rt_date', p_project_in.funding_rate_date);

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

16170: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_bil_rt_date', p_project_in.projfunc_bil_rate_date);
16171: END IF;
16172:
16173: IF l_b_fnding_rt_dt_flag = 'Y' THEN
16174: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rt_date', p_project_in.funding_rate_date);
16175: END IF;
16176:
16177: IF l_b_prjfnc_cst_rt_dt_flag = 'Y' THEN
16178: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_cst_rt_date', p_project_in.projfunc_cost_rate_date);

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

16174: DBMS_SQL.BIND_VARIABLE(l_cursor, ':fnding_rt_date', p_project_in.funding_rate_date);
16175: END IF;
16176:
16177: IF l_b_prjfnc_cst_rt_dt_flag = 'Y' THEN
16178: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_cst_rt_date', p_project_in.projfunc_cost_rate_date);
16179: END IF;
16180:
16181: IF l_b_asgn_prec_tsk_flag = 'Y' THEN
16182: DBMS_SQL.BIND_VARIABLE(l_cursor, ':asgn_prec_tsk_flg', RTRIM(p_project_in.assign_precedes_task));

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

16178: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prjfnc_cst_rt_date', p_project_in.projfunc_cost_rate_date);
16179: END IF;
16180:
16181: IF l_b_asgn_prec_tsk_flag = 'Y' THEN
16182: DBMS_SQL.BIND_VARIABLE(l_cursor, ':asgn_prec_tsk_flg', RTRIM(p_project_in.assign_precedes_task));
16183: END IF;
16184:
16185: IF l_b_splt_cst_fm_wp_flag = 'Y' THEN
16186: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_wp_flag', RTRIM(p_project_in.split_cost_from_workplan_flag));

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

16182: DBMS_SQL.BIND_VARIABLE(l_cursor, ':asgn_prec_tsk_flg', RTRIM(p_project_in.assign_precedes_task));
16183: END IF;
16184:
16185: IF l_b_splt_cst_fm_wp_flag = 'Y' THEN
16186: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_wp_flag', RTRIM(p_project_in.split_cost_from_workplan_flag));
16187: END IF;
16188:
16189: IF l_b_splt_cst_fm_bill_flag = 'Y' THEN
16190: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_bill_flag', RTRIM(p_project_in.split_cost_from_bill_flag));

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

16186: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_wp_flag', RTRIM(p_project_in.split_cost_from_workplan_flag));
16187: END IF;
16188:
16189: IF l_b_splt_cst_fm_bill_flag = 'Y' THEN
16190: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_bill_flag', RTRIM(p_project_in.split_cost_from_bill_flag));
16191: END IF;
16192:
16193: IF l_b_adv_act_set_id_flag = 'Y' THEN
16194: DBMS_SQL.BIND_VARIABLE(l_cursor, ':adv_act_set_id', p_project_in.adv_action_set_id);

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

16190: DBMS_SQL.BIND_VARIABLE(l_cursor, ':splt_cst_fm_bill_flag', RTRIM(p_project_in.split_cost_from_bill_flag));
16191: END IF;
16192:
16193: IF l_b_adv_act_set_id_flag = 'Y' THEN
16194: DBMS_SQL.BIND_VARIABLE(l_cursor, ':adv_act_set_id', p_project_in.adv_action_set_id);
16195: END IF;
16196:
16197: IF l_b_st_adv_act_set_flag = 'Y' THEN
16198: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_adv_act_set_flag', RTRIM(p_project_in.start_adv_action_set_flag));

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

16194: DBMS_SQL.BIND_VARIABLE(l_cursor, ':adv_act_set_id', p_project_in.adv_action_set_id);
16195: END IF;
16196:
16197: IF l_b_st_adv_act_set_flag = 'Y' THEN
16198: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_adv_act_set_flag', RTRIM(p_project_in.start_adv_action_set_flag));
16199: END IF;
16200:
16201: IF l_b_pri_code_flag = 'Y' THEN
16202: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pri_code', RTRIM(p_project_in.priority_code));

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

16198: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_adv_act_set_flag', RTRIM(p_project_in.start_adv_action_set_flag));
16199: END IF;
16200:
16201: IF l_b_pri_code_flag = 'Y' THEN
16202: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pri_code', RTRIM(p_project_in.priority_code));
16203: END IF;
16204:
16205: IF l_b_retn_bil_inv_fmt_id_flg = 'Y' THEN
16206: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_bil_inv_fmt_id', TO_CHAR(p_project_in.retn_billing_inv_format_id));

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

16202: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pri_code', RTRIM(p_project_in.priority_code));
16203: END IF;
16204:
16205: IF l_b_retn_bil_inv_fmt_id_flg = 'Y' THEN
16206: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_bil_inv_fmt_id', TO_CHAR(p_project_in.retn_billing_inv_format_id));
16207: END IF;
16208:
16209: IF l_b_retn_acnt_flag = 'Y' THEN
16210: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_acnt_flag', RTRIM(p_project_in.retn_accounting_flag));

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

16206: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_bil_inv_fmt_id', TO_CHAR(p_project_in.retn_billing_inv_format_id));
16207: END IF;
16208:
16209: IF l_b_retn_acnt_flag = 'Y' THEN
16210: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_acnt_flag', RTRIM(p_project_in.retn_accounting_flag));
16211: END IF;
16212:
16213: IF l_b_reval_fndng_flag = 'Y' THEN
16214: DBMS_SQL.BIND_VARIABLE(l_cursor, ':reval_fndng_flg', RTRIM(p_project_in.revaluate_funding_flag));

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

16210: DBMS_SQL.BIND_VARIABLE(l_cursor, ':retn_acnt_flag', RTRIM(p_project_in.retn_accounting_flag));
16211: END IF;
16212:
16213: IF l_b_reval_fndng_flag = 'Y' THEN
16214: DBMS_SQL.BIND_VARIABLE(l_cursor, ':reval_fndng_flg', RTRIM(p_project_in.revaluate_funding_flag));
16215: END IF;
16216:
16217: IF l_b_sec_lvl_flag = 'Y' THEN
16218: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sec_lvl', RTRIM(p_project_in.security_level));

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

16214: DBMS_SQL.BIND_VARIABLE(l_cursor, ':reval_fndng_flg', RTRIM(p_project_in.revaluate_funding_flag));
16215: END IF;
16216:
16217: IF l_b_sec_lvl_flag = 'Y' THEN
16218: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sec_lvl', RTRIM(p_project_in.security_level));
16219: END IF;
16220:
16221: IF l_b_lbr_disc_rsn_code_flg = 'Y' THEN
16222: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_code', RTRIM(p_project_in.labor_disc_reason_code));

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

16218: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sec_lvl', RTRIM(p_project_in.security_level));
16219: END IF;
16220:
16221: IF l_b_lbr_disc_rsn_code_flg = 'Y' THEN
16222: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_code', RTRIM(p_project_in.labor_disc_reason_code));
16223: END IF;
16224:
16225: IF l_b_nn_lbr_disc_rsn_cd_flg = 'Y' THEN
16226: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));

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

16222: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_code', RTRIM(p_project_in.labor_disc_reason_code));
16223: END IF;
16224:
16225: IF l_b_nn_lbr_disc_rsn_cd_flg = 'Y' THEN
16226: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));
16227: END IF;
16228:
16229: IF l_b_inc_gn_los_flag = 'Y' THEN
16230: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inc_gn_los_flg', RTRIM(p_project_in.include_gains_losses_flag));

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

16226: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));
16227: END IF;
16228:
16229: IF l_b_inc_gn_los_flag = 'Y' THEN
16230: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inc_gn_los_flg', RTRIM(p_project_in.include_gains_losses_flag));
16231: END IF;
16232:
16233:
16234: IF l_b_lb_sch_tp_fg = 'Y' THEN

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

16231: END IF;
16232:
16233:
16234: IF l_b_lb_sch_tp_fg = 'Y' THEN
16235: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_type', RTRIM(p_project_in.labor_sch_type));
16236: END IF;
16237:
16238: IF l_b_nn_lb_sch_tp_fg = 'Y' THEN
16239: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_tp', RTRIM(p_project_in.non_labor_sch_type));

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

16235: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_type', RTRIM(p_project_in.labor_sch_type));
16236: END IF;
16237:
16238: IF l_b_nn_lb_sch_tp_fg = 'Y' THEN
16239: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_tp', RTRIM(p_project_in.non_labor_sch_type));
16240: END IF;
16241:
16242: IF l_b_emp_bill_rt_sch_id_fg2 = 'Y' THEN
16243: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_project_in.emp_bill_rate_schedule_id);

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

16239: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_tp', RTRIM(p_project_in.non_labor_sch_type));
16240: END IF;
16241:
16242: IF l_b_emp_bill_rt_sch_id_fg2 = 'Y' THEN
16243: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_project_in.emp_bill_rate_schedule_id);
16244: END IF;
16245:
16246: IF l_b_jb_bill_rt_sch_id_fg2 = 'Y' THEN
16247: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_project_in.job_bill_rate_schedule_id);

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

16243: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_project_in.emp_bill_rate_schedule_id);
16244: END IF;
16245:
16246: IF l_b_jb_bill_rt_sch_id_fg2 = 'Y' THEN
16247: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_project_in.job_bill_rate_schedule_id);
16248: END IF;
16249:
16250: IF l_b_lb_sch_fx_dt_fg = 'Y' THEN
16251: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_fx_dt', p_project_in.labor_schedule_fixed_date);

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

16247: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_project_in.job_bill_rate_schedule_id);
16248: END IF;
16249:
16250: IF l_b_lb_sch_fx_dt_fg = 'Y' THEN
16251: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_fx_dt', p_project_in.labor_schedule_fixed_date);
16252: END IF;
16253:
16254: IF l_b_lb_sch_dsct_fg = 'Y' THEN
16255: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_dsct', p_project_in.labor_schedule_discount);

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

16251: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_fx_dt', p_project_in.labor_schedule_fixed_date);
16252: END IF;
16253:
16254: IF l_b_lb_sch_dsct_fg = 'Y' THEN
16255: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_dsct', p_project_in.labor_schedule_discount);
16256: END IF;
16257:
16258: IF l_b_lb_disc_rn_cd_fg2 = 'Y' THEN
16259: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_disc_rn_cd', RTRIM(p_project_in.labor_disc_reason_code));

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

16255: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_sch_dsct', p_project_in.labor_schedule_discount);
16256: END IF;
16257:
16258: IF l_b_lb_disc_rn_cd_fg2 = 'Y' THEN
16259: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_disc_rn_cd', RTRIM(p_project_in.labor_disc_reason_code));
16260: END IF;
16261:
16262: IF l_b_rv_ind_rt_sch_id_fg = 'Y' THEN
16263: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_project_in.REV_IND_RATE_SCH_ID);

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

16259: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lb_disc_rn_cd', RTRIM(p_project_in.labor_disc_reason_code));
16260: END IF;
16261:
16262: IF l_b_rv_ind_rt_sch_id_fg = 'Y' THEN
16263: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_project_in.REV_IND_RATE_SCH_ID);
16264: END IF;
16265:
16266: IF l_b_inv_ind_rt_sch_id_fg = 'Y' THEN
16267: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_project_in.INV_IND_RATE_SCH_ID);

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

16263: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_project_in.REV_IND_RATE_SCH_ID);
16264: END IF;
16265:
16266: IF l_b_inv_ind_rt_sch_id_fg = 'Y' THEN
16267: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_project_in.INV_IND_RATE_SCH_ID);
16268: END IF;
16269:
16270: IF l_b_ind_sch_fx_dt_fg = 'Y' THEN
16271: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_ind_sch_fx_dt', p_project_in.rev_ind_sch_fixed_date);

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

16267: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_project_in.INV_IND_RATE_SCH_ID);
16268: END IF;
16269:
16270: IF l_b_ind_sch_fx_dt_fg = 'Y' THEN
16271: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_ind_sch_fx_dt', p_project_in.rev_ind_sch_fixed_date);
16272: END IF;
16273:
16274: IF l_b_inv_ind_sch_fx_dt_fg = 'Y' THEN
16275: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_sch_fx_dt', p_project_in.inv_ind_sch_fixed_date);

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

16271: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rev_ind_sch_fx_dt', p_project_in.rev_ind_sch_fixed_date);
16272: END IF;
16273:
16274: IF l_b_inv_ind_sch_fx_dt_fg = 'Y' THEN
16275: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_sch_fx_dt', p_project_in.inv_ind_sch_fixed_date);
16276: END IF;
16277:
16278: IF l_b_nn_lb_bill_rt_org_id_fg = 'Y' THEN
16279: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_bill_rt_org_id', p_project_in.non_labor_bill_rate_org_id);

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

16275: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_sch_fx_dt', p_project_in.inv_ind_sch_fixed_date);
16276: END IF;
16277:
16278: IF l_b_nn_lb_bill_rt_org_id_fg = 'Y' THEN
16279: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_bill_rt_org_id', p_project_in.non_labor_bill_rate_org_id);
16280: END IF;
16281:
16282: IF l_b_n_lb_st_bl_rt_sc_id_fg2 = 'Y' THEN
16283: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lab_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);

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

16279: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_bill_rt_org_id', p_project_in.non_labor_bill_rate_org_id);
16280: END IF;
16281:
16282: IF l_b_n_lb_st_bl_rt_sc_id_fg2 = 'Y' THEN
16283: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lab_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);
16284: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bill_rt_sch', RTRIM(l_std_bill_rate_schedule));
16285: END IF;
16286:
16287: IF l_b_nn_lb_sch_fx_dt_fg = 'Y' THEN

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

16280: END IF;
16281:
16282: IF l_b_n_lb_st_bl_rt_sc_id_fg2 = 'Y' THEN
16283: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lab_std_bill_rt_sch_id', p_project_in.non_lab_std_bill_rt_sch_id);
16284: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bill_rt_sch', RTRIM(l_std_bill_rate_schedule));
16285: END IF;
16286:
16287: IF l_b_nn_lb_sch_fx_dt_fg = 'Y' THEN
16288: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_fx_dt', p_project_in.non_labor_schedule_fixed_date);

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

16284: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bill_rt_sch', RTRIM(l_std_bill_rate_schedule));
16285: END IF;
16286:
16287: IF l_b_nn_lb_sch_fx_dt_fg = 'Y' THEN
16288: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_fx_dt', p_project_in.non_labor_schedule_fixed_date);
16289: END IF;
16290:
16291: IF l_b_nn_lb_sch_dst_fg = 'Y' THEN
16292: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_dst', p_project_in.non_labor_schedule_discount);

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

16288: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_fx_dt', p_project_in.non_labor_schedule_fixed_date);
16289: END IF;
16290:
16291: IF l_b_nn_lb_sch_dst_fg = 'Y' THEN
16292: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_dst', p_project_in.non_labor_schedule_discount);
16293: END IF;
16294:
16295: IF l_b_n_lb_disc_rsn_cd_fg2 = 'Y' THEN
16296: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_dis_rn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));

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

16292: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_sch_dst', p_project_in.non_labor_schedule_discount);
16293: END IF;
16294:
16295: IF l_b_n_lb_disc_rsn_cd_fg2 = 'Y' THEN
16296: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_dis_rn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));
16297: END IF;
16298:
16299: IF l_b_as_alloc_mth_fg = 'Y' THEN
16300: DBMS_SQL.BIND_VARIABLE(l_cursor, ':as_alloc_mth', RTRIM(p_project_in.asset_allocation_method));

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

16296: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lb_dis_rn_cd', RTRIM(p_project_in.non_labor_disc_reason_code));
16297: END IF;
16298:
16299: IF l_b_as_alloc_mth_fg = 'Y' THEN
16300: DBMS_SQL.BIND_VARIABLE(l_cursor, ':as_alloc_mth', RTRIM(p_project_in.asset_allocation_method));
16301: END IF;
16302:
16303: IF l_b_cp_evt_proc_fg = 'Y' THEN
16304: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cp_evt_proc', RTRIM(p_project_in.capital_event_processing));

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

16300: DBMS_SQL.BIND_VARIABLE(l_cursor, ':as_alloc_mth', RTRIM(p_project_in.asset_allocation_method));
16301: END IF;
16302:
16303: IF l_b_cp_evt_proc_fg = 'Y' THEN
16304: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cp_evt_proc', RTRIM(p_project_in.capital_event_processing));
16305: END IF;
16306:
16307: IF l_b_cint_rt_sch_id_fg = 'Y' THEN
16308: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_rt_sch', p_project_in.cint_rate_sch_id);

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

16304: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cp_evt_proc', RTRIM(p_project_in.capital_event_processing));
16305: END IF;
16306:
16307: IF l_b_cint_rt_sch_id_fg = 'Y' THEN
16308: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_rt_sch', p_project_in.cint_rate_sch_id);
16309: END IF;
16310:
16311: IF l_b_cint_elg_fg = 'Y' THEN
16312: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_project_in.cint_eligible_flag));

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

16308: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_rt_sch', p_project_in.cint_rate_sch_id);
16309: END IF;
16310:
16311: IF l_b_cint_elg_fg = 'Y' THEN
16312: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_project_in.cint_eligible_flag));
16313: END IF;
16314:
16315: IF l_b_cint_stp_dt_fg = 'Y' THEN
16316: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', p_project_in.cint_stop_date);

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

16312: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_project_in.cint_eligible_flag));
16313: END IF;
16314:
16315: IF l_b_cint_stp_dt_fg = 'Y' THEN
16316: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', p_project_in.cint_stop_date);
16317: END IF;
16318:
16319: /* Added for bug 6248841 */
16320: IF l_b_cc_tax_task_id = 'Y' THEN

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

16317: END IF;
16318:
16319: /* Added for bug 6248841 */
16320: IF l_b_cc_tax_task_id = 'Y' THEN
16321: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_cc_tax_task_id', p_project_in.cc_tax_task_id);
16322: END IF;
16323:
16324: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
16325: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);

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

16320: IF l_b_cc_tax_task_id = 'Y' THEN
16321: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_cc_tax_task_id', p_project_in.cc_tax_task_id);
16322: END IF;
16323:
16324: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
16325: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
16326: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
16327:
16328: --end bug 2955326

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

16321: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_cc_tax_task_id', p_project_in.cc_tax_task_id);
16322: END IF;
16323:
16324: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
16325: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
16326: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
16327:
16328: --end bug 2955326
16329:

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

16322: END IF;
16323:
16324: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
16325: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
16326: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
16327:
16328: --end bug 2955326
16329:
16330: -- FP_M changes begin (venkat) 3

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

16331:
16332: -- COMMENT BEGIN --
16333: -------------- Begin Comment : Diable for now as the col sys_program_flag not in pa_projects -------
16334: -- IF l_sys_program_flag = 'Y' THEN
16335: -- DBMS_SQL.BIND_VARIABLE(l_cursor, ':sys_program_flg', RTRIM(p_project_in.sys_program_flag));
16336: -- END IF;
16337: -------------- end Comment : Diable for now as the col sys_program_flag not in pa_projects ---------
16338: -- COMMENT END --
16339:

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

16339:
16340: -- Bug # 5072032.
16341:
16342: IF l_b_sys_program_flag_fg = 'Y' THEN
16343: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sys_program_flag', RTRIM(p_project_in.sys_program_flag));
16344: END IF;
16345:
16346: IF l_b_allow_multi_prog_rollup_fg = 'Y' THEN
16347: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_multi_program_rollup', RTRIM(p_project_in.allow_multi_program_rollup));

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

16343: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sys_program_flag', RTRIM(p_project_in.sys_program_flag));
16344: END IF;
16345:
16346: IF l_b_allow_multi_prog_rollup_fg = 'Y' THEN
16347: DBMS_SQL.BIND_VARIABLE(l_cursor, ':allow_multi_program_rollup', RTRIM(p_project_in.allow_multi_program_rollup));
16348: END IF;
16349:
16350: -- End of Bug # 5072032.
16351:

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

16350: -- End of Bug # 5072032.
16351:
16352:
16353: IF l_enable_top_task_cust_flag = 'Y' THEN
16354: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_cust_flg', RTRIM(p_project_in.enable_top_task_customer_flag));
16355: END IF;
16356:
16357: IF l_enable_top_task_inv_mth_flag = 'Y' THEN
16358: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_inv_mth_flg', RTRIM(p_project_in.enable_top_task_inv_mth_flag));

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

16354: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_cust_flg', RTRIM(p_project_in.enable_top_task_customer_flag));
16355: END IF;
16356:
16357: IF l_enable_top_task_inv_mth_flag = 'Y' THEN
16358: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_inv_mth_flg', RTRIM(p_project_in.enable_top_task_inv_mth_flag));
16359: END IF;
16360:
16361: IF l_projfunc_attr_for_ar_flag = 'Y' THEN
16362: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfunc_attr_for_ar_flg', RTRIM(p_project_in.projfunc_attr_for_ar_flag));

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

16358: DBMS_SQL.BIND_VARIABLE(l_cursor, ':enable_top_task_inv_mth_flg', RTRIM(p_project_in.enable_top_task_inv_mth_flag));
16359: END IF;
16360:
16361: IF l_projfunc_attr_for_ar_flag = 'Y' THEN
16362: DBMS_SQL.BIND_VARIABLE(l_cursor, ':projfunc_attr_for_ar_flg', RTRIM(p_project_in.projfunc_attr_for_ar_flag));
16363: END IF;
16364:
16365: -- FP_M changes end (venkat)
16366:

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

16365: -- FP_M changes end (venkat)
16366:
16367: --sunkalya federal bug#5511353
16368: IF l_date_eff_funds_flag = 'Y' THEN
16369: DBMS_SQL.BIND_VARIABLE(l_cursor, ':date_eff_funds_consumption', RTRIM(p_project_in.date_eff_funds_flag));
16370: END IF;
16371:
16372: --sunkalya federal bug#5511353
16373:

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

16372: --sunkalya federal bug#5511353
16373:
16374: /* 7508661 : EnC : Start */
16375: IF l_ar_rec_notify_flag = 'Y' THEN
16376: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ar_rec_notify_flag', RTRIM(p_project_in.ar_rec_notify_flag));
16377: END IF;
16378:
16379: IF l_auto_release_pwp_inv = 'Y' THEN
16380: DBMS_SQL.BIND_VARIABLE(l_cursor, ':auto_release_pwp_inv', RTRIM(p_project_in.auto_release_pwp_inv));

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

16376: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ar_rec_notify_flag', RTRIM(p_project_in.ar_rec_notify_flag));
16377: END IF;
16378:
16379: IF l_auto_release_pwp_inv = 'Y' THEN
16380: DBMS_SQL.BIND_VARIABLE(l_cursor, ':auto_release_pwp_inv', RTRIM(p_project_in.auto_release_pwp_inv));
16381: END IF;
16382: /* 7508661 : EnC : End */
16383: /* Added for 12.2Payroll billing ER 11899223 */
16384: IF l_bill_labor_accrual = 'Y' THEN

Line 16385: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bill_labor_accrual', RTRIM(p_project_in.bill_labor_accrual));

16381: END IF;
16382: /* 7508661 : EnC : End */
16383: /* Added for 12.2Payroll billing ER 11899223 */
16384: IF l_bill_labor_accrual = 'Y' THEN
16385: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bill_labor_accrual', RTRIM(p_project_in.bill_labor_accrual));
16386: END IF;
16387:
16388: IF l_adj_on_std_inv = 'Y' THEN
16389: DBMS_SQL.BIND_VARIABLE(l_cursor, ':adj_on_std_inv', RTRIM(p_project_in.adj_on_std_inv));

Line 16389: DBMS_SQL.BIND_VARIABLE(l_cursor, ':adj_on_std_inv', RTRIM(p_project_in.adj_on_std_inv));

16385: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bill_labor_accrual', RTRIM(p_project_in.bill_labor_accrual));
16386: END IF;
16387:
16388: IF l_adj_on_std_inv = 'Y' THEN
16389: DBMS_SQL.BIND_VARIABLE(l_cursor, ':adj_on_std_inv', RTRIM(p_project_in.adj_on_std_inv));
16390: END IF;
16391: /* Added for 12.2Payroll billing ER 11899223 */
16392:
16393: l_rows := dbms_sql.execute(l_cursor);

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

16389: DBMS_SQL.BIND_VARIABLE(l_cursor, ':adj_on_std_inv', RTRIM(p_project_in.adj_on_std_inv));
16390: END IF;
16391: /* Added for 12.2Payroll billing ER 11899223 */
16392:
16393: l_rows := dbms_sql.execute(l_cursor);
16394:
16395: IF dbms_sql.is_open (l_cursor)
16396: THEN
16397: dbms_sql.close_cursor (l_cursor);

Line 16395: IF dbms_sql.is_open (l_cursor)

16391: /* Added for 12.2Payroll billing ER 11899223 */
16392:
16393: l_rows := dbms_sql.execute(l_cursor);
16394:
16395: IF dbms_sql.is_open (l_cursor)
16396: THEN
16397: dbms_sql.close_cursor (l_cursor);
16398: END IF;
16399: END IF;-- Skip below update to avoid locking issue when called from Bulk_Update_Task_Lite

Line 16397: dbms_sql.close_cursor (l_cursor);

16393: l_rows := dbms_sql.execute(l_cursor);
16394:
16395: IF dbms_sql.is_open (l_cursor)
16396: THEN
16397: dbms_sql.close_cursor (l_cursor);
16398: END IF;
16399: END IF;-- Skip below update to avoid locking issue when called from Bulk_Update_Task_Lite
16400: IF l_debug_mode = 'Y' THEN
16401: pa_debug.g_err_stage := 'Done with updating project level data...';

Line 21723: l_cursor := dbms_sql.open_cursor;

21719:
21720: l_statement := l_statement ||
21721: ' WHERE PROJECT_ID = '|| TO_CHAR(l_project_id);
21722:
21723: l_cursor := dbms_sql.open_cursor;
21724: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
21725: l_rows := dbms_sql.execute(l_cursor);
21726: IF dbms_sql.is_open (l_cursor) THEN
21727: dbms_sql.close_cursor (l_cursor);

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

21720: l_statement := l_statement ||
21721: ' WHERE PROJECT_ID = '|| TO_CHAR(l_project_id);
21722:
21723: l_cursor := dbms_sql.open_cursor;
21724: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
21725: l_rows := dbms_sql.execute(l_cursor);
21726: IF dbms_sql.is_open (l_cursor) THEN
21727: dbms_sql.close_cursor (l_cursor);
21728: END IF;

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

21721: ' WHERE PROJECT_ID = '|| TO_CHAR(l_project_id);
21722:
21723: l_cursor := dbms_sql.open_cursor;
21724: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
21725: l_rows := dbms_sql.execute(l_cursor);
21726: IF dbms_sql.is_open (l_cursor) THEN
21727: dbms_sql.close_cursor (l_cursor);
21728: END IF;
21729:

Line 21726: IF dbms_sql.is_open (l_cursor) THEN

21722:
21723: l_cursor := dbms_sql.open_cursor;
21724: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
21725: l_rows := dbms_sql.execute(l_cursor);
21726: IF dbms_sql.is_open (l_cursor) THEN
21727: dbms_sql.close_cursor (l_cursor);
21728: END IF;
21729:
21730: /*Stubbed Out Auto Initiate Demand on Project Approval functionality

Line 21727: dbms_sql.close_cursor (l_cursor);

21723: l_cursor := dbms_sql.open_cursor;
21724: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
21725: l_rows := dbms_sql.execute(l_cursor);
21726: IF dbms_sql.is_open (l_cursor) THEN
21727: dbms_sql.close_cursor (l_cursor);
21728: END IF;
21729:
21730: /*Stubbed Out Auto Initiate Demand on Project Approval functionality
21731: Bug 3819086