APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_PHONES

Line 398: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE

394: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
395: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
396: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
397: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
398: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
399: ,p_phn_h_date_from IN per_phones.date_from%TYPE
400: ,p_phn_h_date_to IN per_phones.date_to%TYPE
401: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
402: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

Line 399: ,p_phn_h_date_from IN per_phones.date_from%TYPE

395: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
396: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
397: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
398: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
399: ,p_phn_h_date_from IN per_phones.date_from%TYPE
400: ,p_phn_h_date_to IN per_phones.date_to%TYPE
401: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
402: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
403: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE

Line 400: ,p_phn_h_date_to IN per_phones.date_to%TYPE

396: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
397: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
398: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
399: ,p_phn_h_date_from IN per_phones.date_from%TYPE
400: ,p_phn_h_date_to IN per_phones.date_to%TYPE
401: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
402: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
403: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
404: ,p_phn_w_date_from IN per_phones.date_from%TYPE

Line 401: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE

397: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
398: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
399: ,p_phn_h_date_from IN per_phones.date_from%TYPE
400: ,p_phn_h_date_to IN per_phones.date_to%TYPE
401: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
402: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
403: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
404: ,p_phn_w_date_from IN per_phones.date_from%TYPE
405: ,p_phn_w_date_to IN per_phones.date_to%TYPE

Line 402: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

398: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
399: ,p_phn_h_date_from IN per_phones.date_from%TYPE
400: ,p_phn_h_date_to IN per_phones.date_to%TYPE
401: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
402: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
403: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
404: ,p_phn_w_date_from IN per_phones.date_from%TYPE
405: ,p_phn_w_date_to IN per_phones.date_to%TYPE
406: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE

Line 403: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE

399: ,p_phn_h_date_from IN per_phones.date_from%TYPE
400: ,p_phn_h_date_to IN per_phones.date_to%TYPE
401: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
402: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
403: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
404: ,p_phn_w_date_from IN per_phones.date_from%TYPE
405: ,p_phn_w_date_to IN per_phones.date_to%TYPE
406: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
407: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

Line 404: ,p_phn_w_date_from IN per_phones.date_from%TYPE

400: ,p_phn_h_date_to IN per_phones.date_to%TYPE
401: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
402: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
403: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
404: ,p_phn_w_date_from IN per_phones.date_from%TYPE
405: ,p_phn_w_date_to IN per_phones.date_to%TYPE
406: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
407: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
408: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE

Line 405: ,p_phn_w_date_to IN per_phones.date_to%TYPE

401: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
402: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
403: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
404: ,p_phn_w_date_from IN per_phones.date_from%TYPE
405: ,p_phn_w_date_to IN per_phones.date_to%TYPE
406: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
407: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
408: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
409: ,p_phn_m_date_from IN per_phones.date_from%TYPE

Line 406: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE

402: ,p_phn_h_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
403: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
404: ,p_phn_w_date_from IN per_phones.date_from%TYPE
405: ,p_phn_w_date_to IN per_phones.date_to%TYPE
406: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
407: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
408: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
409: ,p_phn_m_date_from IN per_phones.date_from%TYPE
410: ,p_phn_m_date_to IN per_phones.date_to%TYPE

Line 407: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

403: ,p_phn_w_phone_id OUT NOCOPY per_phones.phone_id%TYPE
404: ,p_phn_w_date_from IN per_phones.date_from%TYPE
405: ,p_phn_w_date_to IN per_phones.date_to%TYPE
406: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
407: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
408: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
409: ,p_phn_m_date_from IN per_phones.date_from%TYPE
410: ,p_phn_m_date_to IN per_phones.date_to%TYPE
411: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE

Line 408: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE

404: ,p_phn_w_date_from IN per_phones.date_from%TYPE
405: ,p_phn_w_date_to IN per_phones.date_to%TYPE
406: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
407: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
408: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
409: ,p_phn_m_date_from IN per_phones.date_from%TYPE
410: ,p_phn_m_date_to IN per_phones.date_to%TYPE
411: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
412: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

Line 409: ,p_phn_m_date_from IN per_phones.date_from%TYPE

405: ,p_phn_w_date_to IN per_phones.date_to%TYPE
406: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
407: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
408: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
409: ,p_phn_m_date_from IN per_phones.date_from%TYPE
410: ,p_phn_m_date_to IN per_phones.date_to%TYPE
411: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
412: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
413: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE

Line 410: ,p_phn_m_date_to IN per_phones.date_to%TYPE

406: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
407: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
408: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
409: ,p_phn_m_date_from IN per_phones.date_from%TYPE
410: ,p_phn_m_date_to IN per_phones.date_to%TYPE
411: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
412: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
413: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
414: ,p_phn_hf_date_from IN per_phones.date_from%TYPE

Line 411: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE

407: ,p_phn_w_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
408: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
409: ,p_phn_m_date_from IN per_phones.date_from%TYPE
410: ,p_phn_m_date_to IN per_phones.date_to%TYPE
411: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
412: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
413: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
414: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
415: ,p_phn_hf_date_to IN per_phones.date_to%TYPE

Line 412: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

408: ,p_phn_m_phone_id OUT NOCOPY per_phones.phone_id%TYPE
409: ,p_phn_m_date_from IN per_phones.date_from%TYPE
410: ,p_phn_m_date_to IN per_phones.date_to%TYPE
411: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
412: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
413: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
414: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
415: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
416: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE

Line 413: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE

409: ,p_phn_m_date_from IN per_phones.date_from%TYPE
410: ,p_phn_m_date_to IN per_phones.date_to%TYPE
411: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
412: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
413: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
414: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
415: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
416: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
417: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

Line 414: ,p_phn_hf_date_from IN per_phones.date_from%TYPE

410: ,p_phn_m_date_to IN per_phones.date_to%TYPE
411: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
412: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
413: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
414: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
415: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
416: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
417: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
418: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE

Line 415: ,p_phn_hf_date_to IN per_phones.date_to%TYPE

411: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
412: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
413: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
414: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
415: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
416: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
417: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
418: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
419: ,p_phn_wf_date_from IN per_phones.date_from%TYPE

Line 416: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE

412: ,p_phn_m_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
413: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
414: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
415: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
416: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
417: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
418: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
419: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
420: ,p_phn_wf_date_to IN per_phones.date_to%TYPE

Line 417: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

413: ,p_phn_hf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
414: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
415: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
416: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
417: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
418: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
419: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
420: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
421: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE

Line 418: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE

414: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
415: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
416: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
417: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
418: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
419: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
420: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
421: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
422: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

Line 419: ,p_phn_wf_date_from IN per_phones.date_from%TYPE

415: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
416: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
417: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
418: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
419: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
420: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
421: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
422: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
423: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE

Line 420: ,p_phn_wf_date_to IN per_phones.date_to%TYPE

416: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
417: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
418: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
419: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
420: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
421: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
422: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
423: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
424: ,p_change_date IN per_pay_proposals.change_date%TYPE

Line 421: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE

417: ,p_phn_hf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
418: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
419: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
420: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
421: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
422: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
423: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
424: ,p_change_date IN per_pay_proposals.change_date%TYPE
425: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE

Line 422: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE

418: ,p_phn_wf_phone_id OUT NOCOPY per_phones.phone_id%TYPE
419: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
420: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
421: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
422: ,p_phn_wf_object_version_number OUT NOCOPY per_phones.object_version_number%TYPE
423: ,p_pay_proposal_id OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
424: ,p_change_date IN per_pay_proposals.change_date%TYPE
425: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
426: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE

Line 779: l_phone_id per_phones.phone_id%TYPE;

775: --
776: l_address_id per_addresses.address_id%TYPE;
777: l_addr_object_version_number per_addresses.object_version_number%TYPE;
778: --
779: l_phone_id per_phones.phone_id%TYPE;
780: l_phn_object_version_number per_phones.object_version_number%TYPE;
781: --
782: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
783: l_dpf_object_version_number per_deployment_factors.object_version_number%TYPE;

Line 780: l_phn_object_version_number per_phones.object_version_number%TYPE;

776: l_address_id per_addresses.address_id%TYPE;
777: l_addr_object_version_number per_addresses.object_version_number%TYPE;
778: --
779: l_phone_id per_phones.phone_id%TYPE;
780: l_phn_object_version_number per_phones.object_version_number%TYPE;
781: --
782: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
783: l_dpf_object_version_number per_deployment_factors.object_version_number%TYPE;
784: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

Line 3062: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

3058: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3059: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3060: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3061: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3062: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3063: ,p_phn_h_date_from IN per_phones.date_from%TYPE
3064: ,p_phn_h_date_to IN per_phones.date_to%TYPE
3065: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
3066: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

Line 3063: ,p_phn_h_date_from IN per_phones.date_from%TYPE

3059: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3060: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3061: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3062: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3063: ,p_phn_h_date_from IN per_phones.date_from%TYPE
3064: ,p_phn_h_date_to IN per_phones.date_to%TYPE
3065: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
3066: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3067: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

Line 3064: ,p_phn_h_date_to IN per_phones.date_to%TYPE

3060: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3061: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3062: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3063: ,p_phn_h_date_from IN per_phones.date_from%TYPE
3064: ,p_phn_h_date_to IN per_phones.date_to%TYPE
3065: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
3066: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3067: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3068: ,p_phn_w_date_from IN per_phones.date_from%TYPE

Line 3065: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE

3061: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3062: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3063: ,p_phn_h_date_from IN per_phones.date_from%TYPE
3064: ,p_phn_h_date_to IN per_phones.date_to%TYPE
3065: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
3066: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3067: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3068: ,p_phn_w_date_from IN per_phones.date_from%TYPE
3069: ,p_phn_w_date_to IN per_phones.date_to%TYPE

Line 3066: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

3062: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3063: ,p_phn_h_date_from IN per_phones.date_from%TYPE
3064: ,p_phn_h_date_to IN per_phones.date_to%TYPE
3065: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
3066: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3067: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3068: ,p_phn_w_date_from IN per_phones.date_from%TYPE
3069: ,p_phn_w_date_to IN per_phones.date_to%TYPE
3070: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE

Line 3067: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

3063: ,p_phn_h_date_from IN per_phones.date_from%TYPE
3064: ,p_phn_h_date_to IN per_phones.date_to%TYPE
3065: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
3066: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3067: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3068: ,p_phn_w_date_from IN per_phones.date_from%TYPE
3069: ,p_phn_w_date_to IN per_phones.date_to%TYPE
3070: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
3071: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

Line 3068: ,p_phn_w_date_from IN per_phones.date_from%TYPE

3064: ,p_phn_h_date_to IN per_phones.date_to%TYPE
3065: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
3066: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3067: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3068: ,p_phn_w_date_from IN per_phones.date_from%TYPE
3069: ,p_phn_w_date_to IN per_phones.date_to%TYPE
3070: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
3071: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3072: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

Line 3069: ,p_phn_w_date_to IN per_phones.date_to%TYPE

3065: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE
3066: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3067: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3068: ,p_phn_w_date_from IN per_phones.date_from%TYPE
3069: ,p_phn_w_date_to IN per_phones.date_to%TYPE
3070: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
3071: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3072: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3073: ,p_phn_m_date_from IN per_phones.date_from%TYPE

Line 3070: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE

3066: ,p_phn_h_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3067: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3068: ,p_phn_w_date_from IN per_phones.date_from%TYPE
3069: ,p_phn_w_date_to IN per_phones.date_to%TYPE
3070: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
3071: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3072: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3073: ,p_phn_m_date_from IN per_phones.date_from%TYPE
3074: ,p_phn_m_date_to IN per_phones.date_to%TYPE

Line 3071: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

3067: ,p_phn_w_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3068: ,p_phn_w_date_from IN per_phones.date_from%TYPE
3069: ,p_phn_w_date_to IN per_phones.date_to%TYPE
3070: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
3071: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3072: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3073: ,p_phn_m_date_from IN per_phones.date_from%TYPE
3074: ,p_phn_m_date_to IN per_phones.date_to%TYPE
3075: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE

Line 3072: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

3068: ,p_phn_w_date_from IN per_phones.date_from%TYPE
3069: ,p_phn_w_date_to IN per_phones.date_to%TYPE
3070: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
3071: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3072: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3073: ,p_phn_m_date_from IN per_phones.date_from%TYPE
3074: ,p_phn_m_date_to IN per_phones.date_to%TYPE
3075: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
3076: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

Line 3073: ,p_phn_m_date_from IN per_phones.date_from%TYPE

3069: ,p_phn_w_date_to IN per_phones.date_to%TYPE
3070: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
3071: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3072: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3073: ,p_phn_m_date_from IN per_phones.date_from%TYPE
3074: ,p_phn_m_date_to IN per_phones.date_to%TYPE
3075: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
3076: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3077: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

Line 3074: ,p_phn_m_date_to IN per_phones.date_to%TYPE

3070: ,p_phn_w_phone_number IN per_phones.phone_number%TYPE
3071: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3072: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3073: ,p_phn_m_date_from IN per_phones.date_from%TYPE
3074: ,p_phn_m_date_to IN per_phones.date_to%TYPE
3075: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
3076: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3077: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3078: ,p_phn_hf_date_from IN per_phones.date_from%TYPE

Line 3075: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE

3071: ,p_phn_w_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3072: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3073: ,p_phn_m_date_from IN per_phones.date_from%TYPE
3074: ,p_phn_m_date_to IN per_phones.date_to%TYPE
3075: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
3076: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3077: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3078: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
3079: ,p_phn_hf_date_to IN per_phones.date_to%TYPE

Line 3076: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

3072: ,p_phn_m_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3073: ,p_phn_m_date_from IN per_phones.date_from%TYPE
3074: ,p_phn_m_date_to IN per_phones.date_to%TYPE
3075: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
3076: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3077: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3078: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
3079: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
3080: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE

Line 3077: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

3073: ,p_phn_m_date_from IN per_phones.date_from%TYPE
3074: ,p_phn_m_date_to IN per_phones.date_to%TYPE
3075: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
3076: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3077: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3078: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
3079: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
3080: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
3081: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

Line 3078: ,p_phn_hf_date_from IN per_phones.date_from%TYPE

3074: ,p_phn_m_date_to IN per_phones.date_to%TYPE
3075: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
3076: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3077: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3078: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
3079: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
3080: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
3081: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3082: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

Line 3079: ,p_phn_hf_date_to IN per_phones.date_to%TYPE

3075: ,p_phn_m_phone_number IN per_phones.phone_number%TYPE
3076: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3077: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3078: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
3079: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
3080: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
3081: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3082: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3083: ,p_phn_wf_date_from IN per_phones.date_from%TYPE

Line 3080: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE

3076: ,p_phn_m_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3077: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3078: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
3079: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
3080: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
3081: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3082: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3083: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
3084: ,p_phn_wf_date_to IN per_phones.date_to%TYPE

Line 3081: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

3077: ,p_phn_hf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3078: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
3079: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
3080: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
3081: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3082: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3083: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
3084: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
3085: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE

Line 3082: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

3078: ,p_phn_hf_date_from IN per_phones.date_from%TYPE
3079: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
3080: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
3081: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3082: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3083: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
3084: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
3085: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
3086: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

Line 3083: ,p_phn_wf_date_from IN per_phones.date_from%TYPE

3079: ,p_phn_hf_date_to IN per_phones.date_to%TYPE
3080: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
3081: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3082: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3083: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
3084: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
3085: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
3086: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3087: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE

Line 3084: ,p_phn_wf_date_to IN per_phones.date_to%TYPE

3080: ,p_phn_hf_phone_number IN per_phones.phone_number%TYPE
3081: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3082: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3083: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
3084: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
3085: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
3086: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3087: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
3088: ,p_change_date IN per_pay_proposals.change_date%TYPE

Line 3085: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE

3081: ,p_phn_hf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3082: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3083: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
3084: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
3085: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
3086: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3087: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
3088: ,p_change_date IN per_pay_proposals.change_date%TYPE
3089: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE

Line 3086: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE

3082: ,p_phn_wf_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3083: ,p_phn_wf_date_from IN per_phones.date_from%TYPE
3084: ,p_phn_wf_date_to IN per_phones.date_to%TYPE
3085: ,p_phn_wf_phone_number IN per_phones.phone_number%TYPE
3086: ,p_phn_wf_object_version_number IN OUT NOCOPY per_phones.object_version_number%TYPE
3087: ,p_pay_proposal_id IN OUT NOCOPY per_pay_proposals.pay_proposal_id%TYPE
3088: ,p_change_date IN per_pay_proposals.change_date%TYPE
3089: ,p_proposed_salary_n IN per_pay_proposals.proposed_salary_n%TYPE
3090: ,p_proposal_reason IN per_pay_proposals.proposal_reason%TYPE

Line 3447: l_phone_id per_phones.phone_id%TYPE;

3443: --
3444: l_address_id per_addresses.address_id%TYPE;
3445: l_addr_object_version_number per_addresses.object_version_number%TYPE;
3446: --
3447: l_phone_id per_phones.phone_id%TYPE;
3448: l_phn_object_version_number per_phones.object_version_number%TYPE;
3449: --
3450: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
3451: l_dpf_object_version_number per_deployment_factors.object_version_number%TYPE;

Line 3448: l_phn_object_version_number per_phones.object_version_number%TYPE;

3444: l_address_id per_addresses.address_id%TYPE;
3445: l_addr_object_version_number per_addresses.object_version_number%TYPE;
3446: --
3447: l_phone_id per_phones.phone_id%TYPE;
3448: l_phn_object_version_number per_phones.object_version_number%TYPE;
3449: --
3450: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
3451: l_dpf_object_version_number per_deployment_factors.object_version_number%TYPE;
3452: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

Line 7028: ,p_phn_h_phone_id per_phones.phone_id%TYPE

7024: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7025: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7026: ,p_address_id per_addresses.address_id%TYPE
7027: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7028: ,p_phn_h_phone_id per_phones.phone_id%TYPE
7029: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
7030: ,p_phn_w_phone_id per_phones.phone_id%TYPE
7031: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
7032: ,p_phn_m_phone_id per_phones.phone_id%TYPE

Line 7029: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE

7025: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7026: ,p_address_id per_addresses.address_id%TYPE
7027: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7028: ,p_phn_h_phone_id per_phones.phone_id%TYPE
7029: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
7030: ,p_phn_w_phone_id per_phones.phone_id%TYPE
7031: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
7032: ,p_phn_m_phone_id per_phones.phone_id%TYPE
7033: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE

Line 7030: ,p_phn_w_phone_id per_phones.phone_id%TYPE

7026: ,p_address_id per_addresses.address_id%TYPE
7027: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7028: ,p_phn_h_phone_id per_phones.phone_id%TYPE
7029: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
7030: ,p_phn_w_phone_id per_phones.phone_id%TYPE
7031: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
7032: ,p_phn_m_phone_id per_phones.phone_id%TYPE
7033: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
7034: ,p_phn_hf_phone_id per_phones.phone_id%TYPE

Line 7031: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE

7027: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7028: ,p_phn_h_phone_id per_phones.phone_id%TYPE
7029: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
7030: ,p_phn_w_phone_id per_phones.phone_id%TYPE
7031: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
7032: ,p_phn_m_phone_id per_phones.phone_id%TYPE
7033: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
7034: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
7035: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE

Line 7032: ,p_phn_m_phone_id per_phones.phone_id%TYPE

7028: ,p_phn_h_phone_id per_phones.phone_id%TYPE
7029: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
7030: ,p_phn_w_phone_id per_phones.phone_id%TYPE
7031: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
7032: ,p_phn_m_phone_id per_phones.phone_id%TYPE
7033: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
7034: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
7035: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
7036: ,p_phn_wf_phone_id per_phones.phone_id%TYPE

Line 7033: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE

7029: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
7030: ,p_phn_w_phone_id per_phones.phone_id%TYPE
7031: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
7032: ,p_phn_m_phone_id per_phones.phone_id%TYPE
7033: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
7034: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
7035: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
7036: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
7037: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE

Line 7034: ,p_phn_hf_phone_id per_phones.phone_id%TYPE

7030: ,p_phn_w_phone_id per_phones.phone_id%TYPE
7031: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
7032: ,p_phn_m_phone_id per_phones.phone_id%TYPE
7033: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
7034: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
7035: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
7036: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
7037: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE
7038: ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE

Line 7035: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE

7031: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE
7032: ,p_phn_m_phone_id per_phones.phone_id%TYPE
7033: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
7034: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
7035: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
7036: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
7037: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE
7038: ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE
7039: ,p_pyp_object_version_number per_pay_proposals.object_version_number%TYPE

Line 7036: ,p_phn_wf_phone_id per_phones.phone_id%TYPE

7032: ,p_phn_m_phone_id per_phones.phone_id%TYPE
7033: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
7034: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
7035: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
7036: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
7037: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE
7038: ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE
7039: ,p_pyp_object_version_number per_pay_proposals.object_version_number%TYPE
7040: ,p_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE

Line 7037: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE

7033: ,p_phn_m_object_version_number per_phones.object_version_number%TYPE
7034: ,p_phn_hf_phone_id per_phones.phone_id%TYPE
7035: ,p_phn_hf_object_version_number per_phones.object_version_number%TYPE
7036: ,p_phn_wf_phone_id per_phones.phone_id%TYPE
7037: ,p_phn_wf_object_version_number per_phones.object_version_number%TYPE
7038: ,p_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE
7039: ,p_pyp_object_version_number per_pay_proposals.object_version_number%TYPE
7040: ,p_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE
7041: ,p_dpf_object_version_number per_deployment_factors.object_version_number%TYPE