[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
, p_auto_select_flag VARCHAR2
, p_contracts_preferred_engineer VARCHAR2
, p_ib_preferred_engineer VARCHAR2
, p_contract_id NUMBER
, p_customer_product_id NUMBER
, p_effort_duration NUMBER
, p_effort_uom VARCHAR2
, p_start_date date
, p_end_date date
, p_territory_flag VARCHAR2
, p_calendar_flag VARCHAR2
, p_web_availability_flag VARCHAR2
, p_category_id NUMBER
, p_inventory_item_id NUMBER
, p_inventory_org_id NUMBER
, p_problem_code VARCHAR2
, p_calling_doc_id NUMBER
, p_calling_doc_type VARCHAR2
, p_column_list VARCHAR2
, p_business_process_id NUMBER
, p_business_process_date date
, p_filter_excluded_resource VARCHAR2
, p32_a0 out nocopy JTF_NUMBER_TABLE
, p32_a1 out nocopy JTF_NUMBER_TABLE
, p32_a2 out nocopy JTF_VARCHAR2_TABLE_100
, p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
, p32_a4 out nocopy JTF_DATE_TABLE
, p32_a5 out nocopy JTF_DATE_TABLE
, p32_a6 out nocopy JTF_NUMBER_TABLE
, p32_a7 out nocopy JTF_NUMBER_TABLE
, p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
, p32_a9 out nocopy JTF_NUMBER_TABLE
, p32_a10 out nocopy JTF_NUMBER_TABLE
, p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
, p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
, p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
, p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
, p32_a15 out nocopy JTF_NUMBER_TABLE
, p32_a16 out nocopy JTF_VARCHAR2_TABLE_100
, p32_a17 out nocopy JTF_NUMBER_TABLE
, p32_a18 out nocopy JTF_VARCHAR2_TABLE_100
, p32_a19 out nocopy JTF_DATE_TABLE
, p32_a20 out nocopy JTF_DATE_TABLE
, p32_a21 out nocopy JTF_NUMBER_TABLE
, p32_a22 out nocopy JTF_VARCHAR2_TABLE_200
, p32_a23 out nocopy JTF_VARCHAR2_TABLE_100
, p32_a24 out nocopy JTF_NUMBER_TABLE
, p32_a25 out nocopy JTF_VARCHAR2_TABLE_100
, p32_a26 out nocopy JTF_VARCHAR2_TABLE_100
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p26_a0 NUMBER := 0-1962.0724
, p26_a1 NUMBER := 0-1962.0724
, p26_a2 VARCHAR2 := fnd_api.g_miss_char
, p26_a3 NUMBER := 0-1962.0724
, p26_a4 VARCHAR2 := fnd_api.g_miss_char
, p26_a5 VARCHAR2 := fnd_api.g_miss_char
, p26_a6 VARCHAR2 := fnd_api.g_miss_char
, p26_a7 VARCHAR2 := fnd_api.g_miss_char
, p26_a8 VARCHAR2 := fnd_api.g_miss_char
, p26_a9 VARCHAR2 := fnd_api.g_miss_char
, p26_a10 VARCHAR2 := fnd_api.g_miss_char
, p26_a11 NUMBER := 0-1962.0724
, p26_a12 NUMBER := 0-1962.0724
, p26_a13 NUMBER := 0-1962.0724
, p26_a14 NUMBER := 0-1962.0724
, p26_a15 VARCHAR2 := fnd_api.g_miss_char
, p26_a16 NUMBER := 0-1962.0724
, p26_a17 NUMBER := 0-1962.0724
, p26_a18 NUMBER := 0-1962.0724
, p26_a19 NUMBER := 0-1962.0724
, p26_a20 VARCHAR2 := fnd_api.g_miss_char
, p26_a21 NUMBER := 0-1962.0724
, p26_a22 VARCHAR2 := fnd_api.g_miss_char
, p26_a23 VARCHAR2 := fnd_api.g_miss_char
, p26_a24 VARCHAR2 := fnd_api.g_miss_char
, p26_a25 VARCHAR2 := fnd_api.g_miss_char
, p26_a26 VARCHAR2 := fnd_api.g_miss_char
, p26_a27 VARCHAR2 := fnd_api.g_miss_char
, p26_a28 VARCHAR2 := fnd_api.g_miss_char
, p26_a29 VARCHAR2 := fnd_api.g_miss_char
, p26_a30 VARCHAR2 := fnd_api.g_miss_char
, p26_a31 VARCHAR2 := fnd_api.g_miss_char
, p26_a32 VARCHAR2 := fnd_api.g_miss_char
, p26_a33 VARCHAR2 := fnd_api.g_miss_char
, p26_a34 VARCHAR2 := fnd_api.g_miss_char
, p26_a35 VARCHAR2 := fnd_api.g_miss_char
, p26_a36 VARCHAR2 := fnd_api.g_miss_char
, p26_a37 NUMBER := 0-1962.0724
, p26_a38 NUMBER := 0-1962.0724
, p26_a39 NUMBER := 0-1962.0724
, p26_a40 NUMBER := 0-1962.0724
, p26_a41 NUMBER := 0-1962.0724
, p26_a42 NUMBER := 0-1962.0724
, p26_a43 NUMBER := 0-1962.0724
, p26_a44 NUMBER := 0-1962.0724
, p26_a45 NUMBER := 0-1962.0724
, p26_a46 NUMBER := 0-1962.0724
, p26_a47 VARCHAR2 := fnd_api.g_miss_char
, p26_a48 VARCHAR2 := fnd_api.g_miss_char
, p26_a49 VARCHAR2 := fnd_api.g_miss_char
, p26_a50 VARCHAR2 := fnd_api.g_miss_char
, p26_a51 VARCHAR2 := fnd_api.g_miss_char
, p26_a52 NUMBER := 0-1962.0724
, p26_a53 NUMBER := 0-1962.0724
, p27_a0 NUMBER := 0-1962.0724
, p27_a1 NUMBER := 0-1962.0724
, p27_a2 NUMBER := 0-1962.0724
, p27_a3 VARCHAR2 := fnd_api.g_miss_char
, p27_a4 NUMBER := 0-1962.0724
, p27_a5 VARCHAR2 := fnd_api.g_miss_char
, p27_a6 VARCHAR2 := fnd_api.g_miss_char
, p27_a7 VARCHAR2 := fnd_api.g_miss_char
, p27_a8 VARCHAR2 := fnd_api.g_miss_char
, p27_a9 VARCHAR2 := fnd_api.g_miss_char
, p27_a10 VARCHAR2 := fnd_api.g_miss_char
, p27_a11 VARCHAR2 := fnd_api.g_miss_char
, p27_a12 NUMBER := 0-1962.0724
, p27_a13 NUMBER := 0-1962.0724
, p27_a14 NUMBER := 0-1962.0724
, p27_a15 NUMBER := 0-1962.0724
, p27_a16 NUMBER := 0-1962.0724
, p27_a17 NUMBER := 0-1962.0724
, p27_a18 NUMBER := 0-1962.0724
, p27_a19 VARCHAR2 := fnd_api.g_miss_char
, p27_a20 NUMBER := 0-1962.0724
, p27_a21 NUMBER := 0-1962.0724
, p27_a22 NUMBER := 0-1962.0724
, p27_a23 NUMBER := 0-1962.0724
, p27_a24 VARCHAR2 := fnd_api.g_miss_char
, p27_a25 NUMBER := 0-1962.0724
, p27_a26 VARCHAR2 := fnd_api.g_miss_char
, p27_a27 VARCHAR2 := fnd_api.g_miss_char
, p27_a28 VARCHAR2 := fnd_api.g_miss_char
, p27_a29 VARCHAR2 := fnd_api.g_miss_char
, p27_a30 VARCHAR2 := fnd_api.g_miss_char
, p27_a31 VARCHAR2 := fnd_api.g_miss_char
, p27_a32 VARCHAR2 := fnd_api.g_miss_char
, p27_a33 VARCHAR2 := fnd_api.g_miss_char
, p27_a34 VARCHAR2 := fnd_api.g_miss_char
, p27_a35 VARCHAR2 := fnd_api.g_miss_char
, p27_a36 VARCHAR2 := fnd_api.g_miss_char
, p27_a37 VARCHAR2 := fnd_api.g_miss_char
, p27_a38 VARCHAR2 := fnd_api.g_miss_char
, p27_a39 VARCHAR2 := fnd_api.g_miss_char
, p27_a40 VARCHAR2 := fnd_api.g_miss_char
, p27_a41 NUMBER := 0-1962.0724
, p27_a42 NUMBER := 0-1962.0724
, p27_a43 NUMBER := 0-1962.0724
, p27_a44 NUMBER := 0-1962.0724
, p27_a45 NUMBER := 0-1962.0724
, p27_a46 NUMBER := 0-1962.0724
, p27_a47 NUMBER := 0-1962.0724
, p27_a48 NUMBER := 0-1962.0724
, p27_a49 NUMBER := 0-1962.0724
, p27_a50 NUMBER := 0-1962.0724
, p27_a51 VARCHAR2 := fnd_api.g_miss_char
, p27_a52 VARCHAR2 := fnd_api.g_miss_char
, p27_a53 VARCHAR2 := fnd_api.g_miss_char
, p27_a54 VARCHAR2 := fnd_api.g_miss_char
, p27_a55 VARCHAR2 := fnd_api.g_miss_char
, p27_a56 NUMBER := 0-1962.0724
, p27_a57 NUMBER := 0-1962.0724
, p28_a0 VARCHAR2 := fnd_api.g_miss_char
, p28_a1 VARCHAR2 := fnd_api.g_miss_char
, p28_a2 VARCHAR2 := fnd_api.g_miss_char
, p28_a3 VARCHAR2 := fnd_api.g_miss_char
, p28_a4 VARCHAR2 := fnd_api.g_miss_char
, p28_a5 VARCHAR2 := fnd_api.g_miss_char
, p28_a6 VARCHAR2 := fnd_api.g_miss_char
, p28_a7 VARCHAR2 := fnd_api.g_miss_char
, p28_a8 VARCHAR2 := fnd_api.g_miss_char
, p28_a9 VARCHAR2 := fnd_api.g_miss_char
, p28_a10 VARCHAR2 := fnd_api.g_miss_char
, p28_a11 VARCHAR2 := fnd_api.g_miss_char
, p28_a12 VARCHAR2 := fnd_api.g_miss_char
, p28_a13 VARCHAR2 := fnd_api.g_miss_char
, p28_a14 VARCHAR2 := fnd_api.g_miss_char
, p28_a15 VARCHAR2 := fnd_api.g_miss_char
, p28_a16 VARCHAR2 := fnd_api.g_miss_char
, p28_a17 VARCHAR2 := fnd_api.g_miss_char
, p28_a18 VARCHAR2 := fnd_api.g_miss_char
, p28_a19 VARCHAR2 := fnd_api.g_miss_char
, p28_a20 VARCHAR2 := fnd_api.g_miss_char
, p28_a21 VARCHAR2 := fnd_api.g_miss_char
, p28_a22 VARCHAR2 := fnd_api.g_miss_char
, p28_a23 VARCHAR2 := fnd_api.g_miss_char
, p28_a24 VARCHAR2 := fnd_api.g_miss_char
, p28_a25 NUMBER := 0-1962.0724
, p28_a26 NUMBER := 0-1962.0724
, p28_a27 NUMBER := 0-1962.0724
, p28_a28 NUMBER := 0-1962.0724
, p28_a29 NUMBER := 0-1962.0724
, p28_a30 NUMBER := 0-1962.0724
, p28_a31 NUMBER := 0-1962.0724
, p28_a32 NUMBER := 0-1962.0724
, p28_a33 NUMBER := 0-1962.0724
, p28_a34 NUMBER := 0-1962.0724
, p28_a35 NUMBER := 0-1962.0724
, p28_a36 NUMBER := 0-1962.0724
, p28_a37 NUMBER := 0-1962.0724
, p28_a38 NUMBER := 0-1962.0724
, p28_a39 NUMBER := 0-1962.0724
, p28_a40 NUMBER := 0-1962.0724
, p28_a41 NUMBER := 0-1962.0724
, p28_a42 NUMBER := 0-1962.0724
, p28_a43 NUMBER := 0-1962.0724
, p28_a44 NUMBER := 0-1962.0724
, p28_a45 NUMBER := 0-1962.0724
, p28_a46 NUMBER := 0-1962.0724
, p28_a47 NUMBER := 0-1962.0724
, p28_a48 NUMBER := 0-1962.0724
, p28_a49 NUMBER := 0-1962.0724
, p28_a50 VARCHAR2 := fnd_api.g_miss_char
, p28_a51 VARCHAR2 := fnd_api.g_miss_char
, p28_a52 VARCHAR2 := fnd_api.g_miss_char
, p28_a53 VARCHAR2 := fnd_api.g_miss_char
, p28_a54 VARCHAR2 := fnd_api.g_miss_char
, p28_a55 VARCHAR2 := fnd_api.g_miss_char
, p28_a56 VARCHAR2 := fnd_api.g_miss_char
, p28_a57 VARCHAR2 := fnd_api.g_miss_char
, p28_a58 VARCHAR2 := fnd_api.g_miss_char
, p28_a59 VARCHAR2 := fnd_api.g_miss_char
, p28_a60 VARCHAR2 := fnd_api.g_miss_char
, p28_a61 VARCHAR2 := fnd_api.g_miss_char
, p28_a62 VARCHAR2 := fnd_api.g_miss_char
, p28_a63 VARCHAR2 := fnd_api.g_miss_char
, p28_a64 VARCHAR2 := fnd_api.g_miss_char
)
as
ddp_start_date date;
p_auto_select_flag,
p_contracts_preferred_engineer,
p_ib_preferred_engineer,
p_contract_id,
p_customer_product_id,
p_effort_duration,
p_effort_uom,
ddp_start_date,
ddp_end_date,
p_territory_flag,
p_calendar_flag,
p_web_availability_flag,
p_category_id,
p_inventory_item_id,
p_inventory_org_id,
p_problem_code,
p_calling_doc_id,
p_calling_doc_type,
p_column_list,
ddp_sr_rec,
ddp_sr_task_rec,
ddp_defect_rec,
p_business_process_id,
ddp_business_process_date,
p_filter_excluded_resource,
ddx_assign_resources_tbl,
x_return_status,
x_msg_count,
x_msg_data);
, p_auto_select_flag VARCHAR2
, p_contracts_preferred_engineer VARCHAR2
, p_ib_preferred_engineer VARCHAR2
, p_effort_duration NUMBER
, p_effort_uom VARCHAR2
, p_start_date date
, p_end_date date
, p_territory_flag VARCHAR2
, p_calendar_flag VARCHAR2
, p_web_availability_flag VARCHAR2
, p_task_id NUMBER
, p_column_list VARCHAR2
, p_business_process_id NUMBER
, p_business_process_date date
, p_filter_excluded_resource VARCHAR2
, p20_a0 out nocopy JTF_NUMBER_TABLE
, p20_a1 out nocopy JTF_NUMBER_TABLE
, p20_a2 out nocopy JTF_VARCHAR2_TABLE_100
, p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
, p20_a4 out nocopy JTF_DATE_TABLE
, p20_a5 out nocopy JTF_DATE_TABLE
, p20_a6 out nocopy JTF_NUMBER_TABLE
, p20_a7 out nocopy JTF_NUMBER_TABLE
, p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
, p20_a9 out nocopy JTF_NUMBER_TABLE
, p20_a10 out nocopy JTF_NUMBER_TABLE
, p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
, p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
, p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
, p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
, p20_a15 out nocopy JTF_NUMBER_TABLE
, p20_a16 out nocopy JTF_VARCHAR2_TABLE_100
, p20_a17 out nocopy JTF_NUMBER_TABLE
, p20_a18 out nocopy JTF_VARCHAR2_TABLE_100
, p20_a19 out nocopy JTF_DATE_TABLE
, p20_a20 out nocopy JTF_DATE_TABLE
, p20_a21 out nocopy JTF_NUMBER_TABLE
, p20_a22 out nocopy JTF_VARCHAR2_TABLE_200
, p20_a23 out nocopy JTF_VARCHAR2_TABLE_100
, p20_a24 out nocopy JTF_NUMBER_TABLE
, p20_a25 out nocopy JTF_VARCHAR2_TABLE_100
, p20_a26 out nocopy JTF_VARCHAR2_TABLE_100
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
)
as
ddp_start_date date;
p_auto_select_flag,
p_contracts_preferred_engineer,
p_ib_preferred_engineer,
p_effort_duration,
p_effort_uom,
ddp_start_date,
ddp_end_date,
p_territory_flag,
p_calendar_flag,
p_web_availability_flag,
p_task_id,
p_column_list,
p_business_process_id,
ddp_business_process_date,
p_filter_excluded_resource,
ddx_assign_resources_tbl,
x_return_status,
x_msg_count,
x_msg_data);
, p_auto_select_flag VARCHAR2
, p_contracts_preferred_engineer VARCHAR2
, p_ib_preferred_engineer VARCHAR2
, p_contract_id NUMBER
, p_customer_product_id NUMBER
, p_effort_duration NUMBER
, p_effort_uom VARCHAR2
, p_start_date date
, p_end_date date
, p_territory_flag VARCHAR2
, p_calendar_flag VARCHAR2
, p_web_availability_flag VARCHAR2
, p_category_id NUMBER
, p_inventory_item_id NUMBER
, p_inventory_org_id NUMBER
, p_problem_code VARCHAR2
, p_dr_id NUMBER
, p_column_list VARCHAR2
, p_business_process_id NUMBER
, p_business_process_date date
, p_filter_excluded_resource VARCHAR2
, p27_a0 out nocopy JTF_NUMBER_TABLE
, p27_a1 out nocopy JTF_NUMBER_TABLE
, p27_a2 out nocopy JTF_VARCHAR2_TABLE_100
, p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
, p27_a4 out nocopy JTF_DATE_TABLE
, p27_a5 out nocopy JTF_DATE_TABLE
, p27_a6 out nocopy JTF_NUMBER_TABLE
, p27_a7 out nocopy JTF_NUMBER_TABLE
, p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
, p27_a9 out nocopy JTF_NUMBER_TABLE
, p27_a10 out nocopy JTF_NUMBER_TABLE
, p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
, p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
, p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
, p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
, p27_a15 out nocopy JTF_NUMBER_TABLE
, p27_a16 out nocopy JTF_VARCHAR2_TABLE_100
, p27_a17 out nocopy JTF_NUMBER_TABLE
, p27_a18 out nocopy JTF_VARCHAR2_TABLE_100
, p27_a19 out nocopy JTF_DATE_TABLE
, p27_a20 out nocopy JTF_DATE_TABLE
, p27_a21 out nocopy JTF_NUMBER_TABLE
, p27_a22 out nocopy JTF_VARCHAR2_TABLE_200
, p27_a23 out nocopy JTF_VARCHAR2_TABLE_100
, p27_a24 out nocopy JTF_NUMBER_TABLE
, p27_a25 out nocopy JTF_VARCHAR2_TABLE_100
, p27_a26 out nocopy JTF_VARCHAR2_TABLE_100
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p23_a0 NUMBER := 0-1962.0724
, p23_a1 NUMBER := 0-1962.0724
, p23_a2 NUMBER := 0-1962.0724
, p23_a3 VARCHAR2 := fnd_api.g_miss_char
, p23_a4 NUMBER := 0-1962.0724
, p23_a5 VARCHAR2 := fnd_api.g_miss_char
, p23_a6 VARCHAR2 := fnd_api.g_miss_char
, p23_a7 VARCHAR2 := fnd_api.g_miss_char
, p23_a8 VARCHAR2 := fnd_api.g_miss_char
, p23_a9 VARCHAR2 := fnd_api.g_miss_char
, p23_a10 VARCHAR2 := fnd_api.g_miss_char
, p23_a11 VARCHAR2 := fnd_api.g_miss_char
, p23_a12 NUMBER := 0-1962.0724
, p23_a13 NUMBER := 0-1962.0724
, p23_a14 NUMBER := 0-1962.0724
, p23_a15 NUMBER := 0-1962.0724
, p23_a16 NUMBER := 0-1962.0724
, p23_a17 NUMBER := 0-1962.0724
, p23_a18 NUMBER := 0-1962.0724
, p23_a19 VARCHAR2 := fnd_api.g_miss_char
, p23_a20 NUMBER := 0-1962.0724
, p23_a21 NUMBER := 0-1962.0724
, p23_a22 NUMBER := 0-1962.0724
, p23_a23 NUMBER := 0-1962.0724
, p23_a24 VARCHAR2 := fnd_api.g_miss_char
, p23_a25 NUMBER := 0-1962.0724
, p23_a26 VARCHAR2 := fnd_api.g_miss_char
, p23_a27 VARCHAR2 := fnd_api.g_miss_char
, p23_a28 VARCHAR2 := fnd_api.g_miss_char
, p23_a29 VARCHAR2 := fnd_api.g_miss_char
, p23_a30 VARCHAR2 := fnd_api.g_miss_char
, p23_a31 VARCHAR2 := fnd_api.g_miss_char
, p23_a32 VARCHAR2 := fnd_api.g_miss_char
, p23_a33 VARCHAR2 := fnd_api.g_miss_char
, p23_a34 VARCHAR2 := fnd_api.g_miss_char
, p23_a35 VARCHAR2 := fnd_api.g_miss_char
, p23_a36 VARCHAR2 := fnd_api.g_miss_char
, p23_a37 VARCHAR2 := fnd_api.g_miss_char
, p23_a38 VARCHAR2 := fnd_api.g_miss_char
, p23_a39 VARCHAR2 := fnd_api.g_miss_char
, p23_a40 VARCHAR2 := fnd_api.g_miss_char
, p23_a41 NUMBER := 0-1962.0724
, p23_a42 NUMBER := 0-1962.0724
, p23_a43 NUMBER := 0-1962.0724
, p23_a44 NUMBER := 0-1962.0724
, p23_a45 NUMBER := 0-1962.0724
, p23_a46 NUMBER := 0-1962.0724
, p23_a47 NUMBER := 0-1962.0724
, p23_a48 NUMBER := 0-1962.0724
, p23_a49 NUMBER := 0-1962.0724
, p23_a50 NUMBER := 0-1962.0724
, p23_a51 VARCHAR2 := fnd_api.g_miss_char
, p23_a52 VARCHAR2 := fnd_api.g_miss_char
, p23_a53 VARCHAR2 := fnd_api.g_miss_char
, p23_a54 VARCHAR2 := fnd_api.g_miss_char
, p23_a55 VARCHAR2 := fnd_api.g_miss_char
)
as
ddp_start_date date;
p_auto_select_flag,
p_contracts_preferred_engineer,
p_ib_preferred_engineer,
p_contract_id,
p_customer_product_id,
p_effort_duration,
p_effort_uom,
ddp_start_date,
ddp_end_date,
p_territory_flag,
p_calendar_flag,
p_web_availability_flag,
p_category_id,
p_inventory_item_id,
p_inventory_org_id,
p_problem_code,
p_dr_id,
p_column_list,
ddp_dr_rec,
p_business_process_id,
ddp_business_process_date,
p_filter_excluded_resource,
ddx_assign_resources_tbl,
x_return_status,
x_msg_count,
x_msg_data);
, p_auto_select_flag VARCHAR2
, p_effort_duration NUMBER
, p_effort_uom VARCHAR2
, p_start_date date
, p_end_date date
, p_territory_flag VARCHAR2
, p_calendar_flag VARCHAR2
, p_business_process_id NUMBER
, p_business_process_date date
, p15_a0 out nocopy JTF_NUMBER_TABLE
, p15_a1 out nocopy JTF_NUMBER_TABLE
, p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a4 out nocopy JTF_DATE_TABLE
, p15_a5 out nocopy JTF_DATE_TABLE
, p15_a6 out nocopy JTF_NUMBER_TABLE
, p15_a7 out nocopy JTF_NUMBER_TABLE
, p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
, p15_a9 out nocopy JTF_NUMBER_TABLE
, p15_a10 out nocopy JTF_NUMBER_TABLE
, p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a15 out nocopy JTF_NUMBER_TABLE
, p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a17 out nocopy JTF_NUMBER_TABLE
, p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a19 out nocopy JTF_DATE_TABLE
, p15_a20 out nocopy JTF_DATE_TABLE
, p15_a21 out nocopy JTF_NUMBER_TABLE
, p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
, p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a24 out nocopy JTF_NUMBER_TABLE
, p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p12_a0 NUMBER := 0-1962.0724
, p12_a1 NUMBER := 0-1962.0724
, p12_a2 VARCHAR2 := fnd_api.g_miss_char
, p12_a3 VARCHAR2 := fnd_api.g_miss_char
, p12_a4 VARCHAR2 := fnd_api.g_miss_char
, p12_a5 VARCHAR2 := fnd_api.g_miss_char
, p12_a6 VARCHAR2 := fnd_api.g_miss_char
, p12_a7 VARCHAR2 := fnd_api.g_miss_char
, p12_a8 NUMBER := 0-1962.0724
, p12_a9 NUMBER := 0-1962.0724
, p12_a10 NUMBER := 0-1962.0724
, p12_a11 NUMBER := 0-1962.0724
, p12_a12 NUMBER := 0-1962.0724
, p12_a13 NUMBER := 0-1962.0724
, p12_a14 NUMBER := 0-1962.0724
, p12_a15 VARCHAR2 := fnd_api.g_miss_char
, p12_a16 NUMBER := 0-1962.0724
, p12_a17 VARCHAR2 := fnd_api.g_miss_char
, p12_a18 NUMBER := 0-1962.0724
, p12_a19 NUMBER := 0-1962.0724
, p12_a20 VARCHAR2 := fnd_api.g_miss_char
, p12_a21 NUMBER := 0-1962.0724
, p12_a22 VARCHAR2 := fnd_api.g_miss_char
, p12_a23 VARCHAR2 := fnd_api.g_miss_char
, p12_a24 NUMBER := 0-1962.0724
, p12_a25 VARCHAR2 := fnd_api.g_miss_char
, p12_a26 DATE := fnd_api.g_miss_date
, p12_a27 VARCHAR2 := fnd_api.g_miss_char
, p12_a28 NUMBER := 0-1962.0724
, p12_a29 NUMBER := 0-1962.0724
, p12_a30 NUMBER := 0-1962.0724
, p12_a31 NUMBER := 0-1962.0724
, p12_a32 NUMBER := 0-1962.0724
, p12_a33 NUMBER := 0-1962.0724
, p12_a34 NUMBER := 0-1962.0724
, p12_a35 VARCHAR2 := fnd_api.g_miss_char
, p12_a36 VARCHAR2 := fnd_api.g_miss_char
, p12_a37 VARCHAR2 := fnd_api.g_miss_char
, p12_a38 VARCHAR2 := fnd_api.g_miss_char
, p12_a39 VARCHAR2 := fnd_api.g_miss_char
, p12_a40 VARCHAR2 := fnd_api.g_miss_char
, p12_a41 VARCHAR2 := fnd_api.g_miss_char
, p12_a42 VARCHAR2 := fnd_api.g_miss_char
, p12_a43 VARCHAR2 := fnd_api.g_miss_char
, p12_a44 VARCHAR2 := fnd_api.g_miss_char
, p12_a45 VARCHAR2 := fnd_api.g_miss_char
, p12_a46 VARCHAR2 := fnd_api.g_miss_char
, p12_a47 VARCHAR2 := fnd_api.g_miss_char
, p12_a48 VARCHAR2 := fnd_api.g_miss_char
, p12_a49 VARCHAR2 := fnd_api.g_miss_char
, p12_a50 NUMBER := 0-1962.0724
)
as
ddp_start_date date;
p_auto_select_flag,
p_effort_duration,
p_effort_uom,
ddp_start_date,
ddp_end_date,
p_territory_flag,
p_calendar_flag,
ddp_opportunity_rec,
p_business_process_id,
ddp_business_process_date,
ddx_assign_resources_tbl,
x_return_status,
x_msg_count,
x_msg_data);
, p_auto_select_flag VARCHAR2
, p_effort_duration NUMBER
, p_effort_uom VARCHAR2
, p_start_date date
, p_end_date date
, p_territory_flag VARCHAR2
, p_calendar_flag VARCHAR2
, p_business_process_id NUMBER
, p_business_process_date date
, p15_a0 out nocopy JTF_NUMBER_TABLE
, p15_a1 out nocopy JTF_NUMBER_TABLE
, p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a4 out nocopy JTF_DATE_TABLE
, p15_a5 out nocopy JTF_DATE_TABLE
, p15_a6 out nocopy JTF_NUMBER_TABLE
, p15_a7 out nocopy JTF_NUMBER_TABLE
, p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
, p15_a9 out nocopy JTF_NUMBER_TABLE
, p15_a10 out nocopy JTF_NUMBER_TABLE
, p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a15 out nocopy JTF_NUMBER_TABLE
, p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a17 out nocopy JTF_NUMBER_TABLE
, p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a19 out nocopy JTF_DATE_TABLE
, p15_a20 out nocopy JTF_DATE_TABLE
, p15_a21 out nocopy JTF_NUMBER_TABLE
, p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
, p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a24 out nocopy JTF_NUMBER_TABLE
, p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p12_a0 NUMBER := 0-1962.0724
, p12_a1 NUMBER := 0-1962.0724
, p12_a2 VARCHAR2 := fnd_api.g_miss_char
, p12_a3 VARCHAR2 := fnd_api.g_miss_char
, p12_a4 VARCHAR2 := fnd_api.g_miss_char
, p12_a5 VARCHAR2 := fnd_api.g_miss_char
, p12_a6 VARCHAR2 := fnd_api.g_miss_char
, p12_a7 VARCHAR2 := fnd_api.g_miss_char
, p12_a8 NUMBER := 0-1962.0724
, p12_a9 NUMBER := 0-1962.0724
, p12_a10 NUMBER := 0-1962.0724
, p12_a11 NUMBER := 0-1962.0724
, p12_a12 NUMBER := 0-1962.0724
, p12_a13 NUMBER := 0-1962.0724
, p12_a14 NUMBER := 0-1962.0724
, p12_a15 VARCHAR2 := fnd_api.g_miss_char
, p12_a16 NUMBER := 0-1962.0724
, p12_a17 VARCHAR2 := fnd_api.g_miss_char
, p12_a18 NUMBER := 0-1962.0724
, p12_a19 NUMBER := 0-1962.0724
, p12_a20 VARCHAR2 := fnd_api.g_miss_char
, p12_a21 NUMBER := 0-1962.0724
, p12_a22 VARCHAR2 := fnd_api.g_miss_char
, p12_a23 NUMBER := 0-1962.0724
, p12_a24 VARCHAR2 := fnd_api.g_miss_char
, p12_a25 DATE := fnd_api.g_miss_date
, p12_a26 NUMBER := 0-1962.0724
, p12_a27 NUMBER := 0-1962.0724
, p12_a28 NUMBER := 0-1962.0724
, p12_a29 NUMBER := 0-1962.0724
, p12_a30 NUMBER := 0-1962.0724
, p12_a31 NUMBER := 0-1962.0724
, p12_a32 VARCHAR2 := fnd_api.g_miss_char
, p12_a33 VARCHAR2 := fnd_api.g_miss_char
, p12_a34 VARCHAR2 := fnd_api.g_miss_char
, p12_a35 VARCHAR2 := fnd_api.g_miss_char
, p12_a36 VARCHAR2 := fnd_api.g_miss_char
, p12_a37 VARCHAR2 := fnd_api.g_miss_char
, p12_a38 VARCHAR2 := fnd_api.g_miss_char
, p12_a39 VARCHAR2 := fnd_api.g_miss_char
, p12_a40 VARCHAR2 := fnd_api.g_miss_char
, p12_a41 VARCHAR2 := fnd_api.g_miss_char
, p12_a42 VARCHAR2 := fnd_api.g_miss_char
, p12_a43 VARCHAR2 := fnd_api.g_miss_char
, p12_a44 VARCHAR2 := fnd_api.g_miss_char
, p12_a45 VARCHAR2 := fnd_api.g_miss_char
, p12_a46 VARCHAR2 := fnd_api.g_miss_char
, p12_a47 NUMBER := 0-1962.0724
)
as
ddp_start_date date;
p_auto_select_flag,
p_effort_duration,
p_effort_uom,
ddp_start_date,
ddp_end_date,
p_territory_flag,
p_calendar_flag,
ddp_lead_rec,
p_business_process_id,
ddp_business_process_date,
ddx_assign_resources_tbl,
x_return_status,
x_msg_count,
x_msg_data);
, p_auto_select_flag VARCHAR2
, p_effort_duration NUMBER
, p_effort_uom VARCHAR2
, p_start_date date
, p_end_date date
, p_territory_flag VARCHAR2
, p_calendar_flag VARCHAR2
, p_business_process_id NUMBER
, p_business_process_date date
, p15_a0 out nocopy JTF_NUMBER_TABLE
, p15_a1 out nocopy JTF_NUMBER_TABLE
, p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a4 out nocopy JTF_DATE_TABLE
, p15_a5 out nocopy JTF_DATE_TABLE
, p15_a6 out nocopy JTF_NUMBER_TABLE
, p15_a7 out nocopy JTF_NUMBER_TABLE
, p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
, p15_a9 out nocopy JTF_NUMBER_TABLE
, p15_a10 out nocopy JTF_NUMBER_TABLE
, p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a15 out nocopy JTF_NUMBER_TABLE
, p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a17 out nocopy JTF_NUMBER_TABLE
, p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a19 out nocopy JTF_DATE_TABLE
, p15_a20 out nocopy JTF_DATE_TABLE
, p15_a21 out nocopy JTF_NUMBER_TABLE
, p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
, p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a24 out nocopy JTF_NUMBER_TABLE
, p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
, p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p12_a0 VARCHAR2 := fnd_api.g_miss_char
, p12_a1 VARCHAR2 := fnd_api.g_miss_char
, p12_a2 VARCHAR2 := fnd_api.g_miss_char
, p12_a3 VARCHAR2 := fnd_api.g_miss_char
, p12_a4 VARCHAR2 := fnd_api.g_miss_char
, p12_a5 VARCHAR2 := fnd_api.g_miss_char
, p12_a6 NUMBER := 0-1962.0724
, p12_a7 NUMBER := 0-1962.0724
, p12_a8 NUMBER := 0-1962.0724
, p12_a9 NUMBER := 0-1962.0724
, p12_a10 NUMBER := 0-1962.0724
, p12_a11 NUMBER := 0-1962.0724
, p12_a12 NUMBER := 0-1962.0724
, p12_a13 VARCHAR2 := fnd_api.g_miss_char
, p12_a14 NUMBER := 0-1962.0724
, p12_a15 VARCHAR2 := fnd_api.g_miss_char
, p12_a16 NUMBER := 0-1962.0724
, p12_a17 NUMBER := 0-1962.0724
, p12_a18 VARCHAR2 := fnd_api.g_miss_char
, p12_a19 NUMBER := 0-1962.0724
, p12_a20 VARCHAR2 := fnd_api.g_miss_char
, p12_a21 VARCHAR2 := fnd_api.g_miss_char
, p12_a22 VARCHAR2 := fnd_api.g_miss_char
, p12_a23 VARCHAR2 := fnd_api.g_miss_char
, p12_a24 VARCHAR2 := fnd_api.g_miss_char
, p12_a25 VARCHAR2 := fnd_api.g_miss_char
, p12_a26 VARCHAR2 := fnd_api.g_miss_char
, p12_a27 VARCHAR2 := fnd_api.g_miss_char
, p12_a28 VARCHAR2 := fnd_api.g_miss_char
, p12_a29 VARCHAR2 := fnd_api.g_miss_char
, p12_a30 VARCHAR2 := fnd_api.g_miss_char
, p12_a31 VARCHAR2 := fnd_api.g_miss_char
, p12_a32 VARCHAR2 := fnd_api.g_miss_char
, p12_a33 VARCHAR2 := fnd_api.g_miss_char
, p12_a34 VARCHAR2 := fnd_api.g_miss_char
, p12_a35 VARCHAR2 := fnd_api.g_miss_char
, p12_a36 NUMBER := 0-1962.0724
)
as
ddp_start_date date;
p_auto_select_flag,
p_effort_duration,
p_effort_uom,
ddp_start_date,
ddp_end_date,
p_territory_flag,
p_calendar_flag,
ddp_account_rec,
p_business_process_id,
ddp_business_process_date,
ddx_assign_resources_tbl,
x_return_status,
x_msg_count,
x_msg_data);
, p_auto_select_flag VARCHAR2
, p_effort_duration NUMBER
, p_effort_uom VARCHAR2
, p_start_date date
, p_end_date date
, p_territory_flag VARCHAR2
, p_calendar_flag VARCHAR2
, p_web_availability_flag VARCHAR2
, p13_a0 JTF_NUMBER_TABLE
, p13_a1 JTF_VARCHAR2_TABLE_100
, p_business_process_id NUMBER
, p_business_process_date date
, p16_a0 out nocopy JTF_NUMBER_TABLE
, p16_a1 out nocopy JTF_NUMBER_TABLE
, p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
, p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
, p16_a4 out nocopy JTF_DATE_TABLE
, p16_a5 out nocopy JTF_DATE_TABLE
, p16_a6 out nocopy JTF_NUMBER_TABLE
, p16_a7 out nocopy JTF_NUMBER_TABLE
, p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
, p16_a9 out nocopy JTF_NUMBER_TABLE
, p16_a10 out nocopy JTF_NUMBER_TABLE
, p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
, p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
, p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
, p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
, p16_a15 out nocopy JTF_NUMBER_TABLE
, p16_a16 out nocopy JTF_VARCHAR2_TABLE_100
, p16_a17 out nocopy JTF_NUMBER_TABLE
, p16_a18 out nocopy JTF_VARCHAR2_TABLE_100
, p16_a19 out nocopy JTF_DATE_TABLE
, p16_a20 out nocopy JTF_DATE_TABLE
, p16_a21 out nocopy JTF_NUMBER_TABLE
, p16_a22 out nocopy JTF_VARCHAR2_TABLE_200
, p16_a23 out nocopy JTF_VARCHAR2_TABLE_100
, p16_a24 out nocopy JTF_NUMBER_TABLE
, p16_a25 out nocopy JTF_VARCHAR2_TABLE_100
, p16_a26 out nocopy JTF_VARCHAR2_TABLE_100
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
)
as
ddp_start_date date;
p_auto_select_flag,
p_effort_duration,
p_effort_uom,
ddp_start_date,
ddp_end_date,
p_territory_flag,
p_calendar_flag,
p_web_availability_flag,
ddp_esc_tbl,
p_business_process_id,
ddp_business_process_date,
ddx_assign_resources_tbl,
x_return_status,
x_msg_count,
x_msg_data);