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 4871: l_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;

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

Line 5011: OKL_AM_PARTIES_PVT.get_party_details (

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

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

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

Line 5768: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

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

Line 5769: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

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

Line 5799: okl_am_parties_pvt.get_quote_parties (

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

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

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

Line 5893: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

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

Line 5894: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

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

Line 5937: okl_am_parties_pvt.get_quote_parties (

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

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

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

Line 6178: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

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

Line 6179: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

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

Line 6210: okl_am_parties_pvt.get_quote_parties (

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

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

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

Line 6318: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

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

Line 6319: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

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

Line 6348: okl_am_parties_pvt.get_quote_parties (

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

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

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

Line 6439: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

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

Line 6440: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

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

Line 6468: okl_am_parties_pvt.get_quote_parties (

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

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

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

Line 6560: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

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

Line 6561: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

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

Line 6590: okl_am_parties_pvt.get_quote_parties (

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

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

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