APPS.AS_OPP_HEADER_PVT dependencies on AS_STATUSES_B

Line 500: from as_statuses_b

496: IS
497:
498: CURSOR c_WIN_LOSS_INDICATOR(c_STATUS_CODE VARCHAR2) IS
499: select WIN_LOSS_INDICATOR
500: from as_statuses_b
501: where status_code = c_STATUS_CODE;
502:
503: l_indicator varchar2(1);
504:

Line 1451: as_statuses_b st

1447:
1448: cursor comp_required ( p_status_profile VARCHAR2, p_lead_id NUMBER) IS
1449: select 'Y'
1450: from as_leads_all ld,
1451: as_statuses_b st
1452: where ld.status = st.status_code
1453: and ld.lead_id = p_lead_id
1454: and (( p_status_profile = 'BOTH' and
1455: ( st.OPP_OPEN_STATUS_FLAG <> 'Y' or st.FORECAST_ROLLUP_FLAG = 'Y')) OR

Line 1517: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;

1513: l_opp_worst_forecast_amount NUMBER;
1514: l_opp_forecast_amount NUMBER;
1515: l_opp_best_forecast_amount NUMBER;
1516: l_win_probability NUMBER;
1517: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
1518: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
1519: l_old_win_probability NUMBER;
1520: l_old_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
1521: l_old_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;

Line 1518: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;

1514: l_opp_forecast_amount NUMBER;
1515: l_opp_best_forecast_amount NUMBER;
1516: l_win_probability NUMBER;
1517: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
1518: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
1519: l_old_win_probability NUMBER;
1520: l_old_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
1521: l_old_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
1522: l_old_tot_rev_opp_forecast_amt NUMBER; -- Added for ASNB

Line 1520: l_old_win_loss_indicator as_statuses_b.win_loss_indicator%Type;

1516: l_win_probability NUMBER;
1517: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
1518: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
1519: l_old_win_probability NUMBER;
1520: l_old_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
1521: l_old_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
1522: l_old_tot_rev_opp_forecast_amt NUMBER; -- Added for ASNB
1523: l_tot_rev_opp_forecast_amt NUMBER; -- Added for R12
1524: l_update_count NUMBER;

Line 1521: l_old_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;

1517: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
1518: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
1519: l_old_win_probability NUMBER;
1520: l_old_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
1521: l_old_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
1522: l_old_tot_rev_opp_forecast_amt NUMBER; -- Added for ASNB
1523: l_tot_rev_opp_forecast_amt NUMBER; -- Added for R12
1524: l_update_count NUMBER;
1525: l_count NUMBER;

Line 3111: FROM as_statuses_b

3107: )
3108: IS
3109: CURSOR C_STATUS_Exists (c_status CHAR) IS
3110: SELECT 'X'
3111: FROM as_statuses_b
3112: WHERE status_code = c_status
3113: and enabled_flag = 'Y'
3114: and opp_flag = 'Y';
3115:

Line 3159: -- STATUS should exist in as_statuses_b

3155: p_msg_name => 'API_MISSING_STATUS');
3156:
3157: x_return_status := FND_API.G_RET_STS_ERROR;
3158:
3159: -- STATUS should exist in as_statuses_b
3160: ELSIF(p_STATUS <> FND_API.G_MISS_CHAR)
3161: THEN
3162: OPEN C_STATUS_Exists (p_STATUS);
3163: FETCH C_STATUS_Exists into l_val;

Line 5682: FROM as_statuses_b

5678: )
5679: IS
5680: CURSOR C_Get_OppOpenStatusFlag (c_STATUS_CODE VARCHAR2) IS
5681: SELECT opp_open_status_flag
5682: FROM as_statuses_b
5683: WHERE STATUS_CODE = c_STATUS_CODE
5684: and opp_flag = 'Y'
5685: and ENABLED_FLAG = 'Y';
5686: l_val VARCHAR2(1);