APPS.XTR_IMPORT_DEAL_DATA dependencies on XTR_DEAL_TYPES_V

Line 493: From Xtr_Deal_Types_V

489: where external_deal_id = p_external_deal_id
490: and deal_type=p_user_deal_type;
491: Cursor getDealType Is
492: Select Deal_Type
493: From Xtr_Deal_Types_V
494: Where User_Deal_Type = p_user_deal_type;
495: BEGIN
496: open getDeal;
497: fetch getDeal into ARec;

Line 611: From Xtr_Deal_Types_V

607: /* Determine if the deal type is invalid or supported. */
608: /*------------------------------------------------------*/
609: Cursor Valid_Deal_Type(B_Deal_Type In Varchar2) Is
610: Select Deal_Type
611: From Xtr_Deal_Types_V
612: Where User_Deal_Type = B_Deal_Type;
613:
614: /*------------------------------------------------------*/
615: /* Determine if the deal type is invalid or supported. */

Line 619: From Xtr_Deal_Types_V

615: /* Determine if the deal type is invalid or supported. */
616: /*------------------------------------------------------*/
617: Cursor Get_deal_name(p_deal_type In Varchar2) Is
618: Select Name
619: From Xtr_Deal_Types_V
620: Where Deal_Type = p_deal_type;
621:
622:
623: /*-------------------*/

Line 627: L_Deal_Name xtr_deal_types_v.name%type;

623: /*-------------------*/
624: /* Local variables. */
625: /*-------------------*/
626: LRec_External_Deal xtr_deals_interface%rowtype;
627: L_Deal_Name xtr_deal_types_v.name%type;
628: L_Deal_Type xtr_deal_types_v.deal_type%type;
629: deal_error BOOLEAN Default FALSE;
630: user_error BOOLEAN Default FALSE;
631: duplicate_error BOOLEAN Default FALSE;

Line 628: L_Deal_Type xtr_deal_types_v.deal_type%type;

624: /* Local variables. */
625: /*-------------------*/
626: LRec_External_Deal xtr_deals_interface%rowtype;
627: L_Deal_Name xtr_deal_types_v.name%type;
628: L_Deal_Type xtr_deal_types_v.deal_type%type;
629: deal_error BOOLEAN Default FALSE;
630: user_error BOOLEAN Default FALSE;
631: duplicate_error BOOLEAN Default FALSE;
632: mandatory_error BOOLEAN Default FALSE;