APPS.OTA_TDB_BUS2 dependencies on RA_CUSTOMER_TRX_ALL

Line 937: l_commitment_id ra_customer_trx_all.customer_trx_id%TYPE;

933: Procedure check_commitment_date
934: (p_line_id in number
935: ,p_event_id in number
936: ) is
937: l_commitment_id ra_customer_trx_all.customer_trx_id%TYPE;
938: l_commitment_number ra_customer_trx_all.trx_number%TYPE;
939: l_commitment_end_date ra_customer_trx_all.end_date_commitment%TYPE;
940: l_commitment_start_date ra_customer_trx_all.start_date_commitment%TYPE;
941: l_event_end_date ota_events.course_end_date%TYPE;

Line 938: l_commitment_number ra_customer_trx_all.trx_number%TYPE;

934: (p_line_id in number
935: ,p_event_id in number
936: ) is
937: l_commitment_id ra_customer_trx_all.customer_trx_id%TYPE;
938: l_commitment_number ra_customer_trx_all.trx_number%TYPE;
939: l_commitment_end_date ra_customer_trx_all.end_date_commitment%TYPE;
940: l_commitment_start_date ra_customer_trx_all.start_date_commitment%TYPE;
941: l_event_end_date ota_events.course_end_date%TYPE;
942: --

Line 939: l_commitment_end_date ra_customer_trx_all.end_date_commitment%TYPE;

935: ,p_event_id in number
936: ) is
937: l_commitment_id ra_customer_trx_all.customer_trx_id%TYPE;
938: l_commitment_number ra_customer_trx_all.trx_number%TYPE;
939: l_commitment_end_date ra_customer_trx_all.end_date_commitment%TYPE;
940: l_commitment_start_date ra_customer_trx_all.start_date_commitment%TYPE;
941: l_event_end_date ota_events.course_end_date%TYPE;
942: --
943: CURSOR c_event

Line 940: l_commitment_start_date ra_customer_trx_all.start_date_commitment%TYPE;

936: ) is
937: l_commitment_id ra_customer_trx_all.customer_trx_id%TYPE;
938: l_commitment_number ra_customer_trx_all.trx_number%TYPE;
939: l_commitment_end_date ra_customer_trx_all.end_date_commitment%TYPE;
940: l_commitment_start_date ra_customer_trx_all.start_date_commitment%TYPE;
941: l_event_end_date ota_events.course_end_date%TYPE;
942: --
943: CURSOR c_event
944: IS SELECT course_end_date