[Home] [Help]
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);
793: exception
794: when no_data_found then
795: lv_exists := 'N';
796: END;
797:
798: IF lv_exists = 'N' then
799: INSERT INTO XDP_ORDER_RELATIONSHIPS
800: (ORDER_ID,
801: RELATED_ORDER_ID,
802: ORDER_RELATIONSHIP,
803: created_by,
834: where order_id = p_related_sdp_order_id;
835:
836: return;
837: ELSE
838: UPDATE XDP_ORDER_RELATIONSHIPS
839: SET
840: last_updated_by = FND_GLOBAL.USER_ID,
841: last_update_date = sysdate,
842: last_update_login = FND_GLOBAL.LOGIN_ID,
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);
889: exception
890: when no_data_found then
891: lv_exists := 'N';
892: END;
893:
894: IF lv_exists = 'N' then
895: INSERT INTO XDP_ORDER_RELATIONSHIPS
896: (ORDER_ID,
897: RELATED_ORDER_ID,
898: ORDER_RELATIONSHIP,
899: created_by,
930: where order_id = p_related_sdp_order_id;
931:
932: return;
933: ELSE
934: UPDATE XDP_ORDER_RELATIONSHIPS
935: SET
936: last_updated_by = FND_GLOBAL.USER_ID,
937: last_update_date = sysdate,
938: last_update_login = FND_GLOBAL.LOGIN_ID,
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);
1012: exception
1013: when no_data_found then
1014: lv_exists := 'N';
1015: END;
1016:
1017: IF lv_exists = 'N' then
1018: INSERT INTO XDP_ORDER_RELATIONSHIPS
1019: (ORDER_ID,
1020: RELATED_ORDER_ID,
1021: ORDER_RELATIONSHIP,
1022: created_by,
1053: where order_id = p_related_sdp_order_id;
1054:
1055: return;
1056: ELSE
1057: UPDATE XDP_ORDER_RELATIONSHIPS
1058: SET
1059: last_updated_by = FND_GLOBAL.USER_ID,
1060: last_update_date = sysdate,
1061: last_update_login = FND_GLOBAL.LOGIN_ID,
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);
1103: exception
1104: when no_data_found then
1105: lv_exists := 'N';
1106: END;
1107:
1108: IF lv_exists = 'N' then
1109: INSERT INTO XDP_ORDER_RELATIONSHIPS
1110: (ORDER_ID,
1111: RELATED_ORDER_ID,
1112: ORDER_RELATIONSHIP,
1113: created_by,
1144: where order_id = p_related_sdp_order_id;
1145:
1146: return;
1147: ELSE
1148: UPDATE XDP_ORDER_RELATIONSHIPS
1149: SET
1150: last_updated_by = FND_GLOBAL.USER_ID,
1151: last_update_date = sysdate,
1152: last_update_login = FND_GLOBAL.LOGIN_ID,
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);
1196: exception
1197: when no_data_found then
1198: lv_exists := 'N';
1199: END;
1200:
1201: IF lv_exists = 'N' then
1202: INSERT INTO XDP_ORDER_RELATIONSHIPS
1203: (ORDER_ID,
1204: RELATED_ORDER_ID,
1205: ORDER_RELATIONSHIP,
1206: created_by,
1221: );
1222:
1223: return;
1224: ELSE
1225: UPDATE XDP_ORDER_RELATIONSHIPS
1226: SET
1227: last_updated_by = FND_GLOBAL.USER_ID,
1228: last_update_date = sysdate,
1229: last_update_login = FND_GLOBAL.LOGIN_ID,