DBA Data[Home] [Help]

APPS.OE_NEGOTIATE_WF dependencies on OE_ID_TO_VALUE

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

633: from oe_blanket_headers_all
634: where header_id = to_number(itemkey);
635: END IF;
636:
637: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
638: 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);
639:
640:
641: l_aname(1) := 'SALESPERSON';

Line 638: 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);

634: where header_id = to_number(itemkey);
635: END IF;
636:
637: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
638: 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);
639:
640:
641: l_aname(1) := 'SALESPERSON';
642: l_avaluetext(1) := l_salesrep;

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

1358: from oe_blanket_headers_all
1359: where header_id = p_header_id;
1360: END IF;
1361:
1362: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
1363: 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);
1364: l_aname(1) := 'SALESPERSON';
1365: l_avaluetext(1) := l_salesrep;
1366: l_aname(2) := 'SOLD_TO';

Line 1363: 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);

1359: where header_id = p_header_id;
1360: END IF;
1361:
1362: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
1363: 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);
1364: l_aname(1) := 'SALESPERSON';
1365: l_avaluetext(1) := l_salesrep;
1366: l_aname(2) := 'SOLD_TO';
1367: l_avaluetext(2) := l_sold_to;