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 1121: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

1117: l_init_msg_list VARCHAR2(1) := 'T';
1118:
1119: ERR EXCEPTION;
1120: l_batch_id NUMBER;
1121: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1122: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1123: --get the recipient email address
1124: CURSOR c_recipient(p_recipient_id IN NUMBER)
1125: IS

Line 1122: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

1118:
1119: ERR EXCEPTION;
1120: l_batch_id NUMBER;
1121: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1122: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1123: --get the recipient email address
1124: CURSOR c_recipient(p_recipient_id IN NUMBER)
1125: IS
1126: SELECT hzp.email_address email

Line 1240: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(

1236: l_xmp_rec.param_name := 'P_ART_ID';
1237: l_xmp_rec.param_value := l_art_id;
1238: l_xmp_rec.param_type_code := 'NUMBER';
1239:
1240: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(
1241: p_api_version => l_api_version
1242: ,p_init_msg_list => l_init_msg_list
1243: ,x_return_status => l_return_status
1244: ,x_msg_count => x_msg_count

Line 1352: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

1348: l_init_msg_list VARCHAR2(1) := 'T';
1349:
1350: ERR EXCEPTION;
1351: l_batch_id NUMBER;
1352: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1353: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1354: --get the recipient email address
1355: CURSOR c_recipient(p_recipient_id IN NUMBER)
1356: IS

Line 1353: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

1349:
1350: ERR EXCEPTION;
1351: l_batch_id NUMBER;
1352: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1353: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1354: --get the recipient email address
1355: CURSOR c_recipient(p_recipient_id IN NUMBER)
1356: IS
1357: SELECT hzp.email_address email

Line 1467: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(

1463: l_xmp_rec.param_name := 'P_ART_ID';
1464: l_xmp_rec.param_value := l_art_id;
1465: l_xmp_rec.param_type_code := 'NUMBER';
1466:
1467: OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec(
1468: p_api_version => l_api_version
1469: ,p_init_msg_list => l_init_msg_list
1470: ,x_return_status => l_return_status
1471: ,x_msg_count => x_msg_count