DBA Data[Home] [Help]

APPS.GHR_MASS_CON_PROGRAM dependencies on GHR_PA_REMARKS

Line 444: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

440: p_prd IN VARCHAR2
441: )
442: is
443: l_proc varchar2(72) := g_package || 'create_remarks';
444: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
445: l_remark_id ghr_pa_remarks.remark_id%type;
446: l_description ghr_pa_remarks.description%type;
447: l_desc_ins_val ghr_pa_remarks.description%type;
448: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;

Line 445: l_remark_id ghr_pa_remarks.remark_id%type;

441: )
442: is
443: l_proc varchar2(72) := g_package || 'create_remarks';
444: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
445: l_remark_id ghr_pa_remarks.remark_id%type;
446: l_description ghr_pa_remarks.description%type;
447: l_desc_ins_val ghr_pa_remarks.description%type;
448: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
449: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;

Line 446: l_description ghr_pa_remarks.description%type;

442: is
443: l_proc varchar2(72) := g_package || 'create_remarks';
444: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
445: l_remark_id ghr_pa_remarks.remark_id%type;
446: l_description ghr_pa_remarks.description%type;
447: l_desc_ins_val ghr_pa_remarks.description%type;
448: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
449: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
450: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;

Line 447: l_desc_ins_val ghr_pa_remarks.description%type;

443: l_proc varchar2(72) := g_package || 'create_remarks';
444: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
445: l_remark_id ghr_pa_remarks.remark_id%type;
446: l_description ghr_pa_remarks.description%type;
447: l_desc_ins_val ghr_pa_remarks.description%type;
448: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
449: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
450: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
451: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;

Line 448: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;

444: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
445: l_remark_id ghr_pa_remarks.remark_id%type;
446: l_description ghr_pa_remarks.description%type;
447: l_desc_ins_val ghr_pa_remarks.description%type;
448: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
449: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
450: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
451: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
452: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

Line 449: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;

445: l_remark_id ghr_pa_remarks.remark_id%type;
446: l_description ghr_pa_remarks.description%type;
447: l_desc_ins_val ghr_pa_remarks.description%type;
448: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
449: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
450: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
451: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
452: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
453: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;

Line 450: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;

446: l_description ghr_pa_remarks.description%type;
447: l_desc_ins_val ghr_pa_remarks.description%type;
448: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
449: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
450: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
451: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
452: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
453: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
454: l_p_object_version_number ghr_pa_remarks.object_version_number%type;

Line 451: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;

447: l_desc_ins_val ghr_pa_remarks.description%type;
448: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
449: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
450: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
451: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
452: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
453: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
454: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
455:

Line 452: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

448: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
449: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
450: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
451: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
452: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
453: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
454: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
455:
456: begin

Line 453: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;

449: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
450: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
451: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
452: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
453: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
454: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
455:
456: begin
457: hr_utility.set_location('Entering ' || l_proc,5);

Line 454: l_p_object_version_number ghr_pa_remarks.object_version_number%type;

450: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
451: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
452: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
453: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
454: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
455:
456: begin
457: hr_utility.set_location('Entering ' || l_proc,5);
458: IF p_noa_action IN ('472','772') THEN

Line 472: ghr_pa_remarks_api.create_pa_remarks

468: (p_desc => l_description,
469: p_information1 => 'Lapse in appropriations',
470: p_desc_out => l_desc_ins_val
471: );
472: ghr_pa_remarks_api.create_pa_remarks
473: (
474: p_pa_request_id => p_pa_request_id
475: ,p_remark_id => l_remark_id
476: ,p_description => l_desc_ins_val

Line 493: ghr_pa_remarks_api.create_pa_remarks

489: (p_remark_code => 'G33',
490: p_effective_date => p_effective_date,
491: p_remark_id => l_remark_id,
492: p_remark_desc => l_description);
493: ghr_pa_remarks_api.create_pa_remarks
494: (
495: p_pa_request_id => p_pa_request_id
496: ,p_remark_id => l_remark_id
497: ,p_description => l_description

Line 513: ghr_pa_remarks_api.create_pa_remarks

509: (p_remark_code => 'B72',
510: p_effective_date => p_effective_date,
511: p_remark_id => l_remark_id,
512: p_remark_desc => l_description);
513: ghr_pa_remarks_api.create_pa_remarks
514: (
515: p_pa_request_id => p_pa_request_id
516: ,p_remark_id => l_remark_id
517: ,p_description => l_description

Line 533: ghr_pa_remarks_api.create_pa_remarks

529: (p_remark_code => 'B71',
530: p_effective_date => p_effective_date,
531: p_remark_id => l_remark_id,
532: p_remark_desc => l_description);
533: ghr_pa_remarks_api.create_pa_remarks
534: (
535: p_pa_request_id => p_pa_request_id
536: ,p_remark_id => l_remark_id
537: ,p_description => l_description

Line 556: ghr_pa_remarks_api.create_pa_remarks

552: (p_remark_code => 'X45',
553: p_effective_date => p_effective_date,
554: p_remark_id => l_remark_id,
555: p_remark_desc => l_description);
556: ghr_pa_remarks_api.create_pa_remarks
557: (
558: p_pa_request_id => p_pa_request_id
559: ,p_remark_id => l_remark_id
560: ,p_description => l_description

Line 574: ghr_pa_remarks_api.create_pa_remarks

570: (p_remark_code => 'X61',
571: p_effective_date => p_effective_date,
572: p_remark_id => l_remark_id,
573: p_remark_desc => l_description);
574: ghr_pa_remarks_api.create_pa_remarks
575: (
576: p_pa_request_id => p_pa_request_id
577: ,p_remark_id => l_remark_id
578: ,p_description => l_description