APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_XMLP_PARAMS_PVT

Line 360: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

356: l_init_msg_list VARCHAR2(1) := 'T';
357:
358: ERR EXCEPTION;
359: l_batch_id NUMBER;
360: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
361: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
362:
363: --get the recipient email address
364: CURSOR c_recipient(p_recipient_id IN NUMBER)

Line 361: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

357:
358: ERR EXCEPTION;
359: l_batch_id NUMBER;
360: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
361: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
362:
363: --get the recipient email address
364: CURSOR c_recipient(p_recipient_id IN NUMBER)
365: IS

Line 488: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(

484: l_xmp_rec.param_name := 'P_ART_ID';
485: l_xmp_rec.param_value := l_art_id;
486: l_xmp_rec.param_type_code := 'NUMBER';
487:
488: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(
489: p_api_version => l_api_version
490: ,p_init_msg_list => l_init_msg_list
491: ,x_return_status => l_return_status
492: ,x_msg_count => x_msg_count

Line 1166: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

1162: l_init_msg_list VARCHAR2(1) := 'T';
1163:
1164: ERR EXCEPTION;
1165: l_batch_id NUMBER;
1166: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1167: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1168: --get the recipient email address
1169: CURSOR c_recipient(p_recipient_id IN NUMBER)
1170: IS

Line 1167: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

1163:
1164: ERR EXCEPTION;
1165: l_batch_id NUMBER;
1166: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1167: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1168: --get the recipient email address
1169: CURSOR c_recipient(p_recipient_id IN NUMBER)
1170: IS
1171: SELECT hzp.email_address email

Line 1285: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(

1281: l_xmp_rec.param_name := 'P_ART_ID';
1282: l_xmp_rec.param_value := l_art_id;
1283: l_xmp_rec.param_type_code := 'NUMBER';
1284:
1285: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(
1286: p_api_version => l_api_version
1287: ,p_init_msg_list => l_init_msg_list
1288: ,x_return_status => l_return_status
1289: ,x_msg_count => x_msg_count

Line 1397: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

1393: l_init_msg_list VARCHAR2(1) := 'T';
1394:
1395: ERR EXCEPTION;
1396: l_batch_id NUMBER;
1397: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1398: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1399: --get the recipient email address
1400: CURSOR c_recipient(p_recipient_id IN NUMBER)
1401: IS

Line 1398: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

1394:
1395: ERR EXCEPTION;
1396: l_batch_id NUMBER;
1397: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1398: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1399: --get the recipient email address
1400: CURSOR c_recipient(p_recipient_id IN NUMBER)
1401: IS
1402: SELECT hzp.email_address email

Line 1512: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(

1508: l_xmp_rec.param_name := 'P_ART_ID';
1509: l_xmp_rec.param_value := l_art_id;
1510: l_xmp_rec.param_type_code := 'NUMBER';
1511:
1512: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(
1513: p_api_version => l_api_version
1514: ,p_init_msg_list => l_init_msg_list
1515: ,x_return_status => l_return_status
1516: ,x_msg_count => x_msg_count