APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_FINANCE

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

963: end if;
964:
965: if l_create_finance_line = 'Y' then
966: --
967: ota_finance.maintain_finance_line(p_finance_header_id => l_finance_header_id,
968: p_booking_id => p_booking_id ,
969: p_currency_code => l_currency_code ,
970: p_standard_amount => p_standard_amount,
971: p_unitary_amount => p_unitary_amount ,

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

Line 2916: ota_finance.maintain_finance_line

2912: IF l_cancelled_flag <> 'Y' OR c_get_fin_line_status%NOTFOUND THEN
2913: IF (p_update_finance_line = 'C') THEN
2914: OTA_LEARNER_ENROLL_SS.cancel_finance(p_booking_id); --Bug#7110214
2915: ELSE
2916: ota_finance.maintain_finance_line
2917: (p_finance_header_id => p_finance_header_id,
2918: p_booking_id => p_booking_id ,
2919: p_currency_code => p_currency_code ,
2920: p_standard_amount => p_standard_amount,