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_TDB_BUS dependencies on PER_LETTER_REQUESTS

Line 2654: select per_letter_requests_s.nextval

2650: FUNCTION get_letter_request_id (p_letter_type_id in number,
2651: p_event_id in number) return number IS
2652: --
2653: Cursor c_next_id is
2654: select per_letter_requests_s.nextval
2655: from dual;
2656: --
2657: l_request_id number(15);
2658:

Line 2668: insert into per_letter_requests

2664: open c_next_id;
2665: fetch c_next_id into l_request_id;
2666: close c_next_id;
2667: --
2668: insert into per_letter_requests
2669: (letter_request_id
2670: ,business_group_id
2671: ,letter_type_id
2672: ,date_from

Line 2696: from per_letter_requests

2692: /***FUNCTION get_letter_request_id (p_letter_type_id in number) return number IS
2693: --
2694: Cursor c_request is
2695: select letter_request_id
2696: from per_letter_requests
2697: where letter_type_id = p_letter_type_id
2698: and request_status = 'PENDING';
2699: --
2700: Cursor c_next_id is

Line 2701: select per_letter_requests_s.nextval

2697: where letter_type_id = p_letter_type_id
2698: and request_status = 'PENDING';
2699: --
2700: Cursor c_next_id is
2701: select per_letter_requests_s.nextval
2702: from dual;
2703: --
2704: l_request_id number(15);
2705: l_proc varchar2(72) := g_package||'get_letter_request_id';

Line 2719: insert into per_letter_requests

2715: open c_next_id;
2716: fetch c_next_id into l_request_id;
2717: close c_next_id;
2718: --
2719: insert into per_letter_requests
2720: (letter_request_id
2721: ,business_group_id
2722: ,letter_type_id
2723: ,date_from

Line 2759: l_letter_request_id per_letter_requests.letter_request_id%TYPE;

2755: --
2756: l_dummy varchar2 (1);
2757: l_found boolean := true;
2758:
2759: l_letter_request_id per_letter_requests.letter_request_id%TYPE;
2760: l_letter_req_id per_letter_requests.letter_request_id%TYPE;
2761: l_letter_type_id per_letter_types.letter_type_id%TYPE;
2762: l_business_group_id per_letter_types.business_group_id%TYPE;
2763: l_event_id number;

Line 2760: l_letter_req_id per_letter_requests.letter_request_id%TYPE;

2756: l_dummy varchar2 (1);
2757: l_found boolean := true;
2758:
2759: l_letter_request_id per_letter_requests.letter_request_id%TYPE;
2760: l_letter_req_id per_letter_requests.letter_request_id%TYPE;
2761: l_letter_type_id per_letter_types.letter_type_id%TYPE;
2762: l_business_group_id per_letter_types.business_group_id%TYPE;
2763: l_event_id number;
2764: --

Line 2772: per_letter_requests c

2768: select b.letter_type_id,
2769: c.letter_request_id
2770: from per_letter_gen_statuses a,
2771: per_letter_types b,
2772: per_letter_requests c
2773: where a.assignment_status_type_id = p_booking_status_type_id
2774: and b.letter_type_id = a.letter_type_id
2775: and b.generation_status_type = 'OTA_BOOKING'
2776: and c.letter_type_id = b.letter_type_id

Line 2787: per_letter_requests c

2783: select b.letter_type_id,
2784: c.letter_request_id
2785: from per_letter_gen_statuses a,
2786: per_letter_types b,
2787: per_letter_requests c
2788: where a.assignment_status_type_id = p_booking_status_type_id
2789: and b.letter_type_id = a.letter_type_id
2790: and b.generation_status_type = 'OTA_BOOKING'
2791: and c.letter_type_id = b.letter_type_id

Line 2923: from per_letter_requests

2919: and b.generation_status_type = 'OTA_BOOKING';
2920: --
2921: cursor c_requests (p_letter_type_id in number) is
2922: select letter_request_id
2923: from per_letter_requests
2924: where letter_type_id = p_letter_type_id
2925: and request_status = 'PENDING'
2926: and auto_or_manual = 'AUTO';
2927: --