APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_FINANCE

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 810: ota_finance.maintain_finance_line(p_finance_header_id => l_finance_header_id,

806: end if;
807:
808: if l_create_finance_line = 'Y' then
809: --
810: ota_finance.maintain_finance_line(p_finance_header_id => l_finance_header_id,
811: p_booking_id => p_booking_id ,
812: p_currency_code => l_currency_code ,
813: p_standard_amount => p_standard_amount,
814: p_unitary_amount => p_unitary_amount ,

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

Line 2713: ota_finance.maintain_finance_line

2709: IF l_cancelled_flag <> 'Y' OR c_get_fin_line_status%NOTFOUND THEN
2710: IF (p_update_finance_line = 'C') THEN
2711: OTA_LEARNER_ENROLL_SS.cancel_finance(p_booking_id); --Bug#7110214
2712: ELSE
2713: ota_finance.maintain_finance_line
2714: (p_finance_header_id => p_finance_header_id,
2715: p_booking_id => p_booking_id ,
2716: p_currency_code => p_currency_code ,
2717: p_standard_amount => p_standard_amount,