DBA Data[Home] [Help]

APPS.OE_APPROVALS_WF dependencies on OE_ID_TO_VALUE

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

196: where obha.header_id = to_number(itemkey)
197: and obha.order_number = obhe.order_number;
198: END IF;
199:
200: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
201: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id => l_sold_to_org_id,
202: x_org => l_sold_to,
203: x_customer_number => l_customer_number);
204:

Line 201: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id => l_sold_to_org_id,

197: and obha.order_number = obhe.order_number;
198: END IF;
199:
200: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
201: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id => l_sold_to_org_id,
202: x_org => l_sold_to,
203: x_customer_number => l_customer_number);
204:
205:

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

433: and obha.order_number = obhe.order_number;
434:
435: END IF;
436:
437: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
438: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id => l_sold_to_org_id,
439: x_org => l_sold_to,
440: x_customer_number => l_customer_number);
441:

Line 438: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id => l_sold_to_org_id,

434:
435: END IF;
436:
437: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);
438: OE_Id_To_Value.Sold_To_Org(p_sold_to_org_id => l_sold_to_org_id,
439: x_org => l_sold_to,
440: x_customer_number => l_customer_number);
441:
442:

Line 1922: oe_id_to_value.salesrep

1918: AND obha.order_number = obhe.order_number;
1919: END IF;
1920:
1921: l_salesrep :=
1922: oe_id_to_value.salesrep
1923: (p_salesrep_id => l_salesrep_id);
1924: oe_id_to_value.sold_to_org
1925: (p_sold_to_org_id => l_sold_to_org_id,
1926: x_org => l_sold_to,

Line 1924: oe_id_to_value.sold_to_org

1920:
1921: l_salesrep :=
1922: oe_id_to_value.salesrep
1923: (p_salesrep_id => l_salesrep_id);
1924: oe_id_to_value.sold_to_org
1925: (p_sold_to_org_id => l_sold_to_org_id,
1926: x_org => l_sold_to,
1927: x_customer_number => l_customer_number
1928: );