APPS.IBE_QUOTE_SAVE_PVT dependencies on ASO_QUOTE_STATUSES_VL

Line 1317: from aso_quote_statuses_vl

1313: l_retrieval_number NUMBER := FND_API.G_MISS_NUM;
1314:
1315: cursor c_get_quote_status is
1316: select quote_status_id
1317: from aso_quote_statuses_vl
1318: where status_code = 'INACTIVE';
1319:
1320: cursor c_get_recip_id(c_qte_header_id number) is
1321: select quote_sharee_id

Line 3637: l_quote_status aso_quote_statuses_vl.status_code%type;

3633: lx_last_update_date DATE;
3634: l_check_resource_id NUMBER;
3635: l_reason_code_meaning fnd_lookup_values_vl.meaning%type;
3636: lx_jtf_note_id NUMBER;
3637: l_quote_status aso_quote_statuses_vl.status_code%type;
3638:
3639: rec_get_SR_user_id c_get_SR_user_id%rowtype;
3640: rec_get_jtf_resource c_get_jtf_resource%rowtype;
3641: rec_find_resourceid c_find_resourceid%rowtype;

Line 3749: --obtain the status_id for 'DRAFT' from aso_quote_statuses_vl

3745:
3746: exit when c_get_jtf_resource%notfound;
3747: end loop;
3748:
3749: --obtain the status_id for 'DRAFT' from aso_quote_statuses_vl
3750: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3751: IBE_UTIL.debug('obtain the status_id for DRAFT from aso_quote_statuses_vl ');
3752: END IF;
3753:

Line 3751: IBE_UTIL.debug('obtain the status_id for DRAFT from aso_quote_statuses_vl ');

3747: end loop;
3748:
3749: --obtain the status_id for 'DRAFT' from aso_quote_statuses_vl
3750: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3751: IBE_UTIL.debug('obtain the status_id for DRAFT from aso_quote_statuses_vl ');
3752: END IF;
3753:
3754: for rec_get_status_id in c_get_status_id('DRAFT') loop
3755: l_status_id := rec_get_status_id.quote_status_id;

Line 4362: from aso_quote_statuses_vl

4358: where agreement_id = p_agreement_id;
4359:
4360: Cursor c_quote_sts_id(p_status_code varchar2) is
4361: select quote_status_id
4362: from aso_quote_statuses_vl
4363: where status_code = p_status_code;
4364:
4365: rec_term_pricelist c_term_pricelist%rowtype;
4366: rec_quote_sts_id c_quote_sts_id%rowtype;