DBA Data[Home] [Help]

APPS.PA_TRANSACTIONS_PUB dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 761: -- p_attribute_category pa_expenditure_items_all.attribute_category%TYPE

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

Line 764: -- p_attribute1 IN OUT pa_expenditure_items_all.attribute1%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

Line 765: -- p_attribute2 IN OUT pa_expenditure_items_all.attribute2%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

Line 766: -- p_attribute3 IN OUT pa_expenditure_items_all.attribute3%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

Line 767: -- p_attribute4 IN OUT pa_expenditure_items_all.attribute4%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

Line 768: -- p_attribute5 IN OUT pa_expenditure_items_all.attribute5%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

Line 769: -- p_attribute6 IN OUT pa_expenditure_items_all.attribute6%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

Line 770: -- p_attribute7 IN OUT pa_expenditure_items_all.attribute7%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: --

Line 771: -- p_attribute8 IN OUT pa_expenditure_items_all.attribute8%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: --
775: -- OUT

Line 772: -- p_attribute9 IN OUT pa_expenditure_items_all.attribute9%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
776: -- x_status_code OUT VARCHAR2

Line 773: -- p_attribute10 IN OUT pa_expenditure_items_all.attribute10%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
777: -- x_error_message OUT VARCHAR2

Line 781: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,

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,

Line 782: p_attribute1 IN OUT NOCOPY pa_expenditure_items_all.attribute1%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,

Line 783: p_attribute2 IN OUT NOCOPY pa_expenditure_items_all.attribute2%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,

Line 784: p_attribute3 IN OUT NOCOPY pa_expenditure_items_all.attribute3%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,

Line 785: p_attribute4 IN OUT NOCOPY pa_expenditure_items_all.attribute4%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,

Line 786: p_attribute5 IN OUT NOCOPY pa_expenditure_items_all.attribute5%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,

Line 787: p_attribute6 IN OUT NOCOPY pa_expenditure_items_all.attribute6%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,

Line 788: p_attribute7 IN OUT NOCOPY pa_expenditure_items_all.attribute7%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,

Line 789: p_attribute8 IN OUT NOCOPY pa_expenditure_items_all.attribute8%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,
793: x_error_message OUT NOCOPY VARCHAR2);

Line 790: p_attribute9 IN OUT NOCOPY pa_expenditure_items_all.attribute9%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);
794:

Line 791: p_attribute10 IN OUT NOCOPY pa_expenditure_items_all.attribute10%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:
795: /*--------------------------------------------------------------------------------

Line 809: -- The API will check the pa_expenditure_items_all.net_zero_adjustment_flag for

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'.