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_PVT dependencies on DBMS_SQL

Line 8715: l_cursor := dbms_sql.open_cursor;

8711: /* dbms_output.put_line('Statement: '||substr(l_statement,1,100)); */
8712: /* dbms_output.put_line('Statement: '||substr(l_statement,101,100)); */
8713: /* dbms_output.put_line('Statement: '||substr(l_statement,201,100)); */
8714:
8715: l_cursor := dbms_sql.open_cursor;
8716: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
8717:
8718: /* -- Commented by rtarway for BUG 4106154, this should be before opening the curosr, otherwise ora error 'variables not bound' is thrown
8719: -- if we try to bind any of following params

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

8712: /* dbms_output.put_line('Statement: '||substr(l_statement,101,100)); */
8713: /* dbms_output.put_line('Statement: '||substr(l_statement,201,100)); */
8714:
8715: l_cursor := dbms_sql.open_cursor;
8716: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
8717:
8718: /* -- Commented by rtarway for BUG 4106154, this should be before opening the curosr, otherwise ora error 'variables not bound' is thrown
8719: -- if we try to bind any of following params
8720: ----(Begin Venkat) FP_M changes ------------------------------------------------------------

Line 8750: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_tk_ref', RTRIM(p_pm_task_reference));

8746: ----(End Venkat) FP_M changes ------------------------------------------------------------
8747: */
8748: --bug 2955326
8749: IF l_b_pm_tk_ref_flag = 'Y' THEN
8750: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_tk_ref', RTRIM(p_pm_task_reference));
8751: END IF;
8752:
8753: IF l_b_tk_nm_flag = 'Y' THEN
8754: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_name', substrb(RTRIM(p_task_name),1,20)); -- bug 6193314

Line 8754: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_name', substrb(RTRIM(p_task_name),1,20)); -- bug 6193314

8750: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_tk_ref', RTRIM(p_pm_task_reference));
8751: END IF;
8752:
8753: IF l_b_tk_nm_flag = 'Y' THEN
8754: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_name', substrb(RTRIM(p_task_name),1,20)); -- bug 6193314
8755: END IF;
8756:
8757: IF l_b_ln_tk_nm_flag = 'Y' THEN
8758: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ln_tk_name', RTRIM(p_long_task_name));

Line 8758: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ln_tk_name', RTRIM(p_long_task_name));

8754: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_name', substrb(RTRIM(p_task_name),1,20)); -- bug 6193314
8755: END IF;
8756:
8757: IF l_b_ln_tk_nm_flag = 'Y' THEN
8758: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ln_tk_name', RTRIM(p_long_task_name));
8759: END IF;
8760:
8761: IF l_b_tk_desc_flag = 'Y' THEN
8762: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', RTRIM(p_task_description));

Line 8762: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', RTRIM(p_task_description));

8758: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ln_tk_name', RTRIM(p_long_task_name));
8759: END IF;
8760:
8761: IF l_b_tk_desc_flag = 'Y' THEN
8762: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', RTRIM(p_task_description));
8763: END IF;
8764:
8765: IF l_b_rdy_to_bill_flag = 'Y' THEN
8766: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_bill_fg', p_ready_to_bill_flag);

Line 8766: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_bill_fg', p_ready_to_bill_flag);

8762: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', RTRIM(p_task_description));
8763: END IF;
8764:
8765: IF l_b_rdy_to_bill_flag = 'Y' THEN
8766: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_bill_fg', p_ready_to_bill_flag);
8767: END IF;
8768:
8769: IF l_b_rdy_to_dist_flag = 'Y' THEN
8770: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_dist_fg', p_ready_to_distribute_flag);

Line 8770: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_dist_fg', p_ready_to_distribute_flag);

8766: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_bill_fg', p_ready_to_bill_flag);
8767: END IF;
8768:
8769: IF l_b_rdy_to_dist_flag = 'Y' THEN
8770: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_dist_fg', p_ready_to_distribute_flag);
8771: END IF;
8772:
8773: IF l_b_lmt_to_txn_ctrl_fg = 'Y' THEN
8774: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lmt_to_txn_ctrl_fg', p_limit_to_txn_controls_flag);

Line 8774: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lmt_to_txn_ctrl_fg', p_limit_to_txn_controls_flag);

8770: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_dist_fg', p_ready_to_distribute_flag);
8771: END IF;
8772:
8773: IF l_b_lmt_to_txn_ctrl_fg = 'Y' THEN
8774: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lmt_to_txn_ctrl_fg', p_limit_to_txn_controls_flag);
8775: END IF;
8776:
8777: IF l_b_cryng_out_org_id_flag = 'Y' THEN
8778: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cryng_out_org_id', p_carrying_out_organization_id);

Line 8778: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cryng_out_org_id', p_carrying_out_organization_id);

8774: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lmt_to_txn_ctrl_fg', p_limit_to_txn_controls_flag);
8775: END IF;
8776:
8777: IF l_b_cryng_out_org_id_flag = 'Y' THEN
8778: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cryng_out_org_id', p_carrying_out_organization_id);
8779: END IF;
8780:
8781: IF l_b_chgble_fg = 'Y' THEN
8782: DBMS_SQL.BIND_VARIABLE(l_cursor, ':chgble_fg', p_chargeable_flag);

Line 8782: DBMS_SQL.BIND_VARIABLE(l_cursor, ':chgble_fg', p_chargeable_flag);

8778: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cryng_out_org_id', p_carrying_out_organization_id);
8779: END IF;
8780:
8781: IF l_b_chgble_fg = 'Y' THEN
8782: DBMS_SQL.BIND_VARIABLE(l_cursor, ':chgble_fg', p_chargeable_flag);
8783: END IF;
8784:
8785: IF l_b_billable_fg = 'Y' THEN
8786: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bil_fg', p_billable_flag);

Line 8786: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bil_fg', p_billable_flag);

8782: DBMS_SQL.BIND_VARIABLE(l_cursor, ':chgble_fg', p_chargeable_flag);
8783: END IF;
8784:
8785: IF l_b_billable_fg = 'Y' THEN
8786: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bil_fg', p_billable_flag);
8787: END IF;
8788:
8789: IF l_b_srv_tp_cd_fg = 'Y' THEN
8790: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srv_tp_cd', p_service_type_code);

Line 8790: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srv_tp_cd', p_service_type_code);

8786: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bil_fg', p_billable_flag);
8787: END IF;
8788:
8789: IF l_b_srv_tp_cd_fg = 'Y' THEN
8790: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srv_tp_cd', p_service_type_code);
8791: END IF;
8792:
8793: IF l_b_tk_num_fg = 'Y' THEN
8794: --dbms_output.put_line('adding the bind variable'||'-'||p_task_number);

Line 8796: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num','-'||p_task_number); */

8792:
8793: IF l_b_tk_num_fg = 'Y' THEN
8794: --dbms_output.put_line('adding the bind variable'||'-'||p_task_number);
8795: /* bug #5243018: Reverting the fix in bug 4120380.
8796: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num','-'||p_task_number); */
8797: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num', substrb(p_task_number,1,25)); --bug 5733285
8798: /** CODE CHANGE BY ADITI for Bug 4120380.This is to prefix task_number with '-' so that
8799: PA_TASKS_U2 constraint can be overcome.After updating all the tasks in the script,
8800: code again updates the task_number, trimming the '-' added.**/

Line 8797: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num', substrb(p_task_number,1,25)); --bug 5733285

8793: IF l_b_tk_num_fg = 'Y' THEN
8794: --dbms_output.put_line('adding the bind variable'||'-'||p_task_number);
8795: /* bug #5243018: Reverting the fix in bug 4120380.
8796: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num','-'||p_task_number); */
8797: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num', substrb(p_task_number,1,25)); --bug 5733285
8798: /** CODE CHANGE BY ADITI for Bug 4120380.This is to prefix task_number with '-' so that
8799: PA_TASKS_U2 constraint can be overcome.After updating all the tasks in the script,
8800: code again updates the task_number, trimming the '-' added.**/
8801: END IF;

Line 8804: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_dt', p_task_start_date);

8800: code again updates the task_number, trimming the '-' added.**/
8801: END IF;
8802:
8803: IF l_b_tk_st_dt_flag = 'Y' THEN
8804: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_dt', p_task_start_date);
8805: END IF;
8806:
8807: IF l_b_comp_dt_fg = 'Y' THEN
8808: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cmp_dt', p_task_completion_date);

Line 8808: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cmp_dt', p_task_completion_date);

8804: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_dt', p_task_start_date);
8805: END IF;
8806:
8807: IF l_b_comp_dt_fg = 'Y' THEN
8808: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cmp_dt', p_task_completion_date);
8809: END IF;
8810:
8811: IF l_b_prt_tk_id_fg = 'Y' THEN
8812: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prt_tk_id', l_new_parent_task_id);

Line 8812: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prt_tk_id', l_new_parent_task_id);

8808: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cmp_dt', p_task_completion_date);
8809: END IF;
8810:
8811: IF l_b_prt_tk_id_fg = 'Y' THEN
8812: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prt_tk_id', l_new_parent_task_id);
8813: END IF;
8814:
8815: IF l_b_addr_id_fg = 'Y' THEN
8816: DBMS_SQL.BIND_VARIABLE(l_cursor, ':addr_id', p_address_id);

Line 8816: DBMS_SQL.BIND_VARIABLE(l_cursor, ':addr_id', p_address_id);

8812: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prt_tk_id', l_new_parent_task_id);
8813: END IF;
8814:
8815: IF l_b_addr_id_fg = 'Y' THEN
8816: DBMS_SQL.BIND_VARIABLE(l_cursor, ':addr_id', p_address_id);
8817: END IF;
8818:
8819: IF l_b_attr_cat_fg = 'Y' THEN
8820: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(l_attribute_category));

Line 8820: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(l_attribute_category));

8816: DBMS_SQL.BIND_VARIABLE(l_cursor, ':addr_id', p_address_id);
8817: END IF;
8818:
8819: IF l_b_attr_cat_fg = 'Y' THEN
8820: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(l_attribute_category));
8821: END IF;
8822: --bug 6153503 start
8823: IF l_b_attr1_fg = 'Y' THEN
8824: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(l_attribute1));

Line 8824: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(l_attribute1));

8820: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(l_attribute_category));
8821: END IF;
8822: --bug 6153503 start
8823: IF l_b_attr1_fg = 'Y' THEN
8824: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(l_attribute1));
8825: END IF;
8826:
8827: IF l_b_attr2_fg = 'Y' THEN
8828: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(l_attribute2));

Line 8828: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(l_attribute2));

8824: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(l_attribute1));
8825: END IF;
8826:
8827: IF l_b_attr2_fg = 'Y' THEN
8828: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(l_attribute2));
8829: END IF;
8830:
8831: IF l_b_attr3_fg = 'Y' THEN
8832: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(l_attribute3));

Line 8832: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(l_attribute3));

8828: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(l_attribute2));
8829: END IF;
8830:
8831: IF l_b_attr3_fg = 'Y' THEN
8832: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(l_attribute3));
8833: END IF;
8834:
8835: IF l_b_attr4_fg = 'Y' THEN
8836: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(l_attribute4));

Line 8836: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(l_attribute4));

8832: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(l_attribute3));
8833: END IF;
8834:
8835: IF l_b_attr4_fg = 'Y' THEN
8836: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(l_attribute4));
8837: END IF;
8838:
8839: IF l_b_attr5_fg = 'Y' THEN
8840: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(l_attribute5));

Line 8840: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(l_attribute5));

8836: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(l_attribute4));
8837: END IF;
8838:
8839: IF l_b_attr5_fg = 'Y' THEN
8840: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(l_attribute5));
8841: END IF;
8842:
8843: IF l_b_attr6_fg = 'Y' THEN
8844: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(l_attribute6));

Line 8844: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(l_attribute6));

8840: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(l_attribute5));
8841: END IF;
8842:
8843: IF l_b_attr6_fg = 'Y' THEN
8844: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(l_attribute6));
8845: END IF;
8846:
8847: IF l_b_attr7_fg = 'Y' THEN
8848: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(l_attribute7));

Line 8848: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(l_attribute7));

8844: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(l_attribute6));
8845: END IF;
8846:
8847: IF l_b_attr7_fg = 'Y' THEN
8848: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(l_attribute7));
8849: END IF;
8850:
8851: IF l_b_attr8_fg = 'Y' THEN
8852: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(l_attribute8));

Line 8852: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(l_attribute8));

8848: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(l_attribute7));
8849: END IF;
8850:
8851: IF l_b_attr8_fg = 'Y' THEN
8852: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(l_attribute8));
8853: END IF;
8854:
8855: IF l_b_attr9_fg = 'Y' THEN
8856: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(l_attribute9));

Line 8856: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(l_attribute9));

8852: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(l_attribute8));
8853: END IF;
8854:
8855: IF l_b_attr9_fg = 'Y' THEN
8856: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(l_attribute9));
8857: END IF;
8858:
8859: IF l_b_attr10_fg = 'Y' THEN
8860: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(l_attribute10));

Line 8860: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(l_attribute10));

8856: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(l_attribute9));
8857: END IF;
8858:
8859: IF l_b_attr10_fg = 'Y' THEN
8860: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(l_attribute10));
8861: END IF;
8862: --bug 6153503 end
8863:
8864: IF l_b_al_x_chg_fg = 'Y' THEN

Line 8865: DBMS_SQL.BIND_VARIABLE(l_cursor, ':all_x_chg_fg', RTRIM(p_allow_cross_charge_flag));

8861: END IF;
8862: --bug 6153503 end
8863:
8864: IF l_b_al_x_chg_fg = 'Y' THEN
8865: DBMS_SQL.BIND_VARIABLE(l_cursor, ':all_x_chg_fg', RTRIM(p_allow_cross_charge_flag));
8866: END IF;
8867:
8868: IF l_b_prj_rt_tp_fg = 'Y' THEN
8869: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_tp', RTRIM(p_project_rate_type));

Line 8869: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_tp', RTRIM(p_project_rate_type));

8865: DBMS_SQL.BIND_VARIABLE(l_cursor, ':all_x_chg_fg', RTRIM(p_allow_cross_charge_flag));
8866: END IF;
8867:
8868: IF l_b_prj_rt_tp_fg = 'Y' THEN
8869: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_tp', RTRIM(p_project_rate_type));
8870: END IF;
8871:
8872: IF l_b_prj_rt_dt_fg = 'Y' THEN
8873: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_dt', p_project_rate_date);

Line 8873: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_dt', p_project_rate_date);

8869: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_tp', RTRIM(p_project_rate_type));
8870: END IF;
8871:
8872: IF l_b_prj_rt_dt_fg = 'Y' THEN
8873: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_dt', p_project_rate_date);
8874: END IF;
8875:
8876: IF l_b_cc_proc_lbr_fg = 'Y' THEN
8877: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lbr_fg', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048

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

8873: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_dt', p_project_rate_date);
8874: END IF;
8875:
8876: IF l_b_cc_proc_lbr_fg = 'Y' THEN
8877: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lbr_fg', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048
8878: END IF;
8879:
8880: IF l_b_lbr_tp_sch_id_fg = 'Y' THEN
8881: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_sch_id', p_labor_tp_schedule_id);

Line 8881: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_sch_id', p_labor_tp_schedule_id);

8877: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lbr_fg', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048
8878: END IF;
8879:
8880: IF l_b_lbr_tp_sch_id_fg = 'Y' THEN
8881: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_sch_id', p_labor_tp_schedule_id);
8882: END IF;
8883:
8884: IF l_b_lbr_tp_fx_dt_fg = 'Y' THEN
8885: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_fx_dt', p_labor_tp_fixed_date);

Line 8885: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_fx_dt', p_labor_tp_fixed_date);

8881: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_sch_id', p_labor_tp_schedule_id);
8882: END IF;
8883:
8884: IF l_b_lbr_tp_fx_dt_fg = 'Y' THEN
8885: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_fx_dt', p_labor_tp_fixed_date);
8886: END IF;
8887:
8888: IF l_b_cc_proc_nl_fg = 'Y' THEN
8889: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_fg', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048

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

8885: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_fx_dt', p_labor_tp_fixed_date);
8886: END IF;
8887:
8888: IF l_b_cc_proc_nl_fg = 'Y' THEN
8889: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_fg', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048
8890: END IF;
8891:
8892: IF l_b_nl_tp_sch_id_fg = 'Y' THEN
8893: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_nl_tp_schedule_id);

Line 8893: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_nl_tp_schedule_id);

8889: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_fg', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048
8890: END IF;
8891:
8892: IF l_b_nl_tp_sch_id_fg = 'Y' THEN
8893: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_nl_tp_schedule_id);
8894: END IF;
8895:
8896: IF l_b_nl_tp_fx_dt_fg = 'Y' THEN
8897: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_nl_tp_fixed_date);

Line 8897: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_nl_tp_fixed_date);

8893: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_nl_tp_schedule_id);
8894: END IF;
8895:
8896: IF l_b_nl_tp_fx_dt_fg = 'Y' THEN
8897: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_nl_tp_fixed_date);
8898: END IF;
8899:
8900: IF l_b_rcv_prj_inv_fg = 'Y' THEN
8901: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rcv_prj_inv_fg', RTRIM(p_receive_project_invoice_flag));

Line 8901: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rcv_prj_inv_fg', RTRIM(p_receive_project_invoice_flag));

8897: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_nl_tp_fixed_date);
8898: END IF;
8899:
8900: IF l_b_rcv_prj_inv_fg = 'Y' THEN
8901: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rcv_prj_inv_fg', RTRIM(p_receive_project_invoice_flag));
8902: END IF;
8903:
8904: IF l_b_wk_tp_id_fg = 'Y' THEN
8905: DBMS_SQL.BIND_VARIABLE(l_cursor, ':wk_tp_id', p_work_type_id);

Line 8905: DBMS_SQL.BIND_VARIABLE(l_cursor, ':wk_tp_id', p_work_type_id);

8901: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rcv_prj_inv_fg', RTRIM(p_receive_project_invoice_flag));
8902: END IF;
8903:
8904: IF l_b_wk_tp_id_fg = 'Y' THEN
8905: DBMS_SQL.BIND_VARIABLE(l_cursor, ':wk_tp_id', p_work_type_id);
8906: END IF;
8907:
8908: IF l_b_emp_bill_rt_sch_id_fg = 'Y' THEN
8909: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_emp_bill_rate_schedule_id);

Line 8909: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_emp_bill_rate_schedule_id);

8905: DBMS_SQL.BIND_VARIABLE(l_cursor, ':wk_tp_id', p_work_type_id);
8906: END IF;
8907:
8908: IF l_b_emp_bill_rt_sch_id_fg = 'Y' THEN
8909: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_emp_bill_rate_schedule_id);
8910: END IF;
8911:
8912: IF l_b_jb_bill_rt_sch_id_fg = 'Y' THEN
8913: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_job_bill_rate_schedule_id);

Line 8913: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_job_bill_rate_schedule_id);

8909: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_emp_bill_rate_schedule_id);
8910: END IF;
8911:
8912: IF l_b_jb_bill_rt_sch_id_fg = 'Y' THEN
8913: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_job_bill_rate_schedule_id);
8914: END IF;
8915:
8916: IF l_b_nn_lb_std_bl_rt_sch_id_fg = 'Y' THEN
8917: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);

Line 8917: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);

8913: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_job_bill_rate_schedule_id);
8914: END IF;
8915:
8916: IF l_b_nn_lb_std_bl_rt_sch_id_fg = 'Y' THEN
8917: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);
8918: END IF;
8919:
8920: IF l_b_tkfnc_cst_rt_dt_fg = 'Y' THEN
8921: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_dt', p_taskfunc_cost_rate_date);

Line 8921: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_dt', p_taskfunc_cost_rate_date);

8917: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);
8918: END IF;
8919:
8920: IF l_b_tkfnc_cst_rt_dt_fg = 'Y' THEN
8921: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_dt', p_taskfunc_cost_rate_date);
8922: END IF;
8923:
8924: IF l_b_tkfnc_cst_rt_tp_fg = 'Y' THEN
8925: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_tp', RTRIM(p_taskfunc_cost_rate_type));

Line 8925: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_tp', RTRIM(p_taskfunc_cost_rate_type));

8921: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_dt', p_taskfunc_cost_rate_date);
8922: END IF;
8923:
8924: IF l_b_tkfnc_cst_rt_tp_fg = 'Y' THEN
8925: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_tp', RTRIM(p_taskfunc_cost_rate_type));
8926: END IF;
8927:
8928: IF l_b_lbr_disc_rsn_cd_fg = 'Y' THEN
8929: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_cd', RTRIM(p_labor_disc_reason_code));

Line 8929: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_cd', RTRIM(p_labor_disc_reason_code));

8925: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_tp', RTRIM(p_taskfunc_cost_rate_type));
8926: END IF;
8927:
8928: IF l_b_lbr_disc_rsn_cd_fg = 'Y' THEN
8929: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_cd', RTRIM(p_labor_disc_reason_code));
8930: END IF;
8931:
8932: IF l_b_nn_lbr_disc_rsn_cd_fg = 'Y' THEN
8933: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));

Line 8933: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));

8929: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_cd', RTRIM(p_labor_disc_reason_code));
8930: END IF;
8931:
8932: IF l_b_nn_lbr_disc_rsn_cd_fg = 'Y' THEN
8933: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));
8934: END IF;
8935:
8936: IF l_b_act_st_dt_fg = 'Y' THEN
8937: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_st_dt', p_actual_start_date);

Line 8937: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_st_dt', p_actual_start_date);

8933: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));
8934: END IF;
8935:
8936: IF l_b_act_st_dt_fg = 'Y' THEN
8937: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_st_dt', p_actual_start_date);
8938: END IF;
8939:
8940: IF l_b_act_fn_dt_fg = 'Y' THEN
8941: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_fn_dt', p_actual_finish_date);

Line 8941: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_fn_dt', p_actual_finish_date);

8937: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_st_dt', p_actual_start_date);
8938: END IF;
8939:
8940: IF l_b_act_fn_dt_fg = 'Y' THEN
8941: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_fn_dt', p_actual_finish_date);
8942: END IF;
8943:
8944: IF l_b_erly_st_dt_fg = 'Y' THEN
8945: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_st_dt', p_early_start_date);

Line 8945: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_st_dt', p_early_start_date);

8941: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_fn_dt', p_actual_finish_date);
8942: END IF;
8943:
8944: IF l_b_erly_st_dt_fg = 'Y' THEN
8945: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_st_dt', p_early_start_date);
8946: END IF;
8947:
8948: IF l_b_erly_fn_dt_fg = 'Y' THEN
8949: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_fn_dt', p_early_finish_date);

Line 8949: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_fn_dt', p_early_finish_date);

8945: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_st_dt', p_early_start_date);
8946: END IF;
8947:
8948: IF l_b_erly_fn_dt_fg = 'Y' THEN
8949: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_fn_dt', p_early_finish_date);
8950: END IF;
8951:
8952: IF l_b_lt_st_dt_fg = 'Y' THEN
8953: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_st_dt', p_late_start_date);

Line 8953: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_st_dt', p_late_start_date);

8949: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_fn_dt', p_early_finish_date);
8950: END IF;
8951:
8952: IF l_b_lt_st_dt_fg = 'Y' THEN
8953: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_st_dt', p_late_start_date);
8954: END IF;
8955:
8956: IF l_b_lt_fn_dt_fg = 'Y' THEN
8957: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_fn_dt', p_late_finish_date);

Line 8957: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_fn_dt', p_late_finish_date);

8953: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_st_dt', p_late_start_date);
8954: END IF;
8955:
8956: IF l_b_lt_fn_dt_fg = 'Y' THEN
8957: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_fn_dt', p_late_finish_date);
8958: END IF;
8959:
8960: IF l_b_sch_st_dt_fg = 'Y' THEN
8961: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_st_dt', p_scheduled_start_date);

Line 8961: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_st_dt', p_scheduled_start_date);

8957: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_fn_dt', p_late_finish_date);
8958: END IF;
8959:
8960: IF l_b_sch_st_dt_fg = 'Y' THEN
8961: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_st_dt', p_scheduled_start_date);
8962: END IF;
8963:
8964: IF l_b_sch_fn_dt_fg = 'Y' THEN
8965: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_fn_dt', p_scheduled_finish_date);

Line 8965: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_fn_dt', p_scheduled_finish_date);

8961: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_st_dt', p_scheduled_start_date);
8962: END IF;
8963:
8964: IF l_b_sch_fn_dt_fg = 'Y' THEN
8965: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_fn_dt', p_scheduled_finish_date);
8966: END IF;
8967:
8968: IF l_b_cst_ind_rt_sch_id_fg = 'Y' THEN
8969: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_rt_sch_id', p_cost_ind_rate_sch_id);

Line 8969: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_rt_sch_id', p_cost_ind_rate_sch_id);

8965: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_fn_dt', p_scheduled_finish_date);
8966: END IF;
8967:
8968: IF l_b_cst_ind_rt_sch_id_fg = 'Y' THEN
8969: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_rt_sch_id', p_cost_ind_rate_sch_id);
8970: END IF;
8971:
8972: IF l_b_cst_ind_sch_fx_dt_fg = 'Y' THEN
8973: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_sch_fx_dt', p_cost_ind_sch_fixed_date);

Line 8973: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_sch_fx_dt', p_cost_ind_sch_fixed_date);

8969: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_rt_sch_id', p_cost_ind_rate_sch_id);
8970: END IF;
8971:
8972: IF l_b_cst_ind_sch_fx_dt_fg = 'Y' THEN
8973: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_sch_fx_dt', p_cost_ind_sch_fixed_date);
8974: END IF;
8975:
8976: IF l_b_ret_cst_fg = 'Y' THEN
8977: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_cst_fg', RTRIM(p_retirement_cost_flag));

Line 8977: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_cst_fg', RTRIM(p_retirement_cost_flag));

8973: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_sch_fx_dt', p_cost_ind_sch_fixed_date);
8974: END IF;
8975:
8976: IF l_b_ret_cst_fg = 'Y' THEN
8977: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_cst_fg', RTRIM(p_retirement_cost_flag));
8978: END IF;
8979:
8980: IF l_b_cint_elg_fg = 'Y' THEN
8981: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_cint_eligible_flag));

Line 8981: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_cint_eligible_flag));

8977: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_cst_fg', RTRIM(p_retirement_cost_flag));
8978: END IF;
8979:
8980: IF l_b_cint_elg_fg = 'Y' THEN
8981: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_cint_eligible_flag));
8982: END IF;
8983:
8984: IF l_b_cint_stp_dt_fg = 'Y' THEN
8985: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', RTRIM(p_cint_stop_date));

Line 8985: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', RTRIM(p_cint_stop_date));

8981: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_cint_eligible_flag));
8982: END IF;
8983:
8984: IF l_b_cint_stp_dt_fg = 'Y' THEN
8985: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', RTRIM(p_cint_stop_date));
8986: END IF;
8987:
8988: IF l_b_lbr_sch_tp_fg = 'Y' THEN
8989: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_tp', RTRIM(p_labor_sch_type));

Line 8989: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_tp', RTRIM(p_labor_sch_type));

8985: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', RTRIM(p_cint_stop_date));
8986: END IF;
8987:
8988: IF l_b_lbr_sch_tp_fg = 'Y' THEN
8989: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_tp', RTRIM(p_labor_sch_type));
8990: END IF;
8991:
8992: IF l_b_n_lbr_sch_tp_fg = 'Y' THEN
8993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lbr_sch_tp', RTRIM(p_nl_sch_type));

Line 8993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lbr_sch_tp', RTRIM(p_nl_sch_type));

8989: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_tp', RTRIM(p_labor_sch_type));
8990: END IF;
8991:
8992: IF l_b_n_lbr_sch_tp_fg = 'Y' THEN
8993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lbr_sch_tp', RTRIM(p_nl_sch_type));
8994: END IF;
8995:
8996: IF l_b_emp_bill_rt_sch_id_fg2 = 'Y' THEN --IF l_b_jb_bill_rt_sch_id_fg2 = 'Y' THEN - Changed the IF Condition for the Bug:4692368
8997: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_emp_bill_rate_schedule_id);

Line 8997: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_emp_bill_rate_schedule_id);

8993: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lbr_sch_tp', RTRIM(p_nl_sch_type));
8994: END IF;
8995:
8996: IF l_b_emp_bill_rt_sch_id_fg2 = 'Y' THEN --IF l_b_jb_bill_rt_sch_id_fg2 = 'Y' THEN - Changed the IF Condition for the Bug:4692368
8997: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_emp_bill_rate_schedule_id);
8998: END IF;
8999:
9000: IF l_b_jb_bill_rt_sch_id_fg2 = 'Y' THEN
9001: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_job_bill_rate_schedule_id);

Line 9001: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_job_bill_rate_schedule_id);

8997: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_emp_bill_rate_schedule_id);
8998: END IF;
8999:
9000: IF l_b_jb_bill_rt_sch_id_fg2 = 'Y' THEN
9001: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_job_bill_rate_schedule_id);
9002: END IF;
9003:
9004: IF l_b_lbr_sch_fx_dt = 'Y' THEN
9005: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_fx_dt', p_labor_schedule_fixed_date);

Line 9005: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_fx_dt', p_labor_schedule_fixed_date);

9001: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_job_bill_rate_schedule_id);
9002: END IF;
9003:
9004: IF l_b_lbr_sch_fx_dt = 'Y' THEN
9005: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_fx_dt', p_labor_schedule_fixed_date);
9006: END IF;
9007:
9008: IF l_b_lbr_sch_dsnt = 'Y' THEN
9009: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_dsnt', p_labor_schedule_discount);

Line 9009: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_dsnt', p_labor_schedule_discount);

9005: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_fx_dt', p_labor_schedule_fixed_date);
9006: END IF;
9007:
9008: IF l_b_lbr_sch_dsnt = 'Y' THEN
9009: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_dsnt', p_labor_schedule_discount);
9010: END IF;
9011:
9012: IF l_b_rv_ind_rt_sch_id_fg = 'Y' THEN
9013: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_rev_ind_rate_sch_id);

Line 9013: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_rev_ind_rate_sch_id);

9009: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_dsnt', p_labor_schedule_discount);
9010: END IF;
9011:
9012: IF l_b_rv_ind_rt_sch_id_fg = 'Y' THEN
9013: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_rev_ind_rate_sch_id);
9014: END IF;
9015:
9016: IF l_b_inv_ind_rt_sch_id_fg = 'Y' THEN
9017: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_inv_ind_rate_sch_id);

Line 9017: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_inv_ind_rate_sch_id);

9013: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_rev_ind_rate_sch_id);
9014: END IF;
9015:
9016: IF l_b_inv_ind_rt_sch_id_fg = 'Y' THEN
9017: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_inv_ind_rate_sch_id);
9018: END IF;
9019:
9020: IF l_b_rv_ind_sch_fx_dt_fg = 'Y' THEN
9021: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_sch_fx_dt', p_rev_ind_sch_fixed_date);

Line 9021: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_sch_fx_dt', p_rev_ind_sch_fixed_date);

9017: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_inv_ind_rate_sch_id);
9018: END IF;
9019:
9020: IF l_b_rv_ind_sch_fx_dt_fg = 'Y' THEN
9021: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_sch_fx_dt', p_rev_ind_sch_fixed_date);
9022: END IF;
9023:
9024: IF l_b_iv_ind_sch_fx_dt_fg = 'Y' THEN
9025: DBMS_SQL.BIND_VARIABLE(l_cursor, ':iv_ind_sch_fx_dt', p_inv_ind_sch_fixed_date);

Line 9025: DBMS_SQL.BIND_VARIABLE(l_cursor, ':iv_ind_sch_fx_dt', p_inv_ind_sch_fixed_date);

9021: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_sch_fx_dt', p_rev_ind_sch_fixed_date);
9022: END IF;
9023:
9024: IF l_b_iv_ind_sch_fx_dt_fg = 'Y' THEN
9025: DBMS_SQL.BIND_VARIABLE(l_cursor, ':iv_ind_sch_fx_dt', p_inv_ind_sch_fixed_date);
9026: END IF;
9027:
9028: IF l_b_nl_bl_rt_org_id_fg = 'Y' THEN
9029: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_bl_rt_org_id', p_nl_bill_rate_org_id);

Line 9029: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_bl_rt_org_id', p_nl_bill_rate_org_id);

9025: DBMS_SQL.BIND_VARIABLE(l_cursor, ':iv_ind_sch_fx_dt', p_inv_ind_sch_fixed_date);
9026: END IF;
9027:
9028: IF l_b_nl_bl_rt_org_id_fg = 'Y' THEN
9029: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_bl_rt_org_id', p_nl_bill_rate_org_id);
9030: END IF;
9031:
9032: IF l_b_nl_std_bl_rt_sch_fg = 'Y' THEN
9033: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);

Line 9033: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);

9029: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_bl_rt_org_id', p_nl_bill_rate_org_id);
9030: END IF;
9031:
9032: IF l_b_nl_std_bl_rt_sch_fg = 'Y' THEN
9033: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);
9034: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch', RTRIM(l_std_bill_rate_schedule));
9035: END IF;
9036:
9037: IF l_b_nl_sch_fx_dt_fg = 'Y' THEN

Line 9034: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch', RTRIM(l_std_bill_rate_schedule));

9030: END IF;
9031:
9032: IF l_b_nl_std_bl_rt_sch_fg = 'Y' THEN
9033: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);
9034: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch', RTRIM(l_std_bill_rate_schedule));
9035: END IF;
9036:
9037: IF l_b_nl_sch_fx_dt_fg = 'Y' THEN
9038: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_fx_dt', p_nl_schedule_fixed_date);

Line 9038: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_fx_dt', p_nl_schedule_fixed_date);

9034: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch', RTRIM(l_std_bill_rate_schedule));
9035: END IF;
9036:
9037: IF l_b_nl_sch_fx_dt_fg = 'Y' THEN
9038: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_fx_dt', p_nl_schedule_fixed_date);
9039: END IF;
9040:
9041: IF l_b_nl_sch_dsnt_fg = 'Y' THEN
9042: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_dsnt', p_nl_schedule_discount);

Line 9042: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_dsnt', p_nl_schedule_discount);

9038: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_fx_dt', p_nl_schedule_fixed_date);
9039: END IF;
9040:
9041: IF l_b_nl_sch_dsnt_fg = 'Y' THEN
9042: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_dsnt', p_nl_schedule_discount);
9043: END IF;
9044:
9045: IF l_b_nl_disc_rsn_cd_fg = 'Y' THEN
9046: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));

Line 9046: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));

9042: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_dsnt', p_nl_schedule_discount);
9043: END IF;
9044:
9045: IF l_b_nl_disc_rsn_cd_fg = 'Y' THEN
9046: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));
9047: END IF;
9048:
9049: IF l_b_tk_mgr_id_fg = 'Y' THEN
9050: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_mgr_id', p_task_manager_person_id); --Changed from l_new_parent_task_id to p_task_manager_person_id for Bug 3913251

Line 9050: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_mgr_id', p_task_manager_person_id); --Changed from l_new_parent_task_id to p_task_manager_person_id for Bug 3913251

9046: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));
9047: END IF;
9048:
9049: IF l_b_tk_mgr_id_fg = 'Y' THEN
9050: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_mgr_id', p_task_manager_person_id); --Changed from l_new_parent_task_id to p_task_manager_person_id for Bug 3913251
9051: END IF;
9052:
9053: ----(Begin Venkat) FP_M changes ------------------------------------------------------------
9054:

Line 9059: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_md', p_invoice_method);

9055: IF l_inv_md_fg = 'Y'
9056: THEN
9057: -- 4177105 changed usage from l_invoice_method to p_invoice_method
9058: -- because l_invoice_method is unitialized
9059: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_md', p_invoice_method);
9060: END IF;
9061:
9062: IF l_cust_id_fg = 'Y'
9063: THEN

Line 9065: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cust_id', p_customer_id);

9061:
9062: IF l_cust_id_fg = 'Y'
9063: THEN
9064: -- Bug 4193259: Changed l_customer_id to p_customer_id
9065: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cust_id', p_customer_id);
9066: END IF;
9067:
9068: IF l_gen_etc_src_co_fg = 'Y'
9069: THEN

Line 9070: DBMS_SQL.BIND_VARIABLE(l_cursor, ':gen_etc_src_co', p_gen_etc_source_code); /* Changed from l_gen_etc_source_code to p_gen_etc_source_code for bug 6025667 */

9066: END IF;
9067:
9068: IF l_gen_etc_src_co_fg = 'Y'
9069: THEN
9070: DBMS_SQL.BIND_VARIABLE(l_cursor, ':gen_etc_src_co', p_gen_etc_source_code); /* Changed from l_gen_etc_source_code to p_gen_etc_source_code for bug 6025667 */
9071: END IF;
9072:
9073: ----(End Venkat) FP_M changes ------------------------------------------------------------
9074:

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

9071: END IF;
9072:
9073: ----(End Venkat) FP_M changes ------------------------------------------------------------
9074:
9075: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
9076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
9077: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
9078: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_id', l_task_id);
9079:

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

9072:
9073: ----(End Venkat) FP_M changes ------------------------------------------------------------
9074:
9075: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
9076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
9077: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
9078: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_id', l_task_id);
9079:
9080: --end bug 2955326

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

9073: ----(End Venkat) FP_M changes ------------------------------------------------------------
9074:
9075: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
9076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
9077: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
9078: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_id', l_task_id);
9079:
9080: --end bug 2955326
9081:

Line 9078: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_id', l_task_id);

9074:
9075: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
9076: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
9077: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
9078: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_id', l_task_id);
9079:
9080: --end bug 2955326
9081:
9082: l_rows := dbms_sql.execute(l_cursor);

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

9078: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_id', l_task_id);
9079:
9080: --end bug 2955326
9081:
9082: l_rows := dbms_sql.execute(l_cursor);
9083: IF dbms_sql.is_open (l_cursor)
9084: THEN
9085: dbms_sql.close_cursor (l_cursor);
9086: END IF;

Line 9083: IF dbms_sql.is_open (l_cursor)

9079:
9080: --end bug 2955326
9081:
9082: l_rows := dbms_sql.execute(l_cursor);
9083: IF dbms_sql.is_open (l_cursor)
9084: THEN
9085: dbms_sql.close_cursor (l_cursor);
9086: END IF;
9087:

Line 9085: dbms_sql.close_cursor (l_cursor);

9081:
9082: l_rows := dbms_sql.execute(l_cursor);
9083: IF dbms_sql.is_open (l_cursor)
9084: THEN
9085: dbms_sql.close_cursor (l_cursor);
9086: END IF;
9087:
9088: END IF;
9089: