APPS.XDP_ENGINE dependencies on XDP_ORDER_LINEITEM_DETS

Line 1061: from XDP_ORDER_LINEITEM_DETS

1057: lv_param_value varchar2(4000);
1058:
1059: CURSOR c_GetLineParam is
1060: select parameter_value
1061: from XDP_ORDER_LINEITEM_DETS
1062: where
1063: line_item_id = p_line_item_id and
1064: line_parameter_name = p_parameter_name;
1065:

Line 1093: from XDP_ORDER_LINEITEM_DETS

1089: lv_param_value varchar2(4000);
1090:
1091: CURSOR c_GetLineParam is
1092: select parameter_reference_value
1093: from XDP_ORDER_LINEITEM_DETS
1094: where
1095: line_item_id = p_line_item_id and
1096: line_parameter_name = p_parameter_name;
1097:

Line 1167: update XDP_ORDER_LINEITEM_DETS

1163: if lv_exists = 'N' then
1164: raise no_data_found;
1165: end if;
1166:
1167: update XDP_ORDER_LINEITEM_DETS
1168: set
1169: last_updated_by = FND_GLOBAL.USER_ID,
1170: last_update_date = sysdate,
1171: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 2204: FROM XDP_ORDER_LINEITEM_DETS

2200: x_error_description OUT NOCOPY VARCHAR2
2201: ) IS
2202: CURSOR c_line_item IS
2203: SELECT line_parameter_name, PARAMETER_VALUE
2204: FROM XDP_ORDER_LINEITEM_DETS
2205: WHERE LINE_ITEM_ID = p_line_item_id
2206: AND PARAMETER_VALUE IS NULL
2207: FOR UPDATE OF PARAMETER_VALUE NOWAIT;
2208: l_parameter_value VARCHAR2(4000);

Line 2213: UPDATE XDP_ORDER_LINEITEM_DETS SET PARAMETER_VALUE = l_parameter_value

2209: BEGIN
2210: FOR l_line_item_dets IN c_line_item LOOP
2211: Get_Parameter_Value_From_WI(p_line_item_id,l_line_item_dets.line_parameter_name,l_parameter_value);
2212: IF (l_parameter_value IS NOT NULL) THEN
2213: UPDATE XDP_ORDER_LINEITEM_DETS SET PARAMETER_VALUE = l_parameter_value
2214: WHERE CURRENT OF c_line_item;
2215: END IF;
2216: END LOOP;
2217:

Line 2439: from XDP_ORDER_LINEITEM_DETS

2435: select 'Y' yahoo
2436: from dual
2437: where exists(
2438: select 'x'
2439: from XDP_ORDER_LINEITEM_DETS
2440: where line_item_id = p_line_item_id and
2441: line_parameter_name = p_parameter_name);
2442:
2443: lv_exists varchar2(1) := 'N';

Line 2493: insert into XDP_ORDER_LINEITEM_DETS

2489: p_parameter_reference_value IN VARCHAR2)
2490: is
2491: begin
2492:
2493: insert into XDP_ORDER_LINEITEM_DETS
2494: ( line_item_id,
2495: line_parameter_name,
2496: parameter_value,
2497: parameter_reference_value,