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 934: p_service_rec IN okl_svc_pvt.svcv_rec_type

930: --------------------------
931: -- PROCEDURE create_header
932: --------------------------
933: PROCEDURE create_header (
934: p_service_rec IN okl_svc_pvt.svcv_rec_type
935: ,x_service_id OUT NOCOPY NUMBER
936: ,x_return_status OUT NOCOPY VARCHAR2
937: ,x_msg_count OUT NOCOPY NUMBER
938: ,x_msg_data OUT NOCOPY VARCHAR2

Line 944: lx_service_rec okl_svc_pvt.svcv_rec_type;

940:
941: l_program_name CONSTANT VARCHAR2(30) := 'create_header';
942: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
943:
944: lx_service_rec okl_svc_pvt.svcv_rec_type;
945:
946: BEGIN
947:
948: okl_svc_pvt.insert_row (

Line 948: okl_svc_pvt.insert_row (

944: lx_service_rec okl_svc_pvt.svcv_rec_type;
945:
946: BEGIN
947:
948: okl_svc_pvt.insert_row (
949: p_api_version => G_API_VERSION
950: ,p_init_msg_list => G_FALSE
951: ,x_return_status => x_return_status
952: ,x_msg_count => x_msg_count

Line 993: p_service_rec IN okl_svc_pvt.svcv_rec_type

989: --------------------------
990: -- PROCEDURE update_header
991: --------------------------
992: PROCEDURE update_header (
993: p_service_rec IN okl_svc_pvt.svcv_rec_type
994: ,x_return_status OUT NOCOPY VARCHAR2
995: ,x_msg_count OUT NOCOPY NUMBER
996: ,x_msg_data OUT NOCOPY VARCHAR2
997: ) IS

Line 1002: lx_service_rec okl_svc_pvt.svcv_rec_type;

998:
999: l_program_name CONSTANT VARCHAR2(30) := 'update_header';
1000: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
1001:
1002: lx_service_rec okl_svc_pvt.svcv_rec_type;
1003:
1004: BEGIN
1005:
1006: okl_svc_pvt.update_row (

Line 1006: okl_svc_pvt.update_row (

1002: lx_service_rec okl_svc_pvt.svcv_rec_type;
1003:
1004: BEGIN
1005:
1006: okl_svc_pvt.update_row (
1007: p_api_version => G_API_VERSION
1008: ,p_init_msg_list => G_FALSE
1009: ,x_return_status => x_return_status
1010: ,x_msg_count => x_msg_count

Line 1307: ,p_service_rec IN okl_svc_pvt.svcv_rec_type

1303: PROCEDURE create_service (
1304: p_api_version IN NUMBER
1305: ,p_init_msg_list IN VARCHAR2
1306: ,p_transaction_control IN VARCHAR2
1307: ,p_service_rec IN okl_svc_pvt.svcv_rec_type
1308: ,p_assoc_asset_tbl IN line_relation_tbl_type
1309: ,p_payment_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type
1310: ,p_payment_level_tbl IN okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type
1311: ,p_expense_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type

Line 1751: ,p_service_rec IN okl_svc_pvt.svcv_rec_type

1747: PROCEDURE update_service (
1748: p_api_version IN NUMBER
1749: ,p_init_msg_list IN VARCHAR2
1750: ,p_transaction_control IN VARCHAR2
1751: ,p_service_rec IN okl_svc_pvt.svcv_rec_type
1752: ,p_assoc_asset_tbl IN line_relation_tbl_type
1753: ,p_payment_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type
1754: ,p_payment_level_tbl IN okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type
1755: ,p_expense_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type

Line 1981: ,p_service_rec IN okl_svc_pvt.svcv_rec_type

1977: p_api_version IN NUMBER
1978: ,p_init_msg_list IN VARCHAR2
1979: ,p_transaction_control IN VARCHAR2
1980: ,p_source_service_id IN NUMBER
1981: ,p_service_rec IN okl_svc_pvt.svcv_rec_type
1982: ,p_assoc_asset_tbl IN line_relation_tbl_type
1983: ,p_payment_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type
1984: ,p_payment_level_tbl IN okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type
1985: ,p_expense_header_rec IN okl_lease_quote_cashflow_pvt.cashflow_header_rec_type

Line 2089: l_service_rec okl_svc_pvt.svcv_rec_type;

2085:
2086: l_program_name CONSTANT VARCHAR2(30) := 'duplicate_service2';
2087: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2088:
2089: l_service_rec okl_svc_pvt.svcv_rec_type;
2090: lx_service_rec okl_svc_pvt.svcv_rec_type;
2091:
2092: lb_copy_cashflow BOOLEAN := TRUE;
2093: lb_copy_lr BOOLEAN := TRUE;

Line 2090: lx_service_rec okl_svc_pvt.svcv_rec_type;

2086: l_program_name CONSTANT VARCHAR2(30) := 'duplicate_service2';
2087: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2088:
2089: l_service_rec okl_svc_pvt.svcv_rec_type;
2090: lx_service_rec okl_svc_pvt.svcv_rec_type;
2091:
2092: lb_copy_cashflow BOOLEAN := TRUE;
2093: lb_copy_lr BOOLEAN := TRUE;
2094: ld_src_start_date DATE;

Line 2263: l_svcv_rec okl_svc_pvt.svcv_rec_type;

2259: l_program_name CONSTANT VARCHAR2(30) := 'delete_service';
2260: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2261:
2262: l_lrev_tbl okl_lre_pvt.lrev_tbl_type;
2263: l_svcv_rec okl_svc_pvt.svcv_rec_type;
2264: i BINARY_INTEGER;
2265:
2266: CURSOR c_sublines IS
2267: SELECT id

Line 2326: okl_svc_pvt.delete_row (

2322: END IF;
2323:
2324: l_svcv_rec.id := p_service_id;
2325:
2326: okl_svc_pvt.delete_row (
2327: p_api_version => G_API_VERSION
2328: ,p_init_msg_list => G_FALSE
2329: ,x_return_status => x_return_status
2330: ,x_msg_count => x_msg_count