DBA Data[Home] [Help]

APPS.PA_GMS_API dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 363: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE

359: this expenditure item.
360: The function returns NULL if no award is associated with the expenditure item.
361: */
362: FUNCTION VERT_GET_AWARD_NUMBER(
363: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
364: ) RETURN VARCHAR2 IS
365: BEGIN
366: IF NOT PA_GMS_API.VERT_INSTALL THEN
367: RETURN NULL;

Line 390: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE

386: If award range is not specified then the function returns 'Y'
387: If award range is specified then the function returns 'N'
388: */
389: FUNCTION VERT_IS_AWARD_WITHIN_RANGE(
390: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
391: ,p_from_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
392: ,p_to_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
393: ) RETURN VARCHAR2 IS
394: BEGIN