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 3787: from pon_optimize_constraints

3783: -- copy the constraints
3784:
3785: -- make sure there is at least 1 row to prevent no data found exception
3786: select count(*) into l_num_constraints
3787: from pon_optimize_constraints
3788: where scenario_id = p_scenario_id;
3789:
3790: IF (l_num_constraints > 0) THEN
3791:

Line 3792: INSERT INTO PON_OPTIMIZE_CONSTRAINTS(

3788: where scenario_id = p_scenario_id;
3789:
3790: IF (l_num_constraints > 0) THEN
3791:
3792: INSERT INTO PON_OPTIMIZE_CONSTRAINTS(
3793: scenario_id,
3794: sequence_number,
3795: auction_header_id,
3796: constraint_type,

Line 3905: FROM pon_optimize_constraints

3901: ,TO_CHAR(NULL)
3902: ,MIN_SCORE_PRIORITY
3903: ,TO_NUMBER(NULL)
3904: ,TO_CHAR(NULL)
3905: FROM pon_optimize_constraints
3906: WHERE scenario_id = p_scenario_id;
3907:
3908: END IF;
3909:

Line 4550: p_scenario_id IN PON_OPTIMIZE_CONSTRAINTS.SCENARIO_ID%TYPE,

4546:
4547:
4548: FUNCTION does_bid_exist
4549: (
4550: p_scenario_id IN PON_OPTIMIZE_CONSTRAINTS.SCENARIO_ID%TYPE,
4551: p_sequence_number IN PON_OPTIMIZE_CONSTRAINTS.SEQUENCE_NUMBER%TYPE,
4552: p_bid_number IN PON_BID_HEADERS.BID_NUMBER%TYPE
4553: ) RETURN VARCHAR2
4554: IS

Line 4551: p_sequence_number IN PON_OPTIMIZE_CONSTRAINTS.SEQUENCE_NUMBER%TYPE,

4547:
4548: FUNCTION does_bid_exist
4549: (
4550: p_scenario_id IN PON_OPTIMIZE_CONSTRAINTS.SCENARIO_ID%TYPE,
4551: p_sequence_number IN PON_OPTIMIZE_CONSTRAINTS.SEQUENCE_NUMBER%TYPE,
4552: p_bid_number IN PON_BID_HEADERS.BID_NUMBER%TYPE
4553: ) RETURN VARCHAR2
4554: IS
4555: l_bid_exists VARCHAR2(1);

Line 4654: -- same row of pon_optimize_constraints table

4650: IF (l_status <> 'FAILURE') THEN
4651:
4652: -- these initial conditions are applicable to those
4653: -- scenarios where multiple constraints are saved on the
4654: -- same row of pon_optimize_constraints table
4655:
4656: IF (p_constraint_type = 'LINE_CONST') THEN --{
4657:
4658: IF (p_internal_type = 'LINE_SPLIT_AWARD') THEN

Line 4666: UPDATE PON_OPTIMIZE_CONSTRAINTS

4662: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
4663: END IF;
4664: END IF;
4665:
4666: UPDATE PON_OPTIMIZE_CONSTRAINTS
4667: SET SPLIT_AWARD_FLAG = decode(SPLIT_AWARD_FLAG, 'Y', 'N', 'Y'),
4668: SPLIT_AWARD_PRIORITY = NVL2(SPLIT_AWARD_PRIORITY,l_priority,null),
4669: SPLIT_AWARD_INFEAS_FLAG = TO_CHAR(NULL),
4670: SPLIT_AWARD_COST = TO_NUMBER(NULL)

Line 4683: UPDATE PON_OPTIMIZE_CONSTRAINTS

4679: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
4680: END IF;
4681: END IF;
4682:
4683: UPDATE PON_OPTIMIZE_CONSTRAINTS
4684: SET INTEGRAL_QTY_AWARD_FLAG = decode(INTEGRAL_QTY_AWARD_FLAG, 'Y', 'N', 'Y'),
4685: INTEGRAL_QTY_AWARD_PRIORITY = NVL2(INTEGRAL_QTY_AWARD_PRIORITY,l_priority,null),
4686: INTEGRAL_QTY_AWARD_INFEAS_FLAG = TO_CHAR(NULL),
4687: INTEGRAL_QTY_AWARD_COST = TO_NUMBER(NULL)

Line 4732: UPDATE PON_OPTIMIZE_CONSTRAINTS

4728: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
4729: END IF;
4730: END IF;
4731:
4732: UPDATE PON_OPTIMIZE_CONSTRAINTS
4733: SET MIN_QUANTITY = 0,
4734: MAX_QUANTITY = DECODE(l_order_type_lookup_code, 'FIXED PRICE', 1, 'AMOUNT', 1, l_auction_qty),
4735: MIN_MAX_QUANTITY_PRIORITY = NVL2(MIN_MAX_QUANTITY_PRIORITY,l_priority,null),
4736: MIN_MAX_QUANTITY_COST = TO_NUMBER(NULL),

Line 4750: UPDATE PON_OPTIMIZE_CONSTRAINTS

4746: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
4747: END IF;
4748: END IF;
4749:
4750: UPDATE PON_OPTIMIZE_CONSTRAINTS
4751: SET MIN_AMOUNT = TO_NUMBER(NULL),
4752: MAX_AMOUNT = TO_NUMBER(NULL),
4753: MIN_MAX_AMOUNT_PRIORITY = TO_CHAR(NULL),
4754: MIN_MAX_AMOUNT_COST = TO_NUMBER(NULL),

Line 4769: UPDATE PON_OPTIMIZE_CONSTRAINTS

4765: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
4766: END IF;
4767: END IF;
4768:
4769: UPDATE PON_OPTIMIZE_CONSTRAINTS
4770: SET QUANTITY_CUTOFF = TO_NUMBER(NULL),
4771: QUANTITY_CUTOFF_PRIORITY = TO_CHAR(NULL),
4772: QUANTITY_CUTOFF_INFEAS_FLAG = TO_CHAR(NULL),
4773: QUANTITY_CUTOFF_COST = TO_NUMBER(NULL)

Line 4788: UPDATE PON_OPTIMIZE_CONSTRAINTS

4784: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
4785: END IF;
4786: END IF;
4787:
4788: UPDATE PON_OPTIMIZE_CONSTRAINTS
4789: SET PRICE_CUTOFF = TO_NUMBER(NULL),
4790: PRICE_CUTOFF_PRIORITY = TO_CHAR(NULL),
4791: PRICE_CUTOFF_INFEAS_FLAG = TO_CHAR(NULL),
4792: PRICE_CUTOFF_COST = TO_NUMBER(NULL)

Line 4810: UPDATE PON_OPTIMIZE_CONSTRAINTS

4806: -- XYZ - SIMILAR CONDITION NEEDED FOR
4807: -- AwardOptConstraint.SINGLE_HEADER_ATTR_CUTOFF
4808: -- AwardOptConstraint.GROUP_HEADER_ATTR_CUTOFF
4809:
4810: UPDATE PON_OPTIMIZE_CONSTRAINTS
4811: SET MIN_SCORE = TO_NUMBER(NULL),
4812: MIN_SCORE_PRIORITY = TO_CHAR(NULL),
4813: MIN_SCORE_INFEAS_FLAG = TO_CHAR(NULL),
4814: MIN_SCORE_COST = TO_NUMBER(NULL)

Line 4827: UPDATE PON_OPTIMIZE_CONSTRAINTS

4823: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
4824: END IF;
4825: END IF;
4826:
4827: UPDATE PON_OPTIMIZE_CONSTRAINTS
4828: SET FROM_DATE = TO_DATE(NULL),
4829: TO_DATE = TO_DATE(NULL),
4830: PROMISED_DATE_PRIORITY = TO_CHAR(NULL),
4831: PROMISED_DATE_INFEAS_FLAG = TO_CHAR(NULL),

Line 4855: UPDATE PON_OPTIMIZE_CONSTRAINTS

4851: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
4852: END IF;
4853: END IF;
4854:
4855: UPDATE PON_OPTIMIZE_CONSTRAINTS
4856: SET MIN_QUANTITY = TO_NUMBER(NULL),
4857: MAX_QUANTITY = TO_NUMBER(NULL),
4858: MIN_MAX_QUANTITY_PRIORITY = TO_CHAR(NULL),
4859: MIN_MAX_QUANTITY_COST = TO_NUMBER(NULL),

Line 4874: UPDATE PON_OPTIMIZE_CONSTRAINTS

4870: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
4871: END IF;
4872: END IF;
4873:
4874: UPDATE PON_OPTIMIZE_CONSTRAINTS
4875: SET MIN_AMOUNT = TO_NUMBER(NULL),
4876: MAX_AMOUNT = TO_NUMBER(NULL),
4877: MIN_MAX_AMOUNT_PRIORITY = TO_CHAR(NULL),
4878: MIN_MAX_AMOUNT_COST = TO_NUMBER(NULL),

Line 4887: --DELETE FROM PON_OPTIMIZE_CONSTRAINTS

4883:
4884:
4885: --ELSE
4886:
4887: --DELETE FROM PON_OPTIMIZE_CONSTRAINTS
4888: --WHERE SCENARIO_ID = p_scenario_id
4889: --AND CONSTRAINT_TYPE = p_constraint_type
4890: --AND SEQUENCE_NUMBER = p_sequence_number;
4891:

Line 4904: UPDATE PON_OPTIMIZE_CONSTRAINTS

4900: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
4901: END IF;
4902: END IF;
4903:
4904: UPDATE PON_OPTIMIZE_CONSTRAINTS
4905: SET MIN_AMOUNT = TO_NUMBER(NULL),
4906: MAX_AMOUNT = TO_NUMBER(NULL),
4907: MIN_MAX_AMOUNT_PRIORITY = TO_CHAR(NULL),
4908: MIN_MAX_AMOUNT_COST = TO_NUMBER(NULL),

Line 4925: UPDATE PON_OPTIMIZE_CONSTRAINTS

4921: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
4922: END IF;
4923: END IF;
4924:
4925: UPDATE PON_OPTIMIZE_CONSTRAINTS
4926: SET MIN_AMOUNT = TO_NUMBER(NULL),
4927: MAX_AMOUNT = TO_NUMBER(NULL),
4928: MIN_MAX_AMOUNT_PRIORITY = TO_CHAR(NULL),
4929: MIN_MAX_AMOUNT_COST = TO_NUMBER(NULL),

Line 4943: UPDATE PON_OPTIMIZE_CONSTRAINTS

4939: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
4940: END IF;
4941: END IF;
4942:
4943: UPDATE PON_OPTIMIZE_CONSTRAINTS
4944: SET MIN_QUANTITY = TO_NUMBER(NULL),
4945: MAX_QUANTITY = TO_NUMBER(NULL),
4946: MIN_MAX_QUANTITY_PRIORITY = TO_CHAR(NULL),
4947: MIN_MAX_QUANTITY_COST = TO_NUMBER(NULL),

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

4954: ELSE
4955:
4956: IF (g_debug_mode = 'Y') THEN
4957: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4958: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting constraint from pon_optimize_constraints');
4959: END IF;
4960: END IF;
4961: -- INCLUDES LINE-LEVEL INDIVIDUAL SUPPLIER CONSTRAINTS AS WELL
4962:

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

4960: END IF;
4961: -- INCLUDES LINE-LEVEL INDIVIDUAL SUPPLIER CONSTRAINTS AS WELL
4962:
4963: -- if the constraint type is either of the remaining types,
4964: -- we can delete the row from pon_optimize_constraints
4965: -- using the sequence_number
4966:
4967: DELETE FROM PON_OPTIMIZE_CONSTRAINTS
4968: WHERE SCENARIO_ID = l_new_scenario_id

Line 4967: DELETE FROM PON_OPTIMIZE_CONSTRAINTS

4963: -- if the constraint type is either of the remaining types,
4964: -- we can delete the row from pon_optimize_constraints
4965: -- using the sequence_number
4966:
4967: DELETE FROM PON_OPTIMIZE_CONSTRAINTS
4968: WHERE SCENARIO_ID = l_new_scenario_id
4969: AND CONSTRAINT_TYPE = p_constraint_type
4970: AND SEQUENCE_NUMBER = p_sequence_number;
4971:

Line 5054: UPDATE PON_OPTIMIZE_CONSTRAINTS

5050: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SPLIT_AWARD internal type constraint');
5051: END IF;
5052: END IF;
5053:
5054: UPDATE PON_OPTIMIZE_CONSTRAINTS
5055: SET SPLIT_AWARD_COST = l_cost_of_constraint
5056: WHERE SCENARIO_ID = l_parent_scenario_id
5057: AND SEQUENCE_NUMBER = p_sequence_number
5058: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5068: UPDATE PON_OPTIMIZE_CONSTRAINTS

5064: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_INTEGER_QUANTITY internal type constraint');
5065: END IF;
5066: END IF;
5067:
5068: UPDATE PON_OPTIMIZE_CONSTRAINTS
5069: SET INTEGRAL_QTY_AWARD_COST = l_cost_of_constraint
5070: WHERE SCENARIO_ID = l_parent_scenario_id
5071: AND SEQUENCE_NUMBER = p_sequence_number
5072: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5083: UPDATE PON_OPTIMIZE_CONSTRAINTS

5079: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_QTY internal type constraint');
5080: END IF;
5081: END IF;
5082:
5083: UPDATE PON_OPTIMIZE_CONSTRAINTS
5084: SET MIN_MAX_QUANTITY_COST = l_cost_of_constraint
5085: WHERE SCENARIO_ID = l_parent_scenario_id
5086: AND SEQUENCE_NUMBER = p_sequence_number
5087: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5098: UPDATE PON_OPTIMIZE_CONSTRAINTS

5094: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_AWARD_AMOUNT internal type constraint');
5095: END IF;
5096: END IF;
5097:
5098: UPDATE PON_OPTIMIZE_CONSTRAINTS
5099: SET MIN_MAX_AMOUNT_COST = l_cost_of_constraint
5100: WHERE SCENARIO_ID = l_parent_scenario_id
5101: AND SEQUENCE_NUMBER = p_sequence_number
5102: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5113: UPDATE PON_OPTIMIZE_CONSTRAINTS

5109: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_QTY internal type constraint');
5110: END IF;
5111: END IF;
5112:
5113: UPDATE PON_OPTIMIZE_CONSTRAINTS
5114: SET QUANTITY_CUTOFF_COST = l_cost_of_constraint
5115: WHERE SCENARIO_ID = l_parent_scenario_id
5116: AND SEQUENCE_NUMBER = p_sequence_number
5117: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5129: UPDATE PON_OPTIMIZE_CONSTRAINTS

5125: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MAX_PRICE internal type constraint');
5126: END IF;
5127: END IF;
5128:
5129: UPDATE PON_OPTIMIZE_CONSTRAINTS
5130: SET PRICE_CUTOFF_COST = l_cost_of_constraint
5131: WHERE SCENARIO_ID = l_parent_scenario_id
5132: AND SEQUENCE_NUMBER = p_sequence_number
5133: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5145: UPDATE PON_OPTIMIZE_CONSTRAINTS

5141: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_MIN_SCORE internal type constraint');
5142: END IF;
5143: END IF;
5144:
5145: UPDATE PON_OPTIMIZE_CONSTRAINTS
5146: SET MIN_SCORE_COST = l_cost_of_constraint
5147: WHERE SCENARIO_ID = l_parent_scenario_id
5148: AND SEQUENCE_NUMBER = p_sequence_number
5149: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5159: UPDATE PON_OPTIMIZE_CONSTRAINTS

5155: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_PROMISED_DATE internal type constraint');
5156: END IF;
5157: END IF;
5158:
5159: UPDATE PON_OPTIMIZE_CONSTRAINTS
5160: SET PROMISED_DATE_COST = l_cost_of_constraint
5161: WHERE SCENARIO_ID = l_parent_scenario_id
5162: AND SEQUENCE_NUMBER = p_sequence_number
5163: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5185: UPDATE PON_OPTIMIZE_CONSTRAINTS

5181: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_NUM_SUPP internal type constraint');
5182: END IF;
5183: END IF;
5184:
5185: UPDATE PON_OPTIMIZE_CONSTRAINTS
5186: SET MIN_MAX_QUANTITY_COST = l_cost_of_constraint
5187: WHERE SCENARIO_ID = l_parent_scenario_id
5188: AND SEQUENCE_NUMBER = p_sequence_number
5189: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5200: UPDATE PON_OPTIMIZE_CONSTRAINTS

5196: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_ANY_ONE_SUPP internal type constraint');
5197: END IF;
5198: END IF;
5199:
5200: UPDATE PON_OPTIMIZE_CONSTRAINTS
5201: SET MIN_MAX_AMOUNT_COST = l_cost_of_constraint
5202: WHERE SCENARIO_ID = l_parent_scenario_id
5203: AND SEQUENCE_NUMBER = p_sequence_number
5204: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5218: UPDATE PON_OPTIMIZE_CONSTRAINTS

5214: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_AMT internal type constraint');
5215: END IF;
5216: END IF;
5217:
5218: UPDATE PON_OPTIMIZE_CONSTRAINTS
5219: SET MIN_MAX_AMOUNT_COST = l_cost_of_constraint
5220: WHERE SCENARIO_ID = l_parent_scenario_id
5221: AND SEQUENCE_NUMBER = p_sequence_number
5222: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5232: UPDATE PON_OPTIMIZE_CONSTRAINTS

5228: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating LINE_SUPP_SITE_QTT internal type constraint');
5229: END IF;
5230: END IF;
5231:
5232: UPDATE PON_OPTIMIZE_CONSTRAINTS
5233: SET MIN_MAX_QUANTITY_COST = l_cost_of_constraint
5234: WHERE SCENARIO_ID = l_parent_scenario_id
5235: AND SEQUENCE_NUMBER = p_sequence_number
5236: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5247: UPDATE PON_OPTIMIZE_CONSTRAINTS

5243: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating SUPP_BIZ_CONST constraint type');
5244: END IF;
5245: END IF;
5246:
5247: UPDATE PON_OPTIMIZE_CONSTRAINTS
5248: SET MIN_MAX_AMOUNT_COST = l_cost_of_constraint
5249: WHERE SCENARIO_ID = l_parent_scenario_id
5250: AND SEQUENCE_NUMBER = p_sequence_number
5251: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5267: UPDATE PON_OPTIMIZE_CONSTRAINTS

5263: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'SUPP_ASL_CONST, SUPPLIER_CONST constraint types');
5264: END IF;
5265: END IF;
5266:
5267: UPDATE PON_OPTIMIZE_CONSTRAINTS
5268: SET MIN_MAX_AMOUNT_COST = l_cost_of_constraint
5269: WHERE SCENARIO_ID = l_parent_scenario_id
5270: AND SEQUENCE_NUMBER = p_sequence_number
5271: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5281: UPDATE PON_OPTIMIZE_CONSTRAINTS

5277: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NUM_OF_SUPP_CONST constraint type');
5278: END IF;
5279: END IF;
5280:
5281: UPDATE PON_OPTIMIZE_CONSTRAINTS
5282: SET MIN_MAX_QUANTITY_COST = l_cost_of_constraint
5283: WHERE SCENARIO_ID = l_parent_scenario_id
5284: AND SEQUENCE_NUMBER = p_sequence_number
5285: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5296: UPDATE PON_OPTIMIZE_CONSTRAINTS

5292: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating TOTAL_HDR_ATTR_CONST, HDR_ATTR_CONST constraint types');
5293: END IF;
5294: END IF;
5295:
5296: UPDATE PON_OPTIMIZE_CONSTRAINTS
5297: SET MIN_SCORE_COST = l_cost_of_constraint
5298: WHERE SCENARIO_ID = l_parent_scenario_id
5299: AND SEQUENCE_NUMBER = p_sequence_number
5300: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5310: UPDATE PON_OPTIMIZE_CONSTRAINTS

5306: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating INCL_HOLD_SUPP_CONST constraint type');
5307: END IF;
5308: END IF;
5309:
5310: UPDATE PON_OPTIMIZE_CONSTRAINTS
5311: SET EXCLUDED_SUPPLIER_COST = l_cost_of_constraint
5312: WHERE SCENARIO_ID = l_parent_scenario_id
5313: AND SEQUENCE_NUMBER = p_sequence_number
5314: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5324: UPDATE PON_OPTIMIZE_CONSTRAINTS

5320: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before updating NO_SPLIT_GROUP_CONST constraint type');
5321: END IF;
5322: END IF;
5323:
5324: UPDATE PON_OPTIMIZE_CONSTRAINTS
5325: SET SPLIT_AWARD_COST = l_cost_of_constraint
5326: WHERE SCENARIO_ID = l_parent_scenario_id
5327: AND SEQUENCE_NUMBER = p_sequence_number
5328: AND CONSTRAINT_TYPE = p_constraint_type;

Line 5348: from pon_optimize_constraints

5344:
5345:
5346: -- make sure there is at least 1 row to prevent no data found exception
5347: select count(*) into l_num_constraints
5348: from pon_optimize_constraints
5349: where scenario_id = p_scenario_id;
5350:
5351: IF (l_num_constraints > 0) THEN
5352: IF (g_debug_mode = 'Y') THEN

Line 5354: 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 );

5350:
5351: IF (l_num_constraints > 0) THEN
5352: IF (g_debug_mode = 'Y') THEN
5353: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5354: 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 );
5355: END IF;
5356: END IF;
5357:
5358: DELETE FROM PON_OPTIMIZE_CONSTRAINTS WHERE SCENARIO_ID = P_SCENARIO_ID;

Line 5358: DELETE FROM PON_OPTIMIZE_CONSTRAINTS WHERE SCENARIO_ID = P_SCENARIO_ID;

5354: 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 );
5355: END IF;
5356: END IF;
5357:
5358: DELETE FROM PON_OPTIMIZE_CONSTRAINTS WHERE SCENARIO_ID = P_SCENARIO_ID;
5359:
5360: END IF;
5361:
5362: select count(*) into l_num_bid_classes

Line 5423: from pon_optimize_constraints

5419: l_num_constraints := -1;
5420:
5421: -- make sure there is at least 1 row to prevent no data found exception
5422: select count(*) into l_num_constraints
5423: from pon_optimize_constraints
5424: where scenario_id = p_scenario_id;
5425:
5426: IF (l_num_constraints > 0) THEN
5427:

Line 5428: UPDATE PON_OPTIMIZE_CONSTRAINTS

5424: where scenario_id = p_scenario_id;
5425:
5426: IF (l_num_constraints > 0) THEN
5427:
5428: UPDATE PON_OPTIMIZE_CONSTRAINTS
5429: SET
5430: MIN_MAX_AMOUNT_COST = TO_NUMBER(NULL),
5431: MIN_MAX_QUANTITY_COST = TO_NUMBER(NULL),
5432: PRICE_CUTOFF_COST = TO_NUMBER(NULL),