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_TYPES

Line 2683: from per_letter_types a

2679: , sysdate
2680: , 'PENDING'
2681: , 'AUTO'
2682: , p_event_id
2683: from per_letter_types a
2684: where a.letter_type_id = p_letter_type_id;
2685: --
2686: --
2687: RETURN l_request_id;

Line 2732: from per_letter_types a

2728: , p_letter_type_id
2729: , sysdate
2730: , 'PENDING'
2731: , 'AUTO'
2732: from per_letter_types a
2733: where a.letter_type_id = p_letter_type_id;
2734: --
2735: end if;
2736: --

Line 2761: l_letter_type_id per_letter_types.letter_type_id%TYPE;

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: --
2765:

Line 2762: l_business_group_id per_letter_types.business_group_id%TYPE;

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: --
2765:
2766:

Line 2771: per_letter_types b,

2767: Cursor c_letter_requests_evt(cp_status_id in number) is
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'

Line 2786: per_letter_types b,

2782: Cursor c_letter_requests(cp_status_id in number) is
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'

Line 2800: per_letter_types b

2796: --
2797: CURSOR c_letters (cp_status_id in number) IS
2798: select a.letter_type_id
2799: from per_letter_gen_statuses a,
2800: per_letter_types b
2801: where a.assignment_status_type_id = cp_status_id
2802: and b.letter_type_id = a.letter_type_id
2803: and b.generation_status_type = 'OTA_BOOKING'
2804: and a.enabled_flag='Y'; ---***added for bug#2791524;

Line 2916: , per_letter_types b

2912: CURSOR c_letters (cp_status_id in number) IS
2913: select a.letter_type_id
2914: , a.business_group_id
2915: from per_letter_gen_statuses a
2916: , per_letter_types b
2917: where a.assignment_status_type_id = cp_status_id
2918: and b.letter_type_id = a.letter_type_id
2919: and b.generation_status_type = 'OTA_BOOKING';
2920: --