APPS.HR_APPLICANT_DATAUPD dependencies on PER_APPLICATIONS

Line 26: -- + per_applications

22: --
23: -- The following tables are updated:
24: -- + per_all_people_f
25: -- + per_person_type_usages_f
26: -- + per_applications
27: --
28: -- Scenario:
29: --
30: -- Application Records:

Line 63: FROM per_applications appl

59: --
60: CURSOR csr_get_application_details(p_start_rowid rowid, p_end_rowid rowid) IS
61: SELECT application_id, date_end, person_id, object_version_number
62: ,date_received, business_group_id
63: FROM per_applications appl
64: WHERE appl.rowid between p_start_rowid and p_end_rowid
65: AND date_end IS NOT NULL
66: AND EXISTS
67: (SELECT 'Y'

Line 125: l_failed_apl per_applications.application_id%TYPE;

121: --
122: --
123: l_count number;
124: l_appl_rec csr_get_application_details%ROWTYPE;
125: l_failed_apl per_applications.application_id%TYPE;
126: l_person_rec csr_lock_person%ROWTYPE;
127: l_failed_person_id per_all_people_f.person_id%TYPE;
128: l_failed_full_name per_all_people_f.full_name%TYPE;
129: l_rowcount number;

Line 371: from per_applications

367: ) IS
368: --
369: cursor csr_get_apl_rowid(cp_apl_id number) is
370: select rowid
371: from per_applications
372: where application_id = cp_apl_id;
373:
374: l_apl_rowid rowid;
375: --

Line 390: l_table_name := 'PER_APPLICATIONS';

386: req_data varchar2(240);
387: BEGIN
388: --
389: l_product := 'PER';
390: l_table_name := 'PER_APPLICATIONS';
391: l_update_name := g_updateName; -- this matches name used in ADPATCH script
392: --
393: -- get schema name of the table for ROWID range processing
394: --

Line 506: from per_applications

502: ) IS
503: --
504: cursor csr_get_apl_rowid(cp_apl_id number) is
505: select rowid
506: from per_applications
507: where application_id = cp_apl_id;
508:
509: l_apl_rowid rowid;
510: --

Line 524: l_table_name := 'PER_APPLICATIONS';

520: req_data varchar2(240);
521: BEGIN
522: --
523: l_product := 'PER';
524: l_table_name := 'PER_APPLICATIONS';
525: --
526: -- get schema name of the table for ROWID range processing
527: --
528: l_retstatus := fnd_installation.get_app_info(