DBA Data[Home] [Help]

APPS.PA_GMS_API dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 119: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE

115: this expenditure item.
116: The function returns NULL if no award is associated with the expenditure item.
117: */
118: FUNCTION VERT_GET_AWARD_NUMBER(
119: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
120: ) RETURN VARCHAR2;
121:
122: /* Added for Bug 5490120
123: This function accepts the expenditure_item_id as the input.

Line 134: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE

130: If award range is not specified then the function returns 'Y'
131: If award range is specified then the function returns 'N'
132: */
133: FUNCTION VERT_IS_AWARD_WITHIN_RANGE(
134: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
135: ,p_from_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
136: ,p_to_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
137: ) RETURN VARCHAR2;
138: