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_AM_QUOTES_WF dependencies on OKL_XMLP_PARAMS_PVT

Line 1820: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

1816: l_init_msg_list VARCHAR2(1) := 'T';
1817:
1818: ERR EXCEPTION;
1819: l_batch_id NUMBER;
1820: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1821: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1822: --get the recipient email address
1823: CURSOR c_recipient(p_recipient_id IN NUMBER)
1824: IS

Line 1821: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

1817:
1818: ERR EXCEPTION;
1819: l_batch_id NUMBER;
1820: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1821: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1822: --get the recipient email address
1823: CURSOR c_recipient(p_recipient_id IN NUMBER)
1824: IS
1825: SELECT hzp.email_address email

Line 1957: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(

1953: l_xmp_rec.param_name := 'P_LINE_ID';
1954: l_xmp_rec.param_value := l_line_id;
1955: l_xmp_rec.param_type_code := 'NUMBER';
1956:
1957: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(
1958: p_api_version => l_api_version
1959: ,p_init_msg_list => l_init_msg_list
1960: ,x_return_status => l_return_status
1961: ,x_msg_count => x_msg_count

Line 2331: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

2327: WHERE a.qte_id = p_quote_id;
2328:
2329: ERR EXCEPTION;
2330: l_batch_id NUMBER;
2331: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2332: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2333: l_requestor_id NUMBER;
2334:
2335: -- get the sender email address

Line 2332: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

2328:
2329: ERR EXCEPTION;
2330: l_batch_id NUMBER;
2331: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2332: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2333: l_requestor_id NUMBER;
2334:
2335: -- get the sender email address
2336: CURSOR c_requestor_csr (p_requestor_id NUMBER)

Line 2465: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(

2461: l_xmp_rec.param_name := 'P_QUOTE_ID';
2462: l_xmp_rec.param_value := l_id;
2463: l_xmp_rec.param_type_code := 'NUMBER';
2464:
2465: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(
2466: p_api_version => l_api_version
2467: ,p_init_msg_list => l_init_msg_list
2468: ,x_return_status => l_return_status
2469: ,x_msg_count => x_msg_count

Line 2477: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);

2473: );
2474:
2475: IF (is_debug_statement_on) THEN
2476: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2477: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);
2478: END IF;
2479:
2480: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2481: RAISE ERR;

Line 2816: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

2812: l_init_msg_list VARCHAR2(1) := 'T';
2813:
2814: ERR EXCEPTION;
2815: l_batch_id NUMBER;
2816: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2817: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2818: --get the recipient email address
2819: CURSOR c_recipient (p_recipient_id IN varchar2)--ansethur 26-jul-2007 XMLP (p_recipient_id IN NUMBER)
2820: IS

Line 2817: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

2813:
2814: ERR EXCEPTION;
2815: l_batch_id NUMBER;
2816: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2817: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2818: --get the recipient email address
2819: CURSOR c_recipient (p_recipient_id IN varchar2)--ansethur 26-jul-2007 XMLP (p_recipient_id IN NUMBER)
2820: IS
2821: SELECT hzp.email_address email

Line 2993: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(

2989: l_xmp_rec.param_name := 'P_LINE_ID';
2990: l_xmp_rec.param_value := l_cle_id;
2991: l_xmp_rec.param_type_code := 'NUMBER';
2992:
2993: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(
2994: p_api_version => l_api_version
2995: ,p_init_msg_list => l_init_msg_list
2996: ,x_return_status => l_return_status
2997: ,x_msg_count => x_msg_count

Line 3004: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);

3000: ,x_xmp_rec => lx_xmp_rec
3001: );
3002: IF (is_debug_statement_on) THEN
3003: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3004: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);
3005: END IF;
3006:
3007: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3008: RAISE ERR;

Line 4101: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

4097: l_init_msg_list VARCHAR2(1) := 'T';
4098:
4099: ERR EXCEPTION;
4100: l_batch_id NUMBER;
4101: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
4102: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
4103: --get the recipient email address
4104: CURSOR c_recipient(p_recipient_id IN NUMBER)
4105: IS

Line 4102: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

4098:
4099: ERR EXCEPTION;
4100: l_batch_id NUMBER;
4101: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
4102: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
4103: --get the recipient email address
4104: CURSOR c_recipient(p_recipient_id IN NUMBER)
4105: IS
4106: SELECT hzp.email_address email

Line 4243: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(

4239: l_xmp_rec.param_name := 'P_QUOTE_ID';
4240: l_xmp_rec.param_value := l_quote_id;
4241: l_xmp_rec.param_type_code := 'NUMBER';
4242:
4243: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(
4244: p_api_version => l_api_version
4245: ,p_init_msg_list => l_init_msg_list
4246: ,x_return_status => l_return_status
4247: ,x_msg_count => x_msg_count

Line 4254: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);

4250: ,x_xmp_rec => lx_xmp_rec
4251: );
4252: IF (is_debug_statement_on) THEN
4253: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
4254: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);
4255: END IF;
4256:
4257: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
4258: RAISE ERR;

Line 4856: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

4852: l_init_msg_list VARCHAR2(1) := 'T';
4853: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4854: ERR EXCEPTION;
4855: l_batch_id NUMBER;
4856: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
4857: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
4858:
4859: -- Check quote exists
4860: CURSOR get_quote_xmlp_csr ( p_qte_id IN VARCHAR2)

Line 4857: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

4853: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4854: ERR EXCEPTION;
4855: l_batch_id NUMBER;
4856: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
4857: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
4858:
4859: -- Check quote exists
4860: CURSOR get_quote_xmlp_csr ( p_qte_id IN VARCHAR2)
4861: IS

Line 5069: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(

5065: l_xmp_rec.param_name := 'P_QUOTE_ID';
5066: l_xmp_rec.param_value := l_quote_id;
5067: l_xmp_rec.param_type_code := 'NUMBER';
5068:
5069: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(
5070: p_api_version => l_api_version
5071: ,p_init_msg_list => l_init_msg_list
5072: ,x_return_status => l_return_status
5073: ,x_msg_count => x_msg_count

Line 5081: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);

5077: );
5078:
5079: IF (is_debug_statement_on) THEN
5080: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
5081: 'after call to OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec :'||l_return_status);
5082: END IF;
5083:
5084: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5085: RAISE ERR;