DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on CSF_TASKS_PUB

Line 1: PACKAGE BODY CSF_TASKS_PUB AS

1: PACKAGE BODY CSF_TASKS_PUB AS
2: /* $Header: CSFPTSKB.pls 120.99.12020000.8 2013/04/09 09:52:00 hemasha ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_TASKS_PUB';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_TASKS_PUB';

1: PACKAGE BODY CSF_TASKS_PUB AS
2: /* $Header: CSFPTSKB.pls 120.99.12020000.8 2013/04/09 09:52:00 hemasha ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_TASKS_PUB';
5:
6: -- Task Types
7: g_dep_task_type_id CONSTANT NUMBER := 20;
8: g_arr_task_type_id CONSTANT NUMBER := 21;

Line 1201: CSF_TASKS_PUB.CREATE_ACC_HRS(

1197: RAISE fnd_api.g_exc_unexpected_error;
1198: END IF;
1199:
1200:
1201: CSF_TASKS_PUB.CREATE_ACC_HRS(
1202: p_task_id => x_task_id
1203: , x_return_status => x_return_status
1204: , x_msg_count => x_msg_count
1205: , x_msg_data => x_msg_data

Line 1558: csf_tasks_pub.update_task_status(

1554: l_api_name CONSTANT VARCHAR2 (30) := 'AUTOREJECT_TASK';
1555: l_api_version CONSTANT NUMBER := 1.0;
1556: BEGIN
1557: savepoint autoreject_task;
1558: csf_tasks_pub.update_task_status(
1559: p_api_version => 1
1560: , p_init_msg_list => fnd_api.g_true
1561: , p_commit => fnd_api.g_false
1562: , x_return_status => x_return_status

Line 3836: csf_tasks_pub.delete_task (

3832: FETCH c_task_status_info INTO l_task_status_info;
3833: CLOSE c_task_status_info;
3834:
3835: IF l_task_status_info.cancelled_flag = 'Y' THEN
3836: csf_tasks_pub.delete_task (
3837: p_api_version => 1.0
3838: , x_return_status => x_return_status
3839: , x_msg_count => x_msg_count
3840: , x_msg_data => x_msg_data

Line 4519: IF p_action = csf_tasks_pub.g_action_conf_to_received THEN

4515:
4516: i:= l_cust_task_tbl.first;
4517: WHILE i IS NOT null
4518: LOOP
4519: IF p_action = csf_tasks_pub.g_action_conf_to_received THEN
4520: jtf_task_confirmation_pub.set_confirmation_confirmed(
4521: p_api_version => 1.0
4522: , p_init_msg_list => fnd_api.g_false
4523: , p_commit => fnd_api.g_false

Line 4530: ELSIF p_action = csf_tasks_pub.g_action_conf_to_required THEN

4526: , x_msg_data => x_msg_data
4527: , p_task_id => l_cust_task_tbl(i)
4528: , p_object_version_number => l_cust_objver_tbl(i)
4529: );
4530: ELSIF p_action = csf_tasks_pub.g_action_conf_to_required THEN
4531: jtf_task_confirmation_pub.set_confirmation_required(
4532: p_api_version => 1.0
4533: , p_init_msg_list => fnd_api.g_false
4534: , p_commit => fnd_api.g_false

Line 4543: IF p_initiated = csf_tasks_pub.g_dispatcher_initiated THEN

4539: , p_object_version_number => l_cust_objver_tbl(i)
4540: );
4541: IF x_return_status = fnd_api.g_ret_sts_success THEN
4542: IF l_task_info.task_confirmation_status = 'C' THEN
4543: IF p_initiated = csf_tasks_pub.g_dispatcher_initiated THEN
4544: jtf_task_confirmation_pub.increase_counter(
4545: p_api_version => 1.0
4546: , p_init_msg_list => fnd_api.g_false
4547: , p_commit => fnd_api.g_false

Line 4554: ELSIF p_initiated = csf_tasks_pub.g_customer_initiated THEN

4550: , x_msg_data => x_msg_data
4551: , p_task_id => l_cust_task_tbl(i)
4552: , p_object_version_number => l_cust_objver_tbl(i)
4553: );
4554: ELSIF p_initiated = csf_tasks_pub.g_customer_initiated THEN
4555: jtf_task_confirmation_pub.reset_counter(
4556: p_api_version => 1.0
4557: , p_commit => fnd_api.g_false
4558: , p_init_msg_list => fnd_api.g_false

Line 4568: ELSIF p_action = csf_tasks_pub.g_action_conf_not_required THEN

4564: );
4565: END IF;
4566: END IF;
4567: END IF;
4568: ELSIF p_action = csf_tasks_pub.g_action_conf_not_required THEN
4569: jtf_task_confirmation_pub.reset_confirmation_status(
4570: p_api_version => 1.0
4571: , p_init_msg_list => fnd_api.g_false
4572: , p_commit => fnd_api.g_false

Line 5205: csf_tasks_pub.update_task(

5201: open c_obj(p_task_id);
5202: fetch c_obj into l_obj;
5203: close c_obj;
5204:
5205: csf_tasks_pub.update_task(
5206: p_api_version => p_api_version
5207: , p_init_msg_list => p_init_msg_list
5208: , p_commit => p_commit
5209: , p_task_id => p_task_id

Line 5262: p_inst_flex_fld_tbl IN csf_tasks_pub.Inst_flexfld_rec_type

5258: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5259: ROLLBACK TO csf_update_per_task;
5260: end;
5261: PROCEDURE set_desc_field_attr(
5262: p_inst_flex_fld_tbl IN csf_tasks_pub.Inst_flexfld_rec_type
5263: ,p_return_status OUT NOCOPY VARCHAR2
5264: ,p_msg_count OUT NOCOPY NUMBER
5265: ,p_msg_data OUT NOCOPY VARCHAR2
5266: ,p_obj_ver_no OUT NOCOPY NUMBER

Line 5666: csf_tasks_pub.return_primary_phone(s.party_site_id) phone_no

5662: IS
5663: SELECT s.party_site_number,
5664: s.party_site_name,
5665: s.addressee,
5666: csf_tasks_pub.return_primary_phone(s.party_site_id) phone_no
5667: FROM hz_locations l,
5668: hz_party_sites s,
5669: hz_parties p
5670: WHERE s.location_id = p_location_id

Line 5676: l_location_id := csf_tasks_pub.get_task_location_id(p_task_id, p_party_site_id, p_location_id);

5672: AND s.party_id = p.party_id
5673: AND p.party_id =p_party_id_no;
5674: l_location_id NUMBER;
5675: BEGIN
5676: l_location_id := csf_tasks_pub.get_task_location_id(p_task_id, p_party_site_id, p_location_id);
5677: OPEN c_get_site_details(l_location_id,p_party_id);
5678: FETCH c_get_site_details INTO p_party_site_no,p_party_site_nm,p_party_site_add,p_party_site_ph;
5679: END;
5680:

Line 5883: l_dc_task := csf_tasks_pub.has_field_service_rule(l_task_type);

5879: THEN
5880: open c_task_type;
5881: fetch c_task_type into l_task_type;
5882: close c_task_type;
5883: l_dc_task := csf_tasks_pub.has_field_service_rule(l_task_type);
5884: IF l_dc_task = fnd_api.g_true
5885: THEN
5886: csf_tasks_pub.CREATE_ACC_HRS(
5887: p_task_id => l_task_id

Line 5886: csf_tasks_pub.CREATE_ACC_HRS(

5882: close c_task_type;
5883: l_dc_task := csf_tasks_pub.has_field_service_rule(l_task_type);
5884: IF l_dc_task = fnd_api.g_true
5885: THEN
5886: csf_tasks_pub.CREATE_ACC_HRS(
5887: p_task_id => l_task_id
5888: , x_return_status => l_return_status
5889: , x_msg_count => l_msg_count
5890: , x_msg_data => l_msg_data

Line 5917: END csf_tasks_pub;

5913: then
5914: fnd_msg_pub.add_exc_msg ( g_pkg_name, l_api_name );
5915: end if;
5916: END create_achrs;
5917: END csf_tasks_pub;