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

9051: /* dbms_output.put_line('Statement: '||substr(l_statement,1,100)); */
9052: /* dbms_output.put_line('Statement: '||substr(l_statement,101,100)); */
9053: /* dbms_output.put_line('Statement: '||substr(l_statement,201,100)); */
9054:
9055: l_cursor := dbms_sql.open_cursor;
9056: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
9057:
9058: /* -- Commented by rtarway for BUG 4106154, this should be before opening the curosr, otherwise ora error 'variables not bound' is thrown
9059: -- if we try to bind any of following params

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

9052: /* dbms_output.put_line('Statement: '||substr(l_statement,101,100)); */
9053: /* dbms_output.put_line('Statement: '||substr(l_statement,201,100)); */
9054:
9055: l_cursor := dbms_sql.open_cursor;
9056: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
9057:
9058: /* -- Commented by rtarway for BUG 4106154, this should be before opening the curosr, otherwise ora error 'variables not bound' is thrown
9059: -- if we try to bind any of following params
9060: ----(Begin Venkat) FP_M changes ------------------------------------------------------------

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

9086: ----(End Venkat) FP_M changes ------------------------------------------------------------
9087: */
9088: --bug 2955326
9089: IF l_b_pm_tk_ref_flag = 'Y' THEN
9090: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_tk_ref', RTRIM(p_pm_task_reference));
9091: END IF;
9092:
9093: IF l_b_tk_nm_flag = 'Y' THEN
9094: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_name', substrb(RTRIM(p_task_name),1,20)); -- bug 6193314

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

9090: DBMS_SQL.BIND_VARIABLE(l_cursor, ':pm_tk_ref', RTRIM(p_pm_task_reference));
9091: END IF;
9092:
9093: IF l_b_tk_nm_flag = 'Y' THEN
9094: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_name', substrb(RTRIM(p_task_name),1,20)); -- bug 6193314
9095: END IF;
9096:
9097: IF l_b_ln_tk_nm_flag = 'Y' THEN
9098: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ln_tk_name', RTRIM(p_long_task_name));

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

9094: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_name', substrb(RTRIM(p_task_name),1,20)); -- bug 6193314
9095: END IF;
9096:
9097: IF l_b_ln_tk_nm_flag = 'Y' THEN
9098: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ln_tk_name', RTRIM(p_long_task_name));
9099: END IF;
9100:
9101: IF l_b_tk_desc_flag = 'Y' THEN
9102: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', substrb(RTRIM(p_task_description),1,250)); --Bug 8821275

Line 9102: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', substrb(RTRIM(p_task_description),1,250)); --Bug 8821275

9098: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ln_tk_name', RTRIM(p_long_task_name));
9099: END IF;
9100:
9101: IF l_b_tk_desc_flag = 'Y' THEN
9102: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', substrb(RTRIM(p_task_description),1,250)); --Bug 8821275
9103: END IF;
9104:
9105: IF l_b_rdy_to_bill_flag = 'Y' THEN
9106: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_bill_fg', p_ready_to_bill_flag);

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

9102: DBMS_SQL.BIND_VARIABLE(l_cursor, ':descrp', substrb(RTRIM(p_task_description),1,250)); --Bug 8821275
9103: END IF;
9104:
9105: IF l_b_rdy_to_bill_flag = 'Y' THEN
9106: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_bill_fg', p_ready_to_bill_flag);
9107: END IF;
9108:
9109: IF l_b_rdy_to_dist_flag = 'Y' THEN
9110: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_dist_fg', p_ready_to_distribute_flag);

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

9106: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_bill_fg', p_ready_to_bill_flag);
9107: END IF;
9108:
9109: IF l_b_rdy_to_dist_flag = 'Y' THEN
9110: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_dist_fg', p_ready_to_distribute_flag);
9111: END IF;
9112:
9113: IF l_b_lmt_to_txn_ctrl_fg = 'Y' THEN
9114: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lmt_to_txn_ctrl_fg', p_limit_to_txn_controls_flag);

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

9110: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rdy_to_dist_fg', p_ready_to_distribute_flag);
9111: END IF;
9112:
9113: IF l_b_lmt_to_txn_ctrl_fg = 'Y' THEN
9114: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lmt_to_txn_ctrl_fg', p_limit_to_txn_controls_flag);
9115: END IF;
9116:
9117: IF l_b_cryng_out_org_id_flag = 'Y' THEN
9118: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cryng_out_org_id', p_carrying_out_organization_id);

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

9114: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lmt_to_txn_ctrl_fg', p_limit_to_txn_controls_flag);
9115: END IF;
9116:
9117: IF l_b_cryng_out_org_id_flag = 'Y' THEN
9118: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cryng_out_org_id', p_carrying_out_organization_id);
9119: END IF;
9120:
9121: IF l_b_chgble_fg = 'Y' THEN
9122: DBMS_SQL.BIND_VARIABLE(l_cursor, ':chgble_fg', p_chargeable_flag);

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

9118: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cryng_out_org_id', p_carrying_out_organization_id);
9119: END IF;
9120:
9121: IF l_b_chgble_fg = 'Y' THEN
9122: DBMS_SQL.BIND_VARIABLE(l_cursor, ':chgble_fg', p_chargeable_flag);
9123: END IF;
9124:
9125: IF l_b_billable_fg = 'Y' THEN
9126: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bil_fg', p_billable_flag);

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

9122: DBMS_SQL.BIND_VARIABLE(l_cursor, ':chgble_fg', p_chargeable_flag);
9123: END IF;
9124:
9125: IF l_b_billable_fg = 'Y' THEN
9126: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bil_fg', p_billable_flag);
9127: END IF;
9128:
9129: IF l_b_srv_tp_cd_fg = 'Y' THEN
9130: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srv_tp_cd', p_service_type_code);

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

9126: DBMS_SQL.BIND_VARIABLE(l_cursor, ':bil_fg', p_billable_flag);
9127: END IF;
9128:
9129: IF l_b_srv_tp_cd_fg = 'Y' THEN
9130: DBMS_SQL.BIND_VARIABLE(l_cursor, ':srv_tp_cd', p_service_type_code);
9131: END IF;
9132:
9133: IF l_b_tk_num_fg = 'Y' THEN
9134: --dbms_output.put_line('adding the bind variable'||'-'||p_task_number);

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

9132:
9133: IF l_b_tk_num_fg = 'Y' THEN
9134: --dbms_output.put_line('adding the bind variable'||'-'||p_task_number);
9135: /* bug #5243018: Reverting the fix in bug 4120380.
9136: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num','-'||p_task_number); */
9137: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num', substrb(p_task_number,1,25)); --bug 5733285
9138: /** CODE CHANGE BY ADITI for Bug 4120380.This is to prefix task_number with '-' so that
9139: PA_TASKS_U2 constraint can be overcome.After updating all the tasks in the script,
9140: code again updates the task_number, trimming the '-' added.**/

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

9133: IF l_b_tk_num_fg = 'Y' THEN
9134: --dbms_output.put_line('adding the bind variable'||'-'||p_task_number);
9135: /* bug #5243018: Reverting the fix in bug 4120380.
9136: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num','-'||p_task_number); */
9137: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num', substrb(p_task_number,1,25)); --bug 5733285
9138: /** CODE CHANGE BY ADITI for Bug 4120380.This is to prefix task_number with '-' so that
9139: PA_TASKS_U2 constraint can be overcome.After updating all the tasks in the script,
9140: code again updates the task_number, trimming the '-' added.**/
9141: END IF;

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

9140: code again updates the task_number, trimming the '-' added.**/
9141: END IF;
9142:
9143: IF l_b_tk_st_dt_flag = 'Y' THEN
9144: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_dt', p_task_start_date);
9145: END IF;
9146:
9147: IF l_b_comp_dt_fg = 'Y' THEN
9148: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cmp_dt', p_task_completion_date);

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

9144: DBMS_SQL.BIND_VARIABLE(l_cursor, ':st_dt', p_task_start_date);
9145: END IF;
9146:
9147: IF l_b_comp_dt_fg = 'Y' THEN
9148: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cmp_dt', p_task_completion_date);
9149: END IF;
9150:
9151: IF l_b_prt_tk_id_fg = 'Y' THEN
9152: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prt_tk_id', l_new_parent_task_id);

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

9148: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cmp_dt', p_task_completion_date);
9149: END IF;
9150:
9151: IF l_b_prt_tk_id_fg = 'Y' THEN
9152: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prt_tk_id', l_new_parent_task_id);
9153: END IF;
9154:
9155: IF l_b_addr_id_fg = 'Y' THEN
9156: DBMS_SQL.BIND_VARIABLE(l_cursor, ':addr_id', p_address_id);

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

9152: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prt_tk_id', l_new_parent_task_id);
9153: END IF;
9154:
9155: IF l_b_addr_id_fg = 'Y' THEN
9156: DBMS_SQL.BIND_VARIABLE(l_cursor, ':addr_id', p_address_id);
9157: END IF;
9158:
9159: IF l_b_attr_cat_fg = 'Y' THEN
9160: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(l_attribute_category));

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

9156: DBMS_SQL.BIND_VARIABLE(l_cursor, ':addr_id', p_address_id);
9157: END IF;
9158:
9159: IF l_b_attr_cat_fg = 'Y' THEN
9160: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(l_attribute_category));
9161: END IF;
9162: --bug 6153503 start
9163: IF l_b_attr1_fg = 'Y' THEN
9164: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(l_attribute1));

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

9160: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr_cat', RTRIM(l_attribute_category));
9161: END IF;
9162: --bug 6153503 start
9163: IF l_b_attr1_fg = 'Y' THEN
9164: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(l_attribute1));
9165: END IF;
9166:
9167: IF l_b_attr2_fg = 'Y' THEN
9168: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(l_attribute2));

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

9164: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr1', RTRIM(l_attribute1));
9165: END IF;
9166:
9167: IF l_b_attr2_fg = 'Y' THEN
9168: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(l_attribute2));
9169: END IF;
9170:
9171: IF l_b_attr3_fg = 'Y' THEN
9172: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(l_attribute3));

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

9168: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr2', RTRIM(l_attribute2));
9169: END IF;
9170:
9171: IF l_b_attr3_fg = 'Y' THEN
9172: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(l_attribute3));
9173: END IF;
9174:
9175: IF l_b_attr4_fg = 'Y' THEN
9176: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(l_attribute4));

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

9172: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr3', RTRIM(l_attribute3));
9173: END IF;
9174:
9175: IF l_b_attr4_fg = 'Y' THEN
9176: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(l_attribute4));
9177: END IF;
9178:
9179: IF l_b_attr5_fg = 'Y' THEN
9180: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(l_attribute5));

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

9176: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr4', RTRIM(l_attribute4));
9177: END IF;
9178:
9179: IF l_b_attr5_fg = 'Y' THEN
9180: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(l_attribute5));
9181: END IF;
9182:
9183: IF l_b_attr6_fg = 'Y' THEN
9184: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(l_attribute6));

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

9180: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr5', RTRIM(l_attribute5));
9181: END IF;
9182:
9183: IF l_b_attr6_fg = 'Y' THEN
9184: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(l_attribute6));
9185: END IF;
9186:
9187: IF l_b_attr7_fg = 'Y' THEN
9188: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(l_attribute7));

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

9184: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr6', RTRIM(l_attribute6));
9185: END IF;
9186:
9187: IF l_b_attr7_fg = 'Y' THEN
9188: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(l_attribute7));
9189: END IF;
9190:
9191: IF l_b_attr8_fg = 'Y' THEN
9192: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(l_attribute8));

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

9188: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr7', RTRIM(l_attribute7));
9189: END IF;
9190:
9191: IF l_b_attr8_fg = 'Y' THEN
9192: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(l_attribute8));
9193: END IF;
9194:
9195: IF l_b_attr9_fg = 'Y' THEN
9196: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(l_attribute9));

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

9192: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr8', RTRIM(l_attribute8));
9193: END IF;
9194:
9195: IF l_b_attr9_fg = 'Y' THEN
9196: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(l_attribute9));
9197: END IF;
9198:
9199: IF l_b_attr10_fg = 'Y' THEN
9200: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(l_attribute10));

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

9196: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr9', RTRIM(l_attribute9));
9197: END IF;
9198:
9199: IF l_b_attr10_fg = 'Y' THEN
9200: DBMS_SQL.BIND_VARIABLE(l_cursor, ':attr10', RTRIM(l_attribute10));
9201: END IF;
9202: --bug 6153503 end
9203:
9204: IF l_b_al_x_chg_fg = 'Y' THEN

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

9201: END IF;
9202: --bug 6153503 end
9203:
9204: IF l_b_al_x_chg_fg = 'Y' THEN
9205: DBMS_SQL.BIND_VARIABLE(l_cursor, ':all_x_chg_fg', RTRIM(p_allow_cross_charge_flag));
9206: END IF;
9207:
9208: IF l_b_prj_rt_tp_fg = 'Y' THEN
9209: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_tp', RTRIM(p_project_rate_type));

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

9205: DBMS_SQL.BIND_VARIABLE(l_cursor, ':all_x_chg_fg', RTRIM(p_allow_cross_charge_flag));
9206: END IF;
9207:
9208: IF l_b_prj_rt_tp_fg = 'Y' THEN
9209: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_tp', RTRIM(p_project_rate_type));
9210: END IF;
9211:
9212: IF l_b_prj_rt_dt_fg = 'Y' THEN
9213: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_dt', p_project_rate_date);

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

9209: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_tp', RTRIM(p_project_rate_type));
9210: END IF;
9211:
9212: IF l_b_prj_rt_dt_fg = 'Y' THEN
9213: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_dt', p_project_rate_date);
9214: END IF;
9215:
9216: IF l_b_cc_proc_lbr_fg = 'Y' THEN
9217: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lbr_fg', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048

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

9213: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_rt_dt', p_project_rate_date);
9214: END IF;
9215:
9216: IF l_b_cc_proc_lbr_fg = 'Y' THEN
9217: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lbr_fg', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048
9218: END IF;
9219:
9220: IF l_b_lbr_tp_sch_id_fg = 'Y' THEN
9221: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_sch_id', p_labor_tp_schedule_id);

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

9217: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_lbr_fg', RTRIM(l_cc_process_labor_flag)); -- Changed to local variable for Bug 5395048
9218: END IF;
9219:
9220: IF l_b_lbr_tp_sch_id_fg = 'Y' THEN
9221: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_sch_id', p_labor_tp_schedule_id);
9222: END IF;
9223:
9224: IF l_b_lbr_tp_fx_dt_fg = 'Y' THEN
9225: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_fx_dt', p_labor_tp_fixed_date);

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

9221: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_sch_id', p_labor_tp_schedule_id);
9222: END IF;
9223:
9224: IF l_b_lbr_tp_fx_dt_fg = 'Y' THEN
9225: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_fx_dt', p_labor_tp_fixed_date);
9226: END IF;
9227:
9228: IF l_b_cc_proc_nl_fg = 'Y' THEN
9229: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_fg', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048

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

9225: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_tp_fx_dt', p_labor_tp_fixed_date);
9226: END IF;
9227:
9228: IF l_b_cc_proc_nl_fg = 'Y' THEN
9229: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_fg', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048
9230: END IF;
9231:
9232: IF l_b_nl_tp_sch_id_fg = 'Y' THEN
9233: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_nl_tp_schedule_id);

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

9229: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cc_proc_nl_fg', RTRIM(l_cc_process_nl_flag)); -- Changed to local variable for Bug 5395048
9230: END IF;
9231:
9232: IF l_b_nl_tp_sch_id_fg = 'Y' THEN
9233: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_nl_tp_schedule_id);
9234: END IF;
9235:
9236: IF l_b_nl_tp_fx_dt_fg = 'Y' THEN
9237: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_nl_tp_fixed_date);

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

9233: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_sch_id', p_nl_tp_schedule_id);
9234: END IF;
9235:
9236: IF l_b_nl_tp_fx_dt_fg = 'Y' THEN
9237: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_nl_tp_fixed_date);
9238: END IF;
9239:
9240: IF l_b_rcv_prj_inv_fg = 'Y' THEN
9241: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rcv_prj_inv_fg', RTRIM(p_receive_project_invoice_flag));

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

9237: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_tp_fx_dt', p_nl_tp_fixed_date);
9238: END IF;
9239:
9240: IF l_b_rcv_prj_inv_fg = 'Y' THEN
9241: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rcv_prj_inv_fg', RTRIM(p_receive_project_invoice_flag));
9242: END IF;
9243:
9244: IF l_b_wk_tp_id_fg = 'Y' THEN
9245: DBMS_SQL.BIND_VARIABLE(l_cursor, ':wk_tp_id', p_work_type_id);

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

9241: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rcv_prj_inv_fg', RTRIM(p_receive_project_invoice_flag));
9242: END IF;
9243:
9244: IF l_b_wk_tp_id_fg = 'Y' THEN
9245: DBMS_SQL.BIND_VARIABLE(l_cursor, ':wk_tp_id', p_work_type_id);
9246: END IF;
9247:
9248: IF l_b_emp_bill_rt_sch_id_fg = 'Y' THEN
9249: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_emp_bill_rate_schedule_id);

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

9245: DBMS_SQL.BIND_VARIABLE(l_cursor, ':wk_tp_id', p_work_type_id);
9246: END IF;
9247:
9248: IF l_b_emp_bill_rt_sch_id_fg = 'Y' THEN
9249: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_emp_bill_rate_schedule_id);
9250: END IF;
9251:
9252: IF l_b_jb_bill_rt_sch_id_fg = 'Y' THEN
9253: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_job_bill_rate_schedule_id);

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

9249: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id', p_emp_bill_rate_schedule_id);
9250: END IF;
9251:
9252: IF l_b_jb_bill_rt_sch_id_fg = 'Y' THEN
9253: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_job_bill_rate_schedule_id);
9254: END IF;
9255:
9256: IF l_b_nn_lb_std_bl_rt_sch_id_fg = 'Y' THEN
9257: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);

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

9253: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id', p_job_bill_rate_schedule_id);
9254: END IF;
9255:
9256: IF l_b_nn_lb_std_bl_rt_sch_id_fg = 'Y' THEN
9257: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);
9258: END IF;
9259:
9260: IF l_b_tkfnc_cst_rt_dt_fg = 'Y' THEN
9261: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_dt', p_taskfunc_cost_rate_date);

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

9257: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lb_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);
9258: END IF;
9259:
9260: IF l_b_tkfnc_cst_rt_dt_fg = 'Y' THEN
9261: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_dt', p_taskfunc_cost_rate_date);
9262: END IF;
9263:
9264: IF l_b_tkfnc_cst_rt_tp_fg = 'Y' THEN
9265: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_tp', RTRIM(p_taskfunc_cost_rate_type));

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

9261: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_dt', p_taskfunc_cost_rate_date);
9262: END IF;
9263:
9264: IF l_b_tkfnc_cst_rt_tp_fg = 'Y' THEN
9265: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_tp', RTRIM(p_taskfunc_cost_rate_type));
9266: END IF;
9267:
9268: IF l_b_lbr_disc_rsn_cd_fg = 'Y' THEN
9269: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_cd', RTRIM(p_labor_disc_reason_code));

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

9265: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tkfnc_cst_rt_tp', RTRIM(p_taskfunc_cost_rate_type));
9266: END IF;
9267:
9268: IF l_b_lbr_disc_rsn_cd_fg = 'Y' THEN
9269: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_cd', RTRIM(p_labor_disc_reason_code));
9270: END IF;
9271:
9272: IF l_b_nn_lbr_disc_rsn_cd_fg = 'Y' THEN
9273: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));

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

9269: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_disc_rsn_cd', RTRIM(p_labor_disc_reason_code));
9270: END IF;
9271:
9272: IF l_b_nn_lbr_disc_rsn_cd_fg = 'Y' THEN
9273: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));
9274: END IF;
9275:
9276: IF l_b_act_st_dt_fg = 'Y' THEN
9277: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_st_dt', p_actual_start_date);

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

9273: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nn_lbr_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));
9274: END IF;
9275:
9276: IF l_b_act_st_dt_fg = 'Y' THEN
9277: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_st_dt', p_actual_start_date);
9278: END IF;
9279:
9280: IF l_b_act_fn_dt_fg = 'Y' THEN
9281: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_fn_dt', p_actual_finish_date);

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

9277: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_st_dt', p_actual_start_date);
9278: END IF;
9279:
9280: IF l_b_act_fn_dt_fg = 'Y' THEN
9281: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_fn_dt', p_actual_finish_date);
9282: END IF;
9283:
9284: IF l_b_erly_st_dt_fg = 'Y' THEN
9285: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_st_dt', p_early_start_date);

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

9281: DBMS_SQL.BIND_VARIABLE(l_cursor, ':act_fn_dt', p_actual_finish_date);
9282: END IF;
9283:
9284: IF l_b_erly_st_dt_fg = 'Y' THEN
9285: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_st_dt', p_early_start_date);
9286: END IF;
9287:
9288: IF l_b_erly_fn_dt_fg = 'Y' THEN
9289: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_fn_dt', p_early_finish_date);

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

9285: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_st_dt', p_early_start_date);
9286: END IF;
9287:
9288: IF l_b_erly_fn_dt_fg = 'Y' THEN
9289: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_fn_dt', p_early_finish_date);
9290: END IF;
9291:
9292: IF l_b_lt_st_dt_fg = 'Y' THEN
9293: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_st_dt', p_late_start_date);

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

9289: DBMS_SQL.BIND_VARIABLE(l_cursor, ':erly_fn_dt', p_early_finish_date);
9290: END IF;
9291:
9292: IF l_b_lt_st_dt_fg = 'Y' THEN
9293: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_st_dt', p_late_start_date);
9294: END IF;
9295:
9296: IF l_b_lt_fn_dt_fg = 'Y' THEN
9297: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_fn_dt', p_late_finish_date);

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

9293: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_st_dt', p_late_start_date);
9294: END IF;
9295:
9296: IF l_b_lt_fn_dt_fg = 'Y' THEN
9297: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_fn_dt', p_late_finish_date);
9298: END IF;
9299:
9300: IF l_b_sch_st_dt_fg = 'Y' THEN
9301: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_st_dt', p_scheduled_start_date);

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

9297: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lt_fn_dt', p_late_finish_date);
9298: END IF;
9299:
9300: IF l_b_sch_st_dt_fg = 'Y' THEN
9301: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_st_dt', p_scheduled_start_date);
9302: END IF;
9303:
9304: IF l_b_sch_fn_dt_fg = 'Y' THEN
9305: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_fn_dt', p_scheduled_finish_date);

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

9301: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_st_dt', p_scheduled_start_date);
9302: END IF;
9303:
9304: IF l_b_sch_fn_dt_fg = 'Y' THEN
9305: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_fn_dt', p_scheduled_finish_date);
9306: END IF;
9307:
9308: IF l_b_cst_ind_rt_sch_id_fg = 'Y' THEN
9309: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_rt_sch_id', p_cost_ind_rate_sch_id);

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

9305: DBMS_SQL.BIND_VARIABLE(l_cursor, ':sch_fn_dt', p_scheduled_finish_date);
9306: END IF;
9307:
9308: IF l_b_cst_ind_rt_sch_id_fg = 'Y' THEN
9309: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_rt_sch_id', p_cost_ind_rate_sch_id);
9310: END IF;
9311:
9312: IF l_b_cst_ind_sch_fx_dt_fg = 'Y' THEN
9313: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_sch_fx_dt', p_cost_ind_sch_fixed_date);

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

9309: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_rt_sch_id', p_cost_ind_rate_sch_id);
9310: END IF;
9311:
9312: IF l_b_cst_ind_sch_fx_dt_fg = 'Y' THEN
9313: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_sch_fx_dt', p_cost_ind_sch_fixed_date);
9314: END IF;
9315:
9316: IF l_b_ret_cst_fg = 'Y' THEN
9317: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_cst_fg', RTRIM(p_retirement_cost_flag));

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

9313: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cst_ind_sch_fx_dt', p_cost_ind_sch_fixed_date);
9314: END IF;
9315:
9316: IF l_b_ret_cst_fg = 'Y' THEN
9317: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_cst_fg', RTRIM(p_retirement_cost_flag));
9318: END IF;
9319:
9320: IF l_b_cint_elg_fg = 'Y' THEN
9321: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_cint_eligible_flag));

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

9317: DBMS_SQL.BIND_VARIABLE(l_cursor, ':ret_cst_fg', RTRIM(p_retirement_cost_flag));
9318: END IF;
9319:
9320: IF l_b_cint_elg_fg = 'Y' THEN
9321: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_cint_eligible_flag));
9322: END IF;
9323:
9324: IF l_b_cint_stp_dt_fg = 'Y' THEN
9325: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', RTRIM(p_cint_stop_date));

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

9321: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_elg_fg', RTRIM(p_cint_eligible_flag));
9322: END IF;
9323:
9324: IF l_b_cint_stp_dt_fg = 'Y' THEN
9325: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', RTRIM(p_cint_stop_date));
9326: END IF;
9327:
9328: IF l_b_lbr_sch_tp_fg = 'Y' THEN
9329: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_tp', RTRIM(p_labor_sch_type));

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

9325: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cint_stp_dt', RTRIM(p_cint_stop_date));
9326: END IF;
9327:
9328: IF l_b_lbr_sch_tp_fg = 'Y' THEN
9329: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_tp', RTRIM(p_labor_sch_type));
9330: END IF;
9331:
9332: IF l_b_n_lbr_sch_tp_fg = 'Y' THEN
9333: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lbr_sch_tp', RTRIM(p_nl_sch_type));

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

9329: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_tp', RTRIM(p_labor_sch_type));
9330: END IF;
9331:
9332: IF l_b_n_lbr_sch_tp_fg = 'Y' THEN
9333: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lbr_sch_tp', RTRIM(p_nl_sch_type));
9334: END IF;
9335:
9336: 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
9337: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_emp_bill_rate_schedule_id);

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

9333: DBMS_SQL.BIND_VARIABLE(l_cursor, ':n_lbr_sch_tp', RTRIM(p_nl_sch_type));
9334: END IF;
9335:
9336: 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
9337: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_emp_bill_rate_schedule_id);
9338: END IF;
9339:
9340: IF l_b_jb_bill_rt_sch_id_fg2 = 'Y' THEN
9341: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_job_bill_rate_schedule_id);

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

9337: DBMS_SQL.BIND_VARIABLE(l_cursor, ':emp_bill_rt_sch_id2', p_emp_bill_rate_schedule_id);
9338: END IF;
9339:
9340: IF l_b_jb_bill_rt_sch_id_fg2 = 'Y' THEN
9341: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_job_bill_rate_schedule_id);
9342: END IF;
9343:
9344: IF l_b_lbr_sch_fx_dt = 'Y' THEN
9345: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_fx_dt', p_labor_schedule_fixed_date);

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

9341: DBMS_SQL.BIND_VARIABLE(l_cursor, ':jb_bill_rt_sch_id2', p_job_bill_rate_schedule_id);
9342: END IF;
9343:
9344: IF l_b_lbr_sch_fx_dt = 'Y' THEN
9345: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_fx_dt', p_labor_schedule_fixed_date);
9346: END IF;
9347:
9348: IF l_b_lbr_sch_dsnt = 'Y' THEN
9349: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_dsnt', p_labor_schedule_discount);

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

9345: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_fx_dt', p_labor_schedule_fixed_date);
9346: END IF;
9347:
9348: IF l_b_lbr_sch_dsnt = 'Y' THEN
9349: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_dsnt', p_labor_schedule_discount);
9350: END IF;
9351:
9352: IF l_b_rv_ind_rt_sch_id_fg = 'Y' THEN
9353: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_rev_ind_rate_sch_id);

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

9349: DBMS_SQL.BIND_VARIABLE(l_cursor, ':lbr_sch_dsnt', p_labor_schedule_discount);
9350: END IF;
9351:
9352: IF l_b_rv_ind_rt_sch_id_fg = 'Y' THEN
9353: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_rev_ind_rate_sch_id);
9354: END IF;
9355:
9356: IF l_b_inv_ind_rt_sch_id_fg = 'Y' THEN
9357: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_inv_ind_rate_sch_id);

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

9353: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_rt_sch_id', p_rev_ind_rate_sch_id);
9354: END IF;
9355:
9356: IF l_b_inv_ind_rt_sch_id_fg = 'Y' THEN
9357: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_inv_ind_rate_sch_id);
9358: END IF;
9359:
9360: IF l_b_rv_ind_sch_fx_dt_fg = 'Y' THEN
9361: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_sch_fx_dt', p_rev_ind_sch_fixed_date);

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

9357: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_ind_rt_sch_id', p_inv_ind_rate_sch_id);
9358: END IF;
9359:
9360: IF l_b_rv_ind_sch_fx_dt_fg = 'Y' THEN
9361: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_sch_fx_dt', p_rev_ind_sch_fixed_date);
9362: END IF;
9363:
9364: IF l_b_iv_ind_sch_fx_dt_fg = 'Y' THEN
9365: DBMS_SQL.BIND_VARIABLE(l_cursor, ':iv_ind_sch_fx_dt', p_inv_ind_sch_fixed_date);

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

9361: DBMS_SQL.BIND_VARIABLE(l_cursor, ':rv_ind_sch_fx_dt', p_rev_ind_sch_fixed_date);
9362: END IF;
9363:
9364: IF l_b_iv_ind_sch_fx_dt_fg = 'Y' THEN
9365: DBMS_SQL.BIND_VARIABLE(l_cursor, ':iv_ind_sch_fx_dt', p_inv_ind_sch_fixed_date);
9366: END IF;
9367:
9368: IF l_b_nl_bl_rt_org_id_fg = 'Y' THEN
9369: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_bl_rt_org_id', p_nl_bill_rate_org_id);

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

9365: DBMS_SQL.BIND_VARIABLE(l_cursor, ':iv_ind_sch_fx_dt', p_inv_ind_sch_fixed_date);
9366: END IF;
9367:
9368: IF l_b_nl_bl_rt_org_id_fg = 'Y' THEN
9369: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_bl_rt_org_id', p_nl_bill_rate_org_id);
9370: END IF;
9371:
9372: IF l_b_nl_std_bl_rt_sch_fg = 'Y' THEN
9373: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);

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

9369: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_bl_rt_org_id', p_nl_bill_rate_org_id);
9370: END IF;
9371:
9372: IF l_b_nl_std_bl_rt_sch_fg = 'Y' THEN
9373: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);
9374: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch', RTRIM(l_std_bill_rate_schedule));
9375: END IF;
9376:
9377: IF l_b_nl_sch_fx_dt_fg = 'Y' THEN

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

9370: END IF;
9371:
9372: IF l_b_nl_std_bl_rt_sch_fg = 'Y' THEN
9373: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch_id', p_non_lab_std_bill_rt_sch_id);
9374: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch', RTRIM(l_std_bill_rate_schedule));
9375: END IF;
9376:
9377: IF l_b_nl_sch_fx_dt_fg = 'Y' THEN
9378: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_fx_dt', p_nl_schedule_fixed_date);

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

9374: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_std_bl_rt_sch', RTRIM(l_std_bill_rate_schedule));
9375: END IF;
9376:
9377: IF l_b_nl_sch_fx_dt_fg = 'Y' THEN
9378: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_fx_dt', p_nl_schedule_fixed_date);
9379: END IF;
9380:
9381: IF l_b_nl_sch_dsnt_fg = 'Y' THEN
9382: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_dsnt', p_nl_schedule_discount);

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

9378: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_fx_dt', p_nl_schedule_fixed_date);
9379: END IF;
9380:
9381: IF l_b_nl_sch_dsnt_fg = 'Y' THEN
9382: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_dsnt', p_nl_schedule_discount);
9383: END IF;
9384:
9385: IF l_b_nl_disc_rsn_cd_fg = 'Y' THEN
9386: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));

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

9382: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_sch_dsnt', p_nl_schedule_discount);
9383: END IF;
9384:
9385: IF l_b_nl_disc_rsn_cd_fg = 'Y' THEN
9386: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));
9387: END IF;
9388:
9389: IF l_b_tk_mgr_id_fg = 'Y' THEN
9390: 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 9390: 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

9386: DBMS_SQL.BIND_VARIABLE(l_cursor, ':nl_disc_rsn_cd', RTRIM(p_non_labor_disc_reason_code));
9387: END IF;
9388:
9389: IF l_b_tk_mgr_id_fg = 'Y' THEN
9390: 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
9391: END IF;
9392:
9393: ----(Begin Venkat) FP_M changes ------------------------------------------------------------
9394:

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

9395: IF l_inv_md_fg = 'Y'
9396: THEN
9397: -- 4177105 changed usage from l_invoice_method to p_invoice_method
9398: -- because l_invoice_method is unitialized
9399: DBMS_SQL.BIND_VARIABLE(l_cursor, ':inv_md', p_invoice_method);
9400: END IF;
9401:
9402: IF l_cust_id_fg = 'Y'
9403: THEN

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

9401:
9402: IF l_cust_id_fg = 'Y'
9403: THEN
9404: -- Bug 4193259: Changed l_customer_id to p_customer_id
9405: DBMS_SQL.BIND_VARIABLE(l_cursor, ':cust_id', p_customer_id);
9406: END IF;
9407:
9408: IF l_gen_etc_src_co_fg = 'Y'
9409: THEN

Line 9410: 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 */

9406: END IF;
9407:
9408: IF l_gen_etc_src_co_fg = 'Y'
9409: THEN
9410: 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 */
9411: END IF;
9412:
9413: ----(End Venkat) FP_M changes ------------------------------------------------------------
9414:

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

9411: END IF;
9412:
9413: ----(End Venkat) FP_M changes ------------------------------------------------------------
9414:
9415: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
9416: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
9417: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
9418: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_id', l_task_id);
9419:

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

9412:
9413: ----(End Venkat) FP_M changes ------------------------------------------------------------
9414:
9415: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
9416: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
9417: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
9418: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_id', l_task_id);
9419:
9420: --end bug 2955326

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

9413: ----(End Venkat) FP_M changes ------------------------------------------------------------
9414:
9415: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
9416: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
9417: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
9418: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_id', l_task_id);
9419:
9420: --end bug 2955326
9421:

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

9414:
9415: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_usr_id', G_USER_ID);
9416: DBMS_SQL.BIND_VARIABLE(l_cursor, ':g_login_id', G_LOGIN_ID);
9417: DBMS_SQL.BIND_VARIABLE(l_cursor, ':prj_id', l_project_id);
9418: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_id', l_task_id);
9419:
9420: --end bug 2955326
9421:
9422: l_rows := dbms_sql.execute(l_cursor);

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

9418: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_id', l_task_id);
9419:
9420: --end bug 2955326
9421:
9422: l_rows := dbms_sql.execute(l_cursor);
9423: IF dbms_sql.is_open (l_cursor)
9424: THEN
9425: dbms_sql.close_cursor (l_cursor);
9426: END IF;

Line 9423: IF dbms_sql.is_open (l_cursor)

9419:
9420: --end bug 2955326
9421:
9422: l_rows := dbms_sql.execute(l_cursor);
9423: IF dbms_sql.is_open (l_cursor)
9424: THEN
9425: dbms_sql.close_cursor (l_cursor);
9426: END IF;
9427:

Line 9425: dbms_sql.close_cursor (l_cursor);

9421:
9422: l_rows := dbms_sql.execute(l_cursor);
9423: IF dbms_sql.is_open (l_cursor)
9424: THEN
9425: dbms_sql.close_cursor (l_cursor);
9426: END IF;
9427:
9428: END IF;
9429: