DBA Data[Home] [Help]

APPS.PER_MX_VALIDATE_ID dependencies on PER_ALL_PEOPLE_F

Line 53: p_value1 per_all_people_f.per_information1%TYPE,

49: there's a mismatch
50: *******************************************************************************/
51:
52: PROCEDURE compare_id(
53: p_value1 per_all_people_f.per_information1%TYPE,
54: p_value2 per_all_people_f.per_information1%TYPE,
55: p_message fnd_new_messages.message_name%TYPE) AS
56:
57: BEGIN

Line 54: p_value2 per_all_people_f.per_information1%TYPE,

50: *******************************************************************************/
51:
52: PROCEDURE compare_id(
53: p_value1 per_all_people_f.per_information1%TYPE,
54: p_value2 per_all_people_f.per_information1%TYPE,
55: p_message fnd_new_messages.message_name%TYPE) AS
56:
57: BEGIN
58: --

Line 81: p_per_information2 per_all_people_f.per_information2%type,

77: Purpose : This procedure acts as wrapper for per_mx_validations.check_rfc.
78: *******************************************************************************/
79:
80: PROCEDURE VALIDATE_RFC_ID(
81: p_per_information2 per_all_people_f.per_information2%type,
82: p_person_id per_all_people_f.person_id%type) AS
83:
84: p_warning varchar2(1);
85: p_valid_rfc_id per_all_people_f.per_information2%type;

Line 82: p_person_id per_all_people_f.person_id%type) AS

78: *******************************************************************************/
79:
80: PROCEDURE VALIDATE_RFC_ID(
81: p_per_information2 per_all_people_f.per_information2%type,
82: p_person_id per_all_people_f.person_id%type) AS
83:
84: p_warning varchar2(1);
85: p_valid_rfc_id per_all_people_f.per_information2%type;
86: l_proc_name varchar2(100);

Line 85: p_valid_rfc_id per_all_people_f.per_information2%type;

81: p_per_information2 per_all_people_f.per_information2%type,
82: p_person_id per_all_people_f.person_id%type) AS
83:
84: p_warning varchar2(1);
85: p_valid_rfc_id per_all_people_f.per_information2%type;
86: l_proc_name varchar2(100);
87:
88: BEGIN
89: l_proc_name := glb_proc_name ||'VALIDATE_RFC_ID';

Line 119: p_per_information3 per_all_people_f.per_information3%type,

115: Purpose : This procedure acts as wrapper for per_mx_validations.check_ss
116: *******************************************************************************/
117:
118: PROCEDURE VALIDATE_SS_ID(
119: p_per_information3 per_all_people_f.per_information3%type,
120: p_person_id per_all_people_f.person_id%type) AS
121:
122: p_warning varchar2(1);
123: p_valid_ss per_all_people_f.per_information3%type;

Line 120: p_person_id per_all_people_f.person_id%type) AS

116: *******************************************************************************/
117:
118: PROCEDURE VALIDATE_SS_ID(
119: p_per_information3 per_all_people_f.per_information3%type,
120: p_person_id per_all_people_f.person_id%type) AS
121:
122: p_warning varchar2(1);
123: p_valid_ss per_all_people_f.per_information3%type;
124: l_proc_name varchar2(100);

Line 123: p_valid_ss per_all_people_f.per_information3%type;

119: p_per_information3 per_all_people_f.per_information3%type,
120: p_person_id per_all_people_f.person_id%type) AS
121:
122: p_warning varchar2(1);
123: p_valid_ss per_all_people_f.per_information3%type;
124: l_proc_name varchar2(100);
125:
126: BEGIN
127: l_proc_name := glb_proc_name ||'VALIDATE_SS_ID';

Line 158: p_per_information5 per_all_people_f.per_information5%type,

154: Purpose : This procedure acts as wrapper for per_mx_validations.check_fga
155: *******************************************************************************/
156:
157: PROCEDURE VALIDATE_FGA_ID(
158: p_per_information5 per_all_people_f.per_information5%type,
159: p_person_id per_all_people_f.person_id%type) AS
160:
161: p_warning varchar2(1);
162: l_proc_name varchar2(100);

Line 159: p_person_id per_all_people_f.person_id%type) AS

155: *******************************************************************************/
156:
157: PROCEDURE VALIDATE_FGA_ID(
158: p_per_information5 per_all_people_f.per_information5%type,
159: p_person_id per_all_people_f.person_id%type) AS
160:
161: p_warning varchar2(1);
162: l_proc_name varchar2(100);
163:

Line 192: p_per_information6 per_all_people_f.per_information6%type,

188: Purpose : This procedure acts as wrapper for per_mx_validations.check_ms
189: *******************************************************************************/
190:
191: PROCEDURE VALIDATE_MS_ID(
192: p_per_information6 per_all_people_f.per_information6%type,
193: p_person_id per_all_people_f.person_id%type) AS
194:
195: p_warning varchar2(1);
196: l_proc_name varchar2(100);

Line 193: p_person_id per_all_people_f.person_id%type) AS

189: *******************************************************************************/
190:
191: PROCEDURE VALIDATE_MS_ID(
192: p_per_information6 per_all_people_f.per_information6%type,
193: p_person_id per_all_people_f.person_id%type) AS
194:
195: p_warning varchar2(1);
196: l_proc_name varchar2(100);
197:

Line 226: p_per_information4 per_all_people_f.per_information4%type) AS

222: Purpose : This procedure acts as wrapper for per_mx_validations.check_imc
223: *******************************************************************************/
224:
225: PROCEDURE VALIDATE_IMC_ID(
226: p_per_information4 per_all_people_f.per_information4%type) AS
227:
228: l_proc_name varchar2(100);
229: BEGIN
230: l_proc_name := glb_proc_name ||'VALIDATE_IMC_ID';