eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LEARNER_ENROLL_SS dependencies on OTA_FINANCE_LINES

Line 148: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;

144: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
145: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
146: l_object_version_number BINARY_INTEGER;
147: l_tfl_ovn BINARY_INTEGER;
148: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
149: l_booking_type VARCHAR2(4000);
150: l_error_crypt VARCHAR2(4000);
151: --
152: l_mode VARCHAR2(200);

Line 160: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

156: -- -------------------
157: -- Finance API Vars
158: -- -------------------
159: l_auto_create_finance VARCHAR2(40);
160: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
161: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
162: fapi_result VARCHAR2(40);
163: fapi_from VARCHAR2(5);
164: fapi_to VARCHAR2(5);

Line 161: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

157: -- Finance API Vars
158: -- -------------------
159: l_auto_create_finance VARCHAR2(40);
160: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
161: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
162: fapi_result VARCHAR2(40);
163: fapi_from VARCHAR2(5);
164: fapi_to VARCHAR2(5);
165:

Line 166: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

162: fapi_result VARCHAR2(40);
163: fapi_from VARCHAR2(5);
164: fapi_to VARCHAR2(5);
165:
166: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
167: result_create_finance_line VARCHAR2(5) := 'Y';
168: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
169:
170: l_logged_in_user NUMBER;

Line 168: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

164: fapi_to VARCHAR2(5);
165:
166: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
167: result_create_finance_line VARCHAR2(5) := 'Y';
168: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
169:
170: l_logged_in_user NUMBER;
171: l_user NUMBER;
172: l_automatic_transfer_gl VARCHAR2(40);

Line 576: UPDATE ota_finance_lines SET transfer_status = 'AT'

572:
573:
574: IF l_automatic_transfer_gl = 'Y' AND l_finance_line_id IS NOT NULL AND l_offering_id is null THEN
575:
576: UPDATE ota_finance_lines SET transfer_status = 'AT'
577: WHERE finance_line_id = l_finance_line_id;
578:
579:
580:

Line 694: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;

690:
691: -- ------------------------
692: -- Finance_cur Variables
693: -- ------------------------
694: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
695: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
696: l_transfer_status ota_finance_lines.transfer_status%TYPE;
697: lf_booking_id ota_finance_lines.booking_id%TYPE;
698: lf_object_version_number ota_finance_lines.object_version_number%TYPE;

Line 695: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;

691: -- ------------------------
692: -- Finance_cur Variables
693: -- ------------------------
694: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
695: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
696: l_transfer_status ota_finance_lines.transfer_status%TYPE;
697: lf_booking_id ota_finance_lines.booking_id%TYPE;
698: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
699: l_sequence_number ota_finance_lines.sequence_number%TYPE;

Line 696: l_transfer_status ota_finance_lines.transfer_status%TYPE;

692: -- Finance_cur Variables
693: -- ------------------------
694: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
695: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
696: l_transfer_status ota_finance_lines.transfer_status%TYPE;
697: lf_booking_id ota_finance_lines.booking_id%TYPE;
698: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
699: l_sequence_number ota_finance_lines.sequence_number%TYPE;
700: l_raised_date date;

Line 697: lf_booking_id ota_finance_lines.booking_id%TYPE;

693: -- ------------------------
694: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
695: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
696: l_transfer_status ota_finance_lines.transfer_status%TYPE;
697: lf_booking_id ota_finance_lines.booking_id%TYPE;
698: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
699: l_sequence_number ota_finance_lines.sequence_number%TYPE;
700: l_raised_date date;
701: l_finance_count number(10);

Line 698: lf_object_version_number ota_finance_lines.object_version_number%TYPE;

694: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
695: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
696: l_transfer_status ota_finance_lines.transfer_status%TYPE;
697: lf_booking_id ota_finance_lines.booking_id%TYPE;
698: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
699: l_sequence_number ota_finance_lines.sequence_number%TYPE;
700: l_raised_date date;
701: l_finance_count number(10);
702: l_cancelled_flag ota_finance_lines.cancelled_flag%type;

Line 699: l_sequence_number ota_finance_lines.sequence_number%TYPE;

695: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
696: l_transfer_status ota_finance_lines.transfer_status%TYPE;
697: lf_booking_id ota_finance_lines.booking_id%TYPE;
698: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
699: l_sequence_number ota_finance_lines.sequence_number%TYPE;
700: l_raised_date date;
701: l_finance_count number(10);
702: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
703: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;

Line 702: l_cancelled_flag ota_finance_lines.cancelled_flag%type;

698: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
699: l_sequence_number ota_finance_lines.sequence_number%TYPE;
700: l_raised_date date;
701: l_finance_count number(10);
702: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
703: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
704: -- ------------------------
705: -- header_cur Variables
706: -- ------------------------

Line 726: CURSOR finance (p_booking_id ota_finance_lines.booking_id%TYPE) IS

722: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
723: l_tmp_booking_id ota_delegate_bookings.booking_id%TYPE;
724: l_cancel_boolean BOOLEAN;
725:
726: CURSOR finance (p_booking_id ota_finance_lines.booking_id%TYPE) IS
727: SELECT FLN.finance_line_id finance_line_id,
728: FLN.finance_header_id finance_header_id,
729: FLN.transfer_status transfer_status,
730: FLN.booking_id booking_id,

Line 734: FROM OTA_FINANCE_LINES FLN

730: FLN.booking_id booking_id,
731: FLN.object_version_number object_version_number,
732: FLN.sequence_number sequence_number,
733: FLN.Cancelled_flag cancelled_flag
734: FROM OTA_FINANCE_LINES FLN
735: WHERE FLN.booking_id = p_booking_id;
736:
737: CURSOR finance_count (p_finance_header_id ota_finance_lines.finance_header_id%TYPE) IS
738: SELECT count(*)

Line 737: CURSOR finance_count (p_finance_header_id ota_finance_lines.finance_header_id%TYPE) IS

733: FLN.Cancelled_flag cancelled_flag
734: FROM OTA_FINANCE_LINES FLN
735: WHERE FLN.booking_id = p_booking_id;
736:
737: CURSOR finance_count (p_finance_header_id ota_finance_lines.finance_header_id%TYPE) IS
738: SELECT count(*)
739: FROM OTA_FINANCE_LINES FLN
740: WHERE FLN.finance_header_id = p_finance_header_id;
741:

Line 739: FROM OTA_FINANCE_LINES FLN

735: WHERE FLN.booking_id = p_booking_id;
736:
737: CURSOR finance_count (p_finance_header_id ota_finance_lines.finance_header_id%TYPE) IS
738: SELECT count(*)
739: FROM OTA_FINANCE_LINES FLN
740: WHERE FLN.finance_header_id = p_finance_header_id;
741:
742: CURSOR header (p_booking_id ota_finance_lines.booking_id%TYPE) IS
743: SELECT FLH.finance_header_id finance_header_id,

Line 742: CURSOR header (p_booking_id ota_finance_lines.booking_id%TYPE) IS

738: SELECT count(*)
739: FROM OTA_FINANCE_LINES FLN
740: WHERE FLN.finance_header_id = p_finance_header_id;
741:
742: CURSOR header (p_booking_id ota_finance_lines.booking_id%TYPE) IS
743: SELECT FLH.finance_header_id finance_header_id,
744: FLH.cancelled_flag cancelled_flag,
745: FLH.transfer_status transfer_status,
746: FLH.object_version_number object_version_number

Line 748: OTA_FINANCE_LINES FLN

744: FLH.cancelled_flag cancelled_flag,
745: FLH.transfer_status transfer_status,
746: FLH.object_version_number object_version_number
747: FROM OTA_FINANCE_HEADERS FLH,
748: OTA_FINANCE_LINES FLN
749: WHERE FLH.finance_header_id = FLN.finance_header_id
750: AND FLN.booking_id = p_booking_id;
751:
752: CURSOR event_csr (p_event_id ota_events.event_id%TYPE) IS

Line 1822: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;

1818:
1819: -- ------------------------
1820: -- Finance_csr Variables
1821: -- ------------------------
1822: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
1823: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
1824: l_transfer_status ota_finance_lines.transfer_status%TYPE;
1825: lf_booking_id ota_finance_lines.booking_id%TYPE;
1826: lf_object_version_number ota_finance_lines.object_version_number%TYPE;

Line 1823: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;

1819: -- ------------------------
1820: -- Finance_csr Variables
1821: -- ------------------------
1822: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
1823: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
1824: l_transfer_status ota_finance_lines.transfer_status%TYPE;
1825: lf_booking_id ota_finance_lines.booking_id%TYPE;
1826: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
1827: l_sequence_number ota_finance_lines.sequence_number%TYPE;

Line 1824: l_transfer_status ota_finance_lines.transfer_status%TYPE;

1820: -- Finance_csr Variables
1821: -- ------------------------
1822: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
1823: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
1824: l_transfer_status ota_finance_lines.transfer_status%TYPE;
1825: lf_booking_id ota_finance_lines.booking_id%TYPE;
1826: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
1827: l_sequence_number ota_finance_lines.sequence_number%TYPE;
1828: l_finance_count number(10);

Line 1825: lf_booking_id ota_finance_lines.booking_id%TYPE;

1821: -- ------------------------
1822: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
1823: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
1824: l_transfer_status ota_finance_lines.transfer_status%TYPE;
1825: lf_booking_id ota_finance_lines.booking_id%TYPE;
1826: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
1827: l_sequence_number ota_finance_lines.sequence_number%TYPE;
1828: l_finance_count number(10);
1829: l_cancelled_flag ota_finance_lines.cancelled_flag%type;

Line 1826: lf_object_version_number ota_finance_lines.object_version_number%TYPE;

1822: l_finance_line_id ota_finance_lines.finance_line_id%TYPE;
1823: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
1824: l_transfer_status ota_finance_lines.transfer_status%TYPE;
1825: lf_booking_id ota_finance_lines.booking_id%TYPE;
1826: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
1827: l_sequence_number ota_finance_lines.sequence_number%TYPE;
1828: l_finance_count number(10);
1829: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
1830: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;

Line 1827: l_sequence_number ota_finance_lines.sequence_number%TYPE;

1823: l_finance_header_id ota_finance_lines.finance_header_id%TYPE;
1824: l_transfer_status ota_finance_lines.transfer_status%TYPE;
1825: lf_booking_id ota_finance_lines.booking_id%TYPE;
1826: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
1827: l_sequence_number ota_finance_lines.sequence_number%TYPE;
1828: l_finance_count number(10);
1829: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
1830: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
1831:

Line 1829: l_cancelled_flag ota_finance_lines.cancelled_flag%type;

1825: lf_booking_id ota_finance_lines.booking_id%TYPE;
1826: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
1827: l_sequence_number ota_finance_lines.sequence_number%TYPE;
1828: l_finance_count number(10);
1829: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
1830: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
1831:
1832: -- ------------------------
1833: -- header_csr Variables

Line 1875: CURSOR finance_csr (p_booking_id ota_finance_lines.booking_id%TYPE)

1871: SELECT b.date_booking_placed, b.content_player_status, b.object_version_number
1872: FROM ota_delegate_bookings b
1873: WHERE b.booking_id = p_booking_id;
1874:
1875: CURSOR finance_csr (p_booking_id ota_finance_lines.booking_id%TYPE)
1876: IS
1877: SELECT fln.finance_line_id finance_line_id,
1878: fln.finance_header_id finance_header_id,
1879: fln.transfer_status transfer_status,

Line 1884: FROM ota_finance_lines fln

1880: fln.booking_id booking_id,
1881: fln.object_version_number object_version_number,
1882: fln.sequence_number sequence_number,
1883: fln.Cancelled_flag cancelled_flag
1884: FROM ota_finance_lines fln
1885: WHERE fln.booking_id = p_booking_id;
1886:
1887: CURSOR finance_count_csr (p_finance_header_id ota_finance_lines.finance_header_id%TYPE)
1888: IS

Line 1887: CURSOR finance_count_csr (p_finance_header_id ota_finance_lines.finance_header_id%TYPE)

1883: fln.Cancelled_flag cancelled_flag
1884: FROM ota_finance_lines fln
1885: WHERE fln.booking_id = p_booking_id;
1886:
1887: CURSOR finance_count_csr (p_finance_header_id ota_finance_lines.finance_header_id%TYPE)
1888: IS
1889: SELECT count(finance_line_id)
1890: FROM ota_finance_lines fln
1891: WHERE fln.finance_header_id = p_finance_header_id;

Line 1890: FROM ota_finance_lines fln

1886:
1887: CURSOR finance_count_csr (p_finance_header_id ota_finance_lines.finance_header_id%TYPE)
1888: IS
1889: SELECT count(finance_line_id)
1890: FROM ota_finance_lines fln
1891: WHERE fln.finance_header_id = p_finance_header_id;
1892:
1893: CURSOR header_csr (p_booking_id ota_finance_lines.booking_id%TYPE)
1894: IS

Line 1893: CURSOR header_csr (p_booking_id ota_finance_lines.booking_id%TYPE)

1889: SELECT count(finance_line_id)
1890: FROM ota_finance_lines fln
1891: WHERE fln.finance_header_id = p_finance_header_id;
1892:
1893: CURSOR header_csr (p_booking_id ota_finance_lines.booking_id%TYPE)
1894: IS
1895: SELECT flh.finance_header_id finance_header_id,
1896: flh.cancelled_flag cancelled_flag,
1897: flh.transfer_status transfer_status,

Line 1900: ota_finance_lines fln

1896: flh.cancelled_flag cancelled_flag,
1897: flh.transfer_status transfer_status,
1898: flh.object_version_number object_version_number
1899: FROM ota_finance_headers flh,
1900: ota_finance_lines fln
1901: WHERE flh.finance_header_id = fln.finance_header_id
1902: AND fln.booking_id = p_booking_id;
1903:
1904: CURSOR C_USER(p_owner_id NUMBER) IS