APPS.XDP_OA_UTIL dependencies on DUAL

Line 154: from dual;

150: BEGIN
151:
152: select XDP_FULFILL_WORKLIST_S.nextval
153: into lv_instance_id
154: from dual;
155:
156: select order_id,
157: line_number
158: into lv_order_id,

Line 335: from dual;

331: BEGIN
332:
333: select XDP_FULFILL_WORKLIST_S.nextval
334: into lv_instance_id
335: from dual;
336:
337: select order_id,line_number into lv_order_id,lv_line_number
338: from xdp_order_line_items
339: where line_item_id = p_line_item_id;

Line 788: from dual

784: lv_relation := 'COMES_BEFORE';
785: end if;
786: BEGIN
787: select 'Y' into lv_exists
788: from dual
789: where EXISTS(
790: select 'x' from xdp_order_relationships
791: where order_id = p_curr_sdp_order_id AND
792: related_order_id = p_related_sdp_order_id);

Line 884: from dual

880: lv_relation := 'COMES_BEFORE';
881: end if;
882: BEGIN
883: select 'Y' into lv_exists
884: from dual
885: where EXISTS(
886: select 'x' from xdp_order_relationships
887: where order_id = p_curr_sdp_order_id AND
888: related_order_id = p_related_sdp_order_id);

Line 1007: from dual

1003: lv_relation := 'COMES_AFTER';
1004:
1005: BEGIN
1006: select 'Y' into lv_exists
1007: from dual
1008: where EXISTS(
1009: select 'x' from xdp_order_relationships
1010: where order_id = p_curr_sdp_order_id AND
1011: related_order_id = p_related_sdp_order_id);

Line 1098: from dual

1094:
1095: lv_relation := 'COMES_AFTER';
1096: BEGIN
1097: select 'Y' into lv_exists
1098: from dual
1099: where EXISTS(
1100: select 'x' from xdp_order_relationships
1101: where order_id = p_curr_sdp_order_id AND
1102: related_order_id = p_related_sdp_order_id);

Line 1191: from dual

1187: ELSIF p_order_relationship = XDP_TYPES.IS_CHILD_OF THEN
1188: lv_relation := 'IS_CHILD_OF';
1189: BEGIN
1190: select 'Y' into lv_exists
1191: from dual
1192: where EXISTS(
1193: select 'x' from xdp_order_relationships
1194: where order_id = p_curr_sdp_order_id AND
1195: related_order_id = p_related_sdp_order_id);

Line 1328: from dual

1324: lv_relation := 'MERGED_INTO';
1325:
1326: BEGIN
1327: select 'Y' into lv_exists
1328: from dual
1329: where EXISTS(
1330: select 'x' from xdp_wi_relationships
1331: where workitem_instance_id = p_curr_wi_instance_id AND
1332: related_wi_instance_id = p_related_wi_instance_id);