APPS.IBE_QUOTE_SAVE_PVT dependencies on ASO_QUOTE_STATUSES_VL

Line 1336: from aso_quote_statuses_vl

1332: l_retrieval_number NUMBER := FND_API.G_MISS_NUM;
1333:
1334: cursor c_get_quote_status is
1335: select quote_status_id
1336: from aso_quote_statuses_vl
1337: where status_code = 'INACTIVE';
1338:
1339: cursor c_get_recip_id(c_qte_header_id number) is
1340: select quote_sharee_id

Line 3656: l_quote_status aso_quote_statuses_vl.status_code%type;

3652: lx_last_update_date DATE;
3653: l_check_resource_id NUMBER;
3654: l_reason_code_meaning fnd_lookup_values_vl.meaning%type;
3655: lx_jtf_note_id NUMBER;
3656: l_quote_status aso_quote_statuses_vl.status_code%type;
3657:
3658: rec_get_SR_user_id c_get_SR_user_id%rowtype;
3659: rec_get_jtf_resource c_get_jtf_resource%rowtype;
3660: rec_find_resourceid c_find_resourceid%rowtype;

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

3764:
3765: exit when c_get_jtf_resource%notfound;
3766: end loop;
3767:
3768: --obtain the status_id for 'DRAFT' from aso_quote_statuses_vl
3769: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3770: IBE_UTIL.debug('obtain the status_id for DRAFT from aso_quote_statuses_vl ');
3771: END IF;
3772:

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

3766: end loop;
3767:
3768: --obtain the status_id for 'DRAFT' from aso_quote_statuses_vl
3769: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3770: IBE_UTIL.debug('obtain the status_id for DRAFT from aso_quote_statuses_vl ');
3771: END IF;
3772:
3773: for rec_get_status_id in c_get_status_id('DRAFT') loop
3774: l_status_id := rec_get_status_id.quote_status_id;

Line 4393: from aso_quote_statuses_vl

4389: where agreement_id = p_agreement_id;
4390:
4391: Cursor c_quote_sts_id(p_status_code varchar2) is
4392: select quote_status_id
4393: from aso_quote_statuses_vl
4394: where status_code = p_status_code;
4395:
4396: cursor c_pricing_indicators(qte_header_id number) is -- change line logic pricing Test
4397: select quote_header_id, pricing_status_indicator, tax_status_indicator from