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.OZF_OFFER_ADJ_PVT dependencies on QP_LIMITS

Line 387: x_limits_rec OUT NOCOPY QP_Limits_PUB.Limits_Rec_Type

383: Populates a limits record with limits data for a given limitId
384: */
385: PROCEDURE populate_limits_rec
386: (
387: x_limits_rec OUT NOCOPY QP_Limits_PUB.Limits_Rec_Type
388: , x_return_status OUT NOCOPY VARCHAR2
389: , p_limitId IN NUMBER
390: )
391: IS

Line 395: FROM qp_limits

391: IS
392: CURSOR c_limits(cp_limitId NUMBER)
393: IS
394: SELECT *
395: FROM qp_limits
396: WHERE limit_id = cp_limitId;
397: BEGIN
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399: x_limits_rec := null;

Line 447: , px_limitsRec IN OUT NOCOPY QP_Limits_PUB.Limits_Rec_Type

443: (
444: x_return_status OUT NOCOPY VARCHAR2
445: , x_msg_count OUT NOCOPY NUMBER
446: , x_msg_data OUT NOCOPY VARCHAR2
447: , px_limitsRec IN OUT NOCOPY QP_Limits_PUB.Limits_Rec_Type
448: , p_toListLineId IN NUMBER
449: )
450: IS
451: CURSOR c_listHeaderId (cp_listLineId NUMBER) IS

Line 479: l_limitsRec QP_Limits_PUB.Limits_Rec_Type;

475: ,p_fromListLineId IN NUMBER
476: , p_toListLineId IN NUMBER
477: )
478: IS
479: l_limitsRec QP_Limits_PUB.Limits_Rec_Type;
480: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
481: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
482: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
483: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;

Line 480: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;

476: , p_toListLineId IN NUMBER
477: )
478: IS
479: l_limitsRec QP_Limits_PUB.Limits_Rec_Type;
480: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
481: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
482: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
483: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
484: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 481: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;

477: )
478: IS
479: l_limitsRec QP_Limits_PUB.Limits_Rec_Type;
480: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
481: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
482: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
483: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
484: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
485: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;

Line 482: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

478: IS
479: l_limitsRec QP_Limits_PUB.Limits_Rec_Type;
480: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
481: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
482: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
483: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
484: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
485: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
486: BEGIN

Line 483: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;

479: l_limitsRec QP_Limits_PUB.Limits_Rec_Type;
480: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
481: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
482: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
483: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
484: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
485: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
486: BEGIN
487: -- initialize

Line 484: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

480: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;
481: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
482: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
483: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
484: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
485: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
486: BEGIN
487: -- initialize
488: -- populate limits records

Line 485: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;

481: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;
482: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
483: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;
484: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
485: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;
486: BEGIN
487: -- initialize
488: -- populate limits records
489: -- process the limits records

Line 493: FOR l_limits in (SELECT limit_id, list_line_id FROM qp_limits WHERE list_line_id = p_fromListLineId) LOOP

489: -- process the limits records
490: -- create limits
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493: FOR l_limits in (SELECT limit_id, list_line_id FROM qp_limits WHERE list_line_id = p_fromListLineId) LOOP
494: populate_limits_rec
495: (
496: x_limits_rec => l_limitsRec
497: , x_return_status => x_return_status

Line 518: QP_Limits_PUB.Process_Limits

514: RAISE FND_API.G_EXC_ERROR;
515: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
518: QP_Limits_PUB.Process_Limits
519: ( p_init_msg_list => FND_API.g_true,
520: p_api_version_number => 1.0,
521: p_commit => FND_API.g_false,
522: x_return_status => x_return_status,