DBA Data[Home] [Help]

APPS.PA_TRANSACTIONS_PUB dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 767: -- p_attribute_category pa_expenditure_items_all.attribute_category%TYPE

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

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

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

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

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

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

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

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

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

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

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

Line 787: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,

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,

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

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

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

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

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

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

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

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

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

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

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

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