APPS.OTA_TFL_API_BUSINESS_RULES2 dependencies on OTA_FINANCE_LINES

Line 1048: ,p_rec_finance_line in out nocopy ota_finance_lines%rowtype

1044: --
1045: Procedure copy_finance_line
1046: (
1047: p_finance_header_id_to in number
1048: ,p_rec_finance_line in out nocopy ota_finance_lines%rowtype
1049: ,p_transaction_type in varchar2
1050: ) is
1051: --
1052: v_proc varchar2(72) := g_package||'copy_finance_line';

Line 1057: l_transfer_date ota_finance_lines.transfer_date%TYPE := null;

1053: l_finance_line_id number := null;
1054: l_finance_header_id number := p_finance_header_id_to;
1055: l_transfer_status varchar2(2) := 'NT';
1056: --Bug 1664464
1057: l_transfer_date ota_finance_lines.transfer_date%TYPE := null;
1058: --Bug 1664464
1059: --
1060: Begin
1061: --

Line 1154: l_rec_finance_line ota_finance_lines%rowtype;

1150: p_finance_header_id_from in number
1151: ,p_finance_header_id_to in number
1152: ) is
1153: --
1154: l_rec_finance_line ota_finance_lines%rowtype;
1155: v_proc varchar2(72) := g_package||'copy_lines_to_new_header';
1156: --
1157: cursor sel_finance_lines is
1158: select *

Line 1159: from ota_finance_lines tfl

1155: v_proc varchar2(72) := g_package||'copy_lines_to_new_header';
1156: --
1157: cursor sel_finance_lines is
1158: select *
1159: from ota_finance_lines tfl
1160: where tfl.finance_header_id = p_finance_header_id_from
1161: and tfl.cancelled_flag = 'N'
1162: order by sequence_number;
1163: --

Line 1222: p_rec_cancel in out nocopy ota_finance_lines%rowtype

1218: -- The new cancelled flag is passed in as a parameter
1219: --
1220: Procedure update_cancel_flag
1221: (
1222: p_rec_cancel in out nocopy ota_finance_lines%rowtype
1223: ,p_new_cancelled_flag in varchar2
1224: ,p_transaction_type in varchar2
1225: ,p_object_version_number in out nocopy number
1226: ) is

Line 1279: v_rec_finance_line ota_finance_lines%rowtype;

1275: p_finance_header_id in number
1276: ,p_new_cancelled_flag in varchar2
1277: ) is
1278: --
1279: v_rec_finance_line ota_finance_lines%rowtype;
1280: l_transaction_type varchar2(30);
1281: v_proc varchar2(72) := g_package||'set_cancel_flag_for_header';
1282: v_ovn number;
1283: --

Line 1286: from ota_finance_lines tfl

1282: v_ovn number;
1283: --
1284: cursor sel_finance_lines is
1285: select *
1286: from ota_finance_lines tfl
1287: where tfl.finance_header_id = p_finance_header_id;
1288: --
1289: Begin
1290: --

Line 1361: v_rec_finance_line ota_finance_lines%rowtype;

1357: ) is
1358: --
1359: v_proc varchar2(72) := g_package||'cancel_finance_line';
1360: v_header_transfer_status varchar2(30);
1361: v_rec_finance_line ota_finance_lines%rowtype;
1362: --
1363: cursor sel_finance_line is
1364: select *
1365: from ota_finance_lines tfl

Line 1365: from ota_finance_lines tfl

1361: v_rec_finance_line ota_finance_lines%rowtype;
1362: --
1363: cursor sel_finance_line is
1364: select *
1365: from ota_finance_lines tfl
1366: where tfl.finance_line_id = p_finance_line_id;
1367: --
1368: cursor sel_finance_header is
1369: select tfh.transfer_status

Line 1533: v_rec_finance_line ota_finance_lines%rowtype;

1529: ) is
1530: --
1531: v_proc varchar2(72) := g_package||'recancel_finance_line';
1532: v_header_transfer_status varchar2(30);
1533: v_rec_finance_line ota_finance_lines%rowtype;
1534: v_ovn number;
1535: --
1536: cursor sel_finance_line is
1537: select *

Line 1538: from ota_finance_lines tfl

1534: v_ovn number;
1535: --
1536: cursor sel_finance_line is
1537: select *
1538: from ota_finance_lines tfl
1539: where tfl.finance_line_id = p_finance_line_id;
1540: --
1541: cursor sel_finance_header is
1542: select tfh.transfer_status

Line 1677: from ota_finance_lines

1673: , date_raised
1674: , object_version_number
1675: , sequence_number
1676: , transfer_status
1677: from ota_finance_lines
1678: where finance_header_id = p_finance_header_id
1679: and ((p_include_cancelled = 'N'
1680: and cancelled_flag = 'N')
1681: or (p_include_cancelled <> 'N'));