APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_FINANCE_LINES

Line 157: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

153: l_cost_allocation_keyflex_id VARCHAR2(1000);
154: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
155: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
156:
157: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
158: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
159: fapi_result VARCHAR2(40);
160: fapi_from VARCHAR2(5);
161: fapi_to VARCHAR2(5);

Line 158: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

154: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
155: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
156:
157: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
158: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
159: fapi_result VARCHAR2(40);
160: fapi_from VARCHAR2(5);
161: fapi_to VARCHAR2(5);
162:

Line 823: UPDATE ota_finance_lines SET transfer_status = 'AT'

819: p_finance_line_id => p_finance_line_id);
820:
821: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
822: if l_automatic_transfer_gl = 'Y' AND p_finance_line_id IS NOT NULL THEN
823: UPDATE ota_finance_lines SET transfer_status = 'AT'
824: WHERE finance_line_id = p_finance_line_id;
825: end if;
826: --
827: end if;

Line 1708: FROM ota_finance_lines

1704: l_evt_status_chg_comments varchar2(1000) := fnd_message.get_string('OTA','OTA_13523_TDB_STATUS_COMMENTS');
1705:
1706: CURSOR c_get_fin_line_status IS
1707: SELECT cancelled_flag
1708: FROM ota_finance_lines
1709: WHERE finance_line_id = p_finance_line_id;
1710:
1711: l_cancelled_flag ota_finance_lines.cancelled_flag%TYPE;
1712: --Bug 6683076

Line 1711: l_cancelled_flag ota_finance_lines.cancelled_flag%TYPE;

1707: SELECT cancelled_flag
1708: FROM ota_finance_lines
1709: WHERE finance_line_id = p_finance_line_id;
1710:
1711: l_cancelled_flag ota_finance_lines.cancelled_flag%TYPE;
1712: --Bug 6683076
1713: Cursor c_eval_info is
1714: select evt_eval.evaluation_id evt_eval_id,decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1715: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag, --bug 7184369,6935364,7174996