APPS.OTA_COST_TRANSFER_TO_GL_PKG dependencies on OTA_FINANCE_HEADERS

Line 45: l_finance_header_id OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%type;

41: l_upd_line VARCHAR2(1);
42: l_pay_desc VARCHAR2(35) := 'ota_paying_cc_batch_generated';
43: l_rec_desc VARCHAR2(35) := 'ota_receiving_cc_batch_generated';
44: l_value fnd_profile_option_values.profile_option_value%TYPE;
45: l_finance_header_id OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%type;
46: l_exist varchar2(1);
47: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
48: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
49: l_business_group_id ota_delegate_bookings.business_group_id%type:= null;

Line 186: FROM ota_finance_headers ofh

182: ofh.TO_SEGMENT29,
183: ofh.TO_SEGMENT30,
184: ofh.TRANSFER_FROM_CC_ID,
185: ofh.TRANSFER_TO_CC_ID
186: FROM ota_finance_headers ofh
187: WHERE ofh.TYPE = 'CT'
188: AND ofh.TRANSFER_STATUS = 'AT'
189: AND ofh.CANCELLED_FLAG = 'N'
190: ORDER BY

Line 299: FROM ota_finance_headers

295:
296: CURSOR FH_LOCK
297: IS
298: SELECT Finance_header_id
299: FROM ota_finance_headers
300: WHERE Finance_header_id = l_finance_header_id
301: FOR UPDATE;
302:
303: ---*** Added FL_RESOURCE ,FL_CHECK and CHK_ENR_RES Cursor definitions --Bug#2457158

Line 326: CURSOR chk_Enr_Res(p_finance_header_id ota_finance_headers.finance_header_id%TYPE)

322: WHERE fl.finance_header_id = l_finance_header_id and
323: fl.resource_booking_id is not null and
324: fl.cancelled_flag = 'N';
325:
326: CURSOR chk_Enr_Res(p_finance_header_id ota_finance_headers.finance_header_id%TYPE)
327: IS
328: SELECT count(booking_id),
329: count(resource_booking_id)
330: FROM ota_finance_lines

Line 359: -- Main Loop for ota_finance_headers table

355: | Create GL Lines for each OTA Finance Header and Finance Lines |
356: | |
357: *======================================================================*/
358: --
359: -- Main Loop for ota_finance_headers table
360: --
361: FOR ota_fh_row IN ota_fh_csr
362: LOOP
363: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering Finance Header :'

Line 1000: -- Update OTA Finance Headers for Cost Transfer

996: return(l_success);
997: --
998: END otagli;
999: --
1000: -- Update OTA Finance Headers for Cost Transfer
1001: --
1002:
1003: -- ----------------------------------------------------------------------------
1004: -- |---------------------------------< Upd_ota_header >----------------------|

Line 1049: UPDATE ota_finance_headers

1045: ,p_transfer_date => SYSDATE
1046: ,p_validate => False
1047: ,p_Transaction_type => 'UPDATE'); */
1048:
1049: UPDATE ota_finance_headers
1050: SET last_update_date = SYSDATE
1051: ,last_updated_by = v_user_id
1052: ,last_update_login = v_login_id
1053: ,transfer_status = 'ST'