DBA Data[Home] [Help]

APPS.OTA_ADD_TRAINING_SS dependencies on PER_ALL_PEOPLE_F

Line 621: l_person_id per_all_people_f.person_id%TYPE;

617: l_contact_name VARCHAR2(80);
618: l_activity_name ota_activity_versions.version_name%TYPE;
619: l_obj_ver_no VARCHAR2(80);
620: l_business_grp_id VARCHAR2(80);
621: l_person_id per_all_people_f.person_id%TYPE;
622: l_var_person_id VARCHAR2(80);
623: l_from VARCHAR2(100);
624: l_org_id VARCHAR2(800);
625: l_org_name hr_all_organization_units.name%TYPE;

Line 1071: l_person_id per_all_people_f.person_id%TYPE;

1067: l_contact_name VARCHAR2(800);
1068: l_activity_name ota_activity_versions.version_name%TYPE;
1069: l_obj_ver_no VARCHAR2(800);
1070: l_business_grp_id VARCHAR2(800);
1071: l_person_id per_all_people_f.person_id%TYPE;
1072: l_org_id VARCHAR2(800);
1073: l_transaction_mode VARCHAR2(10);
1074: l_some_warning NUMBER := 0;
1075: l_from VARCHAR2(100);

Line 1317: l_person_id per_all_people_f.person_id%TYPE;

1313: l_activity_name ota_activity_versions.version_name%TYPE;
1314: l_old_obj_ver_no VARCHAR2(800);
1315: l_new_obj_ver_no VARCHAR2(800) := NULL;
1316: l_business_grp_id VARCHAR2(800);
1317: l_person_id per_all_people_f.person_id%TYPE;
1318: l_org_id VARCHAR2(800);
1319: l_transaction_mode VARCHAR2(10);
1320: l_some_warning NUMBER := 0;
1321: l_from VARCHAR2(100);

Line 1688: l_learner_name per_all_people_f.full_name%TYPE;

1684: -- Declare cursors and local variables
1685: --
1686: l_some_warning BOOLEAN;
1687: l_proc VARCHAR2(72) := 'Create_Add_Training';
1688: l_learner_name per_all_people_f.full_name%TYPE;
1689:
1690: BEGIN
1691:
1692:

Line 1889: l_learner_name per_all_people_f.full_name%TYPE;

1885: --
1886: l_some_warning BOOLEAN;
1887: l_new_object_version_number NUMBER;
1888: l_proc VARCHAR2(72) := 'Update_Add_Training';
1889: l_learner_name per_all_people_f.full_name%TYPE;
1890: BEGIN
1891: hr_utility.set_location('Entering:'||g_package||l_proc, 40);
1892:
1893: l_new_object_version_number := p_old_object_version_number;

Line 2117: ( Person_id IN per_all_people_f.person_id%TYPE) RETURN per_all_people_f.full_name%TYPE

2113: --
2114: -- {End Of Comments}
2115: -- ----------------------------------------------------------------------------
2116: Function get_internal_contact_name
2117: ( Person_id IN per_all_people_f.person_id%TYPE) RETURN per_all_people_f.full_name%TYPE
2118: IS
2119:
2120: CURSOR c_get_person_name(p_person_id per_all_people_f.person_id%TYPE) IS
2121: SELECT full_name

Line 2120: CURSOR c_get_person_name(p_person_id per_all_people_f.person_id%TYPE) IS

2116: Function get_internal_contact_name
2117: ( Person_id IN per_all_people_f.person_id%TYPE) RETURN per_all_people_f.full_name%TYPE
2118: IS
2119:
2120: CURSOR c_get_person_name(p_person_id per_all_people_f.person_id%TYPE) IS
2121: SELECT full_name
2122: FROM per_all_people_f
2123: WHERE person_id = p_person_id
2124: AND sysdate BETWEEN effective_start_date and effective_end_date; --Bug 5464327: date tracking of per_all_people_f is considered.

Line 2122: FROM per_all_people_f

2118: IS
2119:
2120: CURSOR c_get_person_name(p_person_id per_all_people_f.person_id%TYPE) IS
2121: SELECT full_name
2122: FROM per_all_people_f
2123: WHERE person_id = p_person_id
2124: AND sysdate BETWEEN effective_start_date and effective_end_date; --Bug 5464327: date tracking of per_all_people_f is considered.
2125:
2126: l_person_full_name per_all_people_f.full_name%TYPE;

Line 2124: AND sysdate BETWEEN effective_start_date and effective_end_date; --Bug 5464327: date tracking of per_all_people_f is considered.

2120: CURSOR c_get_person_name(p_person_id per_all_people_f.person_id%TYPE) IS
2121: SELECT full_name
2122: FROM per_all_people_f
2123: WHERE person_id = p_person_id
2124: AND sysdate BETWEEN effective_start_date and effective_end_date; --Bug 5464327: date tracking of per_all_people_f is considered.
2125:
2126: l_person_full_name per_all_people_f.full_name%TYPE;
2127: l_proc VARCHAR2(72) := 'get_internal_contact_name';
2128: BEGIN

Line 2126: l_person_full_name per_all_people_f.full_name%TYPE;

2122: FROM per_all_people_f
2123: WHERE person_id = p_person_id
2124: AND sysdate BETWEEN effective_start_date and effective_end_date; --Bug 5464327: date tracking of per_all_people_f is considered.
2125:
2126: l_person_full_name per_all_people_f.full_name%TYPE;
2127: l_proc VARCHAR2(72) := 'get_internal_contact_name';
2128: BEGIN
2129:
2130: hr_utility.set_location('Entering:'||g_package||l_proc, 10);

Line 2156: -- Organization_Id - this parameter is used to decide if the per_all_people_f

2152: -- per_all_poople_f table. It is ignoring the possiblity of the contact being
2153: -- that of a customer. This function considers that.
2154: -- In Parameters:
2155: -- Contact_Id - person_id/contact id of employee/customer
2156: -- Organization_Id - this parameter is used to decide if the per_all_people_f
2157: -- or the ra_contacts needs to be queried. If this is null, then the incoming
2158: -- person_id belongs to a Customers' contact and ra_contacts is queried.
2159: -- {End Of Comments}
2160: -- ----------------------------------------------------------------------------

Line 2166: CURSOR c_get_person_name(p_person_id per_all_people_f.person_id%TYPE) IS

2162: ( Person_id IN ota_notrng_histories.contact_id%TYPE
2163: ,Organization_id IN ota_notrng_histories.organization_id%TYPE ) RETURN VARCHAR2
2164: IS
2165:
2166: CURSOR c_get_person_name(p_person_id per_all_people_f.person_id%TYPE) IS
2167: SELECT full_name
2168: FROM per_all_people_f
2169: WHERE person_id = p_person_id
2170: AND sysdate BETWEEN effective_start_date and effective_end_date;

Line 2168: FROM per_all_people_f

2164: IS
2165:
2166: CURSOR c_get_person_name(p_person_id per_all_people_f.person_id%TYPE) IS
2167: SELECT full_name
2168: FROM per_all_people_f
2169: WHERE person_id = p_person_id
2170: AND sysdate BETWEEN effective_start_date and effective_end_date;
2171:
2172: CURSOR c_get_contact_name(p_person_id hz_cust_account_roles.cust_account_role_id%TYPE) IS