DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKL_ARINTF_PVT

Line 656: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type

652: x_return_status OUT NOCOPY VARCHAR2
653: --start: | 02-APR-07 cklee R12 Billing enhancement project |
654: -- ,r_xsiv_rec IN Okl_Ext_Sell_Invs_Pub.xsiv_rec_type
655: -- ,r_xlsv_rec IN Okl_Xtl_Sell_Invs_Pub.xlsv_rec_type
656: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type
657: --end: | 02-APR-07 cklee R12 Billing enhancement project |
658: -- rkuttiya added for bug 7209767
659: ,p_source IN VARCHAR2
660: ,l_trx_header_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_header_tbl_type

Line 802: lxfer_rec OKL_ARINTF_PVT.xfer_rec_type;

798: where cle.id = p_cle_id;
799:
800: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
801:
802: lxfer_rec OKL_ARINTF_PVT.xfer_rec_type;
803:
804: -- rmunjulu R12 Fixes
805: l_customer_address_id OKL_TRX_AR_INVOICES_V.ibt_id%TYPE;
806: l_customer_bank_account_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;

Line 1109: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type

1105: ,p_num IN NUMBER
1106: --start: | 02-APR-07 cklee R12 Billing enhancement project |
1107: -- ,r_xsiv_rec IN Okl_Ext_Sell_Invs_Pub.xsiv_rec_type
1108: -- ,r_xlsv_rec IN Okl_Xtl_Sell_Invs_Pub.xlsv_rec_type
1109: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type
1110: --end: | 02-APR-07 cklee R12 Billing enhancement project |
1111: ,l_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type)
1112: IS
1113:

Line 1263: -- Migrated logic from okl_arintf_pvt

1259:
1260: l_reason_code VARCHAR2(30);
1261:
1262: --start: 02-APR-07 cklee R12 Billing enhancement project |
1263: -- Migrated logic from okl_arintf_pvt
1264: CURSOR get_memo_line_id_csr IS
1265: SELECT MEMO_LINE_ID
1266: FROM ar_memo_lines
1267: WHERE NAME = 'Lease Upfront Tax';

Line 1308: lxfer_rec OKL_ARINTF_PVT.xfer_rec_type;

1304: l_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
1305: l_use_inv_org VARCHAR2(10) := NULL;
1306: --end: 02-APR-07 cklee R12 Billing enhancement project |
1307:
1308: lxfer_rec OKL_ARINTF_PVT.xfer_rec_type;
1309:
1310: BEGIN
1311:
1312: -- Assign to local record

Line 1318: -- Migrated logic from okl_arintf_pvt

1314:
1315: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1316:
1317: --start: 02-APR-07 cklee R12 Billing enhancement project |
1318: -- Migrated logic from okl_arintf_pvt
1319: -- get memo line id for tax only invoices
1320: l_memo_line_id := NULL;
1321: OPEN get_memo_line_id_csr;
1322: FETCH get_memo_line_id_csr INTO l_memo_line_id;

Line 1591: -- Migrated logic from okl_arintf_pvt

1587: l_trx_lines_tbl(1).TAX_RATE := NULL;
1588: l_trx_lines_tbl(1).TAX_EXEMPTION_ID := NULL;
1589:
1590: --start: 02-APR-07 cklee R12 Billing enhancement project |
1591: -- Migrated logic from okl_arintf_pvt
1592: if lxfer_rec.AMOUNT = 0 then
1593: l_trx_lines_tbl(1).MEMO_LINE_ID := l_memo_line_id;
1594: else
1595: l_trx_lines_tbl(1).MEMO_LINE_ID := NULL;

Line 1683: -- Migrated from OKL_ARIntf_Pvt |

1679: l_trx_lines_tbl(1).GLOBAL_ATTRIBUTE_CATEGORY := NULL;
1680: l_trx_lines_tbl(1).AMOUNT_INCLUDES_TAX_FLAG := NULL;
1681:
1682: --start: 02-APR-07 cklee R12 Billing enhancement project
1683: -- Migrated from OKL_ARIntf_Pvt |
1684: OPEN l_get_inv_org_yn_csr( l_org_id );
1685: FETCH l_get_inv_org_yn_csr INTO l_use_inv_org;
1686: CLOSE l_get_inv_org_yn_csr;
1687:

Line 1724: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type

1720: ,p_line_id IN NUMBER
1721: --start: | 02-APR-07 cklee R12 Billing enhancement project |
1722: -- ,r_xsiv_rec IN Okl_Ext_Sell_Invs_Pub.xsiv_rec_type
1723: -- ,r_xlsv_rec IN Okl_Xtl_Sell_Invs_Pub.xlsv_rec_type
1724: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type
1725: --end: | 02-APR-07 cklee R12 Billing enhancement project |
1726: ,l_trx_dist_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_dist_tbl_type )
1727: IS
1728: --start: | 02-APR-07 cklee R12 Billing enhancement project |

Line 1738: lxfer_rec OKL_ARINTF_PVT.xfer_rec_type;

1734: */
1735: --end: | 02-APR-07 cklee R12 Billing enhancement project |
1736:
1737: i NUMBER;
1738: lxfer_rec OKL_ARINTF_PVT.xfer_rec_type;
1739: BEGIN
1740:
1741: -- Assign IN to local record
1742: lxfer_rec := xfer_rec;

Line 2111: lxfer_rec OKL_ARINTF_PVT.xfer_rec_type;

2107: -- AND OPP.ASSIGNED_PROCESS = p_assigned_process
2108: ORDER BY TAI.ID
2109: ;
2110:
2111: lxfer_rec OKL_ARINTF_PVT.xfer_rec_type;
2112: -- xfer_rec OKL_ARINTF_PVT.xfer_rec_type;
2113:
2114: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2115: -- ------------------------------------------

Line 2112: -- xfer_rec OKL_ARINTF_PVT.xfer_rec_type;

2108: ORDER BY TAI.ID
2109: ;
2110:
2111: lxfer_rec OKL_ARINTF_PVT.xfer_rec_type;
2112: -- xfer_rec OKL_ARINTF_PVT.xfer_rec_type;
2113:
2114: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2115: -- ------------------------------------------
2116: -- Variable definition for AR API call