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.PON_AWARD_PKG dependencies on PON_OPTIMIZE_CONSTRAINTS

Line 2590: from pon_optimize_constraints

2586: -- copy the constraints
2587:
2588: -- make sure there is at least 1 row to prevent no data found exception
2589: select count(*) into l_num_constraints
2590: from pon_optimize_constraints
2591: where scenario_id = p_scenario_id;
2592:
2593: IF (l_num_constraints > 0) THEN
2594:

Line 2595: INSERT INTO PON_OPTIMIZE_CONSTRAINTS(

2591: where scenario_id = p_scenario_id;
2592:
2593: IF (l_num_constraints > 0) THEN
2594:
2595: INSERT INTO PON_OPTIMIZE_CONSTRAINTS(
2596: scenario_id,
2597: sequence_number,
2598: auction_header_id,
2599: constraint_type,

Line 2708: FROM pon_optimize_constraints

2704: ,TO_CHAR(NULL)
2705: ,MIN_SCORE_PRIORITY
2706: ,TO_NUMBER(NULL)
2707: ,TO_CHAR(NULL)
2708: FROM pon_optimize_constraints
2709: WHERE scenario_id = p_scenario_id;
2710:
2711: END IF;
2712:

Line 3334: p_scenario_id IN PON_OPTIMIZE_CONSTRAINTS.SCENARIO_ID%TYPE,

3330:
3331:
3332: FUNCTION does_bid_exist
3333: (
3334: p_scenario_id IN PON_OPTIMIZE_CONSTRAINTS.SCENARIO_ID%TYPE,
3335: p_sequence_number IN PON_OPTIMIZE_CONSTRAINTS.SEQUENCE_NUMBER%TYPE,
3336: p_bid_number IN PON_BID_HEADERS.BID_NUMBER%TYPE
3337: ) RETURN VARCHAR2
3338: IS

Line 3335: p_sequence_number IN PON_OPTIMIZE_CONSTRAINTS.SEQUENCE_NUMBER%TYPE,

3331:
3332: FUNCTION does_bid_exist
3333: (
3334: p_scenario_id IN PON_OPTIMIZE_CONSTRAINTS.SCENARIO_ID%TYPE,
3335: p_sequence_number IN PON_OPTIMIZE_CONSTRAINTS.SEQUENCE_NUMBER%TYPE,
3336: p_bid_number IN PON_BID_HEADERS.BID_NUMBER%TYPE
3337: ) RETURN VARCHAR2
3338: IS
3339: l_bid_exists VARCHAR2(1);

Line 3438: -- same row of pon_optimize_constraints table

3434: IF (l_status <> 'FAILURE') THEN
3435:
3436: -- these initial conditions are applicable to those
3437: -- scenarios where multiple constraints are saved on the
3438: -- same row of pon_optimize_constraints table
3439:
3440: IF (p_constraint_type = 'LINE_CONST') THEN --{
3441:
3442: IF (p_internal_type = 'LINE_SPLIT_AWARD') THEN

Line 3450: UPDATE PON_OPTIMIZE_CONSTRAINTS

3446: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
3447: END IF;
3448: END IF;
3449:
3450: UPDATE PON_OPTIMIZE_CONSTRAINTS
3451: SET SPLIT_AWARD_FLAG = decode(SPLIT_AWARD_FLAG, 'Y', 'N', 'Y'),
3452: SPLIT_AWARD_PRIORITY = NVL2(SPLIT_AWARD_PRIORITY,l_priority,null),
3453: SPLIT_AWARD_INFEAS_FLAG = TO_CHAR(NULL),
3454: SPLIT_AWARD_COST = TO_NUMBER(NULL)

Line 3467: UPDATE PON_OPTIMIZE_CONSTRAINTS

3463: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
3464: END IF;
3465: END IF;
3466:
3467: UPDATE PON_OPTIMIZE_CONSTRAINTS
3468: SET INTEGRAL_QTY_AWARD_FLAG = decode(INTEGRAL_QTY_AWARD_FLAG, 'Y', 'N', 'Y'),
3469: INTEGRAL_QTY_AWARD_PRIORITY = NVL2(INTEGRAL_QTY_AWARD_PRIORITY,l_priority,null),
3470: INTEGRAL_QTY_AWARD_INFEAS_FLAG = TO_CHAR(NULL),
3471: INTEGRAL_QTY_AWARD_COST = TO_NUMBER(NULL)

Line 3516: UPDATE PON_OPTIMIZE_CONSTRAINTS

3512: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
3513: END IF;
3514: END IF;
3515:
3516: UPDATE PON_OPTIMIZE_CONSTRAINTS
3517: SET MIN_QUANTITY = 0,
3518: MAX_QUANTITY = DECODE(l_order_type_lookup_code, 'FIXED PRICE', 1, 'AMOUNT', 1, l_auction_qty),
3519: MIN_MAX_QUANTITY_PRIORITY = NVL2(MIN_MAX_QUANTITY_PRIORITY,l_priority,null),
3520: MIN_MAX_QUANTITY_COST = TO_NUMBER(NULL),

Line 3534: UPDATE PON_OPTIMIZE_CONSTRAINTS

3530: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
3531: END IF;
3532: END IF;
3533:
3534: UPDATE PON_OPTIMIZE_CONSTRAINTS
3535: SET MIN_AMOUNT = TO_NUMBER(NULL),
3536: MAX_AMOUNT = TO_NUMBER(NULL),
3537: MIN_MAX_AMOUNT_PRIORITY = TO_CHAR(NULL),
3538: MIN_MAX_AMOUNT_COST = TO_NUMBER(NULL),

Line 3553: UPDATE PON_OPTIMIZE_CONSTRAINTS

3549: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
3550: END IF;
3551: END IF;
3552:
3553: UPDATE PON_OPTIMIZE_CONSTRAINTS
3554: SET QUANTITY_CUTOFF = TO_NUMBER(NULL),
3555: QUANTITY_CUTOFF_PRIORITY = TO_CHAR(NULL),
3556: QUANTITY_CUTOFF_INFEAS_FLAG = TO_CHAR(NULL),
3557: QUANTITY_CUTOFF_COST = TO_NUMBER(NULL)

Line 3572: UPDATE PON_OPTIMIZE_CONSTRAINTS

3568: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
3569: END IF;
3570: END IF;
3571:
3572: UPDATE PON_OPTIMIZE_CONSTRAINTS
3573: SET PRICE_CUTOFF = TO_NUMBER(NULL),
3574: PRICE_CUTOFF_PRIORITY = TO_CHAR(NULL),
3575: PRICE_CUTOFF_INFEAS_FLAG = TO_CHAR(NULL),
3576: PRICE_CUTOFF_COST = TO_NUMBER(NULL)

Line 3594: UPDATE PON_OPTIMIZE_CONSTRAINTS

3590: -- XYZ - SIMILAR CONDITION NEEDED FOR
3591: -- AwardOptConstraint.SINGLE_HEADER_ATTR_CUTOFF
3592: -- AwardOptConstraint.GROUP_HEADER_ATTR_CUTOFF
3593:
3594: UPDATE PON_OPTIMIZE_CONSTRAINTS
3595: SET MIN_SCORE = TO_NUMBER(NULL),
3596: MIN_SCORE_PRIORITY = TO_CHAR(NULL),
3597: MIN_SCORE_INFEAS_FLAG = TO_CHAR(NULL),
3598: MIN_SCORE_COST = TO_NUMBER(NULL)

Line 3611: UPDATE PON_OPTIMIZE_CONSTRAINTS

3607: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
3608: END IF;
3609: END IF;
3610:
3611: UPDATE PON_OPTIMIZE_CONSTRAINTS
3612: SET FROM_DATE = TO_DATE(NULL),
3613: TO_DATE = TO_DATE(NULL),
3614: PROMISED_DATE_PRIORITY = TO_CHAR(NULL),
3615: PROMISED_DATE_INFEAS_FLAG = TO_CHAR(NULL),

Line 3639: UPDATE PON_OPTIMIZE_CONSTRAINTS

3635: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
3636: END IF;
3637: END IF;
3638:
3639: UPDATE PON_OPTIMIZE_CONSTRAINTS
3640: SET MIN_QUANTITY = TO_NUMBER(NULL),
3641: MAX_QUANTITY = TO_NUMBER(NULL),
3642: MIN_MAX_QUANTITY_PRIORITY = TO_CHAR(NULL),
3643: MIN_MAX_QUANTITY_COST = TO_NUMBER(NULL),

Line 3658: UPDATE PON_OPTIMIZE_CONSTRAINTS

3654: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
3655: END IF;
3656: END IF;
3657:
3658: UPDATE PON_OPTIMIZE_CONSTRAINTS
3659: SET MIN_AMOUNT = TO_NUMBER(NULL),
3660: MAX_AMOUNT = TO_NUMBER(NULL),
3661: MIN_MAX_AMOUNT_PRIORITY = TO_CHAR(NULL),
3662: MIN_MAX_AMOUNT_COST = TO_NUMBER(NULL),

Line 3671: --DELETE FROM PON_OPTIMIZE_CONSTRAINTS

3667:
3668:
3669: --ELSE
3670:
3671: --DELETE FROM PON_OPTIMIZE_CONSTRAINTS
3672: --WHERE SCENARIO_ID = p_scenario_id
3673: --AND CONSTRAINT_TYPE = p_constraint_type
3674: --AND SEQUENCE_NUMBER = p_sequence_number;
3675:

Line 3688: UPDATE PON_OPTIMIZE_CONSTRAINTS

3684: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
3685: END IF;
3686: END IF;
3687:
3688: UPDATE PON_OPTIMIZE_CONSTRAINTS
3689: SET MIN_AMOUNT = TO_NUMBER(NULL),
3690: MAX_AMOUNT = TO_NUMBER(NULL),
3691: MIN_MAX_AMOUNT_PRIORITY = TO_CHAR(NULL),
3692: MIN_MAX_AMOUNT_COST = TO_NUMBER(NULL),

Line 3709: UPDATE PON_OPTIMIZE_CONSTRAINTS

3705: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
3706: END IF;
3707: END IF;
3708:
3709: UPDATE PON_OPTIMIZE_CONSTRAINTS
3710: SET MIN_AMOUNT = TO_NUMBER(NULL),
3711: MAX_AMOUNT = TO_NUMBER(NULL),
3712: MIN_MAX_AMOUNT_PRIORITY = TO_CHAR(NULL),
3713: MIN_MAX_AMOUNT_COST = TO_NUMBER(NULL),

Line 3727: UPDATE PON_OPTIMIZE_CONSTRAINTS

3723: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
3724: END IF;
3725: END IF;
3726:
3727: UPDATE PON_OPTIMIZE_CONSTRAINTS
3728: SET MIN_QUANTITY = TO_NUMBER(NULL),
3729: MAX_QUANTITY = TO_NUMBER(NULL),
3730: MIN_MAX_QUANTITY_PRIORITY = TO_CHAR(NULL),
3731: MIN_MAX_QUANTITY_COST = TO_NUMBER(NULL),

Line 3742: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting constraint from pon_optimize_constraints');

3738: ELSE
3739:
3740: IF (g_debug_mode = 'Y') THEN
3741: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3742: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting constraint from pon_optimize_constraints');
3743: END IF;
3744: END IF;
3745: -- INCLUDES LINE-LEVEL INDIVIDUAL SUPPLIER CONSTRAINTS AS WELL
3746:

Line 3748: -- we can delete the row from pon_optimize_constraints

3744: END IF;
3745: -- INCLUDES LINE-LEVEL INDIVIDUAL SUPPLIER CONSTRAINTS AS WELL
3746:
3747: -- if the constraint type is either of the remaining types,
3748: -- we can delete the row from pon_optimize_constraints
3749: -- using the sequence_number
3750:
3751: DELETE FROM PON_OPTIMIZE_CONSTRAINTS
3752: WHERE SCENARIO_ID = l_new_scenario_id

Line 3751: DELETE FROM PON_OPTIMIZE_CONSTRAINTS

3747: -- if the constraint type is either of the remaining types,
3748: -- we can delete the row from pon_optimize_constraints
3749: -- using the sequence_number
3750:
3751: DELETE FROM PON_OPTIMIZE_CONSTRAINTS
3752: WHERE SCENARIO_ID = l_new_scenario_id
3753: AND CONSTRAINT_TYPE = p_constraint_type
3754: AND SEQUENCE_NUMBER = p_sequence_number;
3755:

Line 3838: UPDATE PON_OPTIMIZE_CONSTRAINTS

3834: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
3835: END IF;
3836: END IF;
3837:
3838: UPDATE PON_OPTIMIZE_CONSTRAINTS
3839: SET SPLIT_AWARD_COST = l_cost_of_constraint
3840: WHERE SCENARIO_ID = l_parent_scenario_id
3841: AND SEQUENCE_NUMBER = p_sequence_number
3842: AND CONSTRAINT_TYPE = p_constraint_type;

Line 3852: UPDATE PON_OPTIMIZE_CONSTRAINTS

3848: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
3849: END IF;
3850: END IF;
3851:
3852: UPDATE PON_OPTIMIZE_CONSTRAINTS
3853: SET INTEGRAL_QTY_AWARD_COST = l_cost_of_constraint
3854: WHERE SCENARIO_ID = l_parent_scenario_id
3855: AND SEQUENCE_NUMBER = p_sequence_number
3856: AND CONSTRAINT_TYPE = p_constraint_type;

Line 3867: UPDATE PON_OPTIMIZE_CONSTRAINTS

3863: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
3864: END IF;
3865: END IF;
3866:
3867: UPDATE PON_OPTIMIZE_CONSTRAINTS
3868: SET MIN_MAX_QUANTITY_COST = l_cost_of_constraint
3869: WHERE SCENARIO_ID = l_parent_scenario_id
3870: AND SEQUENCE_NUMBER = p_sequence_number
3871: AND CONSTRAINT_TYPE = p_constraint_type;

Line 3882: UPDATE PON_OPTIMIZE_CONSTRAINTS

3878: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
3879: END IF;
3880: END IF;
3881:
3882: UPDATE PON_OPTIMIZE_CONSTRAINTS
3883: SET MIN_MAX_AMOUNT_COST = l_cost_of_constraint
3884: WHERE SCENARIO_ID = l_parent_scenario_id
3885: AND SEQUENCE_NUMBER = p_sequence_number
3886: AND CONSTRAINT_TYPE = p_constraint_type;

Line 3897: UPDATE PON_OPTIMIZE_CONSTRAINTS

3893: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
3894: END IF;
3895: END IF;
3896:
3897: UPDATE PON_OPTIMIZE_CONSTRAINTS
3898: SET QUANTITY_CUTOFF_COST = l_cost_of_constraint
3899: WHERE SCENARIO_ID = l_parent_scenario_id
3900: AND SEQUENCE_NUMBER = p_sequence_number
3901: AND CONSTRAINT_TYPE = p_constraint_type;

Line 3913: UPDATE PON_OPTIMIZE_CONSTRAINTS

3909: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
3910: END IF;
3911: END IF;
3912:
3913: UPDATE PON_OPTIMIZE_CONSTRAINTS
3914: SET PRICE_CUTOFF_COST = l_cost_of_constraint
3915: WHERE SCENARIO_ID = l_parent_scenario_id
3916: AND SEQUENCE_NUMBER = p_sequence_number
3917: AND CONSTRAINT_TYPE = p_constraint_type;

Line 3929: UPDATE PON_OPTIMIZE_CONSTRAINTS

3925: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');
3926: END IF;
3927: END IF;
3928:
3929: UPDATE PON_OPTIMIZE_CONSTRAINTS
3930: SET MIN_SCORE_COST = l_cost_of_constraint
3931: WHERE SCENARIO_ID = l_parent_scenario_id
3932: AND SEQUENCE_NUMBER = p_sequence_number
3933: AND CONSTRAINT_TYPE = p_constraint_type;

Line 3943: UPDATE PON_OPTIMIZE_CONSTRAINTS

3939: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
3940: END IF;
3941: END IF;
3942:
3943: UPDATE PON_OPTIMIZE_CONSTRAINTS
3944: SET PROMISED_DATE_COST = l_cost_of_constraint
3945: WHERE SCENARIO_ID = l_parent_scenario_id
3946: AND SEQUENCE_NUMBER = p_sequence_number
3947: AND CONSTRAINT_TYPE = p_constraint_type;

Line 3969: UPDATE PON_OPTIMIZE_CONSTRAINTS

3965: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
3966: END IF;
3967: END IF;
3968:
3969: UPDATE PON_OPTIMIZE_CONSTRAINTS
3970: SET MIN_MAX_QUANTITY_COST = l_cost_of_constraint
3971: WHERE SCENARIO_ID = l_parent_scenario_id
3972: AND SEQUENCE_NUMBER = p_sequence_number
3973: AND CONSTRAINT_TYPE = p_constraint_type;

Line 3984: UPDATE PON_OPTIMIZE_CONSTRAINTS

3980: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
3981: END IF;
3982: END IF;
3983:
3984: UPDATE PON_OPTIMIZE_CONSTRAINTS
3985: SET MIN_MAX_AMOUNT_COST = l_cost_of_constraint
3986: WHERE SCENARIO_ID = l_parent_scenario_id
3987: AND SEQUENCE_NUMBER = p_sequence_number
3988: AND CONSTRAINT_TYPE = p_constraint_type;

Line 4002: UPDATE PON_OPTIMIZE_CONSTRAINTS

3998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
3999: END IF;
4000: END IF;
4001:
4002: UPDATE PON_OPTIMIZE_CONSTRAINTS
4003: SET MIN_MAX_AMOUNT_COST = l_cost_of_constraint
4004: WHERE SCENARIO_ID = l_parent_scenario_id
4005: AND SEQUENCE_NUMBER = p_sequence_number
4006: AND CONSTRAINT_TYPE = p_constraint_type;

Line 4016: UPDATE PON_OPTIMIZE_CONSTRAINTS

4012: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
4013: END IF;
4014: END IF;
4015:
4016: UPDATE PON_OPTIMIZE_CONSTRAINTS
4017: SET MIN_MAX_QUANTITY_COST = l_cost_of_constraint
4018: WHERE SCENARIO_ID = l_parent_scenario_id
4019: AND SEQUENCE_NUMBER = p_sequence_number
4020: AND CONSTRAINT_TYPE = p_constraint_type;

Line 4031: UPDATE PON_OPTIMIZE_CONSTRAINTS

4027: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
4028: END IF;
4029: END IF;
4030:
4031: UPDATE PON_OPTIMIZE_CONSTRAINTS
4032: SET MIN_MAX_AMOUNT_COST = l_cost_of_constraint
4033: WHERE SCENARIO_ID = l_parent_scenario_id
4034: AND SEQUENCE_NUMBER = p_sequence_number
4035: AND CONSTRAINT_TYPE = p_constraint_type;

Line 4051: UPDATE PON_OPTIMIZE_CONSTRAINTS

4047: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'SUPP_ASL_CONST, SUPPLIER_CONST constraint types');
4048: END IF;
4049: END IF;
4050:
4051: UPDATE PON_OPTIMIZE_CONSTRAINTS
4052: SET MIN_MAX_AMOUNT_COST = l_cost_of_constraint
4053: WHERE SCENARIO_ID = l_parent_scenario_id
4054: AND SEQUENCE_NUMBER = p_sequence_number
4055: AND CONSTRAINT_TYPE = p_constraint_type;

Line 4065: UPDATE PON_OPTIMIZE_CONSTRAINTS

4061: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NUM_OF_SUPP_CONST constraint type');
4062: END IF;
4063: END IF;
4064:
4065: UPDATE PON_OPTIMIZE_CONSTRAINTS
4066: SET MIN_MAX_QUANTITY_COST = l_cost_of_constraint
4067: WHERE SCENARIO_ID = l_parent_scenario_id
4068: AND SEQUENCE_NUMBER = p_sequence_number
4069: AND CONSTRAINT_TYPE = p_constraint_type;

Line 4080: UPDATE PON_OPTIMIZE_CONSTRAINTS

4076: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating TOTAL_HDR_ATTR_CONST, HDR_ATTR_CONST constraint types');
4077: END IF;
4078: END IF;
4079:
4080: UPDATE PON_OPTIMIZE_CONSTRAINTS
4081: SET MIN_SCORE_COST = l_cost_of_constraint
4082: WHERE SCENARIO_ID = l_parent_scenario_id
4083: AND SEQUENCE_NUMBER = p_sequence_number
4084: AND CONSTRAINT_TYPE = p_constraint_type;

Line 4094: UPDATE PON_OPTIMIZE_CONSTRAINTS

4090: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating INCL_HOLD_SUPP_CONST constraint type');
4091: END IF;
4092: END IF;
4093:
4094: UPDATE PON_OPTIMIZE_CONSTRAINTS
4095: SET EXCLUDED_SUPPLIER_COST = l_cost_of_constraint
4096: WHERE SCENARIO_ID = l_parent_scenario_id
4097: AND SEQUENCE_NUMBER = p_sequence_number
4098: AND CONSTRAINT_TYPE = p_constraint_type;

Line 4108: UPDATE PON_OPTIMIZE_CONSTRAINTS

4104: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NO_SPLIT_GROUP_CONST constraint type');
4105: END IF;
4106: END IF;
4107:
4108: UPDATE PON_OPTIMIZE_CONSTRAINTS
4109: SET SPLIT_AWARD_COST = l_cost_of_constraint
4110: WHERE SCENARIO_ID = l_parent_scenario_id
4111: AND SEQUENCE_NUMBER = p_sequence_number
4112: AND CONSTRAINT_TYPE = p_constraint_type;

Line 4132: from pon_optimize_constraints

4128:
4129:
4130: -- make sure there is at least 1 row to prevent no data found exception
4131: select count(*) into l_num_constraints
4132: from pon_optimize_constraints
4133: where scenario_id = p_scenario_id;
4134:
4135: IF (l_num_constraints > 0) THEN
4136: IF (g_debug_mode = 'Y') THEN

Line 4138: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario constraints from PON_OPTIMIZE_CONSTRAINTS for p_scenario_id: ' || p_scenario_id );

4134:
4135: IF (l_num_constraints > 0) THEN
4136: IF (g_debug_mode = 'Y') THEN
4137: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4138: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario constraints from PON_OPTIMIZE_CONSTRAINTS for p_scenario_id: ' || p_scenario_id );
4139: END IF;
4140: END IF;
4141:
4142: DELETE FROM PON_OPTIMIZE_CONSTRAINTS WHERE SCENARIO_ID = P_SCENARIO_ID;

Line 4142: DELETE FROM PON_OPTIMIZE_CONSTRAINTS WHERE SCENARIO_ID = P_SCENARIO_ID;

4138: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario constraints from PON_OPTIMIZE_CONSTRAINTS for p_scenario_id: ' || p_scenario_id );
4139: END IF;
4140: END IF;
4141:
4142: DELETE FROM PON_OPTIMIZE_CONSTRAINTS WHERE SCENARIO_ID = P_SCENARIO_ID;
4143:
4144: END IF;
4145:
4146: select count(*) into l_num_bid_classes

Line 4207: from pon_optimize_constraints

4203: l_num_constraints := -1;
4204:
4205: -- make sure there is at least 1 row to prevent no data found exception
4206: select count(*) into l_num_constraints
4207: from pon_optimize_constraints
4208: where scenario_id = p_scenario_id;
4209:
4210: IF (l_num_constraints > 0) THEN
4211:

Line 4212: UPDATE PON_OPTIMIZE_CONSTRAINTS

4208: where scenario_id = p_scenario_id;
4209:
4210: IF (l_num_constraints > 0) THEN
4211:
4212: UPDATE PON_OPTIMIZE_CONSTRAINTS
4213: SET
4214: MIN_MAX_AMOUNT_COST = TO_NUMBER(NULL),
4215: MIN_MAX_QUANTITY_COST = TO_NUMBER(NULL),
4216: PRICE_CUTOFF_COST = TO_NUMBER(NULL),