APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_FINANCE_LINES

Line 169: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

165: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
166: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
167: l_booking_status_type varchar2(10);
168:
169: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
170: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
171: fapi_result VARCHAR2(40);
172: fapi_from VARCHAR2(5);
173: fapi_to VARCHAR2(5);

Line 170: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

166: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
167: l_booking_status_type varchar2(10);
168:
169: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
170: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
171: fapi_result VARCHAR2(40);
172: fapi_from VARCHAR2(5);
173: fapi_to VARCHAR2(5);
174:

Line 980: UPDATE ota_finance_lines SET transfer_status = 'AT'

976: p_finance_line_id => p_finance_line_id);
977:
978: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
979: if l_automatic_transfer_gl = 'Y' AND p_finance_line_id IS NOT NULL THEN
980: UPDATE ota_finance_lines SET transfer_status = 'AT'
981: WHERE finance_line_id = p_finance_line_id;
982: end if;
983: --
984: end if;

Line 1878: FROM ota_finance_lines

1874: l_evt_status_chg_comments varchar2(1000) := fnd_message.get_string('OTA','OTA_13523_TDB_STATUS_COMMENTS');
1875:
1876: CURSOR c_get_fin_line_status IS
1877: SELECT cancelled_flag
1878: FROM ota_finance_lines
1879: WHERE finance_line_id = p_finance_line_id;
1880:
1881: l_cancelled_flag ota_finance_lines.cancelled_flag%TYPE;
1882: --Bug 6683076

Line 1881: l_cancelled_flag ota_finance_lines.cancelled_flag%TYPE;

1877: SELECT cancelled_flag
1878: FROM ota_finance_lines
1879: WHERE finance_line_id = p_finance_line_id;
1880:
1881: l_cancelled_flag ota_finance_lines.cancelled_flag%TYPE;
1882: --Bug 6683076
1883: Cursor c_eval_info is
1884: select evt_eval.evaluation_id evt_eval_id,decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1885: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag, --bug 7184369,6935364,7174996