DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJ_PVT dependencies on QP_LIMITS_PUB

Line 389: x_limits_rec OUT NOCOPY QP_Limits_PUB.Limits_Rec_Type

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

Line 449: , px_limitsRec IN OUT NOCOPY QP_Limits_PUB.Limits_Rec_Type

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

Line 481: l_limitsRec QP_Limits_PUB.Limits_Rec_Type;

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

Line 482: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;

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

Line 483: v_limits_val_rec QP_Limits_PUB.Limits_Val_Rec_Type;

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

Line 484: v_limit_attrs_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

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

Line 485: v_limit_attrs_val_tbl QP_Limits_PUB.Limit_Attrs_Val_Tbl_Type;

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

Line 486: v_limit_balances_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

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

Line 487: v_limit_balances_val_tbl QP_Limits_PUB.Limit_Balances_Val_Tbl_Type;

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

Line 520: QP_Limits_PUB.Process_Limits

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