APPS.PON_AWARD_PKG dependencies on PON_OPTIMIZE_BID_CLASS

Line 2716: from pon_optimize_bid_class

2712:
2713: -- copy the bid class information
2714: -- make sure a row exists first to prevent no data found exception
2715: select count(*) into l_num_bid_classes
2716: from pon_optimize_bid_class
2717: where scenario_id = p_scenario_id;
2718:
2719: IF (l_num_bid_classes > 0) THEN
2720: INSERT INTO PON_OPTIMIZE_BID_CLASS(

Line 2720: INSERT INTO PON_OPTIMIZE_BID_CLASS(

2716: from pon_optimize_bid_class
2717: where scenario_id = p_scenario_id;
2718:
2719: IF (l_num_bid_classes > 0) THEN
2720: INSERT INTO PON_OPTIMIZE_BID_CLASS(
2721: scenario_id,
2722: sequence_number,
2723: bid_number,
2724: creation_date,

Line 2738: FROM pon_optimize_bid_class

2734: l_fnd_user_id,
2735: sysdate,
2736: l_fnd_user_id,
2737: l_fnd_user_id
2738: FROM pon_optimize_bid_class
2739: WHERE scenario_id = p_scenario_id;
2740: END IF;
2741:
2742: x_status := 'SUCCESS';

Line 3347: FROM pon_optimize_bid_class pobc

3343: SELECT 'Y'
3344: INTO l_bid_exists
3345: FROM dual
3346: WHERE EXISTS (SELECT 1
3347: FROM pon_optimize_bid_class pobc
3348: WHERE pobc.scenario_id = p_scenario_id
3349: AND pobc.sequence_number = p_sequence_number
3350: AND pobc.bid_number = p_bid_number);
3351:

Line 4147: from pon_optimize_bid_class

4143:
4144: END IF;
4145:
4146: select count(*) into l_num_bid_classes
4147: from pon_optimize_bid_class
4148: where scenario_id = p_scenario_id;
4149:
4150: IF (l_num_bid_classes > 0) THEN
4151: IF (g_debug_mode = 'Y') THEN

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

4149:
4150: IF (l_num_bid_classes > 0) THEN
4151: IF (g_debug_mode = 'Y') THEN
4152: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4153: 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 );
4154: END IF;
4155: END IF;
4156:
4157: DELETE FROM PON_OPTIMIZE_BID_CLASS WHERE SCENARIO_ID = P_SCENARIO_ID;

Line 4157: DELETE FROM PON_OPTIMIZE_BID_CLASS WHERE SCENARIO_ID = P_SCENARIO_ID;

4153: 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 );
4154: END IF;
4155: END IF;
4156:
4157: DELETE FROM PON_OPTIMIZE_BID_CLASS WHERE SCENARIO_ID = P_SCENARIO_ID;
4158: END IF;
4159:
4160: select count(*) into l_num_results
4161: from pon_optimize_results