763: -- parameters
764: -- Parameters:
765: -- IN
766: -- p_dff_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE
767: -- p_attribute_category pa_expenditure_items_all.attribute_category%TYPE
768: --
769: -- IN/OUT
770: -- p_attribute1 IN OUT pa_expenditure_items_all.attribute1%TYPE
771: -- p_attribute2 IN OUT pa_expenditure_items_all.attribute2%TYPE
766: -- p_dff_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE
767: -- p_attribute_category pa_expenditure_items_all.attribute_category%TYPE
768: --
769: -- IN/OUT
770: -- p_attribute1 IN OUT pa_expenditure_items_all.attribute1%TYPE
771: -- p_attribute2 IN OUT pa_expenditure_items_all.attribute2%TYPE
772: -- p_attribute3 IN OUT pa_expenditure_items_all.attribute3%TYPE
773: -- p_attribute4 IN OUT pa_expenditure_items_all.attribute4%TYPE
774: -- p_attribute5 IN OUT pa_expenditure_items_all.attribute5%TYPE
767: -- p_attribute_category pa_expenditure_items_all.attribute_category%TYPE
768: --
769: -- IN/OUT
770: -- p_attribute1 IN OUT pa_expenditure_items_all.attribute1%TYPE
771: -- p_attribute2 IN OUT pa_expenditure_items_all.attribute2%TYPE
772: -- p_attribute3 IN OUT pa_expenditure_items_all.attribute3%TYPE
773: -- p_attribute4 IN OUT pa_expenditure_items_all.attribute4%TYPE
774: -- p_attribute5 IN OUT pa_expenditure_items_all.attribute5%TYPE
775: -- p_attribute6 IN OUT pa_expenditure_items_all.attribute6%TYPE
768: --
769: -- IN/OUT
770: -- p_attribute1 IN OUT pa_expenditure_items_all.attribute1%TYPE
771: -- p_attribute2 IN OUT pa_expenditure_items_all.attribute2%TYPE
772: -- p_attribute3 IN OUT pa_expenditure_items_all.attribute3%TYPE
773: -- p_attribute4 IN OUT pa_expenditure_items_all.attribute4%TYPE
774: -- p_attribute5 IN OUT pa_expenditure_items_all.attribute5%TYPE
775: -- p_attribute6 IN OUT pa_expenditure_items_all.attribute6%TYPE
776: -- p_attribute7 IN OUT pa_expenditure_items_all.attribute7%TYPE
769: -- IN/OUT
770: -- p_attribute1 IN OUT pa_expenditure_items_all.attribute1%TYPE
771: -- p_attribute2 IN OUT pa_expenditure_items_all.attribute2%TYPE
772: -- p_attribute3 IN OUT pa_expenditure_items_all.attribute3%TYPE
773: -- p_attribute4 IN OUT pa_expenditure_items_all.attribute4%TYPE
774: -- p_attribute5 IN OUT pa_expenditure_items_all.attribute5%TYPE
775: -- p_attribute6 IN OUT pa_expenditure_items_all.attribute6%TYPE
776: -- p_attribute7 IN OUT pa_expenditure_items_all.attribute7%TYPE
777: -- p_attribute8 IN OUT pa_expenditure_items_all.attribute8%TYPE
770: -- p_attribute1 IN OUT pa_expenditure_items_all.attribute1%TYPE
771: -- p_attribute2 IN OUT pa_expenditure_items_all.attribute2%TYPE
772: -- p_attribute3 IN OUT pa_expenditure_items_all.attribute3%TYPE
773: -- p_attribute4 IN OUT pa_expenditure_items_all.attribute4%TYPE
774: -- p_attribute5 IN OUT pa_expenditure_items_all.attribute5%TYPE
775: -- p_attribute6 IN OUT pa_expenditure_items_all.attribute6%TYPE
776: -- p_attribute7 IN OUT pa_expenditure_items_all.attribute7%TYPE
777: -- p_attribute8 IN OUT pa_expenditure_items_all.attribute8%TYPE
778: -- p_attribute9 IN OUT pa_expenditure_items_all.attribute9%TYPE
771: -- p_attribute2 IN OUT pa_expenditure_items_all.attribute2%TYPE
772: -- p_attribute3 IN OUT pa_expenditure_items_all.attribute3%TYPE
773: -- p_attribute4 IN OUT pa_expenditure_items_all.attribute4%TYPE
774: -- p_attribute5 IN OUT pa_expenditure_items_all.attribute5%TYPE
775: -- p_attribute6 IN OUT pa_expenditure_items_all.attribute6%TYPE
776: -- p_attribute7 IN OUT pa_expenditure_items_all.attribute7%TYPE
777: -- p_attribute8 IN OUT pa_expenditure_items_all.attribute8%TYPE
778: -- p_attribute9 IN OUT pa_expenditure_items_all.attribute9%TYPE
779: -- p_attribute10 IN OUT pa_expenditure_items_all.attribute10%TYPE
772: -- p_attribute3 IN OUT pa_expenditure_items_all.attribute3%TYPE
773: -- p_attribute4 IN OUT pa_expenditure_items_all.attribute4%TYPE
774: -- p_attribute5 IN OUT pa_expenditure_items_all.attribute5%TYPE
775: -- p_attribute6 IN OUT pa_expenditure_items_all.attribute6%TYPE
776: -- p_attribute7 IN OUT pa_expenditure_items_all.attribute7%TYPE
777: -- p_attribute8 IN OUT pa_expenditure_items_all.attribute8%TYPE
778: -- p_attribute9 IN OUT pa_expenditure_items_all.attribute9%TYPE
779: -- p_attribute10 IN OUT pa_expenditure_items_all.attribute10%TYPE
780: --
773: -- p_attribute4 IN OUT pa_expenditure_items_all.attribute4%TYPE
774: -- p_attribute5 IN OUT pa_expenditure_items_all.attribute5%TYPE
775: -- p_attribute6 IN OUT pa_expenditure_items_all.attribute6%TYPE
776: -- p_attribute7 IN OUT pa_expenditure_items_all.attribute7%TYPE
777: -- p_attribute8 IN OUT pa_expenditure_items_all.attribute8%TYPE
778: -- p_attribute9 IN OUT pa_expenditure_items_all.attribute9%TYPE
779: -- p_attribute10 IN OUT pa_expenditure_items_all.attribute10%TYPE
780: --
781: -- OUT
774: -- p_attribute5 IN OUT pa_expenditure_items_all.attribute5%TYPE
775: -- p_attribute6 IN OUT pa_expenditure_items_all.attribute6%TYPE
776: -- p_attribute7 IN OUT pa_expenditure_items_all.attribute7%TYPE
777: -- p_attribute8 IN OUT pa_expenditure_items_all.attribute8%TYPE
778: -- p_attribute9 IN OUT pa_expenditure_items_all.attribute9%TYPE
779: -- p_attribute10 IN OUT pa_expenditure_items_all.attribute10%TYPE
780: --
781: -- OUT
782: -- x_status_code OUT VARCHAR2
775: -- p_attribute6 IN OUT pa_expenditure_items_all.attribute6%TYPE
776: -- p_attribute7 IN OUT pa_expenditure_items_all.attribute7%TYPE
777: -- p_attribute8 IN OUT pa_expenditure_items_all.attribute8%TYPE
778: -- p_attribute9 IN OUT pa_expenditure_items_all.attribute9%TYPE
779: -- p_attribute10 IN OUT pa_expenditure_items_all.attribute10%TYPE
780: --
781: -- OUT
782: -- x_status_code OUT VARCHAR2
783: -- x_error_message OUT VARCHAR2
783: -- x_error_message OUT VARCHAR2
784: --
785: PROCEDURE validate_dff (
786: p_dff_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
787: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
788: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
789: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
790: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
791: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
784: --
785: PROCEDURE validate_dff (
786: p_dff_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
787: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
788: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
789: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
790: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
791: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
792: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
785: PROCEDURE validate_dff (
786: p_dff_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
787: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
788: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
789: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
790: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
791: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
792: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
793: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
786: p_dff_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
787: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
788: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
789: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
790: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
791: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
792: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
793: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
794: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
787: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
788: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
789: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
790: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
791: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
792: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
793: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
794: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
795: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
788: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%TYPE,
789: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
790: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
791: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
792: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
793: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
794: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
795: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
796: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,
789: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%TYPE,
790: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
791: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
792: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
793: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
794: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
795: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
796: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,
797: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%TYPE,
790: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%TYPE,
791: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
792: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
793: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
794: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
795: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
796: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,
797: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%TYPE,
798: x_status_code OUT NOCOPY VARCHAR2,
791: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%TYPE,
792: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
793: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
794: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
795: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
796: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,
797: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%TYPE,
798: x_status_code OUT NOCOPY VARCHAR2,
799: x_error_message OUT NOCOPY VARCHAR2);
792: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%TYPE,
793: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
794: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
795: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
796: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,
797: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%TYPE,
798: x_status_code OUT NOCOPY VARCHAR2,
799: x_error_message OUT NOCOPY VARCHAR2);
800:
793: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%TYPE,
794: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%TYPE,
795: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%TYPE,
796: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%TYPE,
797: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%TYPE,
798: x_status_code OUT NOCOPY VARCHAR2,
799: x_error_message OUT NOCOPY VARCHAR2);
800:
801: /*--------------------------------------------------------------------------------
811: -- Function : This procedure can be called from an external system
812: -- to check if an item imported to Projects from an external
813: -- system through Transaction Import has been adjusted in Projects.
814: --
815: -- The API will check the pa_expenditure_items_all.net_zero_adjustment_flag for
816: -- the item in Projects.
817: --
818: -- If the net_zero_adjustment_flag = 'Y'then the item has been adjusted
819: -- in Projects and the API will return x_adjustment_status = 'Adjusted'.