APPS.OTA_ADD_TRAINING_SS dependencies on OTA_NOTRNG_HISTORIES

Line 204: ( p_nota_history_id IN OTA_NOTRNG_HISTORIES.NOTA_HISTORY_ID%TYPE

200: --
201: -- {End Of Comments}
202: -- ----------------------------------------------------------------------------
203: PROCEDURE delete_add_training
204: ( p_nota_history_id IN OTA_NOTRNG_HISTORIES.NOTA_HISTORY_ID%TYPE
205: , p_trng_title IN VARCHAR2
206: , p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
207: , p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE
208: , p_message OUT NOCOPY VARCHAR2

Line 555: ( Person_id IN ota_notrng_histories.contact_id%TYPE

551: -- person_id belongs to a Customers' contact and ra_contacts is queried.
552: -- {End Of Comments}
553: -- ----------------------------------------------------------------------------
554: Function get_learner_name
555: ( Person_id IN ota_notrng_histories.contact_id%TYPE
556: ,Organization_id IN ota_notrng_histories.organization_id%TYPE ) RETURN VARCHAR2;
557:
558:
559: -- ----------------------------------------------------------------------------

Line 556: ,Organization_id IN ota_notrng_histories.organization_id%TYPE ) RETURN VARCHAR2;

552: -- {End Of Comments}
553: -- ----------------------------------------------------------------------------
554: Function get_learner_name
555: ( Person_id IN ota_notrng_histories.contact_id%TYPE
556: ,Organization_id IN ota_notrng_histories.organization_id%TYPE ) RETURN VARCHAR2;
557:
558:
559: -- ----------------------------------------------------------------------------
560: -- |-----------------------------< get_custorg_name >--------------------------|

Line 570: FUNCTION get_custorg_name(p_customer_id OTA_NOTRNG_HISTORIES.CUSTOMER_ID%TYPE,

566: -- In Parameters:
567: -- Customer_Id - customer_id of the Customer
568: -- {End Of Comments}
569: -- ----------------------------------------------------------------------------
570: FUNCTION get_custorg_name(p_customer_id OTA_NOTRNG_HISTORIES.CUSTOMER_ID%TYPE,
571: p_organization_id OTA_NOTRNG_HISTORIES.ORGANIZATION_ID%TYPE)
572: RETURN VARCHAR2;
573:
574:

Line 571: p_organization_id OTA_NOTRNG_HISTORIES.ORGANIZATION_ID%TYPE)

567: -- Customer_Id - customer_id of the Customer
568: -- {End Of Comments}
569: -- ----------------------------------------------------------------------------
570: FUNCTION get_custorg_name(p_customer_id OTA_NOTRNG_HISTORIES.CUSTOMER_ID%TYPE,
571: p_organization_id OTA_NOTRNG_HISTORIES.ORGANIZATION_ID%TYPE)
572: RETURN VARCHAR2;
573:
574:
575: END ota_add_training_ss ;