30: * @param p_primary_language The resource's primary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
31: * @param p_secondary_language The resource's secondary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
32: * @param p_cost_per_hr The salary cost per hour for this resource.
33: * @param p_attribute_access_level Attribute access Level
34: * @param p_object_version_number The object version number of the resource derives from the jtf_rs_resource_extns table.
35: * @param p_wf_process Workflow Process
36: * @param p_wf_item_type Workflow Item Type
37: * @param p_source_mobile_phone Source Mobile Phone
38: * @param p_source_pager Source Pager
46: PROCEDURE start_update_resource_wf (
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
49: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
50: p_resource_id IN jtf_rs_resource_extns.resource_id%type,
51: p_category IN jtf_rs_resource_extns.category%type,
52: p_resource_number IN jtf_rs_resource_extns.resource_number%type,
53: p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,
54: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
49: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
50: p_resource_id IN jtf_rs_resource_extns.resource_id%type,
51: p_category IN jtf_rs_resource_extns.category%type,
52: p_resource_number IN jtf_rs_resource_extns.resource_number%type,
53: p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,
54: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
55: p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
48: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
49: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
50: p_resource_id IN jtf_rs_resource_extns.resource_id%type,
51: p_category IN jtf_rs_resource_extns.category%type,
52: p_resource_number IN jtf_rs_resource_extns.resource_number%type,
53: p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,
54: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
55: p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
56: p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
49: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
50: p_resource_id IN jtf_rs_resource_extns.resource_id%type,
51: p_category IN jtf_rs_resource_extns.category%type,
52: p_resource_number IN jtf_rs_resource_extns.resource_number%type,
53: p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,
54: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
55: p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
56: p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
57: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
50: p_resource_id IN jtf_rs_resource_extns.resource_id%type,
51: p_category IN jtf_rs_resource_extns.category%type,
52: p_resource_number IN jtf_rs_resource_extns.resource_number%type,
53: p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,
54: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
55: p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
56: p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
57: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
58: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
51: p_category IN jtf_rs_resource_extns.category%type,
52: p_resource_number IN jtf_rs_resource_extns.resource_number%type,
53: p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,
54: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
55: p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
56: p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
57: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
58: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
59: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
52: p_resource_number IN jtf_rs_resource_extns.resource_number%type,
53: p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,
54: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
55: p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
56: p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
57: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
58: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
59: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
60: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
53: p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,
54: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
55: p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
56: p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
57: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
58: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
59: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
60: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
61: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
54: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
55: p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
56: p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
57: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
58: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
59: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
60: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
61: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
62: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
55: p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
56: p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
57: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
58: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
59: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
60: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
61: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
62: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
63: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
56: p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
57: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
58: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
59: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
60: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
61: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
62: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
63: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
64: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
57: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
58: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
59: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
60: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
61: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
62: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
63: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
64: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
65: p_attribute_access_level IN jtf_rs_table_attributes_b.attribute_access_level%type,
58: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
59: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
60: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
61: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
62: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
63: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
64: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
65: p_attribute_access_level IN jtf_rs_table_attributes_b.attribute_access_level%type,
66: p_object_version_number IN jtf_rs_resource_extns.object_version_number%type,
59: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
60: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
61: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
62: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
63: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
64: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
65: p_attribute_access_level IN jtf_rs_table_attributes_b.attribute_access_level%type,
66: p_object_version_number IN jtf_rs_resource_extns.object_version_number%type,
67: --p_wf_display_name IN VARCHAR2 DEFAULT NULL,
60: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
61: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
62: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
63: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
64: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
65: p_attribute_access_level IN jtf_rs_table_attributes_b.attribute_access_level%type,
66: p_object_version_number IN jtf_rs_resource_extns.object_version_number%type,
67: --p_wf_display_name IN VARCHAR2 DEFAULT NULL,
68: p_wf_process IN VARCHAR2 DEFAULT 'EMP_UPDATE_PROCESS',
62: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
63: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
64: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
65: p_attribute_access_level IN jtf_rs_table_attributes_b.attribute_access_level%type,
66: p_object_version_number IN jtf_rs_resource_extns.object_version_number%type,
67: --p_wf_display_name IN VARCHAR2 DEFAULT NULL,
68: p_wf_process IN VARCHAR2 DEFAULT 'EMP_UPDATE_PROCESS',
69: p_wf_item_type IN VARCHAR2 DEFAULT 'EMP_TYPE',
70: x_return_status OUT NOCOPY VARCHAR2,
69: p_wf_item_type IN VARCHAR2 DEFAULT 'EMP_TYPE',
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_source_mobile_phone IN jtf_rs_resource_extns.source_mobile_phone%type default fnd_api.g_miss_char,
74: p_source_pager IN jtf_rs_resource_extns.source_pager%type default fnd_api.g_miss_char
75: );
76:
77: /*#
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_source_mobile_phone IN jtf_rs_resource_extns.source_mobile_phone%type default fnd_api.g_miss_char,
74: p_source_pager IN jtf_rs_resource_extns.source_pager%type default fnd_api.g_miss_char
75: );
76:
77: /*#
78: * Check Attribute access level API