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;
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;
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;
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;
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;
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;
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;
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:
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
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);
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
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
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
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
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
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
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