DBA Data[Home] [Help]

APPS.XDP_ENGINE dependencies on XDP_ORDER_PARAMETERS

Line 961: from xdp_order_parameters

957: lv_param_value varchar2(4000);
958:
959: CURSOR c_GetOrderParam is
960: select order_parameter_value
961: from xdp_order_parameters
962: where
963: order_id = p_order_id and
964: order_parameter_name = p_parameter_name;
965:

Line 996: xdp_order_parameters

992: select
993: order_parameter_name parameter_name,
994: order_parameter_value parameter_value
995: from
996: xdp_order_parameters
997: where
998: order_id = p_order_id;
999:
1000: lv_index NUMBER := 0;

Line 1031: update xdp_order_parameters

1027: (p_order_id => Set_Order_Param_Value.p_order_id,
1028: p_parameter_name => Set_Order_Param_value.p_parameter_name);
1029:
1030: IF lv_exists = 'Y' then
1031: update xdp_order_parameters
1032: set
1033: last_updated_by = FND_GLOBAL.USER_ID,
1034: last_update_date = sysdate,
1035: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 2414: from xdp_order_parameters

2410: select 'Y' yahoo
2411: from dual
2412: where exists(
2413: select 'x'
2414: from xdp_order_parameters
2415: where order_id = p_order_id and
2416: order_parameter_name = p_parameter_name);
2417:
2418: lv_exists varchar2(1) := 'N';

Line 2463: insert into xdp_order_parameters

2459: is
2460:
2461: begin
2462:
2463: insert into xdp_order_parameters
2464: (order_id,
2465: order_parameter_name,
2466: order_parameter_value,
2467: created_by,