APPS.PON_AWARD_PKG dependencies on PON_OPTIMIZE_BID_CLASS

Line 3913: from pon_optimize_bid_class

3909:
3910: -- copy the bid class information
3911: -- make sure a row exists first to prevent no data found exception
3912: select count(*) into l_num_bid_classes
3913: from pon_optimize_bid_class
3914: where scenario_id = p_scenario_id;
3915:
3916: IF (l_num_bid_classes > 0) THEN
3917: INSERT INTO PON_OPTIMIZE_BID_CLASS(

Line 3917: INSERT INTO PON_OPTIMIZE_BID_CLASS(

3913: from pon_optimize_bid_class
3914: where scenario_id = p_scenario_id;
3915:
3916: IF (l_num_bid_classes > 0) THEN
3917: INSERT INTO PON_OPTIMIZE_BID_CLASS(
3918: scenario_id,
3919: sequence_number,
3920: bid_number,
3921: creation_date,

Line 3935: FROM pon_optimize_bid_class

3931: l_fnd_user_id,
3932: sysdate,
3933: l_fnd_user_id,
3934: l_fnd_user_id
3935: FROM pon_optimize_bid_class
3936: WHERE scenario_id = p_scenario_id;
3937: END IF;
3938:
3939: x_status := 'SUCCESS';

Line 4563: FROM pon_optimize_bid_class pobc

4559: SELECT 'Y'
4560: INTO l_bid_exists
4561: FROM dual
4562: WHERE EXISTS (SELECT 1
4563: FROM pon_optimize_bid_class pobc
4564: WHERE pobc.scenario_id = p_scenario_id
4565: AND pobc.sequence_number = p_sequence_number
4566: AND pobc.bid_number = p_bid_number);
4567:

Line 5363: from pon_optimize_bid_class

5359:
5360: END IF;
5361:
5362: select count(*) into l_num_bid_classes
5363: from pon_optimize_bid_class
5364: where scenario_id = p_scenario_id;
5365:
5366: IF (l_num_bid_classes > 0) THEN
5367: IF (g_debug_mode = 'Y') THEN

Line 5369: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario details from PON_OPTIMIZE_BID_CLASS for p_scenario_id: ' || p_scenario_id );

5365:
5366: IF (l_num_bid_classes > 0) THEN
5367: IF (g_debug_mode = 'Y') THEN
5368: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5369: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario details from PON_OPTIMIZE_BID_CLASS for p_scenario_id: ' || p_scenario_id );
5370: END IF;
5371: END IF;
5372:
5373: DELETE FROM PON_OPTIMIZE_BID_CLASS WHERE SCENARIO_ID = P_SCENARIO_ID;

Line 5373: DELETE FROM PON_OPTIMIZE_BID_CLASS WHERE SCENARIO_ID = P_SCENARIO_ID;

5369: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Before deleting the dummy scenario details from PON_OPTIMIZE_BID_CLASS for p_scenario_id: ' || p_scenario_id );
5370: END IF;
5371: END IF;
5372:
5373: DELETE FROM PON_OPTIMIZE_BID_CLASS WHERE SCENARIO_ID = P_SCENARIO_ID;
5374: END IF;
5375:
5376: select count(*) into l_num_results
5377: from pon_optimize_results