DBA Data[Home] [Help]

APPS.OE_BLANKET_WF dependencies on OE_ID_TO_VALUE

Line 436: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

432: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
433: where bh.header_id = to_number(itemkey)
434: and bh.order_number = bhx.order_number;
435:
436: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
437: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id=>l_sold_to_org_id, x_org=> l_sold_to,
438: x_customer_number=>l_customer_number);
439: l_aname(1) := 'SALESPERSON';
440: l_avaluetext(1) := l_salesrep;

Line 437: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id=>l_sold_to_org_id, x_org=> l_sold_to,

433: where bh.header_id = to_number(itemkey)
434: and bh.order_number = bhx.order_number;
435:
436: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
437: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id=>l_sold_to_org_id, x_org=> l_sold_to,
438: x_customer_number=>l_customer_number);
439: l_aname(1) := 'SALESPERSON';
440: l_avaluetext(1) := l_salesrep;
441: l_aname(2) := 'SOLD_TO';

Line 860: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

856: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
857: where bh.header_id = p_header_id
858: and bh.order_number = bhx.order_number;
859:
860: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
861: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id=>l_sold_to_org_id, x_org=> l_sold_to,
862: x_customer_number=>l_customer_number);
863: l_aname(1) := 'SALESPERSON';
864: l_avaluetext(1) := l_salesrep;

Line 861: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id=>l_sold_to_org_id, x_org=> l_sold_to,

857: where bh.header_id = p_header_id
858: and bh.order_number = bhx.order_number;
859:
860: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
861: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id=>l_sold_to_org_id, x_org=> l_sold_to,
862: x_customer_number=>l_customer_number);
863: l_aname(1) := 'SALESPERSON';
864: l_avaluetext(1) := l_salesrep;
865: l_aname(2) := 'SOLD_TO';

Line 981: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

977: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
978: where bh.header_id = p_header_id
979: and bh.order_number = bhx.order_number;
980:
981: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
982: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id=>l_sold_to_org_id, x_org=> l_sold_to, x_customer_number=>l_customer_number);
983: l_aname(1) := 'SALESPERSON';
984: l_avaluetext(1) := l_salesrep;
985: l_aname(2) := 'SOLD_TO';

Line 982: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id=>l_sold_to_org_id, x_org=> l_sold_to, x_customer_number=>l_customer_number);

978: where bh.header_id = p_header_id
979: and bh.order_number = bhx.order_number;
980:
981: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
982: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id=>l_sold_to_org_id, x_org=> l_sold_to, x_customer_number=>l_customer_number);
983: l_aname(1) := 'SALESPERSON';
984: l_avaluetext(1) := l_salesrep;
985: l_aname(2) := 'SOLD_TO';
986: l_avaluetext(2) := l_sold_to;