[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, -- 4537865
X_Project_Id IN OUT NOCOPY NUMBER, -- 4537865
x_org_id NUMBER, --R12: Bug 4363092
X_Name VARCHAR2,
X_Long_Name VARCHAR2,
X_Segment1 VARCHAR2,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Login NUMBER,
X_Project_Type VARCHAR2,
X_Carrying_Out_Organization_Id NUMBER,
X_Public_Sector_Flag VARCHAR2,
X_Project_Status_Code VARCHAR2,
X_Description VARCHAR2,
X_Start_Date DATE,
X_Completion_Date DATE,
X_Closed_Date DATE,
X_Distribution_Rule VARCHAR2,
X_Labor_Invoice_Format_Id NUMBER,
X_NL_Invoice_Format_Id NUMBER,
X_Retention_Invoice_Format_Id NUMBER,
X_Retention_Percentage NUMBER,
X_Billing_Offset NUMBER,
X_Billing_Cycle_Id NUMBER,
X_Labor_Std_Bill_Rate_Schdl VARCHAR2,
X_Labor_Bill_Rate_Org_Id NUMBER,
X_Labor_Schedule_Fixed_Date DATE,
X_Labor_Schedule_Discount NUMBER,
X_NL_Std_Bill_Rate_Schdl VARCHAR2,
X_NL_Bill_Rate_Org_Id NUMBER,
X_NL_Schedule_Fixed_Date DATE,
X_NL_Schedule_Discount NUMBER,
X_Limit_To_Txn_Controls_Flag VARCHAR2,
X_Project_Level_Funding_Flag VARCHAR2,
X_Invoice_Comment VARCHAR2,
X_Unbilled_Receivable_Dr NUMBER,
X_Unearned_Revenue_Cr NUMBER,
X_Summary_Flag VARCHAR2,
X_Enabled_Flag VARCHAR2,
X_Segment2 VARCHAR2,
X_Segment3 VARCHAR2,
X_Segment4 VARCHAR2,
X_Segment5 VARCHAR2,
X_Segment6 VARCHAR2,
X_Segment7 VARCHAR2,
X_Segment8 VARCHAR2,
X_Segment9 VARCHAR2,
X_Segment10 VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Cost_Ind_Rate_Sch_Id NUMBER,
X_Rev_Ind_Rate_Sch_Id NUMBER,
X_Inv_Ind_Rate_Sch_Id NUMBER,
X_Cost_Ind_Sch_Fixed_Date DATE,
X_Rev_Ind_Sch_Fixed_Date DATE,
X_Inv_Ind_Sch_Fixed_Date DATE,
X_Labor_Sch_Type VARCHAR2,
X_Non_Labor_Sch_Type VARCHAR2,
X_Template_Flag VARCHAR2,
X_Verification_Date DATE,
X_Created_From_Project_Id NUMBER,
X_Template_Start_Date DATE,
X_Template_End_Date DATE,
X_Project_Currency_Code VARCHAR2,
X_Allow_Cross_Charge_Flag VARCHAR2,
X_Project_Rate_Date DATE,
X_Project_Rate_Type VARCHAR2,
X_Output_Tax_Code VARCHAR2,
X_Retention_Tax_Code VARCHAR2,
X_CC_Process_Labor_Flag VARCHAR2,
X_Labor_Tp_Schedule_Id NUMBER,
X_Labor_Tp_Fixed_Date DATE,
X_CC_Process_NL_Flag VARCHAR2,
X_Nl_Tp_Schedule_Id NUMBER,
X_Nl_Tp_Fixed_Date DATE,
X_CC_Tax_Task_Id NUMBER,
-- 17-MAY-00 kkekkar Added the following columns for CBGA project
-- bill_job_group_id, cost_job_group_id
x_bill_job_group_id NUMBER,
x_cost_job_group_id NUMBER,
x_role_list_id NUMBER,
x_work_type_id NUMBER,
x_calendar_id NUMBER,
x_location_id NUMBER,
x_probability_member_id NUMBER,
x_project_value NUMBER,
x_expected_approval_date DATE,
x_team_template_id NUMBER,
-- 21-MAR-2001 anlee
-- added job_bill_rate_schedule_id,
-- emp_bill_rate_schedule_id for
-- PRM forecasting changes
x_job_bill_rate_schedule_id NUMBER,
x_emp_bill_rate_schedule_id NUMBER,
--MCA Sakthi for MultiAgreementCurreny Project
x_competence_match_wt NUMBER,
x_availability_match_wt NUMBER,
x_job_level_match_wt NUMBER,
x_enable_automated_search VARCHAR2,
x_search_min_availability NUMBER,
x_search_org_hier_id NUMBER,
x_search_starting_org_id NUMBER,
x_search_country_code VARCHAR2,
x_min_cand_score_reqd_for_nom NUMBER,
x_non_lab_std_bill_rt_sch_id NUMBER,
x_invproc_currency_type VARCHAR2,
x_revproc_currency_code VARCHAR2,
x_project_bil_rate_date_code VARCHAR2,
x_project_bil_rate_type VARCHAR2,
x_project_bil_rate_date DATE,
x_project_bil_exchange_rate NUMBER,
x_projfunc_currency_code VARCHAR2,
x_projfunc_bil_rate_date_code VARCHAR2,
x_projfunc_bil_rate_type VARCHAR2,
x_projfunc_bil_rate_date DATE,
x_projfunc_bil_exchange_rate NUMBER,
x_funding_rate_date_code VARCHAR2,
x_funding_rate_type VARCHAR2,
x_funding_rate_date DATE,
x_funding_exchange_rate NUMBER,
x_baseline_funding_flag VARCHAR2,
x_projfunc_cost_rate_type VARCHAR2,
x_projfunc_cost_rate_date DATE,
x_multi_currency_billing_flag VARCHAR2,
x_inv_by_bill_trans_curr_flag VARCHAR2,
--MCA Sakthi for MultiAgreementCurrency Project
--MCA
x_assign_precedes_task VARCHAR2,
--Structure
x_split_cost_from_wokplan_flag VARCHAR2,
x_split_cost_from_bill_flag VARCHAR2,
--Structure
--Advertisement
x_adv_action_set_id NUMBER,
x_start_adv_action_set_flag VARCHAR2,
--Advertisement
--Project Setup
x_priority_code VARCHAR2,
--Project Setup
--Retention
x_retn_billing_inv_format_id NUMBER,
x_retn_accounting_flag VARCHAR2,
--Retention
-- anlee
-- patchset K changes
x_revaluate_funding_flag VARCHAR2,
x_include_gains_losses_flag VARCHAR2,
-- msundare
x_security_level NUMBER,
x_labor_disc_reason_code VARCHAR2,
x_non_labor_disc_reason_code VARCHAR2,
-- End of changes
x_record_version_number NUMBER,
x_btc_cost_base_rev_code VARCHAR2, /* Bug#2638968 */
x_revtrans_currency_type VARCHAR2, /* R12 - Bug 4363092 */
--PA L
x_asset_allocation_method VARCHAR2,
x_capital_event_processing VARCHAR2,
x_cint_rate_sch_id NUMBER,
x_cint_eligible_flag VARCHAR2,
x_cint_stop_date DATE,
--FP_M Changes. Tracking Bug 3279981
x_en_top_task_customer_flag VARCHAR2,
x_en_top_task_inv_mth_flag VARCHAR2,
x_revenue_accrual_method VARCHAR2,
x_invoice_method VARCHAR2,
x_projfunc_attr_for_ar_flag VARCHAR2,
x_sys_program_flag VARCHAR2,
x_allow_multi_program_rollup VARCHAR2,
x_proj_req_res_format_id NUMBER,
x_proj_asgmt_res_format_id NUMBER,
--sunkalya:federal Bug#5511353
x_date_eff_funds_flag VARCHAR2
--sunkalya:federal Bug#5511353
,x_ar_rec_notify_flag VARCHAR2 -- 7508661 : EnC
,x_auto_release_pwp_inv VARCHAR2 -- 7508661 : EnC
) IS
CURSOR C IS SELECT rowid FROM pa_projects
WHERE project_id = X_Project_Id;
CURSOR C2 IS SELECT pa_projects_s.nextval FROM sys.dual;
INSERT INTO pa_projects(
project_id,
org_id, --R12: Bug 4363092
name,
long_name,
segment1,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
project_type,
carrying_out_organization_id,
public_sector_flag,
project_status_code,
description,
start_date,
completion_date,
closed_date,
distribution_rule,
labor_invoice_format_id,
non_labor_invoice_format_id,
retention_invoice_format_id,
retention_percentage,
billing_offset,
billing_cycle_id,
labor_std_bill_rate_schdl,
labor_bill_rate_org_id,
labor_schedule_fixed_date,
labor_schedule_discount,
non_labor_std_bill_rate_schdl,
non_labor_bill_rate_org_id,
non_labor_schedule_fixed_date,
non_labor_schedule_discount,
limit_to_txn_controls_flag,
project_level_funding_flag,
invoice_comment,
unbilled_receivable_dr,
unearned_revenue_cr,
summary_flag,
enabled_flag,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
cost_ind_rate_sch_id,
rev_ind_rate_sch_id,
inv_ind_rate_sch_id,
cost_ind_sch_fixed_date,
rev_ind_sch_fixed_date,
inv_ind_sch_fixed_date,
labor_sch_type,
non_labor_sch_type,
template_flag,
verification_date,
created_from_project_id,
template_start_date_active,
template_end_date_active,
Project_Currency_Code,
Allow_Cross_Charge_Flag,
Project_Rate_Date,
Project_Rate_Type,
Output_Tax_Code,
Retention_Tax_Code,
CC_Process_Labor_Flag,
Labor_Tp_Schedule_Id,
Labor_Tp_Fixed_Date,
CC_Process_NL_Flag,
Nl_Tp_Schedule_Id,
Nl_Tp_Fixed_Date,
CC_Tax_Task_Id,
bill_job_group_id,
cost_job_group_id,
role_list_id,
work_type_id,
calendar_id,
location_id,
probability_member_id,
project_value,
expected_approval_date,
initial_team_template_id,
job_bill_rate_schedule_id,
emp_bill_rate_schedule_id,
--MCA Sakthi for MultiAgreementCurreny Project
competence_match_wt,
availability_match_wt,
job_level_match_wt,
enable_automated_search,
search_min_availability,
search_org_hier_id,
search_starting_org_id,
search_country_code,
min_cand_score_reqd_for_nom,
non_lab_std_bill_rt_sch_id,
invproc_currency_type,
revproc_currency_code,
project_bil_rate_date_code,
project_bil_rate_type,
project_bil_rate_date,
project_bil_exchange_rate,
projfunc_currency_code,
projfunc_bil_rate_date_code,
projfunc_bil_rate_type,
projfunc_bil_rate_date,
projfunc_bil_exchange_rate,
funding_rate_date_code,
funding_rate_type,
funding_rate_date,
funding_exchange_rate,
baseline_funding_flag,
projfunc_cost_rate_type,
projfunc_cost_rate_date,
multi_currency_billing_flag,
inv_by_bill_trans_curr_flag,
--MCA Sakthi for MultiAgreementCurreny Project
assign_precedes_task,
--Structure
split_cost_From_workplan_flag,
split_cost_from_bill_flag,
--Structure
--Advertisement
adv_action_set_id ,
start_adv_action_set_flag,
--Advertisement
--Project Setup
priority_code,
--Project Setup
--Retention
retn_billing_inv_format_id,
retn_accounting_flag ,
--Retention
-- anlee
-- patchset K changes
revaluate_funding_flag,
include_gains_losses_flag,
-- msundare
security_level ,
labor_disc_reason_code ,
non_labor_disc_reason_code ,
-- End of changes
record_version_number,
btc_cost_base_rev_code , /* Bug#2638968 */
revtrans_currency_type, /* R12 - Bug 4363092 */
--PA L
asset_allocation_method ,
capital_event_processing,
cint_rate_sch_id ,
cint_eligible_flag,
cint_stop_date,
--FP_M Changes. Tracking Bug 3279981
enable_top_task_customer_flag,
enable_top_task_inv_mth_flag,
revenue_accrual_method,
invoice_method,
projfunc_attr_for_ar_flag,
sys_program_flag,
allow_multi_program_rollup,
proj_req_res_format_id,
proj_asgmt_res_format_id,
--sunkalya:federal Bug#5511353
date_eff_funds_consumption
--sunkalya:federal Bug#5511353
,ar_rec_notify_flag -- 7508661 : EnC
,auto_release_pwp_inv -- 7508661 : EnC
)
VALUES (
X_Project_Id,
X_Org_id, --R12: Bug 4363092
X_Name,
X_Long_Name,
X_Segment1,
X_Last_Update_Date,
X_Last_Updated_By,
X_Creation_Date,
X_Created_By,
X_Last_Update_Login,
X_Project_Type,
X_Carrying_Out_Organization_Id,
X_Public_Sector_Flag,
X_Project_Status_Code,
X_Description,
X_Start_Date,
X_Completion_Date,
X_Closed_Date,
X_Distribution_Rule,
X_Labor_Invoice_Format_Id,
X_NL_Invoice_Format_Id,
X_Retention_Invoice_Format_Id,
X_Retention_Percentage,
X_Billing_Offset,
X_Billing_Cycle_Id,
X_Labor_Std_Bill_Rate_Schdl,
X_Labor_Bill_Rate_Org_Id,
X_Labor_Schedule_Fixed_Date,
X_Labor_Schedule_Discount,
X_NL_Std_Bill_Rate_Schdl,
X_NL_Bill_Rate_Org_Id,
X_NL_Schedule_Fixed_Date,
X_NL_Schedule_Discount,
X_Limit_To_Txn_Controls_Flag,
X_Project_Level_Funding_Flag,
X_Invoice_Comment,
X_Unbilled_Receivable_Dr,
X_Unearned_Revenue_Cr,
X_Summary_Flag,
X_Enabled_Flag,
X_Segment2,
X_Segment3,
X_Segment4,
X_Segment5,
X_Segment6,
X_Segment7,
X_Segment8,
X_Segment9,
X_Segment10,
X_Attribute_Category,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Cost_Ind_Rate_Sch_Id,
X_Rev_Ind_Rate_Sch_Id,
X_Inv_Ind_Rate_Sch_Id,
X_Cost_Ind_Sch_Fixed_Date,
X_Rev_Ind_Sch_Fixed_Date,
X_Inv_Ind_Sch_Fixed_Date,
X_Labor_Sch_Type,
X_Non_Labor_Sch_Type,
X_Template_Flag,
X_Verification_Date,
X_Created_From_Project_Id,
X_Template_Start_Date,
X_Template_End_Date,
X_Project_Currency_Code,
X_Allow_Cross_Charge_Flag,
X_Project_Rate_Date,
X_Project_Rate_Type,
X_Output_Tax_Code,
X_Retention_Tax_Code,
X_CC_Process_Labor_Flag,
X_Labor_Tp_Schedule_Id,
X_Labor_Tp_Fixed_Date,
X_CC_Process_NL_Flag,
X_Nl_Tp_Schedule_Id,
X_Nl_Tp_Fixed_Date,
X_CC_Tax_Task_Id,
x_bill_job_group_id,
x_cost_job_group_id,
x_role_list_id,
x_work_type_id,
x_calendar_id,
x_location_id,
x_probability_member_id,
x_project_value,
x_expected_approval_date,
x_team_template_id,
x_job_bill_rate_schedule_id,
x_emp_bill_rate_schedule_id,
--MCA Sakthi for MultiAgreementCurreny Project
x_competence_match_wt,
x_availability_match_wt,
x_job_level_match_wt,
x_enable_automated_search,
x_search_min_availability,
x_search_org_hier_id,
x_search_starting_org_id,
x_search_country_code,
x_min_cand_score_reqd_for_nom,
x_non_lab_std_bill_rt_sch_id,
x_invproc_currency_type,
x_revproc_currency_code,
x_project_bil_rate_date_code,
x_project_bil_rate_type,
x_project_bil_rate_date,
x_project_bil_exchange_rate,
x_projfunc_currency_code,
x_projfunc_bil_rate_date_code,
x_projfunc_bil_rate_type,
x_projfunc_bil_rate_date,
x_projfunc_bil_exchange_rate,
x_funding_rate_date_code,
x_funding_rate_type,
x_funding_rate_date,
x_funding_exchange_rate,
x_baseline_funding_flag,
x_projfunc_cost_rate_type,
x_projfunc_cost_rate_date,
x_multi_currency_billing_flag,
x_inv_by_bill_trans_curr_flag,
--MCA Sakthi for MultiAgreementCurreny Project
x_assign_precedes_task,
--Structure
x_split_cost_from_wokplan_flag,
x_split_cost_from_bill_flag,
--Structure
--Advertisement
x_adv_action_set_id ,
x_start_adv_action_set_flag,
--Advertisement
--Project Setup
x_priority_code,
--Project Setup
--Retention
x_retn_billing_inv_format_id ,
x_retn_accounting_flag ,
--Retention
-- anlee
-- patchset K changes
x_revaluate_funding_flag,
x_include_gains_losses_flag,
-- msundare
x_security_level ,
x_labor_disc_reason_code ,
x_non_labor_disc_reason_code ,
-- End of changes
x_record_version_number,
x_btc_cost_base_rev_code, /* Bug#2638968 */
x_revtrans_currency_type, /* R12 - Bug 4363092 */
--PA L
x_asset_allocation_method ,
x_capital_event_processing,
x_cint_rate_sch_id ,
x_cint_eligible_flag,
x_cint_stop_date,
--FP_M Changes. Tracking Bug 3279981
x_en_top_task_customer_flag,
x_en_top_task_inv_mth_flag,
x_revenue_accrual_method,
x_invoice_method,
x_projfunc_attr_for_ar_flag,
x_sys_program_flag,
x_allow_multi_program_rollup,
x_proj_req_res_format_id,
x_proj_asgmt_res_format_id,
--sunkalya:federal Bug#5511353
x_date_eff_funds_flag
--sunkalya:federal Bug#5511353
,x_ar_rec_notify_flag -- 7508661 : EnC
,x_auto_release_pwp_inv -- 7508661 : EnC
);
PA_PROJECT_CTX_SEARCH_PVT.INSERT_ROW (
p_project_id => x_project_id
,p_template_flag => x_template_flag
,p_project_name => x_name
,p_project_number => x_segment1
,p_project_long_name => x_long_name
,p_project_description => x_description
,x_return_status => l_return_status );
,p_procedure_name => 'Insert_Row'
,p_error_text => SUBSTRB(SQLERRM,1,240));
END Insert_Row;
SELECT *
FROM pa_projects
WHERE rowid = X_Rowid
FOR UPDATE of Project_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');