eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LEASE_QUOTE_SERVICE_PVT dependencies on OKL_SVC_PVT

Line 8: p_service_rec IN okl_svc_pvt.svcv_rec_type

4: ----------------------------
5: -- PROCEDURE validate_header
6: ----------------------------
7: PROCEDURE validate_header(
8: p_service_rec IN okl_svc_pvt.svcv_rec_type
9: ,x_return_status OUT NOCOPY VARCHAR2
10: ) IS
11:
12: l_program_name CONSTANT VARCHAR2(30) := 'validate_header';

Line 109: ,x_service_rec OUT NOCOPY okl_svc_pvt.svcv_rec_type

105: -- PROCEDURE get_service_rec
106: ----------------------------
107: PROCEDURE get_service_rec (
108: p_service_id IN NUMBER
109: ,x_service_rec OUT NOCOPY okl_svc_pvt.svcv_rec_type
110: ,x_return_status OUT NOCOPY VARCHAR2
111: ) IS
112:
113: l_program_name CONSTANT VARCHAR2(30) := 'get_service_rec';

Line 948: p_service_rec IN okl_svc_pvt.svcv_rec_type

944: --------------------------
945: -- PROCEDURE create_header
946: --------------------------
947: PROCEDURE create_header (
948: p_service_rec IN okl_svc_pvt.svcv_rec_type
949: ,x_service_id OUT NOCOPY NUMBER
950: ,x_return_status OUT NOCOPY VARCHAR2
951: ,x_msg_count OUT NOCOPY NUMBER
952: ,x_msg_data OUT NOCOPY VARCHAR2

Line 958: lx_service_rec okl_svc_pvt.svcv_rec_type;

954:
955: l_program_name CONSTANT VARCHAR2(30) := 'create_header';
956: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
957:
958: lx_service_rec okl_svc_pvt.svcv_rec_type;
959:
960: BEGIN
961:
962: okl_svc_pvt.insert_row (

Line 962: okl_svc_pvt.insert_row (

958: lx_service_rec okl_svc_pvt.svcv_rec_type;
959:
960: BEGIN
961:
962: okl_svc_pvt.insert_row (
963: p_api_version => G_API_VERSION
964: ,p_init_msg_list => G_FALSE
965: ,x_return_status => x_return_status
966: ,x_msg_count => x_msg_count

Line 1007: p_service_rec IN okl_svc_pvt.svcv_rec_type

1003: --------------------------
1004: -- PROCEDURE update_header
1005: --------------------------
1006: PROCEDURE update_header (
1007: p_service_rec IN okl_svc_pvt.svcv_rec_type
1008: ,x_return_status OUT NOCOPY VARCHAR2
1009: ,x_msg_count OUT NOCOPY NUMBER
1010: ,x_msg_data OUT NOCOPY VARCHAR2
1011: ) IS

Line 1016: lx_service_rec okl_svc_pvt.svcv_rec_type;

1012:
1013: l_program_name CONSTANT VARCHAR2(30) := 'update_header';
1014: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1015:
1016: lx_service_rec okl_svc_pvt.svcv_rec_type;
1017:
1018: BEGIN
1019:
1020: okl_svc_pvt.update_row (

Line 1020: okl_svc_pvt.update_row (

1016: lx_service_rec okl_svc_pvt.svcv_rec_type;
1017:
1018: BEGIN
1019:
1020: okl_svc_pvt.update_row (
1021: p_api_version => G_API_VERSION
1022: ,p_init_msg_list => G_FALSE
1023: ,x_return_status => x_return_status
1024: ,x_msg_count => x_msg_count

Line 1321: ,p_service_rec IN okl_svc_pvt.svcv_rec_type

1317: PROCEDURE create_service (
1318: p_api_version IN NUMBER
1319: ,p_init_msg_list IN VARCHAR2
1320: ,p_transaction_control IN VARCHAR2
1321: ,p_service_rec IN okl_svc_pvt.svcv_rec_type
1322: ,p_assoc_asset_tbl IN line_relation_tbl_type
1323: ,p_payment_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type
1324: ,p_payment_level_tbl IN okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type
1325: ,p_expense_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type

Line 1765: ,p_service_rec IN okl_svc_pvt.svcv_rec_type

1761: PROCEDURE update_service (
1762: p_api_version IN NUMBER
1763: ,p_init_msg_list IN VARCHAR2
1764: ,p_transaction_control IN VARCHAR2
1765: ,p_service_rec IN okl_svc_pvt.svcv_rec_type
1766: ,p_assoc_asset_tbl IN line_relation_tbl_type
1767: ,p_payment_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type
1768: ,p_payment_level_tbl IN okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type
1769: ,p_expense_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type

Line 1995: ,p_service_rec IN okl_svc_pvt.svcv_rec_type

1991: p_api_version IN NUMBER
1992: ,p_init_msg_list IN VARCHAR2
1993: ,p_transaction_control IN VARCHAR2
1994: ,p_source_service_id IN NUMBER
1995: ,p_service_rec IN okl_svc_pvt.svcv_rec_type
1996: ,p_assoc_asset_tbl IN line_relation_tbl_type
1997: ,p_payment_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type
1998: ,p_payment_level_tbl IN okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type
1999: ,p_expense_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type

Line 2103: l_service_rec okl_svc_pvt.svcv_rec_type;

2099:
2100: l_program_name CONSTANT VARCHAR2(30) := 'duplicate_service2';
2101: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2102:
2103: l_service_rec okl_svc_pvt.svcv_rec_type;
2104: lx_service_rec okl_svc_pvt.svcv_rec_type;
2105:
2106: lb_copy_cashflow BOOLEAN := TRUE;
2107: lb_copy_lr BOOLEAN := TRUE;

Line 2104: lx_service_rec okl_svc_pvt.svcv_rec_type;

2100: l_program_name CONSTANT VARCHAR2(30) := 'duplicate_service2';
2101: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2102:
2103: l_service_rec okl_svc_pvt.svcv_rec_type;
2104: lx_service_rec okl_svc_pvt.svcv_rec_type;
2105:
2106: lb_copy_cashflow BOOLEAN := TRUE;
2107: lb_copy_lr BOOLEAN := TRUE;
2108: ld_src_start_date DATE;

Line 2277: l_svcv_rec okl_svc_pvt.svcv_rec_type;

2273: l_program_name CONSTANT VARCHAR2(30) := 'delete_service';
2274: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2275:
2276: l_lrev_tbl okl_lre_pvt.lrev_tbl_type;
2277: l_svcv_rec okl_svc_pvt.svcv_rec_type;
2278: i BINARY_INTEGER;
2279:
2280: CURSOR c_sublines IS
2281: SELECT id

Line 2340: okl_svc_pvt.delete_row (

2336: END IF;
2337:
2338: l_svcv_rec.id := p_service_id;
2339:
2340: okl_svc_pvt.delete_row (
2341: p_api_version => G_API_VERSION
2342: ,p_init_msg_list => G_FALSE
2343: ,x_return_status => x_return_status
2344: ,x_msg_count => x_msg_count