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