37: deduction category while inserting assignment EIT records.
38: *******************************************************************************/
39:
40: PROCEDURE CHK_DUP_PRORATION_INS(
41: p_assignment_id per_assignment_extra_info.assignment_id%TYPE,
42: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
43: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
44: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
45: );
38: *******************************************************************************/
39:
40: PROCEDURE CHK_DUP_PRORATION_INS(
41: p_assignment_id per_assignment_extra_info.assignment_id%TYPE,
42: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
43: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
44: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
45: );
46:
39:
40: PROCEDURE CHK_DUP_PRORATION_INS(
41: p_assignment_id per_assignment_extra_info.assignment_id%TYPE,
42: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
43: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
44: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
45: );
46:
47:
40: PROCEDURE CHK_DUP_PRORATION_INS(
41: p_assignment_id per_assignment_extra_info.assignment_id%TYPE,
42: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
43: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
44: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
45: );
46:
47:
48: /*******************************************************************************
51: deduction category while updating assignment EIT records.
52: *******************************************************************************/
53:
54: PROCEDURE CHK_DUP_PRORATION_UPD(
55: p_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE,
56: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
57: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
58: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
59: );
52: *******************************************************************************/
53:
54: PROCEDURE CHK_DUP_PRORATION_UPD(
55: p_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE,
56: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
57: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
58: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
59: );
60:
53:
54: PROCEDURE CHK_DUP_PRORATION_UPD(
55: p_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE,
56: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
57: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
58: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
59: );
60:
61: GLB_MODE varchar2(10);
54: PROCEDURE CHK_DUP_PRORATION_UPD(
55: p_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE,
56: p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
57: p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
58: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
59: );
60:
61: GLB_MODE varchar2(10);
62: GLB_ASG_EXTRA_INFO_ID per_assignment_extra_info.assignment_extra_info_id%type;
58: p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
59: );
60:
61: GLB_MODE varchar2(10);
62: GLB_ASG_EXTRA_INFO_ID per_assignment_extra_info.assignment_extra_info_id%type;
63:
64: END PER_US_ASG_EXT_INFO_CHK;