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_AM_PARTIES_PVT

Line 4090: l_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;

4086: l_name WF_USERS.description%type;
4087:
4088: l_recipient_name varchar2(100);
4089: l_recipient_id number;
4090: l_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;
4091: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4092:
4093: --12/18/06 rkuttiya added for XMLP Project
4094: x_msg_count NUMBER;

Line 4156: OKL_AM_PARTIES_PVT.get_party_details (

4152: , x_name => l_user_name
4153: , x_description => l_name);
4154:
4155: -- Find party details
4156: OKL_AM_PARTIES_PVT.get_party_details (
4157: p_id_code => l_quote_rec.party_type,
4158: p_id_value => l_quote_rec.qp_party_id,
4159: x_party_object_tbl => l_party_object_tbl,
4160: x_return_status => l_return_status);

Line 4164: 'after call to OKL_AM_PARTIES_PVT.get_party_details :'||l_return_status);

4160: x_return_status => l_return_status);
4161:
4162: IF (is_debug_statement_on) THEN
4163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
4164: 'after call to OKL_AM_PARTIES_PVT.get_party_details :'||l_return_status);
4165: END IF;
4166:
4167: -- Check that a quote id is returned for the TRANSACTION_ID given.
4168:

Line 4873: l_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;

4869: -- and b.qp_role_code = 'RECIPIENT'
4870: and b.quote_id = a.qte_id;
4871:
4872: l_quote_rec get_quote_xmlp_csr%rowtype;
4873: l_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;
4874:
4875: --get the recipient email address
4876: CURSOR c_recipient(p_recipient_id IN NUMBER)
4877: IS

Line 5013: OKL_AM_PARTIES_PVT.get_party_details (

5009: FETCH get_quote_xmlp_csr INTO l_quote_rec;
5010: CLOSE get_quote_xmlp_csr;
5011:
5012: -- Find party details
5013: OKL_AM_PARTIES_PVT.get_party_details (
5014: p_id_code => l_quote_rec.party_type,
5015: p_id_value => l_quote_rec.qp_party_id,
5016: x_party_object_tbl => l_party_object_tbl,
5017: x_return_status => x_return_status);

Line 5021: 'after call to OKL_AM_PARTIES_PVT.get_party_details :'||l_return_status);

5017: x_return_status => x_return_status);
5018:
5019: IF (is_debug_statement_on) THEN
5020: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
5021: 'after call to OKL_AM_PARTIES_PVT.get_party_details :'||l_return_status);
5022: END IF;
5023:
5024: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5025: RAISE API_ERROR;

Line 5770: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

5766: l_api_version CONSTANT NUMBER := 1;
5767: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
5768: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
5769: l_msg_data VARCHAR2(2000);
5770: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
5771: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
5772: l_party_count NUMBER;
5773:
5774: API_ERROR EXCEPTION;

Line 5771: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

5767: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
5768: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
5769: l_msg_data VARCHAR2(2000);
5770: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
5771: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
5772: l_party_count NUMBER;
5773:
5774: API_ERROR EXCEPTION;
5775: -- for debug logging

Line 5801: okl_am_parties_pvt.get_quote_parties (

5797: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5798: RAISE API_ERROR;
5799: END IF;
5800:
5801: okl_am_parties_pvt.get_quote_parties (
5802: p_api_version => l_api_version,
5803: p_init_msg_list => l_init_msg_list,
5804: x_msg_count => l_msg_count,
5805: x_msg_data => l_msg_data,

Line 5813: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);

5809: x_record_count => l_party_count);
5810:
5811: IF (is_debug_statement_on) THEN
5812: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
5813: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);
5814: END IF;
5815:
5816:
5817: IF l_party_count > 0 THEN

Line 5895: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

5891: l_api_version CONSTANT NUMBER := 1;
5892: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
5893: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
5894: l_msg_data VARCHAR2(2000);
5895: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
5896: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
5897: l_total_party_count NUMBER;
5898: l_current_rec NUMBER;
5899:

Line 5896: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

5892: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
5893: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
5894: l_msg_data VARCHAR2(2000);
5895: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
5896: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
5897: l_total_party_count NUMBER;
5898: l_current_rec NUMBER;
5899:
5900: l_recipient_type VARCHAR2(50);

Line 5939: okl_am_parties_pvt.get_quote_parties (

5935: l_q_party_uv_rec.qp_role_code := l_party_type;
5936:
5937: IF l_party_count > 0 THEN
5938:
5939: okl_am_parties_pvt.get_quote_parties (
5940: p_api_version => l_api_version,
5941: p_init_msg_list => l_init_msg_list,
5942: x_msg_count => l_msg_count,
5943: x_msg_data => l_msg_data,

Line 5951: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);

5947: x_record_count => l_total_party_count);
5948:
5949: IF (is_debug_statement_on) THEN
5950: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
5951: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);
5952: END IF;
5953:
5954: IF l_q_party_uv_tbl(l_party_count).co_email IS NOT NULL THEN
5955:

Line 6180: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

6176: l_api_version CONSTANT NUMBER := 1;
6177: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6178: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6179: l_msg_data VARCHAR2(2000);
6180: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6181: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6182: l_party_count NUMBER;
6183: l_delay_days NUMBER(10,4);
6184:

Line 6181: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

6177: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6178: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6179: l_msg_data VARCHAR2(2000);
6180: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6181: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6182: l_party_count NUMBER;
6183: l_delay_days NUMBER(10,4);
6184:
6185: CURSOR c_delay_days_csr(c_qte_id NUMBER) IS

Line 6212: okl_am_parties_pvt.get_quote_parties (

6208:
6209: l_q_party_uv_rec.quote_id := l_quote_id;
6210: l_q_party_uv_rec.qp_role_code := 'ADVANCE_NOTICE';
6211:
6212: okl_am_parties_pvt.get_quote_parties (
6213: p_api_version => l_api_version,
6214: p_init_msg_list => l_init_msg_list,
6215: x_msg_count => l_msg_count,
6216: x_msg_data => l_msg_data,

Line 6224: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);

6220: x_record_count => l_party_count);
6221:
6222: IF (is_debug_statement_on) THEN
6223: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6224: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);
6225: END IF;
6226:
6227: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6228: RAISE API_ERROR;

Line 6320: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

6316: l_api_version CONSTANT NUMBER := 1;
6317: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6318: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6319: l_msg_data VARCHAR2(2000);
6320: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6321: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6322: l_party_count NUMBER;
6323:
6324: API_ERROR EXCEPTION;

Line 6321: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

6317: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6318: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6319: l_msg_data VARCHAR2(2000);
6320: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6321: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6322: l_party_count NUMBER;
6323:
6324: API_ERROR EXCEPTION;
6325: -- for debug logging

Line 6350: okl_am_parties_pvt.get_quote_parties (

6346: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6347: RAISE API_ERROR;
6348: END IF;
6349:
6350: okl_am_parties_pvt.get_quote_parties (
6351: p_api_version => l_api_version,
6352: p_init_msg_list => l_init_msg_list,
6353: x_msg_count => l_msg_count,
6354: x_msg_data => l_msg_data,

Line 6362: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);

6358: x_record_count => l_party_count);
6359:
6360: IF (is_debug_statement_on) THEN
6361: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6362: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);
6363: END IF;
6364:
6365: IF l_party_count > 0 THEN
6366:

Line 6441: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

6437: l_api_version CONSTANT NUMBER := 1;
6438: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6439: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6440: l_msg_data VARCHAR2(2000);
6441: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6442: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6443: l_party_count NUMBER;
6444:
6445: API_ERROR EXCEPTION;

Line 6442: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

6438: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6439: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6440: l_msg_data VARCHAR2(2000);
6441: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6442: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6443: l_party_count NUMBER;
6444:
6445: API_ERROR EXCEPTION;
6446: -- for debug logging

Line 6470: okl_am_parties_pvt.get_quote_parties (

6466: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6467: RAISE API_ERROR;
6468: END IF;
6469:
6470: okl_am_parties_pvt.get_quote_parties (
6471: p_api_version => l_api_version,
6472: p_init_msg_list => l_init_msg_list,
6473: x_msg_count => l_msg_count,
6474: x_msg_data => l_msg_data,

Line 6483: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);

6479:
6480:
6481: IF (is_debug_statement_on) THEN
6482: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6483: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);
6484: END IF;
6485:
6486: IF l_party_count > 0 THEN
6487:

Line 6562: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

6558: l_api_version CONSTANT NUMBER := 1;
6559: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6560: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6561: l_msg_data VARCHAR2(2000);
6562: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6563: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6564: l_party_count NUMBER;
6565:
6566: API_ERROR EXCEPTION;

Line 6563: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

6559: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6560: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6561: l_msg_data VARCHAR2(2000);
6562: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6563: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6564: l_party_count NUMBER;
6565:
6566: API_ERROR EXCEPTION;
6567: -- for debug logging

Line 6592: okl_am_parties_pvt.get_quote_parties (

6588: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6589: RAISE API_ERROR;
6590: END IF;
6591:
6592: okl_am_parties_pvt.get_quote_parties (
6593: p_api_version => l_api_version,
6594: p_init_msg_list => l_init_msg_list,
6595: x_msg_count => l_msg_count,
6596: x_msg_data => l_msg_data,

Line 6604: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);

6600: x_record_count => l_party_count);
6601:
6602: IF (is_debug_statement_on) THEN
6603: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6604: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);
6605: END IF;
6606:
6607: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6608: RAISE API_ERROR;